
Open
Posted
Paid on delivery
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.
Project ID: 40467771
51 proposals
Open for bidding
Remote project
Active 13 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
51 freelancers are bidding on average €452 EUR for this job

With respect to my rich experience as a Finance, Accounting, and Data Analytics professional alongside numerous successful projects in financial planning & analysis and sophisticated financial modeling, I believe I possess the technical know-how, the analytic foresight, and the deep understanding of Swiss business operations that your project demands. Not only can I build you a uniquely integrated and investor-ready 5-Year Financial Model with all the specificities required in a Swiss context, but I also bring dynamic pricing calculators, LTV calculations, churn rate projections and profitability analyses to the table. My past experience and skill set extend to even breakeven analysis and sensitivity tables - both of which will be crucial for your fitness studio project. Furthermore, in selecting me for this project, you'll be getting not only an ergonomic 3-statement structure built in Excel but also a well-rounded expert who goes above and beyond – with detailed assumptions tabs enabling comprehensibility, calculation engines ensuring accuracy, and dashboard summaries guaranteeing ease at overviewing simulated key metrics. Alongside these deliverables, you can always count on my availability to offer support beyond contract limits with no additional charges. So why settle for less when you can have the best? Let's discuss further how I can specifically align my impressive skills with your exact needs. Get in touch!
€250 EUR in 1 day
7.6
7.6

Hi there, I understand you need a fully integrated, investor-ready 5-year financial model for a Swiss fitness studio with detailed operational logic, Swiss tax and payroll considerations, unit economics, scenario analysis, and expansion modeling. My approach will be to develop a fully linked three-statement Excel model with monthly projections for the first 24 months and annual projections thereafter. The model will incorporate Swiss VAT treatment, employer social charges, withholding tax considerations, local rent benchmarks, and operational assumptions tailored to the selected city. Revenue will be driven dynamically through membership tiers, class packs, occupancy ramps, machine utilization, instructor scheduling, and private-session logic, with automated ASP and contribution-margin calculations. I will also build investor-focused outputs including IRR, NPV, ROI/ROE, payback period, breakeven analysis, and sensitivity tables across occupancy, churn, and pricing variables. Expansion logic for multi-site scaling, refinancing, dilution, and valuation modeling will be included in a modular structure for future adaptability. Which Swiss canton and city should the model be optimized for since payroll burden, tax assumptions, commercial rent levels, and regulatory costs can vary significantly across locations? I’m ready to start immediately. Warm Regards, Aneesa.
€250 EUR in 2 days
7.0
7.0

Hey! A strong investor-ready financial model for a Switzerland-based studio business needs more than simple forecasting, it should reflect real operational mechanics, Swiss tax structures, canton-specific employer costs, VAT treatment, occupancy-driven revenue logic, and long-term scalability in a way investors can analyse confidently. Strong experience in advanced Excel financial modelling, multi-scenario forecasting, and operational modelling helps build fully integrated 3-statement models with detailed revenue drivers, unit economics, expansion planning, and valuation logic tailored to real-world business performance. • Fully integrated Excel model with Swiss-specific tax, payroll, VAT, and operational assumptions • Dynamic pricing, occupancy, staffing, unit economics, CAPEX, and breakeven analysis • Scenario modelling, investor returns, expansion logic, refinancing, and valuation forecasting The final model will help support investor discussions, funding decisions, operational planning, and long-term scaling with clear dashboards and transparent calculation flows that are easy to update and audit. Clean structure, accurate business logic, and detailed financial visibility can turn this into a powerful decision-making tool for both operations and future investment rounds. Thanks Arwa M.
€500 EUR in 7 days
6.8
6.8

I am an expert in creating 5-Year Financial Model in Excel using VBA for business plans and also an expert Management Accounting, financial management, and all financial and accounting and share marketing concepts. Experienced MBA Finance as well. I read your project description and I am sure that I can handle your project. • Have done many dissertations, and many finance Research project. • Also, an expert in Research writing, research reports, essays and advance essays, dissertations. • Your project will be delivered on time with high standard. • Expert in in all referencing styles (APA/ Harvard / etc.). • 100 % Assurance on zero percent plagiarism. • TURNITIN / COPYSCAPE plagiarism report will be provided along with completed work • Assistance will be provided with number of clarifications until client satisfaction • I will provide assistance even after the payment. And will maintain data (content) security.
€500 EUR in 7 days
6.7
6.7

Hi, I am a qualified Chartered Accountant from UK having 7 Year experience in accounts, finance, and financial projections. I can provide you with forecasted profit or loss accounts, balance sheet, cashflow, equity analysis, NPV,IRR,Payback,ratio analysis, and breakeven analysis just within a day. Please share your business plan or other data so that I can start working. Please come to chat and discuss further. **Note** the price is negotiable. Thanks & Regard: Shahid Mehmood
€500 EUR in 1 day
6.2
6.2

As a seasoned financial expert and duly recognized Chartered Accountant, I possess the necessary skills to bring your project to life. With over 9 years' experience aiding ventures like yours at various growth stages, I possess deep insights on how to construct and deploy a bottom-up financial model that is fully integrated and investor-ready. My familiarity with Swiss market dynamics, including specific factors such as location peculiarities and taxes will be invaluable as well. Endowed with a meticulous eye for detail, my specialty in financial consulting has honed my ability to apprehend complex data sets and translate them into actionable insights that support concrete decision making. With Switzerland's landscape in mind, I will adeptly incorporate the unique CHF currency, Swiss VAT rules, rental benchmarks, salary social charges and other location specificities into an organized system via Excel.
€250 EUR in 7 days
6.3
6.3

Hey there, I can build a fully integrated, investor-ready 5-year financial model tailored specifically for your Switzerland-based fitness studio, incorporating kanton taxes, Swiss VAT, employer on-costs, withholding tax, payroll charges, and location-specific operating assumptions. As a Chartered Management Accountant with 17 years of experience in accounting, finance, and financial modeling, I have developed forecasting and valuation models for startups and growing businesses focused on profitability, cash flow planning, and investor reporting. The model will include: • Fully linked P&L, Balance Sheet, and Cash Flow statements • Monthly projections for Years 1–2 and annual forecasts for Years 3–5 • Dynamic pricing and ASP calculations for memberships, class packs, private sessions, and workshops • Revenue driven by machine capacity, class schedules, occupancy ramp-up, and utilisation rates • Detailed staffing, payroll allocation, commissions, and contribution margin analysis • CAPEX, OPEX, working capital, and cash runway projections • IRR, NPV, ROI/ROE, payback period, and breakeven analysis • Base, upside, and downside scenarios with sensitivity analysis • Expansion, refinancing, dilution, and valuation modeling logic • Clean dashboards, assumption tabs, editable Excel model, and PDF summary I focus on creating models that are accurate, transparent, easy to navigate, and suitable for investors and lenders. Best regards, Muzammal Pasha
€400 EUR in 7 days
6.3
6.3

Hello, I can build a fully integrated, investor-ready 5-year financial model for your Swiss fitness studio in Excel, designed for fundraising and strategic decision-making. The model will include a fully linked 3-statement structure (P&L, Balance Sheet, Cash Flow), with monthly projections for the first 24 months and annual forecasts for Years 3–5. Revenue will be driven by a dynamic pricing engine covering memberships, class packs, private sessions, and workshops, linked to reformer capacity, occupancy rates, and scheduling. It will automatically calculate ASP, staffing costs, and contribution margins. The model will be fully localized for Switzerland, incorporating canton taxes, VAT, employer social charges, rent benchmarks, and CHF currency assumptions. It will also include CAC, LTV, churn, IRR, NPV, payback period, breakeven analysis, and full scenario/sensitivity testing, plus expansion logic for multi-site growth and valuation modeling. You’ll receive a structured Excel file and a summary PDF. Regards Moiz
€500 EUR in 7 days
6.0
6.0

Hi, I can build a fully integrated, investor-ready 5-year financial model for your Switzerland-based fitness studio in Excel, tailored specifically to Swiss operating conditions including kanton taxes, employer social costs, VAT, withholding tax considerations, and local operating benchmarks. The model will include: • Integrated 3-statement financials (P&L, Balance Sheet, Cash Flow) • Monthly projections for Years 1–2 and annual forecasts for Years 3–5 • Dynamic pricing and revenue engine with memberships, class packs, workshops, and private sessions • Occupancy, capacity, staffing utilization, payroll allocation, and contribution margin analysis • Unit economics dashboard including CAC, LTV, churn, and breakeven metrics • CAPEX, working capital, IRR, NPV, ROI, payback, and valuation modeling • Scenario and sensitivity analysis with upside/downside cases • Expansion logic for multi-site rollout and investor dilution scenarios The final model will be clean, editable, well-structured, and designed for both operational planning and investor presentation, along with a concise PDF summary of assumptions and key findings. Please open the chat for further discussion. Thanks & regards, Naresh
€400 EUR in 1 day
5.7
5.7

Greetings, With extensive experience building investor-grade financial models for fitness, wellness, and multi-location service businesses, I can develop a fully integrated 5-year Excel model tailored specifically for a fitness studio operating in Switzerland. The model will include detailed monthly projections for the first 24 months and annual forecasts through Year 5, with fully linked P&L, Balance Sheet, and Cash Flow statements. I will incorporate Swiss-specific financial considerations including VAT treatment, canton-based taxation, employer social contributions, withholding tax impacts, local rent benchmarks, payroll burden calculations, and operational assumptions aligned with the selected city location. In addition, the model will include advanced investor and operational analytics such as CAC, LTV, churn, machine economics, contribution margins, breakeven analysis, IRR, NPV, ROI/ROE, payback period, and scenario/sensitivity analysis across key business drivers. I can also integrate expansion planning modules covering multi-site rollouts, refinancing structures, investor dilution mechanics, and valuation outputs using EBITDA and revenue multiple methodologies. The final deliverables will include a clean, fully editable Excel workbook with organized assumption tabs, dashboards, and calculation engines, along with a concise PDF summary highlighting key assumptions, findings, and investment insights suitable for lenders or investors. Regards, Aqsa.
€250 EUR in 2 days
5.8
5.8

I understand you need a bottom-up 5-Year Financial Model in Excel for a new Swiss fitness studio, incorporating location specificities, kanton taxes, employer on-top costs, and withholding tax. I recently built an investor-ready integrated financial model for a new F&B venture in Zurich, which accurately projected cash flow and P&L under similar Swiss tax and employment regulations. The model will feature monthly projections for the first 24 months and annual projections thereafter, all within a single, integrated Excel workbook. This will include detailed revenue build-ups, cost of goods sold, operating expenses, capital expenditures, debt financing, and tax calculations specifically tailored to Swiss cantonal requirements. I will build out the Income Statement, Balance Sheet, and Cash Flow Statement to be fully linked and dynamically updateable. Given the focus on a specific business city location, how will the unique demographic and competitive landscape of that chosen canton be factored into the revenue ramp-up assumptions? Ready to start as soon as you confirm scope.
€583 EUR in 21 days
5.3
5.3

With my strong background in financial analysis and modeling, rooted in over a decade of experience, I am confident in my ability to provide you with a top-tier 5-Year Financial Model for your Swiss fitness studio. Having worked on numerous projects of similar complexity, incorporating all the essential facets of your project description won't be an issue. I have ample experience working with Excel at an advanced level, creating integrated 3-Statements and comprehensive cash flow models with ease. What sets me apart is not only my technical proficiency but also my research-based approach. Your project requires accounting for very specific Swiss market nuances such as kanton taxes and the impact of withholding tax. My proven capacity to delve deeply into a market and fully comprehend its intricacies will ensure that your model is tailored precisely to the realities of doing business in Switzerland. Beyond just creating technical deliverables, I pride myself on producing content that's insightful and credible. By meticulously considering key financial metrics like LTV, churn rate, CAC and more my models will go beyond just numbers. They'll tell you the story behind those numbers and illuminate what they mean for your business' future profitability and cash flows. In conclusion, I'm ready to translate information into actionable insights that will give you a solid foundation for making informed business decisions!
€350 EUR in 5 days
4.9
4.9

Hello, I understand you need a fully integrated 5-year investor-ready financial model for a Swiss fitness studio, built in Excel with monthly detail for 24 months and annual projections for years 3–5, fully aligned with Swiss tax, salary, VAT, and operating structures. I will build a complete bottom-up 3-statement model (P&L, Balance Sheet, Cash Flow) in CHF, driven by membership tiers, class packs, occupancy per Reformer machine, staffing logic, CAC/LTV, churn, CAPEX/OPEX, and working capital. The model will include IRR, NPV, ROI, payback period, breakeven analysis, plus scenario and sensitivity tables for key drivers like pricing, occupancy, and churn. You’ll receive a clean, investor-ready Excel with structured assumptions, dynamic dashboards, and expansion logic for multi-site scaling and valuation scenarios, along with a concise PDF summary. As a Preferred Freelancer on Freelancer.com—recognized among the platform’s top 1% professionals—you can expect accurate, structured, and reliable delivery. Questions: 1. Which Swiss canton/city should I use for tax, rent, and salary benchmarks? 2. Do you already have target pricing and Reformer machine count, or should I use industry benchmarks? Best regards, Asif Nawaz Baloch SoasTech
€750 EUR in 7 days
4.9
4.9

Hello, I can build a fully integrated, investor-ready 5-year financial model for your Switzerland-based fitness studio in Excel, with detailed operational, tax, and valuation logic tailored to the Swiss market and canton-specific considerations. I have experience developing advanced financial models including: • Integrated 3-statement modeling (P&L, Balance Sheet, Cash Flow) • Monthly and annual forecasting structures • Dynamic pricing and membership revenue modeling • Capacity-driven operational forecasting • Unit economics and contribution margin analysis • CAPEX/OPEX planning and working capital projections • IRR, NPV, ROI, ROE, payback, and breakeven analysis • Scenario and sensitivity modeling • Expansion, refinancing, and valuation logic The model will include: • Swiss VAT, employer costs, withholding tax, and payroll assumptions • Revenue drivers linked to occupancy, class schedules, and ASP • Instructor utilization and payroll allocation logic • Dashboard summaries and assumption control panels • Clean, transparent formulas with structured calculation tabs • Investor-friendly outputs and presentation quality formatting I can also provide a concise PDF summary highlighting key assumptions, financial insights, and investment metrics alongside the editable Excel model.
€250 EUR in 2 days
5.0
5.0

I understand you need a robust 5-year financial model for a Swiss fitness studio, similar to the detailed bottom-up projections I've developed for other startups requiring nuanced market-specific costings and investor readiness. My experience includes building integrated models that accurately reflect ramp-up, seasonality, and complex tax structures. My approach will leverage Excel's full capabilities for a dynamic, bottom-up build. This involves granular revenue forecasting based on membership tiers, utilization rates, and ancillary services. Cost modeling will meticulously incorporate Swiss-specific elements like kanton taxes, employer on-costs, withholding tax, and location-based operational expenses. I'll build in sensitivity analysis for key drivers and ensure robust debt and equity financing schedules are integrated. To ensure optimal alignment, could you clarify the specific canton of operation for the studio? Also, are there any particular investor reporting requirements or KPIs you'd like to see highlighted? I'm available to discuss this further at your convenience.
€589 EUR in 21 days
4.0
4.0

Hi, I’ve built investor ready Excel financial models for fitness, wellness, and location based service businesses with monthly ramp up, linked three statements, pricing drivers, staffing logic, CAPEX, working capital, debt, returns, and scenario analysis. I’ve also worked on country specific models where local tax, employer on costs, VAT treatment, rent benchmarks, payroll assumptions, and investor dilution had to be clearly separated in assumption tabs. For your Swiss fitness studio, I can build a bottom up 5 year model in CHF with monthly projections for 24 months, annual years 3 to 5, dynamic pricing, ASP calculation, Reformer capacity, occupancy ramp, instructor utilization, class level margins, CAC, LTV, churn, machine economics, breakeven, IRR, NPV, ROI, payback, expansion logic, debt refinancing, dilution, and valuation multiples. I’ll deliver a clean editable Excel file plus a concise PDF summary of assumptions, findings, and investor level outputs. Best regards, George
€500 EUR in 7 days
3.6
3.6

Hello, I’m Sartaj, a finance and administration professional with strong experience in Accounting, Bookkeeping, and Financial Modelling. I have worked on Financial Modelling, Business Analysis, Business Planning, Forecasting, Excel (including advanced Excel and VBA), Payroll, and Financial Research. I’ve reviewed your project and understand that you need a detailed, investor ready 5-year financial model for a fitness studio in Switzerland with accurate Swiss market assumptions and fully integrated financial statements. I can build a fully linked, investor-ready Excel financial model with P&L, Balance Sheet, and Cash Flow statements, including monthly and 5-year forecasts, pricing logic, occupancy planning, staffing calculations, breakeven analysis, and scenario/sensitivity analysis. The model will also include Swiss specific assumptions such as VAT, kanton taxes, employer costs, withholding tax, and local operating expenses. It will be clean, fully editable, and easy to navigate for both investors and internal planning. You will receive: • Fully editable Excel financial model • Clear assumptions and dashboard tabs • Scenario and sensitivity analysis • PDF summary of key assumptions and findings I focus on building accurate, structured, and easy to use financial models that support confident business and investment decisions. Looking forward to discussing the project further. Best regards, Sartaj Ullah [ Accountant & Financial Analyst]
€250 EUR in 10 days
3.1
3.1

Hi, I am Syed Taha Hussain, and I would love to build this comprehensive 5-year financial model for your new fitness studio. Financial market analysis, corporate research, and automated spreadsheet modeling are my primary skills. I am a financial analyst and researcher with extensive experience. I am an expert in structuring fully integrated financial statements, specialising in linking dynamic operational drivers directly to the Income Statement, Balance Sheet, and Cash Flow Statement. I have a strong background in embedding region specific compliance logic into financial architecture, which means I can precisely incorporate Swiss VAT rules, kanton-specific corporate taxes, withholding taxes, and employer social security contributions (on-top costs). I have successfully executed several technical projects requiring professional data visualisation, and advanced sensitivity modeling. Kindly message me in the chat so I can share my previous financial modeling projects as a reference and discuss your specifics to get started immediately.
€280 EUR in 5 days
3.0
3.0

Hi! Investor-ready Swiss fitness studio model — built bottom-up. Dynamic pricing calculator (memberships, packs, sessions) driving ASP automatically, linked to Reformer capacity and occupancy ramp-up. Full 3-statement model in CHF with Swiss VAT, Kanton taxes, AHV/ALV charges and withholding tax. IRR, NPV, payback, breakeven by member count, and sensitivity tables on occupancy, price and churn. Free sample: share your canton and pricing structure — I'll return the revenue model and ASP calculator within 48 hours before you commit. Delivery: 7–10 days. Includes Excel model + PDF summary. One question: do you have existing investor assumptions, or are we defining the capital structure from scratch?
€380 EUR in 7 days
1.6
1.6

Hi there, I'm Cora May, and I’ll build your 5-year, Swiss investor-ready financial model in Excel with fully integrated monthly P&L, balance sheet, and cash flow (CHF). I specialize in bottom-up revenue drivers for fitness studios, dynamic membership/class/private pricing, occupancy ramp from 0% to target, instructor utilization, and class-wise payroll with Swiss-style employer on-costs and VAT logic. For the Swiss market, I’ll incorporate location-specific tax considerations (including Swiss withholding tax handling where relevant), ongoing OPEX detail (rent benchmarks, utilities, insurance, software), and working capital needs to ensure cash-flow reality, not just accounting profits. You’ll get an ASP auto-calculation by revenue mix, plus a unit economics dashboard (CAC, LTV, churn, contribution margin per member, and per machine economics). Finally, the model will include returns and exit metrics (IRR/NPV/ROI, payback), exact cash breakeven month with member count, and Base/Upside/Downside scenario + sensitivity tables tied to occupancy, pricing, and churn. Quick questions: Which Swiss canton/city is the studio in, and do you want instructor compensation modeled as primarily hourly, primarily fixed, or a hybrid with commissions? Also, what is your expected number of reformer machines and target utilization by month for the first 24 months? Best regards!
€555 EUR in 2 days
0.0
0.0

Milan, Switzerland
Member since May 23, 2026
€12-18 EUR / hour
€250-750 EUR
$5-20 USD / hour
€30-250 EUR
$10-50 AUD
₹750-1250 INR / hour
$5000-10000 USD
$30-250 USD
$30-250 SGD
₹7500-75000 INR
$250-750 AUD
£10-20 GBP
$15-25 USD / hour
₹1500-12500 INR
$250-750 USD
₹12500-37500 INR
$10-30 USD
$10-200 USD
€50-60 EUR / hour
₹12500-37500 INR
$30-250 AUD
$750-1500 USD