Mainstreet Junction Business Plan — Sensitivity and Scenario Analysis

How the plan responds to volume, regulated margin, shop basket and cost moving against it, with downside and upside cases.

Sensitivity and Scenario Analysis

Jump to section
On this page

  • 14.1 Single-variable sensitivity
  • 14.2 Scenarios

14.1 Single-variable sensitivity

Project IRR sensitivity to single-variable movements
Figure 21. Project IRR sensitivity to single-variable movements.

Variable moved

Favourable

Adverse

Swing

Adverse case above the 15.5% hurdle?

Fuel volume ±15%

26.1%

13.0%

13.1 points

No

Retail margin ±10%

24.1%

15.4%

8.7 points

No

Operating costs ∓10%

24.2%

15.6%

8.6 points

Yes

Capital cost ∓15%

24.0%

16.0%

8.0 points

Yes

Shop gross profit ±20%

23.3%

16.3%

7.0 points

Yes

Throughput dominates everything. A 15 per cent volume shortfall costs roughly nine points of project return and pushes the project below its hurdle rate; a 15 per cent outperformance adds four. No other single variable moves the outcome as far, which is why the traffic count is described throughout this document as the investment decision rather than a licensing formality.

  • The regulated margin is a real risk and it is outside management’s control. A 10 per cent adverse movement in the effective retail margin — through RAS adjustments lagging cost inflation, or through deeper diesel discounting to win fleet volume — takes the return to 15.4 per cent, barely at the hurdle.
  • Cost discipline matters more than it looks. A 10 per cent operating cost overrun costs roughly six points of return, more than a 15 per cent capital overrun, because operating costs recur while capital does not.
  • The shop is a genuine swing factor. A 20 per cent shortfall in shop gross profit costs 5.6 points of return — confirming that convenience retail execution, not fuel, is where management effort earns its return.
Year 5 EBITDA across throughput and shop gross profit
Figure 22. Year 5 EBITDA across throughput and shop gross profit.

The grid shows the interaction. At the planned shop performance the site needs roughly 400 000 litres a month to hold Year 5 EBITDA above R10 million; with shop gross profit 20 per cent light it needs closer to 460 000. Throughput buys tolerance on the retail ramp and the retail ramp buys tolerance on throughput, and the compound case below is what happens when neither arrives.

14.2 Scenarios

Project IRR across scenarios, with Year 5 EBITDA
Figure 23. Project IRR across scenarios, with Year 5 EBITDA.

Scenario

Definition

Throughput

Year 5 EBITDA

Project IRR

Base

The plan as presented: 480 000 litres a month at maturity, shop at 27% gross margin.

480 000 l/mo

R14.02m

21.9%

Retail ramp disappoints

Shop gross profit 20% light — a slow convenience ramp or no quick-service tenant.

480 000 l/mo

R11.53m

16.3%

Margin compression

Effective retail margin 10% below plan through RAS lag or deeper diesel discounting.

480 000 l/mo

R12.06m

15.4%

Volume shortfall

Throughput 15% below the traffic study — the ordinary consequence of an optimistic count.

408 000 l/mo

R11.29m

13.0%

Volume and retail

Throughput 15% down and shop gross profit 20% light in the same year.

408 000 l/mo

R8.79m

8.4%

Previous section13. Investment Returns