Financial Planning, Forecasting and Control

Introduction

Financial management is not limited to recording what has already happened. It also requires management to anticipate future sales, costs, asset requirements, financing needs and cash flows, and then to compare actual results with those expectations. Financial planning connects strategy with operating decisions; forecasting provides informed estimates of future outcomes; and control ensures that corrective action is taken when performance differs from plan.

A sound plan does not pretend that the future is known with certainty. Rather, it makes assumptions explicit, quantifies their consequences and creates a basis for decisions. Forecasts are therefore decision tools, not promises. Their usefulness depends on the quality of information, the realism of assumptions and the discipline with which results are reviewed.

Learning Objectives

By the end of this chapter, you should be able to:

1. Explain the purpose and process of financial planning and forecasting.
2. Prepare operating forecasts, pro forma statements and cash budgets.
3. Estimate external financing needs using the additional funds needed approach.
4. Calculate and interpret break-even points and operating leverage.
5. Conduct sensitivity and scenario analysis.
6. Explain how budgets support managerial control, governance and ethical decision-making.

1. Financial Planning as an Integrated Process

Financial planning translates an organisation’s strategic objectives into numerical operating and financing plans. A typical planning sequence is:

1. Establish strategic objectives and planning assumptions.
2. Forecast sales and other operating drivers.
3. Prepare production, expense, capital expenditure and working-capital plans.
4. Construct pro forma income statements, balance sheets and cash budgets.
5. Estimate financing surpluses or deficits.
6. Evaluate risks through sensitivity and scenario analysis.
7. Approve budgets, assign responsibility and monitor performance.

The process is iterative. A sales forecast may imply additional inventory and receivables, which require financing. Financing costs may alter profit, taxes and cash flow, requiring the plan to be revised. Consequently, financial planning should be coordinated across marketing, operations, procurement, human resources and treasury.

Planning horizons

A short-term plan, commonly covering a year or less, focuses on liquidity, working capital and operating control. A medium- or long-term plan examines capacity, capital investment, financing structure and strategic growth. Rolling forecasts update the planning horizon periodically—for example, each month a new month is added—so that management does not rely on an outdated annual budget.

Forecasting versus budgeting

A forecast is management’s current best estimate of what is likely to occur. A budget is an authorised plan that communicates targets, resources and responsibilities. The forecast may change as evidence changes; the budget may remain a benchmark for performance evaluation. Confusing a target with a forecast can encourage unrealistic assumptions and conceal emerging problems.

2. Forecasting Operating Performance

Sales forecasting

Sales are often the starting point because many costs, assets and financing requirements depend on revenue. Forecasting methods include:

• Historical analysis: trends, growth rates and seasonal patterns are examined.
• Causal analysis: sales are related to drivers such as price, advertising, income, market size or economic activity.
• Market and managerial judgment: customer research, sales-force information and expert assessments are incorporated.
• Statistical models: time-series or regression methods are used when reliable data exist.
• Bottom-up forecasting: individual products, territories or customers are estimated and aggregated.

A responsible forecast documents the period, units, prices, market assumptions, seasonality and uncertainty. Managers should avoid simply extrapolating exceptional historical growth.

Percentage-of-sales method

The percentage-of-sales method assumes that selected income-statement items, assets and liabilities change in proportion to sales. If current sales are S₀ and forecast sales are S₁, the sales growth rate is:

where g is the growth rate and S values are monetary amounts for comparable periods. The method is simple but should be used only when proportionality is reasonable. Fixed assets, debt and some expenses often do not vary directly with sales.

For example, if sales increase from $800,000 to $920,000:

g = ($920,000 − $800,000) ÷ $800,000 = 0.15 = 15%

Cost behaviour

Forecasting requires distinguishing cost behaviour:

• Variable costs change approximately in proportion to activity.
• Fixed costs remain constant within a relevant operating range.
• Mixed costs contain both fixed and variable components.
• Step costs remain fixed over intervals but increase when capacity thresholds are crossed.

The relevant range matters. A factory’s rent may be fixed up to its capacity, but a new facility may be required when forecast demand exceeds that capacity. Forecasts should therefore reflect operational constraints rather than mechanically applying historical percentages.

3. Pro Forma Financial Statements

Pro forma statements are projected financial statements prepared from explicit assumptions. They support planning, financing discussions and evaluation of the consistency of operating decisions.

Pro forma income statement

A basic forecast income statement may be prepared as follows:

The accounting relationships are:

The final relationship assumes interest expense is tax-deductible, the tax rate applies to positive taxable income and there are no unusual tax adjustments. If taxable income is zero or negative, the simple tax calculation may not apply.

Pro forma balance sheet

A projected balance sheet must satisfy:

Assets may be forecast from sales ratios, operating capacity or explicit investment plans. Liabilities may include trade payables, accruals and planned borrowings. Equity may increase through retained earnings:

This identity assumes no direct adjustments to retained earnings. Comprehensive income items, prior-period adjustments or share transactions require additional analysis.

A projected balance sheet can be completed using a financing plug, such as a bank loan or marketable securities. The plug must be interpreted, not merely inserted. A positive financing requirement indicates that internally generated funds and spontaneous liabilities are insufficient; a negative requirement may indicate surplus cash or the opportunity to repay debt.

Integrated example

Assume a firm has current sales of $1,000,000 and expects sales of $1,150,000. Cost of goods sold is forecast at 60% of sales, operating expenses at 22% of sales, interest at $24,000, and the tax rate at 25%.

Forecast cost of goods sold is $690,000 and operating expenses are $253,000. Operating profit is therefore $207,000. Profit before tax is $183,000, tax is $45,750, and forecast net income is $137,250. If the firm pays dividends of $40,000, retained earnings increase by $97,250.

The calculation is useful only if the assumptions are credible. For example, operating expenses may include a fixed salary component, so applying 22% to all sales could understate costs at lower sales volumes and overstate them at higher volumes.

4. External Financing Needs

Growth often requires investment in receivables, inventory, equipment and other assets before the resulting cash is collected. External financing needs (EFN) estimate the additional funds required from sources outside normal operations.

Under the percentage-of-sales framework, a commonly used expression is:

where:

• EFN = external financing needed;
• A₀ = assets that vary with sales in the base period;
• L₀ = spontaneous liabilities that vary with sales, such as trade payables and accruals;
• S₀ = base-period sales;
• ∆S = S₁ − S₀;
• S₁ = forecast sales;
• M = forecast profit margin, defined as net income ÷ sales;
• d = dividend payout ratio.

The first term represents additional assets, the second represents additional spontaneous financing, and the third represents retained earnings generated internally. The formula assumes proportional asset and liability relationships, a constant profit margin and payout policy, and no adjustment for financing costs caused by the new borrowing. If those assumptions are unrealistic, a full pro forma balance sheet is preferable.

Worked EFN example

Suppose base sales are $2,000,000, forecast sales are $2,400,000, assets that vary with sales are $1,200,000, spontaneous liabilities are $300,000, the net margin is 5%, and the payout ratio is 40%.

Here, ∆S is $400,000. Additional assets are:

($1,200,000 ÷ $2,000,000) × $400,000 = $240,000

Additional spontaneous liabilities are $60,000. Forecast retained earnings are:

$2,400,000 × 0.05 × (1 − 0.40) = $72,000

Thus:

EFN = $240,000 − $60,000 − $72,000 = $108,000

The firm must obtain approximately $108,000 externally, assuming the stated relationships hold. Management could reduce EFN by slowing growth, improving margins, reducing the payout ratio, accelerating receivable collection or increasing inventory efficiency. Each option has operational and stakeholder consequences.

5. Cash Budgets and Liquidity Planning

Profit is not the same as cash. A cash budget forecasts cash receipts, cash payments, financing and the resulting cash balance over a specified period. It is particularly important for a profitable growing firm, because sales on credit can create receivables before cash is collected.

A basic cash budget is:

The terms must refer to the same period and use cash amounts, not accrual revenue or expense.

Illustrative quarterly cash budget

Assume beginning cash is $30,000. Cash receipts are $180,000, cash operating payments are $145,000, a capital expenditure is $50,000, and the minimum desired cash balance is $25,000.

Before financing, ending cash is:

$30,000 + $180,000 − $145,000 − $50,000 = $15,000

Because the desired minimum is $25,000, borrowing of $10,000 is required. The final cash balance is $25,000. If the firm has a credit line, the budget should also show interest, borrowing limits, repayment terms and covenant requirements.

Cash budgets should incorporate collection lags, supplier payment terms, payroll dates, taxes, capital expenditure timing, loan repayments and unusual events. Monthly or weekly budgets may be necessary where cash flows are volatile. A rolling cash forecast is often more useful than a static annual estimate.

6. Break-Even and Operating Leverage Analysis

Break-even analysis examines the activity level at which total revenue equals total cost and operating profit is zero. Let Q be units sold, P selling price per unit, V variable cost per unit and F total fixed operating costs.

The contribution margin per unit is P − V. Setting operating profit to zero gives the break-even quantity:

This formula assumes a constant selling price and unit variable cost, fixed costs within the relevant range, and a single product or a constant sales mix. The break-even sales revenue is:

where:

Example

A product sells for $50, has a variable cost of $30, and annual fixed operating costs are $240,000. The contribution margin is $20 and the break-even quantity is:

Q_BE = $240,000 ÷ $20 = 12,000 units

Break-even revenue is $600,000. At 15,000 units, operating profit is:

15,000 × $20 − $240,000 = $60,000

The margin of safety in units is 3,000, or 20% of expected sales. The margin of safety ratio is:

Operating leverage measures sensitivity of operating profit to sales. At a given output level:

In the example, contribution margin is $300,000 and operating profit is $60,000, so DOL is 5. Approximately, a 1% change in sales produces a 5% change in operating profit, provided price, variable cost and fixed costs remain unchanged. High operating leverage magnifies both gains and losses and is therefore a risk consideration, not simply a measure of efficiency.

7. Sensitivity and Scenario Analysis

Sensitivity analysis changes one assumption at a time to identify which variables most affect an outcome. For example, management might assess the effect on net income of a 5% decrease in sales, a $2 increase in variable cost, or a 10-day increase in collection time.

Scenario analysis changes several related assumptions together. A reasonable set of scenarios might include:

Sensitivity analysis is transparent and easy to communicate, but it may ignore relationships among variables. Scenario analysis captures relationships but depends on judgment in constructing internally consistent scenarios. Probabilistic forecasting, using expected values or simulations, can represent a range of outcomes when probabilities are defensible.

Managers should test financial covenants, minimum cash balances, liquidity ratios and debt-service capacity—not only profit. A plan with attractive profit but inadequate cash may fail operationally.

8. Budgetary Control and Performance Evaluation

Budgetary control compares actual performance with planned performance, investigates material variances and supports corrective action. A useful control cycle is:

Figure: The budgetary control cycle links planning, operations, measurement and corrective action.

Variance analysis should distinguish price, volume, efficiency, mix and timing effects where relevant. A favourable variance is not automatically good: purchasing cheaper materials may reduce quality, and underspending on maintenance may create future failures. Likewise, an unfavourable variance may reflect a beneficial investment or an unexpected growth opportunity.

Responsibility accounting assigns revenues, costs or investments to managers who can meaningfully influence them. Controllable and uncontrollable factors should be distinguished, and performance measures should discourage manipulation. Beyond financial measures, organisations may monitor customer retention, product quality, employee safety, delivery reliability and environmental outcomes.

9. Governance, Ethics and Technology

Forecasts and budgets influence financing, compensation and resource allocation. Ethical risks include deliberately pessimistic forecasts to create easily achieved targets, optimistic forecasts to obtain funding, delaying expenses to meet a target, manipulating revenue recognition and hiding covenant risks. Effective governance requires documented assumptions, review by independent personnel, version control, audit trails and escalation of material uncertainties.

Spreadsheet models remain common but are vulnerable to formula errors, hard-coded assumptions, inconsistent versions and inadequate access controls. Good practice includes separating inputs, calculations and outputs; using clear labels and units; testing extreme cases; reconciling statements; protecting formulas; and retaining an audit trail.

Enterprise resource planning systems, business intelligence platforms and machine-learning tools can improve data integration and near-real-time forecasting. However, AI-generated forecasts may reproduce biased historical patterns, fail during structural change or present unjustified precision. Human review, explainability, data governance, privacy protection and scenario testing remain necessary. Technology supports judgment; it does not remove accountability.

10. Illustrative Case: Northlake Outdoor Equipment

Background

Northlake Outdoor Equipment, a fictional manufacturer, sells camping stoves for $80 each. Variable manufacturing and distribution cost is $48 per unit, and annual fixed operating cost is $640,000. Current annual sales are 30,000 units. Management is considering a marketing campaign expected to increase sales by 20%, but the campaign costs $120,000 annually. The campaign may also reduce the selling price to $78 through promotions.

Problem

Management must determine whether the proposal improves operating profit and whether the higher activity creates a financing and liquidity concern.

Analysis

Under the current plan, contribution per unit is $32 and operating profit is:

30,000 × $32 − $640,000 = $320,000

With the campaign, expected units are 36,000, price is $78, variable cost remains $48, and fixed costs become $760,000. Contribution per unit is $30 and operating profit is:

36,000 × $30 − $760,000 = $320,000

Thus, the base campaign estimate produces the same operating profit, not an improvement. The new break-even quantity is:

$760,000 ÷ $30 = 25,334 units approximately

The current break-even quantity is 20,000 units. The campaign increases operating leverage risk because fixed costs rise and contribution per unit falls.

A downside case of only 10% growth gives 33,000 units. Operating profit would be:

33,000 × $30 − $760,000 = $230,000

An upside case of 30% growth gives 39,000 units and operating profit of $410,000. Management should also examine receivable collection, inventory purchases and the timing of campaign payments. If the additional inventory must be purchased before customer cash is collected, the firm may require a short-term credit facility even where annual profit remains positive.

Approach and outcome

Northlake should not approve the campaign solely on the optimistic sales estimate. It should negotiate measurable campaign milestones, use a rolling cash forecast, establish an inventory limit and evaluate whether the price reduction is necessary. Approval may be appropriate if the downside case remains liquid and the campaign can be discontinued or scaled when evidence is unfavourable.

Learning points

The case demonstrates that revenue growth does not guarantee higher profit; fixed-cost commitments magnify risk; break-even analysis should be combined with cash planning; and scenario analysis is more informative than a single forecast.

Challenges and Limitations

Financial plans are limited by uncertain demand, structural economic changes, incomplete data and behavioural responses. Historical relationships may fail after a new competitor enters, technology changes production or customers alter purchasing patterns. Percentage-of-sales forecasts can ignore capacity constraints and nonlinear costs. Break-even analysis abstracts from competition, taxes, financing costs and multiple products. Budgets can become rigid and encourage short-term behaviour if managers are evaluated mechanically.

These limitations do not make planning unnecessary. They require multiple methods, explicit assumptions, frequent updates and managerial skepticism. A forecast should communicate both an estimate and the conditions under which that estimate is likely to be wrong.

Best-Practice Checklist

• Link forecasts to operational drivers rather than arbitrary percentages.
• Separate fixed, variable, mixed and step costs.
• Reconcile projected income statements, balance sheets and cash budgets.
• Distinguish accounting profit from cash availability.
• Test downside liquidity, covenant compliance and financing capacity.
• Use sensitivity and internally consistent scenario analysis.
• Assign responsibility for assumptions and variance investigation.
• Maintain model controls, documentation and version histories.
• Review forecasts continuously as information changes.
• Preserve integrity by reporting uncertainty and adverse information honestly.

Chapter Summary

Financial planning converts strategy into coordinated operating, investment and financing decisions. Forecasting begins with sales and operating assumptions, but credible forecasts must reflect cost behaviour, capacity, working-capital timing and uncertainty. Pro forma income statements estimate profitability; projected balance sheets show asset, liability and equity consequences; and cash budgets identify liquidity needs that accrual accounting may conceal.

The percentage-of-sales approach provides a convenient first estimate of external financing needs, although its proportionality assumptions must be tested. Break-even analysis identifies the activity level required to cover fixed and variable costs, while operating leverage explains why fixed costs magnify changes in operating profit. Sensitivity analysis changes one assumption at a time, whereas scenario analysis evaluates coherent combinations of assumptions.

Budgetary control closes the planning cycle by comparing actual results with expectations, investigating meaningful variances and taking corrective action. Effective control combines financial measures with operational, customer, quality and ethical considerations. Technology can improve integration and forecasting, but governance, human judgment, transparency and accountability remain essential.

Key Terms

Financial planning: The process of translating objectives into operating, investment and financing plans.

Forecast: A current estimate of likely future results.

Budget: An authorised plan specifying targets, resources and responsibilities.

Pro forma statement: A projected financial statement prepared from stated assumptions.

Cash budget: A schedule of expected cash receipts, payments, borrowing and repayment.

Percentage-of-sales method: A forecasting approach that assumes selected items vary in proportion to sales.

Spontaneous liability: A liability that increases naturally with operations, such as trade payables.

External financing needed: Funds required from outside the firm to support projected operations and growth.

Retained earnings: Cumulative profits retained in the business after dividends.

Working capital: Current operating assets less current operating liabilities.

Fixed cost: A cost that remains constant within a relevant operating range.

Variable cost: A cost that changes with the level of activity.

Contribution margin: Sales less variable costs.

Break-even point: The activity level at which operating profit is zero.

Margin of safety: The excess of expected activity over break-even activity.

Operating leverage: The sensitivity of operating profit to changes in sales.

Sensitivity analysis: Analysis that changes one assumption while holding others constant.

Scenario analysis: Analysis of outcomes under coherent combinations of assumptions.

Variance analysis: Investigation of differences between actual and budgeted results.

Responsibility accounting: Assignment of performance measures to managers who can influence them.

Review Questions

Short Answer Questions

1. Distinguish a forecast from a budget.
2. Why can a profitable firm experience a cash shortage?
3. Define spontaneous liabilities and give two examples.
4. State the assumptions underlying the basic break-even formula.
5. What is the purpose of variance analysis?

Long Answer Questions

1. Explain the stages of an integrated financial planning process.
2. Discuss the advantages and limitations of the percentage-of-sales method.
3. Explain how pro forma income statements, balance sheets and cash budgets are interconnected.
4. Compare sensitivity analysis with scenario analysis and identify appropriate uses for each.
5. Discuss ethical risks in forecasting and the controls that can reduce them.

Analytical / Application Questions

1. A firm sells a product for $75, has variable cost of $45 per unit and fixed costs of $450,000. Calculate break-even units and operating profit at 20,000 units. Interpret the result.
2. Base sales are $1,500,000 and forecast sales are $1,800,000. Assets that vary with sales are $900,000, spontaneous liabilities are $225,000, net margin is 6% and payout ratio is 30%. Estimate external financing needed using the percentage-of-sales approach.
3. Design downside, base and upside scenarios for a retailer facing uncertain sales growth, gross margin and collection periods. Explain which operating and liquidity measures should be monitored in each scenario.

Multiple Choice Questions with Answers

Question 1

A forecast is best described as:

A. A legally binding promise of future results

B. Management’s current best estimate of likely future results

C. A record of prior-period transactions

D. A fixed accounting identity

Correct Answer: B. Management’s current best estimate of likely future results

Question 2

If sales rise from $800,000 to $920,000, the growth rate is:

A. 10%

B. 12%

C. 15%

D. 20%

Correct Answer: C. 15%

Question 3

Which item is normally a spontaneous liability?

A. Trade payable

B. Long-term bond issued

C. Common share capital

D. Machinery

Correct Answer: A. Trade payable

Question 4

A product sells for $50, variable cost is $30 and fixed costs are $240,000. Break-even volume is:

A. 8,000 units

B. 10,000 units

C. 12,000 units

D. 15,000 units

Correct Answer: C. 12,000 units

Question 5

In a cash budget, which item is treated as a cash receipt when collected?

A. Depreciation expense

B. Credit sales at the date of sale

C. Collection from customers

D. Increase in retained earnings

Correct Answer: C. Collection from customers

Question 6

If contribution margin is $300,000 and operating profit is $60,000, degree of operating leverage is:

A. 0.2

B. 2

C. 5

D. 6

Correct Answer: C. 5

Question 7

Sensitivity analysis normally:

A. Changes one assumption while holding other assumptions constant

B. Eliminates all forecasting uncertainty

C. Changes several assumptions without documenting them

D. Uses only historical accounting entries

Correct Answer: A. Changes one assumption while holding other assumptions constant

Question 8

If assets increase by $240,000, spontaneous liabilities increase by $60,000 and retained earnings increase by $72,000, external financing needed is:

A. $108,000

B. $168,000

C. $252,000

D. $372,000

Correct Answer: A. $108,000

Question 9

Which statement about a favourable budget variance is correct?

A. It is always evidence of superior performance

B. It may require investigation because underspending can reduce quality or maintenance

C. It must be ignored if profit is positive

D. It automatically increases cash

Correct Answer: B. It may require investigation because underspending can reduce quality or maintenance

Question 10

The accounting identity that a projected balance sheet must satisfy is:

A. Assets = Revenue − Expenses

B. Assets = Liabilities + Equity

C. Cash = Profit + Dividends

D. Equity = Assets + Liabilities

Correct Answer: B. Assets = Liabilities + Equity