Copperfrontline Logistics Business Plan — Sensitivity and Scenario Analysis
What moves FY2031 EBITDA: northbound fill rate, trips per truck, fuel price and border delay, with scenarios.
Sensitivity and Scenario Analysis
Jump to section
- Overview & contents
- i. Important Notice and Basis of Preparation
- 1. Executive Summary
- 2. The Corridor
- 3. Operating Model
- 4. Commercial Model
- 5. Market and Competitive Position
- 6. SWOT and Strategic Response
- 7. Financial Projections
- 8. Capital Expenditure, Funding and the Balance Sheet
- 9. Sensitivity and Scenario Analysis
- 10. Risk Analysis
- 11. Regulatory and Compliance
- 12. Organisation
- 13. Implementation Roadmap
- 14. Key Performance Indicators
- 15. Investor Returns and Recommendation
- 16. Assumption Register
- A. Appendix A: Consolidated Financial Summary
- B. Appendix B: Round Trip and Fleet Schedules
- C. Appendix C: Funding, Debt Service and Balance Sheet Schedules
- D. Appendix D: Risk Register
- E. Appendix E: Glossary
- 9.1 External shocks
- 9.2 The return leg
- 9.3 What moves FY2031 EBITDA
- 9.4 Scenarios
- 9.5 The downside case
9.1 External shocks
|
Shock |
FY2031 EBITDA (US$m) |
Change from plan |
|---|---|---|
|
As planned |
2.61 |
— |
|
Freight rates fall 10% |
1.63 |
(0.98) |
|
Freight rates fall 15% |
1.14 |
(1.47) |
|
Diesel rises 15% |
2.21 |
(0.40) |
|
Diesel rises 30% |
1.81 |
(0.80) |
|
Northbound fill falls to 60% |
1.84 |
(0.77) |
|
Northbound fill falls to 40% |
0.98 |
(1.63) |
|
One extra dwell day per round trip |
2.37 |
(0.24) |
|
Availability falls to 88% |
2.37 |
(0.24) |
9.2 The return leg
The northbound fill rate deserves separate treatment because it is both the largest controllable exposure and the one most often mishandled. At the planned 78 per cent a round trip contributes US$3 392. At 60 per cent it contributes US$2 690 and FY2031 EBITDA is US$1.84m. At 40 per cent — the level an operator treating the return leg as opportunistic will reach — it contributes US$1 909 and FY2031 EBITDA is US$0.98m, which does not cover debt service of US$1.90m.
Run the fleet with no return freight at all and FY2031 EBITDA is negative US$0.74m. A round trip that covers its diesel is not a business; overheads and debt service are paid out of the return leg, and the difference between a viable haulier and a failing one on this corridor is almost entirely a commercial question rather than an operational one.
9.3 What moves FY2031 EBITDA
|
Driver |
Downside (US$m) |
Upside (US$m) |
Swing (US$m) |
|---|---|---|---|
|
Freight rates ±10% |
1.63 |
3.59 |
1.96 |
|
Northbound fill 60% / 90% |
1.84 |
3.12 |
1.28 |
|
Diesel price ±20% |
2.08 |
3.14 |
1.06 |
|
Round trips per truck ±0.15 a month |
2.34 |
2.88 |
0.54 |
|
Availability 88% / 96% |
2.37 |
2.69 |
0.32 |
|
Overheads ±10% |
2.50 |
2.72 |
0.22 |
|
Fuel shrinkage 5.5% / 1.5% |
2.54 |
2.64 |
0.10 |
|
Base case FY2031 EBITDA |
2.61 |
Freight rates lead, and they are entirely outside management control on a corridor where the company is one of many road hauliers moving a commodity to a port. Northbound fill follows and is the largest driver management can actually move. Diesel is third and is partially transferable to customers through fuel adjustment clauses where they accept them. Note that fuel shrinkage, which occupies a good deal of management attention in businesses of this kind, is the smallest driver in the table at US$0.10m of swing — it is worth controlling, but it is not worth controlling at the expense of the return leg.
9.4 Scenarios
|
Downside |
Base |
Upside |
|
|---|---|---|---|
|
Northbound fill rate |
55% |
78% |
88% |
|
Freight rates against plan |
-10% |
As planned |
As planned |
|
Round trips per truck per month |
1.85 |
2.05 |
2.15 |
|
FY2031 revenue |
7.07 |
9.78 |
10.75 |
|
FY2031 EBITDA |
0.57 |
2.61 |
3.24 |
|
FY2031 EBITDA margin |
8.1% |
26.7% |
30.1% |
The downside combines a 55 per cent fill rate, freight rates ten per cent below plan and 1.85 round trips a month. That is not three independent misfortunes: a corridor under rate pressure is usually a corridor with excess capacity chasing the same loads, which depresses fill and lengthens queues at the same time. On that combination FY2031 EBITDA is US$0.57m against debt service of US$1.90m, and the company is in restructuring rather than in a bad year.