MzanziMart Soweto Market Spaza Shop Business Plan — Appendix A: Detailed Financial Statements

The first year ramps as the store establishes itself: a grand opening builds initial trial, and footfall, basket and the loyal-shopper base grow quarter on…

☰Jump to sectionAll 23 pages▾
Appendix A · 21 of 23

Detailed Financial Statements

A.1 Revenue and category build

R’000

Year 1

Year 2

Year 3

Year 4

Year 5

Revenue

2850

3300

3780

4290

4870

Cost of goods sold

2109

2426

2759

3110

3506

Gross profit

741

875

1021

1180

1364

Gross margin

26%

26.5%

27%

27.5%

28%

EBITDA

134

211

296

390

509

EBITDA margin

4.7%

6.4%

7.8%

9.1%

10.4%

A.1b Illustrative Year-1 quarterly ramp

Year 1

Q1

Q2

Q3

Q4

Revenue (R’000)

640

695

735

780

Customers/day (avg)

165

185

200

210

Regular shoppers (cum.)

700

1,050

1,300

1,500

The first year ramps as the store establishes itself: a grand opening builds initial trial, and footfall, basket and the loyal-shopper base grow quarter on quarter as habit forms, word-of-mouth spreads and value-added services bed in. The quarterly shape is illustrative — the annual total ties to the preserved R2.85 million — but it reflects the realistic build of a new convenience store from opening to a steady run-rate.

A.2 Operating KPIs

Metric

Year 1

Year 2

Year 3

Year 4

Year 5

Customers per day

190

225

255

285

315

Average basket (R)

R41.7

R40.7

R41.2

R41.8

R42.9

Regular shoppers

1500

1900

2300

2700

3100

Inventory turns (×)

12×

12.3×

12.6×

12.9×

13.2×

Headcount

8

9

11

13

15

A.3 Cash & balance-sheet summary

R’000

Year 1

Year 2

Year 3

Year 4

Year 5

Operating cash flow

46

200

279

367

465

Free cash flow (pre-financing)

(269)

200

261

339

442

Closing cash

187

311

439

609

831

Total assets

628

723

837

1000

1215

Equity

348

478

626

822

1069

Balance sheet ties

Yes

Yes

Yes

Yes

Yes

A.4 EBITDA-to-net-profit reconciliation

R’000

Year 1

Year 2

Year 3

Year 4

Year 5

EBITDA

134

211

296

390

509

less Depreciation

(50)

(50)

(53)

(58)

(55)

less Interest

(36)

(29)

(22)

(14)

(7)

less Tax (SBC)

(0)

(3)

(9)

(16)

(36)

Net profit after tax (re-derived)

48

130

213

302

410

Memo: sponsor illustrative net profit

265

360

495

650

840