What Valuation Analysts Can Do on Day One Use the new =COPILOT() formula and super charge your productivity in Excel. The Problem with Excel (and Why This Matters Now) If you work in business valuation or consulting, Excel is still your daily driver. We use it for everything; normalizing financial statements, running DCF models, cleaning client exports, and building rolling KPI dashboards. But as powerful a ...

The Four Pillar Framework Rod Burkert has been spreading the gospel about BVFLS practice development since 2013. In this article, he discusses a framework that he has developed and can be used to close the gap between the practice you have and the practice you want. The people I talk to all seem to have slightly different ideas about practice development. Here is one definition from a Forbes article that I ...

Structured, Clear, and Well-Researched and Reasoned In a litigation setting, a well-written business valuation report can position your conclusion of value as credible. When completed for tax purposes, a well-written business valuation report can help avoid an IRS challenge. In any circumstances, a well-written business valuation report can provide the business owner with ways to increase cash flow and redu ...

An Interview with Zain Kalson, founder of Etheia As part of a broader dialogue around business valuations in the context of divorce, this article features an interview conducted by Andrew Thompson, Esq., with Zain Kalson, the founder of Etheia. The article discusses trends regarding how advanced data analytics are helping attorneys and experts sort through hidden assets, analyze expenses, and improve outcom ...

Get Clients to Count on Your Accounting Is it the valuation of a small privately held company with three employees? Or a large multi-national with employees in the thousands? Perhaps it is reviewing assets in a highly contested divorce. One way or another, you are trying to reach a decision, an opinion, or a conclusion from the data in front of you. Using big data, you must compose a story and present the d ...

Our firm bills clients in six-minute increments, so I've started tracking my beginning and ending time for each job in Excel. Is it possible to round my time calculations to the nearest six-minute increment (a 10th of an hour) in Excel? To read the full article in the Journal of Accountancy, click: Microsoft Office: Rounding Time in Excel. ...

What is the best choice when faced with an array of choices for finding specific data in a financial model? Consider this vector analysis. Conspicuous by its absence, LOOKUP may seem a less versatile function upon first glance, but it is quite useful for modelling. To read the full article in Financial Management, click: Things Are Looking Up With This Excel Function. ...

Q. I have a large Excel workbook with many worksheets, and I'd like to summarize the key elements of this workbook into a single dashboard-type report. What's the best way to do this? To read the full article in the Journal of Accountancy, click: Microsoft Excel: Create a Picture-Based Dashboard Report. ...

At Flint Hills Resources, robotic process automation is supercharging, not eliminating, finance professionals.  The Koch Industries subsidiary shows us how. To read the full article in Financial Management, click: Empowering the Human Element in Automation. ...

Q. We receive Excel-based reports from our European operations with the daily temperatures of our electrical generators and other equipment recorded in Celsius; what's the best way to convert these data to Fahrenheit in Excel? To read the full article in the Journal of Accountancy, click: Microsoft Office: Excel's Versatile CONVERT Function. ...

Learn the formulas, functions, and techniques that enable efficient Benford analysis of data sets.  J. Carlton Collins, Journal of Accountancy contributing editor, looks into this issue and provides some very useful tips and insights. To read the full article in JofA, click: Using Excel and Benford’s Law to Detect Fraud. ...

Visualized Financial Statement Analysis The use of Excel and graphics, commonly referred to as data visualization, can provide a fuller or more holistic view of changes in an entity. Does the traditional audit or report that is devoid of data visualization serve the client? In this article, the author “propos[es] not a replacement for ratios…but rather that financial statement analysis should return to a mo ...

Few Business Owners Seem to Even Know How to Make a Good Guess at What Their Business is Worth.  NY Times Introduces Technology to Help—and Certified Advisers Provide Extra Value.  Mark Cohen, at The New York Times Small Business Guide, reports:  "At 53, Joe Ritz is old enough to remember a time when many of the classic cars that now pull into his specialized repair shop were new. “It’s one field where it p ...