
Awarded
Posted
Paid on delivery
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 ID: 40402701
22 proposals
Remote project
Active 6 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
22 freelancers are bidding on average $1,340 USD for this job

As a highly-seasoned professional with over 15 years of experience leveraging business plans, financial models, and feasibility studies to assist entrepreneurs, startups, and established businesses alike, I believe I'm an excellent match for your Advanced Multi-Jurisdiction Financial Model project. Over the course of my career, I've honed my skills in precisely the areas you're looking for: multi-entity modeling, consolidation, scenario architecture and high-grade financial forecasting that's readily understandable for key stakeholders. I'm confident that my expertise will ensure a best-in-class model that can be effectively presented to investors and senior decision makers due to its rigorous standards and clear presentation. Moreover, I'm well-versed in highly complex modeling projects and possess the ability to translate complexity into actionable outputs. This is an invaluable skill in today's dynamic business environment where simplicity is key. Equally important, I understand your need for timeliness without compromising on quality. With me on your team, you can have confidence that your project will not only be completed accurately but also delivered within the specified timeframe. In short, with me at the helm of your Advanced Multi-Jurisdiction Financial Model project you get a highly dedicated person driven by delivering excellence through expertise and timely completion while maintaining clear communication throughout our collaboration journey.
$850 USD in 7 days
9.0
9.0

Hi, This looks like a multi-entity consolidation and fleet financing challenge where the biggest risk is inconsistent linkage across monthly three-statement schedules and unreliable intercompany eliminations causing misstated group cash/NPV. I’d start by building a single-jurisdiction monthly template (P&L, BS, CF) with dynamic vehicle acquisition logic, debt amortisation schedules, and tax blocks — then replicate and link AU / CA / US with clear intercompany flows and elimination worksheets. Relevant specifics I’ll include: - subscription pricing tiers, utilisation & churn feeding monthly revenue - multiple acquisition paths (cash vs debt) with dynamic amortisation and deposit toggles - jurisdiction tax treatments and repatriation flags + audit checks I’d map deliverables, timeline and fee after a quick review of any existing files. Ready to review current model or brief? — Smith
$1,125 USD in 7 days
7.0
7.0

Hello, Looking for a professional Investment-Grade Multi-Jurisdiction Financial Model for a Car Subscription Platform (Australia, Canada & USA) with full consolidation, three-statement integration, and investor-ready outputs ? I've got you covered! With over a decade of experience in advanced financial modelling, investment banking, private equity analysis, and complex multi-entity corporate finance structures, I’d be thrilled to develop a comprehensive cybersecurity training document covering topics such as Network Security, AI & RPA, Enterprise Security, Endpoint Security, Governance, Data Security, and Industry Controls. After reviewing your project, I understand the importance of building a robust, scalable model suitable for board-level decision-making and investor evaluation. The financial model will include standalone entities for AU, CA, and US, fully integrated into a consolidated group structure with intercompany eliminations and clear audit trails. It will feature a fully linked three-statement model (P&L, Balance Sheet, Cash Flow) with monthly detail in early years and annual projections thereafter. Let’s collaborate to produce a top-tier training document that meets your objectives and sets a new standard for cybersecurity education. Regards, Sana
$750 USD in 3 days
6.0
6.0

⭐⭐⭐⭐⭐ Create Advanced Financial Model for Multi-Jurisdiction Car Subscription Platform ❇️ Hi My Friend, I hope you're doing well. I've reviewed your project requirements and see you're looking for an experienced financial modeller. Look no further; Zohaib is here to help you! My team has successfully completed 50+ similar projects for financial modeling. I will create a robust financial model that meets investor-grade standards, ensuring it is clear and useful for decision-making. ➡️ Why Me? I can easily build your advanced financial model as I have 5 years of experience in financial modeling, specializing in multi-entity and subscription models. My expertise includes scenario analysis, financial forecasting, and compliance with tax regulations. Additionally, I have a strong grip on tools like Excel and financial software, ensuring a comprehensive approach to your project. ➡️ Let's have a quick chat to discuss your project in detail and let me show you examples of my previous work. I look forward to our conversation! ➡️ Skills & Experience: ✅ Financial Modeling ✅ Excel Proficiency ✅ Scenario Analysis ✅ Debt Structuring ✅ Revenue Forecasting ✅ Consolidation Logic ✅ Tax Compliance ✅ Dashboard Creation ✅ Data Analysis ✅ Business Valuation ✅ Presentation Skills ✅ Auditability Checks Waiting for your response! Best Regards, Zohaib
$900 USD in 2 days
5.8
5.8

Yaroomba, Australia
Payment method verified
Member since Nov 2, 2022
$250-750 USD
$250-500 AUD
$8-15 USD / hour
min €36 EUR / hour
₹1500-12500 INR
$250-750 USD
£10-20 GBP
$750-1500 USD
$250-750 USD
$250-750 AUD
$8-15 AUD / hour
$25-50 USD / hour
$30-250 USD
$750-1500 USD
$30-250 AUD
$10-25 USD
₹1500-12500 INR
€750-1500 EUR
$250-750 USD
$250-750 AUD
$8-15 USD / hour
₹600-1500 INR
₹12500-37500 INR