Mr Bakery Master Business Plan — Financial Projections

Five-year projections: revenue building to R17.15m and EBITDA to R1.92m at an 11.2% margin, with the full cost stack by line.

Financial Projections

Jump to section
On this page

  • 14.1 Basis of preparation
  • 14.2 Projected income statement
  • 14.3 The cost base as a share of revenue
  • 14.4 Projected cash flow
  • 14.5 Projected balance sheet

14.1 Basis of preparation

  • All amounts are in nominal South African rand. Revenue is built from units baked per day across 306 trading days, the product mix and price by line, less returns at the rate shown.
  • Prime cost — ingredients, packaging and labour — is modelled as a percentage of net revenue and falls from 69.1 per cent to 63.2 per cent. Energy, rent, distribution and maintenance are stated separately.
  • R96 000 of opening ingredients and pre-opening payroll is a period cost and is charged to income in Year 1. The R128 000 working capital reserve funds opening trading and is carried as cash.
  • Depreciation is charged on the capitalised element of capital expenditure, net of the R180 000 landlord installation allowance, over the useful lives of the fit-out, ovens, equipment and vehicles.
  • Interest and capital derive from the facility-level schedules in Appendix C across seven instruments.
  • Trade debtors are modelled at 32 days on the wholesale share of revenue only, because retail is cash on sale.
  • Corporate income tax is applied at 27 per cent with assessed losses carried forward subject to the section 20 limitation. No tax arises within the projection.
  • The balance sheet is derived rather than plugged; shareholders’ funds roll forward from the two equity subscriptions and retained earnings, and the closing cash position reconciles exactly to the cash flow statement.

14.2 Projected income statement

R’000

Year 1

Year 2

Year 3

Year 4

Year 5

Confectionery

1 387

2 357

3 605

5 078

6 701

Specialty bread

1 505

2 490

3 713

5 142

6 675

Cakes and tarts

388

748

1 275

1 987

2 866

Plain loaves

638

915

1 154

1 381

1 509

Gross sales

3 919

6 511

9 747

13 587

17 752

Less returns

(243)

(339)

(429)

(516)

(604)

Net revenue

3 676

6 172

9 318

13 071

17 148

Ingredients

(1 367)

(2 253)

(3 336)

(4 601)

(5 916)

Packaging

(151)

(247)

(363)

(497)

(634)

Gross profit

2 158

3 672

5 619

7 973

10 597

Labour

(1 022)

(1 673)

(2 460)

(3 359)

(4 287)

Energy

(213)

(364)

(559)

(797)

(1 063)

Rent

(312)

(334)

(482)

(631)

(675)

Distribution

(206)

(329)

(456)

(583)

(716)

Maintenance and card fees

(98)

(171)

(273)

(404)

(547)

Contribution

306

802

1 388

2 199

3 309

Owner and management

(264)

(312)

(372)

(432)

(498)

Administration

(88)

(112)

(148)

(186)

(228)

Sales and marketing

(96)

(132)

(186)

(238)

(296)

Technology

(42)

(54)

(74)

(92)

(114)

Food safety and compliance

(58)

(70)

(92)

(112)

(136)

Insurance

(46)

(58)

(78)

(96)

(118)

EBITDA

(288)

64

438

1 043

1 919

EBITDA margin

-7.8%

1.0%

4.7%

8.0%

11.2%

Pre-opening cost

(96)

Depreciation

(285)

(347)

(471)

(606)

(751)

Interest

(92)

(276)

(381)

(412)

(417)

Profit / (loss) before tax

(761)

(559)

(414)

25

751

Taxation

Profit / (loss) after tax

(761)

(559)

(414)

25

751

Revenue against the cost stack
Figure 15. Revenue against the cost stack.

EBITDA turns positive in Year 2 at R64 000 and reaches R1.92 million in Year 5. Profit after tax arrives in Year 4 at R25 000 and reaches R751 000 in Year 5, after depreciation of R751 000 and interest of R417 000. Assessed losses of R1.73 million accumulate across Years 1 to 3 and shelter the Year 4 and Year 5 taxable profits entirely under the section 20 limitation, so no tax is payable and R958 000 of loss remains unutilised.

14.3 The cost base as a share of revenue

% of revenue

Year 1

Year 2

Year 3

Year 4

Year 5

Behaviour

Ingredients

37.2%

36.5%

35.8%

35.2%

34.5%

Scales with volume; controlled by contract buying and batch weighing

Packaging

4.1%

4.0%

3.9%

3.8%

3.7%

Scales with units; falls slightly on volume purchasing

Labour

27.8%

27.1%

26.4%

25.7%

25.0%

Improves on shift utilisation to Year 3, then close to proportional

Energy

5.8%

5.9%

6.0%

6.1%

6.2%

The only line rising as a share of revenue

Rent

8.5%

5.4%

5.2%

4.8%

3.9%

Fixed; steps at the Year 3 extension and the Year 4 retail lease

Distribution

5.6%

5.3%

4.9%

4.5%

4.2%

Falls as retail grows; broadly flat per wholesale rand

Maintenance and card fees

2.7%

2.8%

2.9%

3.1%

3.2%

Rises with equipment age and card volumes at retail

Overhead

16.2%

12.0%

10.2%

8.8%

8.1%

The dominant source of operating leverage in the plan

Total cost base

107.8%

99.0%

95.3%

92.0%

88.8%

Overhead falls from 16.2 per cent of revenue to 8.1 per cent — a halving, and by far the largest single contributor to the margin improvement. Prime cost contributes 5.9 points and distribution 1.4. The three together are what take the EBITDA margin from minus 7.8 per cent to 11.2 per cent. Overhead is where the operating leverage lives, and it is also the line most easily destroyed by adding management ahead of volume.

14.4 Projected cash flow

R’000

Year 1

Year 2

Year 3

Year 4

Year 5

EBITDA

(288)

64

438

1 043

1 919

Pre-opening cost

(96)

Movement in working capital

(190)

(110)

(108)

(98)

(104)

Taxation paid

Operating cash flow

(574)

(46)

330

945

1 815

Capital expenditure, net of allowance

(2 215)

(568)

(1 140)

(1 125)

(1 330)

Equity introduced

1 620

1 850

Loans and facilities drawn

1 570

1 360

720

900

620

Loan repayments

(282)

(554)

(698)

(848)

Interest paid

(92)

(276)

(381)

(412)

(417)

Net cash flow

309

188

825

(390)

(160)

Closing cash

309

497

1 322

932

772

Cash flow — operating cash turns positive in Year 3
Figure 16. Cash flow — operating cash turns positive in Year 3.

Operating cash flow is negative in Years 1 and 2 and turns positive in Year 3 at R330 000, reaching R1.82 million in Year 5. Closing cash never falls below R309 000, which occurs at the end of Year 1 and is the tightest point in the plan. Cash peaks at R1.32 million in Year 3 after the growth equity subscription and is drawn down again by the Year 4 retail investment.

14.5 Projected balance sheet

R’000

Year 1

Year 2

Year 3

Year 4

Year 5

Plant, vehicles and fit-out

1 930

2 151

2 820

3 339

3 918

Trade debtors

251

400

556

710

872

Stock

53

87

129

178

229

Cash

309

497

1 322

932

772

Total assets

2 543

3 135

4 827

5 159

5 791

Loans outstanding

1 570

2 648

2 813

3 015

2 787

Trade creditors

114

187

277

382

491

Total liabilities

1 684

2 835

3 090

3 397

3 278

Shareholders’ funds

859

300

1 736

1 761

2 512

Total liabilities and shareholders’ funds

2 543

3 135

4 826

5 158

5 790

Balance sheet — asset composition
Figure 17. Balance sheet — asset composition.

Shareholders’ funds fall from R859 000 at the end of Year 1 to R300 000 at the end of Year 2 as accumulated losses erode the founder’s subscription, recover to R1.74 million on the Year 3 growth equity, and reach R2.51 million by Year 5. That dip is the honest shape of a start-up that loses money for three years, and it is the reason the growth equity is subscribed in Year 3 rather than raised as further debt: at the end of Year 2 the balance sheet would not support additional gearing.

Next section15. Break-Even