5-Year Financial Model , financial modelling , cash flow, p&l...Experience with the Swiss market
Budget: €250 – €750 EUR
I require a comprehensive, bottom-up 5-Year Financial Model for a new fitness studio in Switzerland. The model must be built in Excel, fully integrated, and investor-ready, considering location specificities , kanton taxes , employer on top cost, ongoing operational costs. withholding tax ...all specifically for Switzerland and the business city location.
1. Core Structure & Timeline
Integrated 3-Statements: Fully linked Income Statement (P&L), Balance Sheet, and Cash Flow Statement.
Time Horizon: Monthly projections for the first 24 months (to capture ramp-up and seasonality) and annual projections for Years 3–5.
Swiss Context: All figures in CHF, incorporating Swiss VAT rules, typical local rent benchmarks, and salary social charges.
2. Revenue Drivers & Pricing Logic (Critical)
Dynamic Pricing Calculator: A dedicated input section to define and test pricing for:
Membership Tiers: (e.g., Unlimited, Off-Peak, 4x/Month).
Class Packs: (e.g., 5, 10, 20 classes) with expiry logic.
Private Sessions: Hourly rates.
Workshops/Retreats: Occasional revenue streams.
ASP Calculation: The model must automatically calculate the Average Selling Price (ASP) based on the mix of the above products.
Capacity & Occupancy: Revenue must be driven by:
Number of Reformer machines (e.g., 8–12 units).
Class Schedule (sessions per day/week).
Occupancy Rate % per class (with ability to ramp up from 0% to target ~80%).
Detailed staffing logic as instructor utilisation, class-wise payroll allocation, commission structures, and peak vs off-peak scheduling impact on profitability and contribution margins
3. Unit Economics Dashboard
Customer Metrics: Automated calculation of CAC (Customer Acquisition Cost), LTV (Lifetime Value), Churn Rate, and Contribution Margin per Member.
Machine Economics: Revenue and margin contribution per Reformer machine.
4. Costs & Capital Expenditure (CAPEX)
Startup Costs: Detailed breakdown for Reformer equipment (import/customs duties if applicable), studio fit-out (high Swiss standards), legal, and pre-opening marketing.
Operating Expenses (OPEX): Detailed lines for rent, instructor salaries (hourly vs. fixed), utilities, insurance, and software subscriptions.
Working Capital: Projection of cash needed to sustain operations until positive cash flow.
5. Investment Returns & Exit Metrics
Key Returns: Calculation of IRR (Internal Rate of Return), ROI/ROE (Return on Equity), NPV (Net Present Value), and Payback Period (in months).
Breakeven Analysis: Exact month of cash flow breakeven and the specific member count required to cover monthly fixed costs.
6. Scenario & Sensitivity Analysis
Three Scenarios: Base Case, Upside Case (+20% growth), and Downside Case (-20% growth).
Sensitivity Tables: Show impact on IRR and Cash Flow if key variables change (e.g., Occupancy Rate ±10%, Membership Price ±5%, Churn Rate ±2%).
The model should include future expansion logic such as multi-site rollouts, debt refinancing, investor dilution scenarios, and valuation modeling based on EBITDA/revenue multiples over the 5-year horizon.
Deliverables:
Fully editable Excel file with clear assumption tabs, calculation engines, and dashboard summaries.
Brief PDF summary of key findings and assumptions.
1. Core Structure & Timeline
Integrated 3-Statements: Fully linked Income Statement (P&L), Balance Sheet, and Cash Flow Statement.
Time Horizon: Monthly projections for the first 24 months (to capture ramp-up and seasonality) and annual projections for Years 3–5.
Swiss Context: All figures in CHF, incorporating Swiss VAT rules, typical local rent benchmarks, and salary social charges.
2. Revenue Drivers & Pricing Logic (Critical)
Dynamic Pricing Calculator: A dedicated input section to define and test pricing for:
Membership Tiers: (e.g., Unlimited, Off-Peak, 4x/Month).
Class Packs: (e.g., 5, 10, 20 classes) with expiry logic.
Private Sessions: Hourly rates.
Workshops/Retreats: Occasional revenue streams.
ASP Calculation: The model must automatically calculate the Average Selling Price (ASP) based on the mix of the above products.
Capacity & Occupancy: Revenue must be driven by:
Number of Reformer machines (e.g., 8–12 units).
Class Schedule (sessions per day/week).
Occupancy Rate % per class (with ability to ramp up from 0% to target ~80%).
Detailed staffing logic as instructor utilisation, class-wise payroll allocation, commission structures, and peak vs off-peak scheduling impact on profitability and contribution margins
3. Unit Economics Dashboard
Customer Metrics: Automated calculation of CAC (Customer Acquisition Cost), LTV (Lifetime Value), Churn Rate, and Contribution Margin per Member.
Machine Economics: Revenue and margin contribution per Reformer machine.
4. Costs & Capital Expenditure (CAPEX)
Startup Costs: Detailed breakdown for Reformer equipment (import/customs duties if applicable), studio fit-out (high Swiss standards), legal, and pre-opening marketing.
Operating Expenses (OPEX): Detailed lines for rent, instructor salaries (hourly vs. fixed), utilities, insurance, and software subscriptions.
Working Capital: Projection of cash needed to sustain operations until positive cash flow.
5. Investment Returns & Exit Metrics
Key Returns: Calculation of IRR (Internal Rate of Return), ROI/ROE (Return on Equity), NPV (Net Present Value), and Payback Period (in months).
Breakeven Analysis: Exact month of cash flow breakeven and the specific member count required to cover monthly fixed costs.
6. Scenario & Sensitivity Analysis
Three Scenarios: Base Case, Upside Case (+20% growth), and Downside Case (-20% growth).
Sensitivity Tables: Show impact on IRR and Cash Flow if key variables change (e.g., Occupancy Rate ±10%, Membership Price ±5%, Churn Rate ±2%).
The model should include future expansion logic such as multi-site rollouts, debt refinancing, investor dilution scenarios, and valuation modeling based on EBITDA/revenue multiples over the 5-year horizon.
Deliverables:
Fully editable Excel file with clear assumption tabs, calculation engines, and dashboard summaries.
Brief PDF summary of key findings and assumptions.