This is “Assessment of Pro Forma Statements”, section 5.3 from the book Finance for Managers (v. 0.1).
This book is licensed under a Creative Commons by-nc-sa 3.0 license. See the license for more details, but that basically means you can share this book as long as you credit the author (but see below), don't make money from it, and do make it available to everyone else under the same terms.
This content was accessible as of December 29, 2012, and it was downloaded then by Andy Schmitz in an effort to preserve the availability of this book.
Normally, the author and publisher would be credited here. However, the publisher has asked for the customary Creative Commons attribution to the original publisher, authors, title, and book URI to be removed. Additionally, per the publisher's request, their name has been removed in some passages. More information is available on this project's attribution page.
For more information on the source of this book, or why it is available for free, please see the project's home page. You can browse or download additional books there. You may also download a PDF copy of this book (2 MB) or just this chapter (141 KB), suitable for printing or most e-readers, or a .zip file containing this book's HTML files (for use in a web browser offline).
PLEASE NOTE: This book is currently in draft form; material is not final.
Pro forma statements are to be tools to help a company plan for the future. They are only as good as the assumptions upon which they are constructed.
Our analysis has been straightforward and simple but it can get more complex. Companies can change many of the other variables found on their income statements and balance sheets. Companies determine their dividend policy (which influences retained earnings) and they can influence their level of debt (through their capital structure decisions which influences their interest expense) as well as their common stock.
Now we have constructed our pro forma statements. But how accurate are they? What’s the probabilty that our pro forma will correctly depict our company’s future? To answer this question, pro formas can be analyzed using scenario analysis, which we cover in more detail in chapter 13. Companies can analyze best, worst, and most likely case scenarios by creating sets of pro formas with different underlying assumptions. This might seem like a lot of work, but spreadsheets can make these calculations fairly easily.
Pet Products Forever estimates that their most likely case is increase in sales of 10%. Their best case would be an increase of 20% and their worst case would be an increase of 2%. Remember that COGS are % of sales and SG&A are % of sales.
Figure 5.8 Pet Products Forever Inc. Pro Forma Income Statements (Thousands) 2013
The best case results in net earnings of $13 thousand, while our worst outcome is $9.4 thousand. The company is still doing well, even under the worst case scenario. Not a bad result!
Analyze the following pro forma statement using the percent of sales method under best case and worst case scenarios given below.
Sales are $100,000, COGS is $43,000, SG&A is $22,000. Depreciation is $10,000 and tax rate is 40%.