Professor Jessie

Chapter 15: Financial Planning and Forecasting

FIN 3400 — Finance for Non-Financial Managers · MDC Kendall · Fall 2026
Supplementary Module
izquierdojr.com
↓ scroll to explore

The Financial Planning Process

Financial planning is the process of mapping out a firm's future cash inflows and outflows — a roadmap that tells management where the money will come from, where it will go, and whether the firm can sustain its growth ambitions. While the mechanics resemble personal budgeting, corporate financial planning is far more complex because it involves dozens of interacting variables, multiple stakeholders, and strategic tradeoffs.

Where Financial Planning Fits in Strategy

Strategic planning answers three fundamental questions: Where is the firm going? over the next year or more, How will it get there?, and How will we know if it arrived? Financial planning is the quantitative backbone of that process — it translates strategic vision into numbers that can be tested, tracked, and adjusted.

The Four-Step Financial Planning Framework

Analogy: Think of financial planning as planning a road trip. You first estimate how far you'll drive (sales), then calculate how much gas you'll need (assets), identify what fuel you already have in the tank (spontaneous liabilities), figure out how much cash you have for gas stations (retained earnings), and then determine how much you need to borrow or earn along the way (AFN).

Base Case Projections

Every financial plan is built on a base case — a specific set of assumptions about the firm's future operating environment. These assumptions cover everything from sales growth rates and cost structures to interest rates and tax policies. The base case isn't a single number; it's an interlocking web of projected financial statements.

What Base Case Projections Do

Base case projections are the projected financial statements associated with the base case assumptions. They serve three critical functions in the strategic planning process:

Important caveat: A base case is only as good as its assumptions. The 2008 financial crisis revealed that many firms' base cases severely underestimated the possibility of a housing downturn. Always ask: What assumptions could break this plan?

Forecasting Sales: The Foundation

Because sales drive every other projection, getting the sales forecast right is the single most important step in financial planning. There are three primary approaches, ranging from simple to sophisticated. The right choice depends on the firm's sales patterns, data availability, and the cost of forecast errors.

The Naïve Approach

The naïve approach is the simplest forecasting method available: it assumes that next period's sales will equal the most recent period's sales. If the firm sold $10 million last year, the naïve forecast for this year is $10 million — no adjustments, no trend analysis, no fancy math.

Despite its simplicity, the naï approach serves an important purpose: it provides a baseline against which more sophisticated methods can be compared. If your complex model can't beat the naïve forecast, the complexity isn't adding value.

Measuring Forecast Accuracy: MAPE

How do we know if a forecasting method is any good? We need a way to measure forecast error — the gap between what we predicted and what actually happened. The most common metric is the Mean Absolute Percentage Error (MAPE).

How MAPE Works

MAPE measures how efficiently a forecasting technique performs by testing it on historical data. The process involves splitting historical data into two sets: a training set used to develop the forecast model, and a testing set (held "out-of-sample") used to evaluate its accuracy. This mimics real-world conditions — you're asking, "If I had used this method in the past, how wrong would I have been?"

The MAPE Formula

MAPE = (1/n) × Σ | (Actualₜ − Forecastₜ) / Actualₜ | × 100

Where n is the number of forecasts in the testing period. MAPE expresses error as a percentage, making it easy to interpret: a MAPE of 5% means your forecasts were off by an average of 5% from actual values.

Key insight: A low MAPE on historical data doesn't guarantee future success — markets shift, competitors enter, and consumer preferences change. But a high MAPE is a clear warning sign that the forecasting method needs improvement. Use MAPE as a relative comparison tool: method A vs. method B, not as an absolute pass/fail threshold.

The Average Approach

The average approach improves on the naïve method by using a larger sample of historical data. Instead of relying on a single observation, it takes the mean of multiple historic sales figures as the forecast for the next period. This smooths out random fluctuations and generally produces a more stable estimate.

How Far Back Should You Look?

This is the critical question. If sales have shifted to a permanently new level — perhaps after a product launch, market expansion, or competitor exit — including data from before that shift introduces "stale" observations that don't reflect current conditions. A firm that doubled its sales three years ago shouldn't average in figures from before that doubling.

ApproachData UsedBest ForWeakness
NaïveMost recent period onlyStable, flat salesIgnores all patterns
AverageMean of multiple periodsModerately stable salesMay include stale data
Seasonality-AdjustedDeseasonalized + trendSeasonal or trending salesMore complex to implement

Handling Seasonality and Trends

Many businesses experience systematic patterns in their sales — seasonal spikes (retail in Q4, landscaping in summer), cyclical trends (economic expansion/contraction), or long-term growth/decline. When these patterns are strong, simple averaging fails because it ignores the very structure that makes the data predictable.

The Deseasonalization Process

To forecast accurately when seasonality is present, you must first remove the seasonal effects from the historical data — a process called deseasonalization. Here's how it works:

Real-world example: A swimwear manufacturer sees 70% of annual sales between May and August. A naïve or average approach would massively underpredict summer and overpredict winter. By deseasonalizing, identifying the growth trend, then re-applying seasonal factors, the firm can forecast each month with far greater precision — ensuring inventory is available when demand peaks.

Additional Funds Needed (AFN)

Once we have a sales forecast, the next question is: Can the firm fund its own growth, or does it need external capital? The Additional Funds Needed (AFN) framework answers this question. If sales are expected to increase, that growth must be supported by additional assets — more inventory, more receivables, potentially more equipment.

The AFN Formula

AFN = (Necessary increase in assets) − (Spontaneous increase in liabilities) − (Projected increase in retained earnings)

The logic is elegant in its simplicity. The firm needs more assets to support higher sales. Some of that need is automatically covered by liabilities that grow with sales (accounts payable, accrued expenses). Some is covered by profits the firm retains. Whatever remains is the gap that must be filled by external financing — bank loans, bonds, or new equity.

Three possible outcomes: If AFN is positive, the firm must raise external capital. If AFN is zero, the firm is self-funding — it grows exactly as fast as its internal resources allow. If AFN is negative, the firm generates more cash than it needs — it can pay down debt, increase dividends, or repurchase shares.

Breaking Down the AFN Components

1. Necessary Increase in Assets

The first component measures how much additional asset base the firm needs. We calculate the capital intensity ratio — the ratio of sales-driven assets (A*) to current sales — and multiply it by the projected increase in sales:

Δ Assets = (A* / S₀) × (S₁ − S₀)

Where A* represents assets tied directly to sales (typically current assets like inventory and receivables), S₀ is current sales, and S₁ is projected sales.

2. Spontaneous Increase in Liabilities

Some liabilities grow naturally as sales increase — these are called spontaneous liabilities. Accounts payable and accrued wages are the classic examples. We calculate a spontaneous liabilities ratio and apply it the same way:

Δ Liabilities = (L* / S₀) × (S₁ − S₀)

Where L* represents liabilities that vary directly with sales.

3. Projected Increase in Retained Earnings

The firm's own profits provide internal funding. We estimate this by multiplying the firm's profit margin (M) by projected sales, then multiplying by the retention ratio (RR) — the fraction of earnings not paid out as dividends:

Δ Retained Earnings = M × S₁ × RR
Remember the connection: The retention ratio (RR) equals 1 minus the dividend payout ratio. If a firm pays out 40% of earnings as dividends, it retains 60%. Higher retention means more internal funding and lower AFN — which is why growth firms often pay low or no dividends.

AFN with Unused Capacity

The standard AFN formula assumes that all sales-driven assets must grow proportionally with sales. But in reality, most firms have unused capacity in their fixed assets — a factory running at 70% utilization doesn't need a new factory to handle a 20% sales increase. It just needs to operate closer to full capacity.

Adjusting A* for Unused Capacity

When a firm has excess fixed-asset capacity, the assets that must grow with sales (A*) are not the firm's total assets. Instead, A* typically equals only current assets — the inventory and receivables that do scale with sales — because existing fixed assets can absorb the additional production without expansion.

This significantly reduces AFN. A firm with a half-empty warehouse and idle production lines can grow sales substantially before needing to invest in new facilities. Understanding this distinction is crucial for accurate financial planning.

Strategic implication: Firms with significant unused capacity have a temporary growth advantage — they can expand sales without major capital expenditure. Investors should watch for firms operating near full capacity, as those firms will need substantial capital investment to grow further, potentially diluting shareholder value.

When Assets Are "Lumpy"

Why would a firm sit around with unused fixed-asset capacity in the first place? The answer reveals a fundamental characteristic of real-world assets: they are not infinitely divisible. You cannot buy one-fourth of a factory, one-tenth of a nuclear power plant, or half a server rack. Fixed assets must be purchased in discrete, integer-based quantities.

The Lumpiness Problem

Because assets are "chunky" or "lumpy," firms often must buy capacity in large increments that exceed their immediate needs. A firm needing 30% more production capacity might have to build an entirely new plant that doubles capacity — leaving it with significant excess until sales grow to fill it. This creates a step-function pattern in asset acquisition rather than the smooth, linear relationship the basic AFN formula assumes.

Asset acquisition pattern: lumpy vs. linear growth assumption
Planning challenge: The lumpiness of assets means that AFN calculations are inherently approximate. A firm might need zero new investment for a 15% sales increase (using existing capacity), then suddenly need a massive capital expenditure for a 20% increase (requiring a new factory). Financial planners must model these step changes rather than relying on smooth linear projections.

Pro Forma Financial Statements

The AFN formula is a useful shortcut, but it has limitations. It assumes that balance sheet and income statement items change linearly with sales, and it only captures first-order effects — the immediately observable impacts. In reality, changing one item often triggers cascading effects throughout the financial statements.

The Pro Forma Approach

Pro forma financial statements provide a more sophisticated method for estimating AFN. The process:

Why Pro Forma Is Superior

The pro forma approach captures feedback loops that the simple formula misses. For example, taking on new debt increases interest expense, which reduces net income, which reduces retained earnings, which increases AFN further — a circularity that only the iterative approach can resolve. Modern financial modeling software handles these iterations automatically, but understanding the logic behind them is essential for interpreting the results.

Illustrative pro forma: current vs. projected balance sheet (in $ millions)

Key Takeaways

Next up: Chapter 16 — Assessing Long-Term Debt, Equity, and Capital Structure. Now that we know how to forecast how much funding a firm needs, we'll tackle the question of what mix of debt and equity the firm should use to raise it.

Further Learning Resources

Explore these to deepen your understanding of this chapter's topics:

▶ YouTube Financial Planning: Percent of Sales Method Explained 📖 Investopedia Pro Forma Financial Statements — Definition 📖 Investopedia Additional Funds Needed (AFN) — Formula ▶ YouTube Pro Forma Financial Modeling — Ryan O'Connell Finance 💬 Reddit r/finance — Forecasting discussions