Applying Projection Modeling to Analytical Review

By Alex Vuchnich, CPA, CFE - Traditional analytical review techniques are usually premised under the assumption that prior year activity is representative of current year expectations. In many cases this logic stands up. If no significant changes in a company's operations have occurred than expecting the status quo is reasonable. Certain revenue and expense account also tend to exhibit behavior that is predictable based on historical trends. But all too often in practice we typically find ourselves looking at financial data that has changed dramatically from prior periods. In this situation a new model for analytical review needs to be applied in order to develop meaningful expectations about account balances.

In identifying an appropriate model for analysis, one place we can look to is our clients' internal financial management tools. The officers of a business regularly adjust their strategic and operational goals. In making these adjustments they must rely on forecasts and projections to understand the implications for the enterprise. Underlying a projection is the assumption that certain relationships in the financial statements should exist. It seems that this same approach can be used effectively for evaluating the actual financial performance of a company with our own independent expectations. Essentially the auditor can develop an independent budget and sales forecast for the company based on their knowledge of financial accounting and then compare this to actual results.

One method of developing this type of forecast is the sales growth driven model. The accountant starts by developing an expectation about sales for the period. Historical time series analysis can be a good predictor for this. Also many industry specific drivers exist that can also be applied in making this initial assumption. The client's actual sales will also be an important factor here. Once an independent forecast has been developed the auditor needs to evaluate that in the context of actual sales reported by the client. Any major variances must be dealt with before proceeding with the remainder of the analysis. Since sales is the primary driver for the analysis, any significant variance here will result in a forecast that is no longer comparable to what is portrayed on the client's financials.

Once sales have been forecasted, cost of goods sold can be back into based on gross margin percentage and trends in expense accounts can be developed. For the balance sheet, the relationship for many accounts will be tied directly to sales or cost of goods sold. Typically we expect certain turnover relationships between revenue and accounts receivable, inventory, fixed assets and payables. Once the capital needs associated with fixed assets have been identified we can develop expectations about what sort of financing would be needed to maintain the forecasted sales level. Many other factors can be tied into this type of forecast such as principal and interest payment amounts from loan amortization schedules or depreciation expense from fixed asset software projections. Finally, cash can be calculated using the indirect cash flow method to determine the change in cash from the prior period.

By integrating this type of approach into your analytical review process, a thorough understanding of where unexpected or unusual relationships in the financial statements can be obtained. Although traditional historical comparisons are still necessary as a starting point for analytical review, applying a projection model to develop independent expectations is essential for properly planning a meaningful engagement.

This blog

by Alex Vuchnich, CPA, CFE - Alex Vuchnich is the developer of Controlzkit an internal controls anaylsis tool and shares his perspective on how audit and accounting theory, technology and professional ethics interrelate to create forward thinking profitable firms.

More from this blog

Bloggers crew

Steve Knowles has spent 25 years in business and practice in the UK, but he also worked in the states and the years haven't dulled his way of seeing an alternative view to everyone else, and every day is a new adventure.

48253

Joel M. Ungar, CPA is a lifelong resident of the Detroit area and a graduate of The University of Michigan. He is a principal with Silberstein Ungar, PLLC, a Top 15 auditor of SEC public reporting companies.

81336

Allan Boress, CPA, with over 25 years as a practitioner and consultant to the accounting profession. Mr. Boress is the author of 12 published books in 6 different languages, including a best-seller, The "I-Hate-Selling" Book.

53409

Larry Perry, CPA, CPA Firm Support Services, LLC, is the author of accounting and auditing manuals, author and presenter of live staff training seminars, and author of webcast and self-study CPE programs. He blogs about small audits, reviews, and compilations.

96282
Sandra Wiley, COO and Shareholder, is ranked by Accounting Today as one of the 100 Most Influential People in Accounting as a result of her prominent role as an industry expert on HR and training as well as influence as a management and planning consultant. She is also a founding member of The CPA Consultant's Alliance. Sandra is a certified Kolbe™ trainer who advises firms on building balanced teams, managing employee conflict and hiring staff.
24450

Maria Calabrese, CIR, Human Resources manager for Fazio, Mannuzza, Roche, Tankel, LaPilusa, LLC in Cranford, New Jersey, Maria's topics revolve around the world of: Mentoring, Performance management, and The "Y Generation," a.k.a. "The whY generation".

60712

William Brighenti is a CPA, Certified QuickBooks ProAdvisor, and Certified [Business] Valuation Analyst, operating an accounting, tax, and QuickBooks consulting firm in Hartford, Connecticut, Accountants CPA Hartford.

86350

Ken Garen, CPA, is the co-founder and President of Universal Business Computing Company (www.ubcc.com), a software development firm of high-volume, high-productivity accounting and payroll technology.

28398

Eva Rosenberg, MBA, EA, is the publisher of TaxMama.com, and author of the weekly syndicated Ask TaxMama column. She provides answers to tax questions from taxpayers and tax professionals worldwide.

69418

Amy Vetter, CPA, CITP is the CPA Programs Leader for Intacct Corporation responsible for leading the CPA/BPO Partners nationally.

38018
Brian Strahle is the owner of LEVERAGE SALT, LLC where he provides state and local tax technical services to accounting firms, law firms and tax research organizations across the United States. He also writes a weekly column in Tax Analysts State tax Notes entitled, "The SALT Effect." For more info, visit his website: www.leveragestateandlocaltax.com
109163
Scott H. Cytron, ABC, is president of Cytron and Company, known for helping companies and organizations improve their bottom line through a hybrid of strategic public relations, communications, marketing programs and top-notch client service. An accredited consultant, Scott works with companies, organizations and individuals in professional services (accounting, finance, medical, legal, engineering), high-tech and B2B/B2C product/service sales.
29831

Rita Keller is a nationally known CPA firm management consultant, speaker, author, mentor and blogger. She has over 30 years hands-on experience in CPA firm management, marketing, technology and administrative operations.

57676
Stacy Kildal is the mom of two fantastic kids, an Advanced Certified QuickBooks ProAdvisor, Certified Enterprise Solutions ProAdvisor, Sleeter Group Certified Consultant, a nationally recognized member of the Intuit Trainer and Writer Network, and co-host of RadioFree QuickBooks.
31846
Michael Alter's blog specializes in providing practical advice to those who seek greater profitability and practice management tactics that enhance deeper client relationships.
36382

Sally Glick, CMO, Principal, Marketer of the Year in 2003 and AAM Hall of Famer in 2007, leads a lively discussion of the constantly expanding roles of marketing and the professional marketers that drive this initiative in accounting firms of all sizes.

107705

The IMA Young Professionals Blog features the insights of IMA’s Young Professionals Committee. Committee members share advice and experiences on careers, continuing education, work/life balance, and other issues affecting young accounting and finance professionals.

37686

FEI Financial Reporting Blog provides highlights from SEC, PCAOB, FASB, IASB, and other regulatory news, including reporting under Sarbanes-Oxley Sect 404. It is written by Edith Orenstein, Director of Technical Policy Analysis at FEI.

118934

Sue Anderson has 30 years of experience in continuing education for accountants. Currently she is the program director for online CPE provider CPE Link.

66687

Jim Fahey is COO of Apple Growth Partners, a regional CPA firm in Ohio. His focus is on the effective and efficient use of technology within the firm by all team members.

43482
Caleb Newquist is the Editor-in-Chief of Sift Media US, overseeing content for both AccountingWEB and Going Concern.
71093

Leita Hart-Fanta, CPA, CGFM, and CGAP is the author of "The Yellow Book Interpreted" and owner of Yellowbook-CPE.com a website devoted to training for governmental auditors.

97809

AccountingWEB is more than just a U.S. team of journalists and financial and technology experts - we have an international side, too! Members of our British team who publish AccountingWEB.co.uk share their ideas, insights, and perspectives from across the pond.

58467