Advanced Multi-Jurisdiction Financial Model – Car Subscription Platform Board/Investor Grade)
Budget: $750 – $1,500 USD
Advanced Multi-Jurisdiction Financial Model – Car Subscription Platform Board/Investor Grade)
Project Overview:
We are seeking a highly experienced financial modeller (IB / PE / Big 4 / Tier 1 consulting background preferred) to develop a fully integrated, institutional-grade financial model for a car subscription platform operating across Australia, Canada, and the United States.
This model will be used for strategic decision-making, capital structuring, and potential investor engagement, and must meet a boardroom/investor-ready standard in both rigour and presentation.
Scope & Requirements:
1. Multi-Entity & Consolidation Framework
Standalone models for:
Australia (AU)
Canada (CA)
United States (US)
Fully integrated consolidated group model
Intercompany flows, eliminations, and clear consolidation logic
2. Three-Statement Financial Model
Fully linked:
Income Statement
Balance Sheet
Cash Flow Statement
Monthly granularity (at minimum in early years), rolling into annual view
Strong auditability and error checks
3. Core Business Modelling (Subscription Fleet)
Revenue model based on:
Subscription pricing tiers
Utilisation rates
Customer growth/churn assumptions
Fleet build-up logic:
Vehicle acquisition timing and scaling
Active vs idle fleet tracking
4. Asset & Financing Structure
Multiple acquisition strategies:
Outright purchase
Debt-financed acquisition
Fully dynamic loan/amortisation schedules
Scenario-driven inputs for:
Deposit levels (0%, 10%, 20%+)
Interest rates
Loan terms
Depreciation schedules aligned to jurisdictional tax rules
5. Tax & Jurisdictional Complexity
Incorporate country-specific tax treatments:
Corporate income tax
GST/VAT/Sales tax impacts where relevant
Clear structure allowing refinement of tax assumptions
(Advanced): Consideration of cross-border structuring and cash repatriation logic
6. Scenario & Sensitivity Engine
Dynamic scenario toggles for:
Pricing
Utilisation
Funding mix (equity vs debt)
Growth rates
Sensitivity analysis (data tables and/or scenario manager)
Ability to compare scenarios side-by-side
7. Dashboard & Outputs
Executive-level dashboard including:
IRR, NPV, payback period
Cash flow profiles
Unit economics (per vehicle / per customer)
Break-even analysis
Clean, presentation-ready charts
8. Model Design Standards
Institutional modelling best practices:
Clear separation of inputs, calculations, and outputs
No hardcoding within formulas
Consistent formatting and structure
Built-in error checks and flags
Fully transparent and easy to audit
Deliverables:
Excel model (investment-grade quality)
Supporting notes / documentation explaining structure and logic
Optional: short walkthrough (video or call)
Ideal Candidate:
Background in Investment Banking, Private Equity, Big 4, or Tier 1 consulting
Proven experience building complex, multi-entity financial models
Strong understanding of debt structuring, asset-heavy businesses, and/or leasing/subscription models
Ability to translate complexity into clear, decision-useful outputs
To Apply, Please Include:
Examples of high-end financial models you have built (preferably similar complexity)
Your approach to:
Multi-country modelling
Consolidation
Scenario architecture
Estimated timeline and fee
Note: We are prioritising quality over cost. The expectation is a best-in-class model that can be used with investors and senior stakeholders.
Project Overview:
We are seeking a highly experienced financial modeller (IB / PE / Big 4 / Tier 1 consulting background preferred) to develop a fully integrated, institutional-grade financial model for a car subscription platform operating across Australia, Canada, and the United States.
This model will be used for strategic decision-making, capital structuring, and potential investor engagement, and must meet a boardroom/investor-ready standard in both rigour and presentation.
Scope & Requirements:
1. Multi-Entity & Consolidation Framework
Standalone models for:
Australia (AU)
Canada (CA)
United States (US)
Fully integrated consolidated group model
Intercompany flows, eliminations, and clear consolidation logic
2. Three-Statement Financial Model
Fully linked:
Income Statement
Balance Sheet
Cash Flow Statement
Monthly granularity (at minimum in early years), rolling into annual view
Strong auditability and error checks
3. Core Business Modelling (Subscription Fleet)
Revenue model based on:
Subscription pricing tiers
Utilisation rates
Customer growth/churn assumptions
Fleet build-up logic:
Vehicle acquisition timing and scaling
Active vs idle fleet tracking
4. Asset & Financing Structure
Multiple acquisition strategies:
Outright purchase
Debt-financed acquisition
Fully dynamic loan/amortisation schedules
Scenario-driven inputs for:
Deposit levels (0%, 10%, 20%+)
Interest rates
Loan terms
Depreciation schedules aligned to jurisdictional tax rules
5. Tax & Jurisdictional Complexity
Incorporate country-specific tax treatments:
Corporate income tax
GST/VAT/Sales tax impacts where relevant
Clear structure allowing refinement of tax assumptions
(Advanced): Consideration of cross-border structuring and cash repatriation logic
6. Scenario & Sensitivity Engine
Dynamic scenario toggles for:
Pricing
Utilisation
Funding mix (equity vs debt)
Growth rates
Sensitivity analysis (data tables and/or scenario manager)
Ability to compare scenarios side-by-side
7. Dashboard & Outputs
Executive-level dashboard including:
IRR, NPV, payback period
Cash flow profiles
Unit economics (per vehicle / per customer)
Break-even analysis
Clean, presentation-ready charts
8. Model Design Standards
Institutional modelling best practices:
Clear separation of inputs, calculations, and outputs
No hardcoding within formulas
Consistent formatting and structure
Built-in error checks and flags
Fully transparent and easy to audit
Deliverables:
Excel model (investment-grade quality)
Supporting notes / documentation explaining structure and logic
Optional: short walkthrough (video or call)
Ideal Candidate:
Background in Investment Banking, Private Equity, Big 4, or Tier 1 consulting
Proven experience building complex, multi-entity financial models
Strong understanding of debt structuring, asset-heavy businesses, and/or leasing/subscription models
Ability to translate complexity into clear, decision-useful outputs
To Apply, Please Include:
Examples of high-end financial models you have built (preferably similar complexity)
Your approach to:
Multi-country modelling
Consolidation
Scenario architecture
Estimated timeline and fee
Note: We are prioritising quality over cost. The expectation is a best-in-class model that can be used with investors and senior stakeholders.