Centurion Motor Exchange Business Plan — Sensitivity and Scenario Analysis

What moves the outcome: units sold, gross per unit, days to sell and floor-plan cost, with scenarios.

Section 23 of 28

Sensitivity and Scenario Analysis

Jump to section

The downside is survivable on one site; opening Site 2 regardless would not be

Table 23.1: Scenario definitions

Driver

Downside (gated)

Base

Upside

Stress (ungated)

Retail volume vs plan

–10%

Plan

+10%

–10%

Trading spread

13.0%

14.0%

14.75%

13.0%

Average selling price (FY28, ex VAT)

R245,000

R245,000

R250,000

R245,000

Stock days

52

45

40

52

Finance penetration

58%

65%

70%

58%

Fixed costs

+3%

Plan

Plan

+3%

Interest rates

+50bp

Prime 10.50%

Prime 10.50%

+50bp

Site 2 and Tranche B

Not opened / not drawn

Opened Mar 2029

Opened Mar 2029

Opened regardless

Head office payroll

Cut to R1.5m (management response)

R2.4m

R2.4m

R2.4m

Each downside driver is individually plausible; the case does not stack worst-case outcomes. The stress case isolates the effect of expanding into a weak market.

Table 23.2: Scenario results

Output

Downside (gated)

Base

Upside

Stress (ungated)

FY32 retail units

708

1,465

1,611

1,318

FY32 revenue

R228.7m

R473.7m

R531.1m

R425.9m

FY32 EBITDA

R2.7m

R15.4m

R25.8m

R5.0m

Cumulative net profit FY28–FY32

(R9.6m)

R13.6m

R39.2m

(R22.2m)

FY32 closing cash / (overdraft)

(R4.7m)

R19.3m

R46.6m

(R19.2m)

Minimum operating DSCR, FY29–FY32

0.52x

1.96x

3.97x

neg.

Peak overdraft (limit R4.0m)

R4.7m

Not used

Not used

R19.2m

First month overdraft exceeds limit

Month 56

Never

Never

Month 26

Equity invested by Investor

R12m

R24m

R24m

R24m

Exit equity value (5.0x)

R8.9m

R95.6m

R174.9m

R5.2m

Investor MOIC

0.30x

1.99x

3.64x

0.11x

Investor IRR

(21.6%)

18.0%

35.9%

(43.8%)

1: EBITDA by scenario
Figure 1. 1: EBITDA by scenario

What the downside and stress cases show

In the downside, management declines to open Site 2 and cuts head-office cost. Site 1 remains EBITDA-positive from FY29 but earns only R2.7m by FY32, net profit stays negative until FY32, and the operating DSCR is between 0.52x and 0.92x, a breach in every tested year. The overdraft is first drawn in FY30 and exceeds its R4m limit in month 56, peaking at R4.7m. The Investor recovers 0.30x of Tranche A. The business survives, but only with lender forbearance or a further R3–5m of equity.

In the stress case the same trading conditions apply but Site 2 is opened anyway. The overdraft limit is breached in month 26, within two months of Site 2’s launch, and the funding gap peaks at R19.2m. Equity falls to R7.8m by FY32 and the Investor recovers 0.11x. This is the clearest quantitative argument for the Tranche B gate.

Volume and trading spread are the value drivers; financing terms are second-order

2: Investor IRR sensitivity (tornado)
Figure 2. 2: Investor IRR sensitivity (tornado)

Table 23.3: Single-variable sensitivities

Variable (adverse / favourable)

FY32 EBITDA

Investor IRR

Min op. DSCR

Lowest liquidity*

Retail volume ±10%

R10.9m / R19.9m

6.1% / 26.6%

1.02x / 2.87x

(R2.1m)

Trading spread ±1.0pp

R11.1m / R19.7m

5.7% / 26.7%

1.05x / 2.84x

(R3.7m)

Average selling price ±5%

R12.5m / R18.3m

10.9% / 23.9%

1.35x / 2.56x

(R0.7m)

Finance penetration ±10pp

R14.8m / R16.0m

16.7% / 19.4%

1.83x / 2.09x

R1.3m

Fixed costs ±10%

R13.0m / R17.8m

11.7% / 23.3%

1.35x / 2.55x

(R1.8m)

Stock days ±10 days

R14.4m / R16.4m

14.8% / 20.9%

1.74x / 2.16x

(R0.8m)

Interest rates ±200bp

R14.6m / R16.2m

16.1% / 19.8%

1.73x / 2.21x

R0.7m

Exit multiple ±1.0x

R15.4m / R15.4m

13.2% / 22.3%

1.96x / 1.96x

R1.9m

Recon cost per unit ±20%

R13.1m / R17.7m

12.4% / 22.9%

1.48x / 2.44x

(R0.5m)

* Lowest month-end cash less peak overdraft in the adverse case. Base case: FY32 EBITDA R15.4m; IRR 18.0%; minimum DSCR 1.96x.

The table also shows how little room the base case has. On its own, a 10% volume shortfall or a one-point fall in trading spread takes the minimum operating DSCR to about 1.02x, below the 1.30x covenant, and pushes the business into its overdraft, even with Site 2 opened on schedule. These are the two variables the Tranche B milestones are designed to test before further capital is committed.

3: Two-way sensitivity: volume and trading spread
Figure 3. 3: Two-way sensitivity: volume and trading spread

Table 23.4: FY32 EBITDA by volume and trading spread (R million)

Volume vs plan \ spread

12%

13%

14%

15%

16%

80%

(0.6)

2.9

6.4

9.8

13.3

90%

3.1

7.0

10.9

14.8

18.7

100%

6.7

11.1

15.4

19.7

24.1

110%

10.4

15.1

19.9

24.7

29.4

120%

14.0

19.2

24.4

29.6

34.8

Table 23.5: Interest-rate stress

Prime rate shock

FY32 EBITDA

FY32 net profit

Minimum operating DSCR

Base

R15.4m

R8.5m

1.96x

+100bp

R15.0m

R8.2m

1.84x

+200bp

R14.6m

R7.9m

1.73x

+300bp

R14.3m

R7.6m

1.62x