Pro Forma Analysis: Forecasting a Company's Financial Future

Title: Corporate Finance: A Practical Approach (2nd ed.)
Authors: Michelle R. Clayman, Martin S. Fridson, George H. Troughton
ISBN: 978-1-118-10537-5

Previous: Financial Statement Ratios | Next: Mergers and Acquisitions: Motives and Transactions

The second half of Chapter 9 shifts from reading the past to guessing the future. After common-size statements and ratios tell you what happened, pro forma analysis asks: what happens next?

From ratios to forecasts

Pro forma statements are projected income statements and balance sheets. You build them using relationships from recent history plus assumptions about what will change. The goal is not a perfect prediction. It is a structured way to think about revenue growth, cost structure, and financing needs.

The book starts with a blunt example. Take P&G’s 2004 financials, assume every line item scales with sales at the same rate as 2004, and project 2005 revenue growth at 18.5%. The model predicts $7.682 billion in net income. Actual result: $7.257 billion. Off by about $425 million.

Why the miss? Revenue growth came in at 10.4%, not 18.5%. And “other nonoperating income” does not track sales in a predictable way. The lesson: revenue forecasting is the load-bearing wall. Get that wrong and everything downstream wobbles.

Sales-driven vs. fixed accounts

Not every line item moves with revenue. The book splits accounts into two groups.

Sales-driven accounts tend to scale with revenue: cost of goods sold, SG&A, and most working capital items (current assets and current liabilities). For Wal-Mart, COGS ran around 79% of sales and operating expenses around 16% for 15 years. That stability makes forecasting easier.

Fixed burdens do not follow sales. Interest expense depends on capital structure. Taxes depend on tax rates and profitability. You estimate these separately.

For a fictional company called Imaginaire, the book uses these relationships:

• COGS: 60% of sales
• Operating expenses: 10% of sales
• Current assets: 60% of sales
• Current liabilities: 25% of sales
• Tax rate: 35%

Those percentages come from common-size analysis of historical data.

Forecasting revenue is the hard part

You can project revenue several ways: last year’s growth rate, average growth over a decade, or a linear regression on historical sales. For P&G in 2005, all three methods undershot actual revenue. Why? Acquisitions and divestitures changed the product mix. Past growth patterns did not capture the new business.

Good revenue forecasts blend historical trends with forward-looking information: segment data, management guidance, industry conditions, and planned M&A. If a company reports consistent segment breakdowns, track each segment and roll them up.

The financing plug problem

Here is where pro forma gets real. You forecast the income statement, carry net income to retained earnings on the balance sheet, and project sales-driven asset and liability accounts. Then you check: do assets equal liabilities plus equity?

Almost always, they do not. You get a financing deficiency (need more cash) or a financing surplus (extra cash). Something has to balance the books. That “plug” is usually debt, equity, stock repurchases, or dividends.

The Imaginaire example shows a €24.5 million surplus after a 5% revenue growth forecast. The company could pay down debt, buy back stock, or raise dividends. But if debt changes, interest expense changes, which changes net income, which changes retained earnings. You iterate until the surplus or deficit shrinks to rounding error.

Two approaches:

1. Adjust debt only until the balance sheet balances.
2. Maintain the current debt-to-equity ratio, splitting the surplus between debt reduction and equity (treasury stock repurchases).

Each assumption about capital structure ripples through interest, taxes, and earnings. Pro forma is as much about financing policy as about operations.

Putting it all together

The full pro forma workflow from Exhibit 9-20:

1. Estimate sales-driven relationships from common-size analysis.
2. Estimate fixed burdens (interest and taxes).
3. Forecast revenue (the critical input).
4. Build pro forma income statement and balance sheet.
5. Identify financing deficiency or surplus.
6. Assume how management handles the plug.
7. Iterate until balanced.

Sensitivity analysis comes next: what if revenue grows 3% instead of 5%? What if COGS rises to 62% of sales? Pro forma turns one forecast into a range of scenarios.

What this chapter really teaches

Financial statement analysis is a loop. Common-size analysis reveals patterns. Ratios quantify performance and risk. Pro forma analysis projects those patterns forward. None of it works in isolation.

The P&G decade-long ratio study showed a company improving margins, increasing leverage (especially short-term debt), and shifting its product mix through acquisitions. Pro forma would need to account for all of that before projecting the next year.

And the humility point matters. The book’s own P&G forecast missed by hundreds of millions. Pro forma assumptions need to be realistic, not optimistic. A model is only as good as the revenue forecast and the judgment behind every plug.

Next: Mergers and Acquisitions: Motives and Transactions