How do build-out, utilisation, pricing, and operating assumptions shape project performance?
Model profile
Intercity Bus Transport
Company-owned intercity coach operator: coach fleet buildout by segment (CAPEX/debt by default), a driver-and-mechanic payroll roster, escalating fare and cost schedules, financing, three statements, and valuation.
Decision scope
Questions this model helps you examine
What capital, replacement, working capital, and financing programme is required?
How resilient are cash flows and returns under operational and market downside cases?
Model capabilities
What this model includes
The profile below is generated from the same catalogue and workspace definitions used by the application.
- Coach fleet renewal by route segment, company-owned by default (CAPEX/debt), lease optional
- Company payroll roster: driver and mechanic headcount scales with fleet size
- Optional affiliate-operator capacity with booking-fee economics
- Fare, staff wages, maintenance, fixed-cost, and fuel schedules that each escalate on their own annual increment
- Baggage, onboard, parcel/courier, charter, and cancellation ancillary revenue
- Term loan, cash-driven working-capital revolver, and multi-investor equity
- Three statements, enterprise DCF and equity-return valuation, breakeven, and financial-ratio analysis
- Cost-per-passenger-mile, revenue-per-bus, and load-factor analytics
- Named scenarios, goal seek, tornado, VaR/CVaR, correlated Monte Carlo, and a route-expansion decision tree
Build the case
Inputs and workspaces
- AssumptionsProject timing, WACC/tax, fuel, ancillary revenue, and overheads
- Route segmentsCoach buildout, fare rates, and cost schedules per segment
- StaffCompany payroll roster: driver and mechanic headcount and wages
- Affiliate operatorsIndependently owned coach capacity and booking-fee economics
- FinancingLoans, revolver, investors, and non-fleet CAPEX schedule
- AnalyticsNamed scenarios, goal seek, correlated Monte Carlo, and the route-expansion decision tree
Review the result
Outputs and analysis
- Project NPVUSD
- Project IRRAnnual
- Equity IRRAnnual
- Equity MOICMultiple on invested equity
- EBITDA marginFinal year
- Minimum DSCRLowest period
- Cost per passenger-mileUSD, whole horizon
- Ending cashUSD
- 5 additional metrics in the workspace
- Financial statementsDetailed schedules
- Fleet, financing & valuationDetailed schedules
- Risk & analyticsDetailed schedules
Designed for review
Who this model is for
- Infrastructure sponsors
- Operating and engineering teams
- Financial advisers
- Investors and lenders
Governed evidence
The review trail stays with the result.
Each completed calculation preserves the model version, saved inputs, reporting-currency snapshot, immutable run, and result fingerprint used for its reports.
- Version-controlled calculation logic
- Saved assumptions and scenarios
- Immutable calculation runs
- Reporting context preserved in exports
Ready to explore the case?