Advanced financial analysis · Beyond the IB course

Integrated forecast

Will the plan make a profit, and can the business pay for it, year by year?

Back to 3.4 Final accounts Also for 3.7 Cash flow, 3.5 Profitability and liquidity ratio analysis and 3.6 Efficiency ratio analysis (HL)

  • Beyond the IB course
  • Builds on IB 3.4, 3.5, 3.6, 3.7
  • Undergraduate, MBA, professional and teacher
  • Simulated data Example: Emberly Roasters, fictional

The forecast

Example figures: Emberly Roasters, a fictional business. Simulated data.

Sales
Sales
From year two. Negative for a fall.
Costs
Costs
Every cost that rises with each unit; the forecast treats it as cost of sales.
Wages, rent and other overheads, before depreciation.
Applied to the variable cost per unit and to the fixed costs.
Investment and depreciation
Investment and depreciation
Straight line, a full year’s charge in the year of purchase.
Working capital
Working capital
Year-end debtors = sales revenue × days ÷ 365.
Year-end stock = cost of sales × days ÷ 365.
Year-end creditors = cost of sales × days ÷ 365.
Interest, tax and dividends
Interest, tax and dividends
On the borrowing and any overdraft at the start of each year.
On profit before tax; none on a loss.
The opening position
The opening position
Every loan, short or long term, except an overdraft.

At the start of the first year. Retained earnings are whatever makes the opening position balance.

Scenarios

Each scenario moves the base case’s drivers: per cent changes, and percentage points for growth.

Upside
Downside
Two strategic alternatives

Each alternative changes the year-one drivers, in year-one prices, and may invest and borrow in the first year.

Alternative A
Depreciated over the life of new assets.
Negative for a saving.
Negative for a saving.
Alternative B
Depreciated over the life of new assets.
Negative for a saving.
Negative for a saving.
Currency

Emberly Roasters’s figures are in dollars.

The drivers and the opening position

Years
5, from 2026
Units sold in year one
43,200
Growth in units, a year
4%
Selling price per unit, year one
$24
Price rise, a year
2%
Variable cost per unit, year one
$14.40
Fixed costs, year one
$348,000
Cost inflation, a year
2.50%
Capital expenditure, each year
$15,000
Life of new assets, years
8
Years left in the assets owned now
10
Debtor days
37
Stock days
45
Creditor days
49
Interest rate
6%
Borrowing repaid each year
$40,200
Tax rate
25%
Dividends, share of profit
35%
Opening: non-current assets (net book value)
$358,000
Opening: stock
$66,800
Opening: debtors
$97,300
Opening: cash (negative if overdrawn)
$8,400
Opening: trade creditors
$72,600
Opening: borrowings
$201,000
Opening: share capital
$100,000
Upside: units sold
+3%
Upside: growth in units, percentage points
+1.5 points
Upside: selling price
+1%
Upside: variable cost per unit
0%
Upside: fixed costs
0%
Downside: units sold
−5%
Downside: growth in units, percentage points
−2 points
Downside: selling price
−1%
Downside: variable cost per unit
+1%
Downside: fixed costs
0%
Alternative A
Automate the packing
Automate the packing: investment in year one
$180,000
Automate the packing: new borrowing in year one
$150,000
Automate the packing: change in variable cost per unit
−$1.10
Automate the packing: change in fixed costs, a year
$9,000
Automate the packing: change in units sold
0%
Alternative B
Outsource the packing
Outsource the packing: investment in year one
$0
Outsource the packing: new borrowing in year one
$0
Outsource the packing: change in variable cost per unit
$0.50
Outsource the packing: change in fixed costs, a year
−$40,800
Outsource the packing: change in units sold
0%

Changing these figures needs JavaScript. With it switched off, the page shows the full worked example for the figures above.

Your figures are kept in this browser once you change them. Nothing is sent anywhere.

Result

Scenario
Option

These results are for the last complete figures. Correct the figure marked in the inputs to update them.

Showing the Base case: Making no change.

Lowest year-end cash

−$14,425

an overdraft at the end of 2027; overdrawn at 4 of 5 year-ends

Profit for the year, 2026
$12,7392030: $58,575
Profit over 5 years
$172,806
Cash at the end of 2030
$19,054in the bank
Net cash at the end of 2030
$19,054cash less borrowing and any overdraft
ROCE, 2030 IB
21.8%the IB’s formula, on closing capital employed
Balance check
Balances every yearassets − liabilities = equity

Section 01: The three statements

The statement of profit or loss, the statement of cash flows and the statement of financial position for the case in view, linked year by year.

Statement of profit or loss for each year ended 31 December, Base case: Making no change
$20262027202820292030
Sales revenue1,036,8001,099,8371,166,7231,237,6891,312,977
Cost of sales (variable costs)(622,080)(663,137)(706,949)(753,693)(803,049)
Gross profit414,720436,700459,774483,996509,928
Fixed costs(348,000)(356,700)(365,618)(374,758)(384,127)
Depreciation(37,675)(39,550)(41,425)(43,300)(45,175)
Profit before interest and tax29,04540,45052,73165,93880,626
Interest(12,060)(10,106)(8,102)(5,589)(2,526)
Profit before tax16,98530,34444,62960,34978,100
Tax(4,246)(7,586)(11,157)(15,087)(19,525)
Profit for the year12,73922,75833,47245,26258,575
Dividends(4,459)(7,965)(11,715)(15,842)(20,501)
Retained profit8,28014,79321,75729,42038,074
Statement of cash flows for each year, built from the profit (the indirect method), Base case: Making no change
$20262027202820292030
Cash flows from operating activities
Profit for the year12,73922,75833,47245,26258,575
Add back depreciation37,67539,55041,42543,30045,175
(Increase) or decrease in stock(9,895)(5,062)(5,401)(5,763)(6,085)
(Increase) or decrease in debtors(7,800)(6,390)(6,781)(7,193)(7,632)
Increase or (decrease) in trade creditors10,9125,5125,8816,2766,626
Net cash from operating activities43,63156,36868,59681,88296,659
Cash flows from investing activities
Purchase of non-current assets(15,000)(15,000)(15,000)(15,000)(15,000)
Net cash used in investing activities(15,000)(15,000)(15,000)(15,000)(15,000)
Cash flows from financing activities
New borrowing00000
Borrowing repaid(40,200)(40,200)(40,200)(40,200)(40,200)
Dividends paid(4,459)(7,965)(11,715)(15,842)(20,501)
Net cash from financing activities(44,659)(48,165)(51,915)(56,042)(60,701)
Net change in cash(16,028)(6,797)1,68110,84020,958
Cash at the start of the year8,400(7,628)(14,425)(12,744)(1,904)
Cash at the end of the year(7,628)(14,425)(12,744)(1,904)19,054

Negative figures in brackets, as in the guide’s layouts. Interest and tax are paid in the year they are charged, so they sit inside the profit for the year; a published statement of cash flows would show them on lines of their own.

Statement of financial position at the start and at 31 December each year, Base case: Making no change
$Start of 202620262027202820292030
Non-current assets (net book value)358,000335,325310,775284,350256,050225,875
Current assets
Cash8,400000019,054
Debtors97,300105,100111,490118,271125,464133,096
Stock66,80076,69581,75787,15892,92199,006
Total current assets172,500181,795193,247205,429218,385251,156
Total assets530,500517,120504,022489,779474,435477,031
Current liabilities
Bank overdraft07,62814,42512,7441,9040
Trade creditors72,60083,51289,02494,905101,181107,807
Total current liabilities72,60091,140103,449107,649103,085107,807
Non-current liabilities: borrowings201,000160,800120,60080,40040,2000
Total liabilities273,600251,940224,049188,049143,285107,807
Net assets256,900265,180279,973301,730331,150369,224
Equity
Share capital100,000100,000100,000100,000100,000100,000
Retained earnings156,900165,180179,973201,730231,150269,224
Total equity256,900265,180279,973301,730331,150369,224

Section 02: Measures year by year

The IB’s ratios where the course has them, and measures beyond it, for the case in view.

Measures for each year, Base case: Making no change
Measure20262027202820292030
Units sold43,20044,92846,72548,59450,538
Gross margin40.0%39.7%39.4%39.1%38.8%
Profit margin (IB 3.5)2.8%3.7%4.5%5.3%6.1%
ROCE (IB 3.5)6.8%10.1%13.8%17.8%21.8%
Gearing (IB 3.6, HL)37.7%30.1%21.0%10.8%0.0%
Current ratio (IB 3.5)1.991.871.912.122.33
Interest cover2.4 times4.0 times6.5 times11.8 times31.9 times
Break-even units, before interest40,17540,76741,36741,97442,548
Degree of operating leverage14.2810.808.727.346.32
Net debt (negative: net cash)$168,428$135,025$93,144$42,104−$19,054

Section 03: Base, upside and downside

The same plan with the drivers moved: how far profit and cash move with them, for the option in view.

Each scenario (Making no change)
MeasureBase caseUpsideDownside
Sales revenue, 2030$1,312,977$1,446,428$1,142,560
Profit for the year, 2026$12,739$30,079−$19,347
Profit for the year, 2030$58,575$104,107−$9,777
Profit over 5 years$172,806$327,416−$74,238
Lowest year-end cash−$14,425 (2027)−$389 (2026)−$151,221 (2030)
Cash at the end of 2030$19,054$106,821−$151,221
Net debt at the end of 2030 (negative: net cash)−$19,054−$106,821$151,221
ROCE, 203021.8%30.1%0.1%
Year-end cash in each scenario (Making no change)Base case: 2026 −$7,628, 2027 −$14,425, 2028 −$12,744, 2029 −$1,904, 2030 $19,054. Upside: 2026 −$389, 2027 $6,282, 2028 $25,792, 2029 $58,857, 2030 $106,821. Downside: 2026 −$29,279, 2027 −$65,735, 2028 −$98,487, 2029 −$127,236, 2030 −$151,221. Below zero the business is overdrawn.Base caseUpsideDownside−$200k−$100k$0$100k$200kOverdrawn20262027202820292030Year-end cash (below zero: an overdraft)Base case, end of 2026: −$7,628Base case, end of 2027: −$14,425Base case, end of 2028: −$12,744Base case, end of 2029: −$1,904Base case, end of 2030: $19,054Upside, end of 2026: −$389Upside, end of 2027: $6,282Upside, end of 2028: $25,792Upside, end of 2029: $58,857Upside, end of 2030: $106,821Downside, end of 2026: −$29,279Downside, end of 2027: −$65,735Downside, end of 2028: −$98,487Downside, end of 2029: −$127,236Downside, end of 2030: −$151,221
Chart Year-end cash in the base case, the upside and the downside. Below the zero line the business is overdrawn and is borrowing from the bank.
The chart’s figures as a table
Year-end cash in each scenario
YearBase caseUpsideDownside
2026−$7,628−$389−$29,279
2027−$14,425$6,282−$65,735
2028−$12,744$25,792−$98,487
2029−$1,904$58,857−$127,236
2030$19,054$106,821−$151,221

Reading. Profit over the 5 years is −$74,238 in the downside, $172,806 in the base case and $327,416 in the upside. The swing is wide because the margin is thin: in 2026 the base case’s degree of operating leverage is 14.3, so a 1% change in units sold, at the same prices and costs, moves profit before interest and tax by about 14.3%. In the downside the overdraft reaches $151,221 at the end of 2030: the size of the facility, or the new finance, the plan would need if things go badly. Scenarios are not predictions: they show how far the result moves when the drivers do, so the board knows which assumptions the plan depends on.

Section 04: Two strategic alternatives, side by side

Each alternative run through every statement, then every scenario with every option.

Each option (Base case)
MeasureMaking no changeAutomate the packingOutsource the packing
Investment in 2026$0$180,000$0
Break-even units, 202640,17538,98937,899
Operating leverage, 202614.2810.268.15
Profit for the year, 2026$12,739$18,004$27,139
Profit for the year, 2030$58,575$73,448$71,212
Profit over 5 years$172,806$223,903$242,787
Lowest year-end cash−$14,425 (2027)−$12,225 (2026)$1,969 (2026)
Net debt at the end of 2030 (negative: net cash)−$19,054$15,904−$64,852
ROCE, 203021.8%19.8%23.5%
Profit for the year under each option (Base case)Making no change: 2026 $12,739, 2027 $22,758, 2028 $33,472, 2029 $45,262, 2030 $58,575. Automate the packing: 2026 $18,004, 2027 $30,083, 2028 $44,056, 2029 $58,312, 2030 $73,448. Outsource the packing: 2026 $27,139, 2027 $37,281, 2028 $48,048, 2029 $59,107, 2030 $71,212.Making no changeAutomate the packingOutsource the packing$0$20k$40k$60k$80k20262027202820292030Profit for the yearMaking no change, 2026: profit $12,739Making no change, 2027: profit $22,758Making no change, 2028: profit $33,472Making no change, 2029: profit $45,262Making no change, 2030: profit $58,575Automate the packing, 2026: profit $18,004Automate the packing, 2027: profit $30,083Automate the packing, 2028: profit $44,056Automate the packing, 2029: profit $58,312Automate the packing, 2030: profit $73,448Outsource the packing, 2026: profit $27,139Outsource the packing, 2027: profit $37,281Outsource the packing, 2028: profit $48,048Outsource the packing, 2029: profit $59,107Outsource the packing, 2030: profit $71,212
Chart Profit for the year under each option. Where two lines cross, the option with the lower variable cost has caught up with the one with the lower fixed costs.
The chart’s figures as a table
Profit for the year under each option
YearMaking no changeAutomate the packingOutsource the packing
2026$12,739$18,004$27,139
2027$22,758$30,083$37,281
2028$33,472$44,056$48,048
2029$45,262$58,312$59,107
2030$58,575$73,448$71,212

Reading. Base case: the most profit over the 5 years comes from Outsource the packing, $242,787, against $223,903 (Automate the packing) and $172,806 (Making no change). But Automate the packing earns the most in 2030 ($73,448, against $71,212): it is catching up, and over a longer horizon the order could change. Automate the packing needs $180,000 in 2026, $150,000 of it borrowed; its net debt at the end of 2030 is $15,904. Outsource the packing puts the least strain on cash: its lowest year-end balance is $1,969.

Every scenario with every option

Profit over 5 years, every scenario with every option
OptionBase caseUpsideDownside
Making no change$172,806$327,416−$74,238
Automate the packing$223,903$389,871−$23,728
Outsource the packing$242,787$390,009$29,224

Reading. On profit over the whole forecast, Outsource the packing comes first in every scenario: a choice that wins whichever way the drivers move is robust. Its narrowest lead is in the upside, $138 over Automate the packing, so a small change in the drivers could reverse it.

Section 05: What it means

For the case in view: the reading, then what a forecast like this cannot tell you.

The reading

In the case shown (Base case: Making no change), sales revenue moves from $1,036,800 in 2026 to $1,312,977 in 2030, and the profit for the year from $12,739 to $58,575: $172,806 over the 5 years. The profit margin, the IB’s profit before interest and tax as a share of sales revenue, moves from 2.8% to 6.1%.

Cash is lowest at the end of 2027, an overdraft of $14,425 (overdrawn at 4 of 5 year-ends), and 2030 ends with $19,054 in the bank. All the borrowing has been repaid by then.

Profit is not cash. Over the 5 years the business earns $172,806 of profit and generates $347,136 of cash from its operations: the profit, plus $207,125 of depreciation (a cost that uses no cash), less $32,795 tied up in more stock and debtors than extra supplier credit pays for. Capital expenditure of $75,000, the repayments and the dividends then come out of that cash.

The statement of financial position balances in every year: assets less liabilities equal equity, because the cash on it is the cash the statement of cash flows arrives at.

Where a forecast stops

  • A forecast is only as good as its drivers, and small errors compound: a growth rate a point too high adds up over five years.
  • Scenarios are not probabilities. In practice the drivers move together, and a downside often brings lower prices and lower volume at once.
  • Year-end figures hide what happens within a year: a business can run out of cash in March and look healthy in December. A cash flow forecast by month, such as the Financial Laboratory’s, shows the months.
  • The forecast stops after a few years, so an investment that pays off later looks worse here than over its life. Value it over its whole life with the capital budgeting comparator.
  • Interest, tax and dividends are simplified, and all borrowing sits on one line.

Section 06: How the model works

The assumptions behind every figure, stated so they can be challenged.

  • Units sold grow by the growth rate from year two; the price rises by its own rate; the variable cost per unit and the fixed costs rise with cost inflation. Every figure is rounded to a whole unit of money as it is worked out, so every total adds up exactly.
  • Cost of sales is every cost that varies with output. For Emberly Roasters that includes delivery, so its gross margin is not directly comparable with the 2025 accounts, whose cost of sales leaves delivery among the expenses.
  • Depreciation is straight line: the assets owned at the start over the years left in them, and each year’s capital expenditure over its life, with a full year’s charge in the year of purchase.
  • Year-end debtors are sales revenue × debtor days ÷ 365; stock and trade creditors are cost of sales × days ÷ 365. The IB’s stock turnover uses average stock; a forecast sets the closing balance instead.
  • Interest is charged on the borrowing and any overdraft at the start of each year, with new borrowing drawn at the start of year one. Tax is a rate on profit before tax, none on a loss; both are paid in the year. Dividends are a share of the profit for the year, none from a loss.
  • The first year uses the Financial Laboratory’s month of 2026 for twelve months: a price of $24.00 a bag, a variable cost of $14.40 and fixed costs of $29,000 a month. The opening position is the lab’s statement of financial position at 31 December 2025, with its short-term loans and long-term borrowing on one line.

Section 07: Where the IB course stops

What this tool takes from the IB course, and what it adds beyond it.

IB What the IB course uses

  • 3.4 Final accounts SL and HL The statement of profit or loss and the statement of financial position, and their layouts. Guide, p. 29; layouts pp. 59 to 63
  • 3.4 Final accounts HL only Depreciation by the straight line method, used here for every asset. Guide, p. 29
  • 3.7 Cash flow SL and HL The difference between profit and cash flow, working capital, cash flow forecasts, and the relationship between investment, profit and cash flow. Guide, p. 29
  • 3.5 Profitability and liquidity ratio analysis SL and HL The profit margin, ROCE and the current ratio, reported for each forecast year. Guide, p. 29
  • 3.6 Efficiency ratio analysis HL only Debtor days, creditor days and stock turnover in days, used here to set the year-end balances; the gearing ratio. Guide, p. 29

Beyond the IB course What this tool adds

  • A statement of cash flows built from profit (the indirect method). The IB’s cash flow forecast lists receipts and payments instead.
  • Linking the three statements so that the balance sheet balances in every year.
  • Forecasting several years from drivers: volume, price, growth, costs, capital expenditure and working capital days.
  • Base, upside and downside scenarios, and two strategic alternatives compared through every statement.
  • Interest cover, net debt and the degree of operating leverage for each year.

The course’s content is described in the platform’s words from the Business management guide (first assessment 2024), checked against the guide on 29 October 2026; see the claims register. The formulas the guide gives are on the formula sheet. Nothing on this page is an IB method unless it is marked IB, and no question here is an IB question.

Section 08: Sources

The method rests on standard references, cited here and in the source register. They were not opened for this release; the explanations are the platform’s own.

Section 09: The IB parts, worked on their own

The Financial Laboratory and the Finance Desk work the parts the IB course uses, with the guide’s formulas and layouts.