Financial Planning, Forecasting and Control

Introduction and Context

Financial management is not limited to raising funds and selecting investments. Managers must also determine what resources the organisation will require, when cash will be needed, how results will be monitored, and what corrective action is appropriate. Financial planning connects strategy with quantified expectations. Forecasting estimates likely future outcomes; budgeting authorises planned actions; financial control compares actual performance with plans and explains deviations.

These activities are especially important because profitability does not guarantee liquidity. A growing business may report accounting profits while experiencing cash shortages because it must finance inventory, receivables, capital expenditure, or debt repayments. Effective planning therefore integrates the income statement, statement of financial position, cash flows, financing policy, performance measures and risk analysis.

Learning Objectives

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

1. Explain the relationship between financial planning, forecasting, budgeting and control.
2. Prepare sales, operating and cash forecasts.
3. Construct a cash budget and identify financing surpluses or deficits.
4. Prepare pro forma financial statements using appropriate assumptions.
5. Estimate external financing requirements.
6. Apply variance analysis, dashboards and key performance indicators.
7. Calculate sustainable growth and interpret value-based performance measures.
8. Evaluate the behavioural, ethical and technological issues associated with financial control.

1. The Financial Planning System

A financial plan translates strategic intentions into expected revenues, costs, assets, liabilities, financing and cash flows. It normally covers several time horizons:

Planning is forward-looking, whereas control is both diagnostic and corrective. The planning and control cycle is continuous:

Figure: The financial planning and control cycle.

A plan is useful only when assumptions are explicit. Important assumptions include expected volume, price, collection patterns, supplier credit, wage rates, tax payments, capital expenditure, depreciation, dividend policy, interest rates and minimum cash balances. Sensitivity and scenario analysis should be used where uncertainty is material.

2. Forecasting Approaches

A forecast is an estimate of what is likely to occur, not a target or a guarantee. A budget is an authorised plan, while a target may represent a desired level of performance. Confusing these concepts can encourage unrealistic reporting or dysfunctional behaviour.

2.1 Qualitative and quantitative methods

Qualitative methods use expert judgement, customer interviews, sales-force opinions and management consensus. They are useful when products are new or historical data are weak. Quantitative methods use historical relationships, statistical models and operational drivers. Good practice combines both and requires managers to document significant judgemental adjustments.

2.2 Percentage-of-sales method

The percentage-of-sales method assumes that selected income-statement items, assets and spontaneous liabilities vary in a stable proportion to sales. If an item is expected to remain at proportion a of sales, its forecast value is:

where X₁ is the forecast item, a is the historical ratio, and S₁ is forecast sales. The method is simple but inappropriate when capacity, economies of scale, inflation, fixed costs or working-capital policy change substantially.

2.3 Driver-based forecasting

Driver-based models identify operational causes of financial outcomes. Revenue may be forecast as customers × purchase frequency × average order value. Labour cost may depend on production hours × wage rate. Receivables may depend on credit sales and collection days. This approach improves accountability because managers can connect financial results with controllable activities.

3. The Cash Budget

The cash budget forecasts cash receipts, cash payments and the resulting financing requirement for each period. It is a liquidity tool, not a measure of profit.

The equation assumes that all relevant cash movements are included and that the period’s opening balance is known. If management requires a minimum cash balance C_min, the borrowing required before financing is:

If the unfinanced balance exceeds the minimum, the firm may repay debt or invest the surplus, subject to contractual and policy constraints.

Worked Example 1: Monthly cash budget

Illustrative Company expects the following cash sales and collections from credit sales:

The opening January cash balance is 12,000 and the minimum desired balance is 10,000. Assume no financing at the beginning of January.

January ending cash before financing is 12,000 + 50,000 − 56,000 = 6,000. Required borrowing is 10,000 − 6,000 = 4,000, producing an ending balance of 10,000.

February ending cash before financing is 10,000 + 58,000 − 61,000 = 7,000. A further 3,000 is required. March ending cash before financing is 10,000 + 66,000 − 70,000 = 6,000, requiring another 4,000. Total additional borrowing during the three months is 11,000. Interest, transaction costs and repayment terms would need to be added in a full financing plan.

A cash budget should distinguish operating receipts and payments from investing and financing flows. Non-cash expenses such as depreciation are excluded from cash payments, although depreciation affects taxable profit and therefore may indirectly affect cash taxes.

4. Pro Forma Financial Statements

Pro forma statements estimate future financial position and performance under stated assumptions. They help managers assess profitability, liquidity, leverage and financing needs.

4.1 Pro forma income statement

A forecast income statement begins with sales and applies assumptions about variable costs, fixed costs, depreciation, interest and tax. For example:

where EBIT is earnings before interest and tax. If interest expense is I and the tax rate is T, with positive taxable income, then:

This simplified equation assumes no unusual items, tax-loss carryforwards or differing tax treatments.

4.2 Pro forma statement of financial position

A forecast statement of financial position must satisfy:

The balancing figure is often called external financing required (EFR), but it should not be treated as a residual without considering the firm’s financing policy. If forecast assets exceed forecast liabilities and internally generated equity, EFR is positive. If the reverse occurs, the firm may have excess financing capacity.

4.3 Retained earnings and dividends

Forecast retained earnings are calculated as:

where RE₀ and RE₁ are opening and closing retained earnings. The equation assumes dividends are recognised in the period and that no direct equity adjustments are included.

5. External Financing Requirements

The external financing requirement estimates the funds that must be obtained from lenders or investors to support planned growth. A commonly used percentage-of-sales expression is:

where A* is assets that increase with sales, L* is spontaneous liabilities that increase with sales, S₀ is current sales, ∆S is the change in sales, M is the profit margin, S₁ is forecast sales, and RR is the retention ratio. The formula assumes proportional asset and liability relationships, a constant profit margin and a constant retention ratio.

The first term represents additional assets required. The second represents financing supplied automatically by trade payables and accruals. The third represents internally generated retained earnings. The formula should be adjusted for excess capacity, step costs, changes in working-capital policy, inflation and financing costs.

Worked Example 2: EFR

A company has current sales of 500,000 and forecasts sales of 600,000. Assets that vary with sales equal 400,000, spontaneous liabilities equal 100,000, the profit margin is 6%, and the retention ratio is 60%.

The sales increase is 100,000. Additional assets required are:

(400,000 ÷ 500,000) × 100,000 = 80,000

Spontaneous financing is:

(100,000 ÷ 500,000) × 100,000 = 20,000

Retained earnings generated are:

0.06 × 600,000 × 0.60 = 21,600

Therefore:

EFR = 80,000 − 20,000 − 21,600 = 38,400

The company requires approximately 38,400 of additional external finance, assuming the stated relationships remain valid.

6. Variance Analysis and Financial Control

Variance analysis compares actual results with a benchmark. The benchmark may be the original budget, a flexible budget adjusted for actual activity, a prior period, or an external benchmark. A variance is not automatically good or bad: its significance depends on cause, controllability, persistence and impact on other objectives.

For a cost item, a basic price variance is:

A quantity or efficiency variance is:

A positive cost variance conventionally indicates an unfavourable outcome when actual cost exceeds standard cost; organisations must state their sign convention clearly. The formulas assume separable price and quantity effects and a reliable standard.

For sales, managers may analyse price and volume effects. A contribution-based volume variance can be expressed as:

Flexible budgets are preferable when actual output differs materially from planned output. A static budget may label a volume-driven cost increase as inefficiency even when cost per unit was controlled.

Effective control follows a sequence: identify material deviations, investigate causes, assign responsibility, assess consequences, agree corrective action, and monitor whether the action works. Overly frequent or poorly designed variance reports can produce short-term decisions, inventory manipulation, delayed maintenance and other dysfunctional behaviour.

7. Dashboards and Key Performance Indicators

A dashboard presents selected financial and non-financial indicators in a form that supports timely decisions. It should not become a crowded collection of metrics. Each KPI requires a precise definition, data owner, reporting frequency, target, tolerance and escalation rule.

A KPI should be strategically connected. For example, reducing delivery time may improve customer retention, but expediting every order may reduce operating margin. Balanced measurement reduces the risk that managers optimise one indicator at the expense of organisational value.

8. Sustainable Growth and Value-Based Measures

Sustainable growth concerns the rate at which a firm can grow without changing its operating and financial policies or issuing new equity. A common expression is:

where g is sustainable growth, ROE is return on equity, and b is the retention ratio. Since b = 1 − dividend payout ratio, the formula assumes constant profitability, asset efficiency, leverage, dividend policy and no new external equity.

Using the DuPont relationship:

ROE can be decomposed into profit margin, total asset turnover and financial leverage. This decomposition helps determine whether growth is supported by improved margins, better asset utilisation or greater leverage.

Value-based performance measures focus on returns above the cost of capital. Net operating profit after tax is:

Economic value added is commonly expressed as:

where WACC is the weighted average cost of capital. Positive EVA indicates that operating returns exceed the capital charge, subject to consistent measurement of operating profit and invested capital. EVA is not identical to accounting profit and may require adjustments for items such as capitalised development expenditure or unusual accounting treatments.

Return on invested capital is:

Value creation generally requires ROIC > WACC, although managers must also consider risk, duration, growth quality and cash-flow sustainability.

9. Integrated Illustrative Case

Background

Riverbend Foods, an illustrative mid-sized manufacturer, expects sales to rise from 2.0 million to 2.4 million next year. It has limited cash reserves and plans to introduce a product line requiring additional inventory and receivables.

Problem

Management prepared a profit forecast but did not prepare a monthly cash budget. The board is concerned that growth may create a liquidity crisis and that the proposed performance dashboard focuses only on sales.

Analysis

The finance team forecasts credit sales, collection delays, supplier payment terms, inventory purchases, payroll, capital expenditure, tax and debt service by month. It prepares a flexible budget based on actual production volume and separates price, volume and efficiency variances. It also calculates EFR using revised working-capital ratios rather than assuming that all assets rise proportionally with sales.

The team recommends KPIs covering gross margin, operating cash flow, receivable days, inventory days, on-time delivery, defect rate and ROIC. A minimum cash balance is established, with escalation when projected cash falls below that threshold. Scenario analysis tests a 10% sales shortfall, slower collections and a 15% increase in raw-material prices.

Approach and solution

Management chooses a combination of a committed revolving credit facility and tighter credit controls. Sales growth is approved only when contribution margins and cash conversion remain within agreed limits. Monthly forecasts are updated using a rolling twelve-month horizon. Variances are investigated by accountable managers rather than automatically penalised.

Outcome

The analysis shows that the business is profitable under the base case but requires temporary borrowing during the inventory build-up. Under the adverse collection scenario, the existing facility is insufficient. Management therefore delays part of the capital expenditure, renegotiates supplier terms and strengthens credit approval before launching the product line.

Learning points

1. Profit forecasts cannot substitute for cash budgets.
2. Growth consumes cash when receivables and inventory rise.
3. Flexible budgets improve diagnosis when activity changes.
4. Dashboards should combine financial, operational and value measures.
5. Scenario analysis reveals financing risk that a single forecast can hide.

10. Governance, Ethics, Technology and Limitations

Financial forecasts influence lending, investment, compensation and employment decisions. Managers therefore have a duty to present assumptions honestly, distinguish estimates from commitments, and avoid manipulating forecasts to obtain financing or bonuses. Controls should protect confidential data, prevent unauthorised changes and preserve an audit trail.

Spreadsheet models are flexible but vulnerable to formula errors, inconsistent versions and hidden assumptions. Organisations should use documented model structures, input controls, independent review, version management and reconciliation to accounting records. Enterprise planning systems can automate data collection and scenario analysis, but automation does not remove the need for professional judgement.

Artificial intelligence can assist with anomaly detection, demand forecasting and narrative variance commentary. However, historical data may encode bias, unusual events may be misinterpreted, and generated explanations may be inaccurate. Human review, access controls, explainability and validation against actual outcomes are essential. Sensitive financial data should not be transferred to unauthorised tools.

Forecasts are inherently uncertain. A model may fail because relationships change, data are incomplete, managers respond strategically, or an external shock occurs. Best practice is therefore not to seek false precision but to combine a documented base case with sensitivity analysis, alternative scenarios, ranges and clear decision triggers.

Chapter Summary

Financial planning translates strategy into quantified expectations for sales, costs, assets, financing and cash. Forecasting estimates likely outcomes, budgeting authorises a plan, and control compares actual results with appropriate benchmarks. Cash budgets reveal timing-based liquidity needs, while pro forma statements show the expected effects on profitability and financial position. External financing requirements can be estimated from asset growth, spontaneous liabilities and retained earnings, but the result depends on explicit assumptions.

Variance analysis is most useful when it distinguishes price, volume and efficiency effects and uses flexible budgets where activity changes. Dashboards should combine financial, customer, operational, people and value indicators. Sustainable growth links ROE with earnings retention, while EVA and ROIC assess whether returns exceed the cost of capital. Ethical governance, model validation, scenario analysis and responsible technology use are necessary for reliable financial decision-making.

Key Terms

Financial plan: A quantified representation of an organisation’s strategic and operating intentions.

Forecast: An estimate of likely future results.

Budget: An authorised plan for resource use and performance.

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

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

External financing required: Funds needed from outside the firm to support planned operations or growth.

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

Retention ratio: The proportion of earnings retained rather than distributed as dividends.

Flexible budget: A budget adjusted to the actual level of activity.

Variance: The difference between actual and benchmark performance.

Price variance: The cost difference caused by paying a price different from standard.

Efficiency variance: The cost difference caused by using more or fewer inputs than standard.

Key performance indicator: A defined measure used to monitor strategically important performance.

Rolling forecast: A forecast continuously extended as the latest period is completed.

Sustainable growth: Growth achievable under unchanged operating, financing and dividend policies.

ROE: Return on equity, measuring earnings relative to shareholders’ equity.

ROIC: Return on invested capital, measuring operating returns on capital employed.

WACC: Weighted average cost of capital.

EVA: Economic value added, or NOPAT less a capital charge.

Scenario analysis: Examination of outcomes under alternative assumptions.

Review Questions

5 Short Answer Questions

1. Distinguish between a forecast, a budget and a target.
2. Why can a profitable business experience a cash shortage?
3. What is the purpose of a flexible budget?
4. Define external financing required.
5. State two limitations of the percentage-of-sales method.

5 Long Answer Questions

1. Explain how strategic planning, forecasting, budgeting and control form an integrated cycle.
2. Describe the preparation of a monthly cash budget and explain how a minimum cash balance affects borrowing decisions.
3. Explain the assumptions and limitations of the external financing requirement formula.
4. Discuss how dashboards can combine financial and non-financial KPIs without encouraging dysfunctional behaviour.
5. Compare accounting profit measures with EVA and ROIC as measures of value creation.

3 Analytical / Application Questions

1. A firm forecasts sales of 900,000, up from 750,000. Variable assets are 60% of current sales, spontaneous liabilities are 12% of current sales, the profit margin is 5%, and the retention ratio is 70%. Calculate the estimated EFR and explain two reasons why the result may differ from the firm’s actual financing need.
2. Actual material usage is 5,400 kilograms at 4.20 per kilogram. The standard allowed for actual output is 5,000 kilograms at a standard price of 4.00. Calculate the price and quantity variances and interpret them using a clearly stated sign convention.
3. A company has ROE of 16% and retains 45% of earnings. Calculate sustainable growth, then evaluate whether growth at 10% is consistent with the stated assumptions. Identify two assumptions that should be stress-tested before approving the plan.

Multiple Choice Questions with Answers

Question 1

Which item is normally excluded from a cash budget because it is non-cash?

A. Depreciation expense

B. Supplier payment

C. Cash wages

D. Loan repayment

Correct Answer: A. Depreciation expense

Question 2

A company has beginning cash of 12,000, receipts of 50,000 and payments of 56,000. If its minimum cash balance is 10,000, how much must it borrow?

A. 2,000

B. 4,000

C. 6,000

D. 10,000

Correct Answer: B. 4,000

Question 3

Using the chapter’s EFR assumptions, which item provides internal financing for growth?

A. Additional fixed assets

B. Spontaneous liabilities

C. Retained earnings

D. Higher receivables

Correct Answer: C. Retained earnings

Question 4

A flexible budget is especially useful when:

A. Actual activity differs from planned activity

B. All costs are fixed

C. No variance analysis is required

D. The firm has no operating data

Correct Answer: A. Actual activity differs from planned activity

Question 5

If EBIT is 100,000 and the tax rate is 25%, with no other adjustments, NOPAT is:

A. 25,000

B. 75,000

C. 100,000

D. 125,000

Correct Answer: B. 75,000

Question 6

Sustainable growth is commonly calculated as:

A. ROE × retention ratio

B. ROE ÷ retention ratio

C. ROIC × payout ratio

D. WACC × dividend yield

Correct Answer: A. ROE × retention ratio

Question 7

Positive EVA generally indicates that:

A. Sales exceed assets

B. Operating returns exceed the capital charge

C. Dividends exceed earnings

D. Cash is always positive

Correct Answer: B. Operating returns exceed the capital charge

Question 8

Receivable days primarily measure:

A. The speed of inventory production

B. The average time taken to collect credit sales

C. The cost of equity

D. The level of depreciation

Correct Answer: B. The average time taken to collect credit sales

Question 9

If actual material price exceeds standard price, the price variance for a cost is generally:

A. Favourable

B. Unfavourable

C. Zero

D. A volume variance

Correct Answer: B. Unfavourable

Question 10

Which practice best improves the reliability of an automated financial forecast?

A. Removing human review

B. Using undocumented assumptions

C. Validating outputs against actual outcomes

D. Allowing unrestricted model changes

Correct Answer: C. Validating outputs against actual outcomes