
Open
Posted
•
Ends in 4 hours
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: 40468032
55 proposals
Open for bidding
Remote project
Active 19 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
55 freelancers are bidding on average €463 EUR for this job

As a financial expert with a strong background in Excel-based models and intimate knowledge of the Swiss finance market, I am uniquely positioned to deliver a comprehensive, investor-ready 5-Year Financial Model for your fitness studio project in Switzerland. I understand the intricacies of Swiss location-specific taxes, employer on-top costs, VAT rules, rent benchmarks, and more, all factors that have crucial implications for your bottom line. My meticulous attention to detail and deep understanding of cash flow forecasting will ensure nothing is left to chance in this crucial document. One of the vital aspects of the financial model will be accurately estimating the revenue drivers and pricing logic specific to your fitness studio. As part of my regular work, I have developed sophisticated pricing calculators incorporating dynamic pricing strategies for various businesses. Your project requires precise cash flow projections till breakeven analysis and detailed investment planning with multiple sensitivities, I excel at these tasks. Transparent collaborations, timely updates and maintaining confidentiality are non-negotiable aspects of my work ethic that would uphold your peace of mind throughout the project. Let's partner up and create a successful roadmap towards your financial success!
€750 EUR in 7 days
9.0
9.0

Heyy! Thank you for sharing your fitness studio financial model project details. I’ve thoroughly gone through the requirements and I can help you build a fully integrated, investor ready 5 year financial model in Excel tailored specifically for the Swiss market, including kanton taxes, Swiss payroll contributions, VAT structure, operational costs, occupancy driven revenue logic, and detailed expansion forecasting. Being a Harvard Graduate and having more than 7 years of experience in advanced financial forecasting, valuation modeling, and investor reporting. I will create a dynamic and highly structured model with integrated 3 statements, scenario analysis, unit economics, breakeven tracking, IRR and NPV calculations, sensitivity dashboards, and scalable multi site expansion logic while ensuring clarity, accuracy, and professional presentation throughout the workbook and summary report. Send me a message for further discussion about the project. Thanks, Arwa M.
€750 EUR in 7 days
6.7
6.7

With nearly a decade of experience as a Chartered Accountant and ACA qualified professional, I’m delighted to offer my expertise in accounting, finance, and financial modeling to your 5-Year Financial Model for your new fitness studio in Switzerland. Having actively worked and acquired extensive knowledge about the Swiss finance market, I understand the importance of incorporating location specificities, such as Swiss VAT rules, typical local rent benchmarks, employer on-top costs, and withholding tax. My proficiency in building fully integrated and investor-ready models align with your project's requirements. My work will include a comprehensive Integration of 3-Statements including an Income Statement (P&L), Balance Sheet, and Cash Flow Statement meticulously capturing all details relevant to Switzerland. Your project also specifically states the need for a detailed Revenue Drivers & Pricing Logic section which is critical for long-term success. As a seasoned financial analyst, I have already worked on several projects involving this aspect. The model will enable dynamic pricing calculations that will define and test pricing for membership tiers, class packs as well as private sessions.
€250 EUR in 7 days
6.3
6.3

1. I am an expert in Market research, Market analysis, Marketing strategies and planning/ Feasibility study. I read your project description and I am sure that I can handle your project. I Have possess a strong knowlegde in 5-Year Financial Model , financial modelling , cash flow, p&l, Experience with the Swiss finance market. I Have done many works similar to this project. please reach me in chat for discussion. Sure, I can handle your project. 2. Also expert in all marketing and business writing, PERT, SWOT analysis, environmental analysis , PESTLE analysis, Marketing MIX, Segmentation, Project management, Budgeting, Financial consideration, business plan, market research, SWOT analysis and have done many similar projects. 3. Also an expert in Research writing, research reports, essays and advance essays, dissertations. 4. Your project will be delivered on time with high standard. 5. Expert in all referencing styles (APA/ Harvard, etc.). 6. 100 % Assurance on zero percent plagiarism. 7. TURNITIN / COPYSCAPE plagiarism report will be provided along with completed work 8. Assistance will be provided with number of clarifications until client satisfaction 9. I will provide assistance even after the payment. And will maintain data (content) security.
€250 EUR in 1 day
6.8
6.8

Hi, A Switzerland-based fitness studio financial model built with investor-grade precision can turn expansion plans into clear funding decisions. I will build a fully integrated 5-year Excel model covering Swiss kanton taxes, VAT, payroll charges, occupancy-driven revenue, reformer machine economics, and multi-site expansion logic to support stronger cash flow planning and clearer ROI visibility. 1. Improve investor confidence with integrated IRR, NPV, and breakeven analysis. 2. Increase pricing and occupancy visibility for stronger profit margins. With 6 years of experience, I bring advanced financial modeling expertise for startups and operational businesses. I work with Excel, Power Query, scenario analysis tools, and dynamic dashboard systems to create structured and easy-to-update models. I also make investor pitch financial summaries, valuation models, budgeting systems, and forecasting dashboards for fundraising and strategic planning. The bid price is tentative; let’s connect over chat to discuss the project, exchange sample works, and go over the budget in more detail. Line spacing Moiz H.
€500 EUR in 7 days
6.1
6.1

Hi, I am an expert in Financial Modeling. I have completed the same type of work before. Please have a look: https://www.freelancer.com/projects/finance/Financial-Model-investment-model/reviews I can do your model. Lets discuss in details.
€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

Heyyy, A Swiss fitness studio financial model done properly is not a generic template with CHF swapped in it needs canton-specific tax treatment, Swiss social charges on top of salaries, VAT logic, and rent benchmarks that actually reflect what landlords in your city are charging. Building bottom-up, investor-ready financial models for service businesses with this level of Swiss regulatory and operational detail is work that has been delivered to founders and investors who know exactly what they are looking at. Full three-statement integration, monthly projections for the first 24 months, dynamic pricing calculator across membership tiers, class packs and private sessions, capacity and occupancy ramp-up logic, unit economics dashboard with CAC, LTV and churn, CAPEX breakdown, IRR, NPV, payback period, breakeven analysis, three scenarios, sensitivity tables, and future expansion modeling all in a clean Excel file with a PDF summary of key findings. Send the location details and any existing assumptions over in chat and let's build a model your investors will trust. Warm Regards, Aqsa I.
€500 EUR in 7 days
6.0
6.0

Hello, I am an experienced financial modeler with deep expertise in Swiss fitness studio economics (kanton taxes, social charges, withholding tax, local rents). I will build an investor‑ready 5‑year Excel model (monthly for 24 months, annual years 3‑5) with dynamic pricing, capacity/occupancy drivers, staffing logic, unit economics (CAC, LTV, churn), CAPEX/OPEX, returns (IRR, NPV, payback), breakeven, three scenarios, sensitivity tables, and multi‑site expansion logic. Deliverables: editable Excel file plus brief PDF summary. Ready to start once you share your city, reformer count, and class schedule. Regards, Zafar
€250 EUR in 1 day
6.2
6.2

Hello there, I can build a fully integrated 5-year Excel financial model for your Swiss fitness studio, including 3-statement projections, pricing logic, occupancy/capacity drivers, staffing, CAPEX/OPEX, Swiss tax/social cost assumptions, and investor return metrics. The model will include unit economics, breakeven analysis, scenarios, sensitivity tables, expansion logic, debt/refinancing, dilution, valuation outputs, and a clean investor-ready dashboard. I’ll keep the workbook fully editable with transparent assumptions, linked formulas, and a brief PDF summary of key findings and assumptions.
€250 EUR in 1 day
5.2
5.2

I fully understand the importance of location-specific information when it comes to financial modeling. In this case, as someone who has experience in the Swiss Finance market, I'm well-aware of the nuances involving kanton taxes, employer on top cost, withholding tax etc. that are vital for a model based in Switzerland. Incorporating these detail-oriented nuances into your model will ensure its investor-readiness and expected real world profitability. Further differentiating myself from others, my skills extend beyond merely creating the model; they also encompass a holistic engagement through presentation which includes detailed explanation of assumptions built along with findings. My proven track record and ability to deliver exceptional results make me an ideal choice for your project. As an analytical mind committed to providing clients with value-generating insights tailored to their specific requirements, I'm looking forward to turning your data into actionable intelligence that optimizes decision-making.
€500 EUR in 7 days
5.9
5.9

Hi aa940, Last week I delivered a very similar, Swiss‑specific 5‑year model for a Zurich reformer studio, so I’m confident to handle this really well. I’ll keep inputs clean and Swiss‑compliant, so you avoid delays, confusion, and rework. i would like to know the below. - Exact city/kanton, legal form (GmbH/AG), and financing mix (equity, bank debt, leasing)? - Starting capacity plan: reformers count, classes per day (weekday/weekend), and target ramp (occupancy and churn)? I think we should model instructor payroll with utilisation, 13th salary, vacation accruals, AHV/ALV/BVG/UVG and withholding to get true class margins. I think we should add cohort‑based LTV/CAC by channel and a cash low‑watermark alert to size working capital and debt draws. Lets follow a plan like this. 1) I set up Assumptions tabs: CHF, VAT 8.1%, city rent benchmarks, kanton taxes, employer on‑top rates, import/customs. 2) I build the revenue engine: pricing calculator (tiers/packs/private/workshops with expiries), capacity/ASP, occupancy ramp, staffing and commissions. 3) I link P&L, BS, CF monthly (24m) then annual Y3–Y5, with CAPEX, WC, debt/refi, tax, and cash sweep. 4) I deliver dashboards: unit & machine economics, breakeven month/members, IRR/NPV/ROI, EV/EBITDA and revenue multiples, base/±20% cases, sensitivities, multi‑site and dilution; plus a concise PDF
€750 EUR in 11 days
5.3
5.3

As a veteran in the finance and accounting industry with over 15 years of professional experience and a broad skillset encompassing accounting, financial analysis, research, and modeling, I'm well-equipped to take on your ambitious 5-Year Financial Model project. Having worked extensively in different capacities with SMEs across multiple countries including the UAE, UK, US, and Qatar -- I not only understand the importance of local context specificities but also have enormous adaptability and attentiveness to unique tax legislations and employer cost structures. Moreover, one unique value I bring to all projects is my meticulousness. Due to the complex nature of this project there is no room for error or oversight. In light of this I guarantee a high level of attention to details in ensuring precise calculation engines for CAC (Customer Acquisition Costs), LTV (Lifetime Value) ,Churn Rate and Contribution Margin per Member. That's just a snippet of why I'm the right fit for your fitness studio project. With me as part of your team you can expect unwavering dedication;open lines for collaboration + communication and an unyielding commitment to delivering excellent solutions that meet (and exceed) expectations. I look forward to discussing elaborately how we can tailor this model to fit your fitness studio needs perfectly. Ready when you are!
€500 EUR in 7 days
5.0
5.0

Greetings! I will build a comprehensive bottom up 5 year financial model in Excel for your fitness studio in Switzerland. Integrated 3 statements with monthly projections for 24 months then annual for years 3 to 5. Swiss specific VAT, kanton taxes, employer social charges, rent benchmarks, and withholding tax. Revenue drivers with dynamic pricing calculator for memberships, class packs, private sessions. Capacity and occupancy based on number of reformers and class schedule. Unit economics dashboard for CAC, LTV, churn, contribution margin. Startup costs, OPEX, CAPEX. IRR, ROI, NPV, payback period. Breakeven analysis. Three scenarios base, upside, downside with sensitivity tables. Future expansion logic. Deliverables include editable Excel file and PDF summary. Please share your location, machine count, and target occupancy ramp. Thanks, Revival
€250 EUR in 7 days
4.3
4.3

As a highly-skilled financial modeling specialist with extensive experience in Swiss business practices, I'm confident I can create the detailed, integrated, and investor-ready 5-year financial model you need for your fitness studio in Switzerland. Taking into account the unique peculiarities that come with Swiss business operations such as the canton taxes, employer on top cost, ongoing operational costs, and withholding tax - the resulting model will accurately capture your business' future financial performance. I have an intricate understanding of how to work with Swiss VAT rules, typical local rent benchmarks, and salary social charges which is an advantage when it comes to building a comprehensive financial model. In addition to my technical proficiency with accounting software like QuickBooks Online and Excel that are crucial for executing a project of this scope efficiently I would also bring with me a wealth of experience in different aspects of bookkeeping where accuracy, efficiency, attention to detail all paired with the ability to be innovative while solving complex problems stemming from each project were key factors; qualities that would elevate your project's execution significantly. So let's start charting strategically accurate financial projections for your Swiss fitness studio!
€500 EUR in 7 days
4.1
4.1

⭐Investor-Ready 5-Year Financial Model for Swiss Fitness Studio⭐ Hey, ➤ I can build a fully integrated, bottom-up 5-year financial model tailored specifically for your Switzerland-based fitness studio, designed for investor presentations, fundraising, operational planning, and expansion forecasting. ✅What I will deliver: ↪️ Fully linked 3-statement financial model (P&L, Balance Sheet, Cash Flow) ↪️ Monthly projections for first 24 months + annual projections for Years 3–5 ↪️ Swiss-specific assumptions including CHF, VAT, kanton taxes, employer costs, and withholding tax logic ↪️ Dynamic pricing engine for memberships, class packs, private sessions, and workshops ✅Financial analysis included: ↪️ CAC, LTV, churn rate, contribution margin calculations ↪️ Revenue & profitability per reformer machine ↪️ Breakeven analysis with required member count and breakeven month ↪️ IRR, ROI, ROE, NPV, and payback period calculations ↪️ Working capital and runway forecasting ↪️ CAPEX planning including fit-out, equipment import/customs, and pre-launch costs ✅Scenario & sensitivity modeling: ↪️ Base case, upside (+20%), and downside (-20%) scenarios ↪️ Sensitivity tables for occupancy, pricing, and churn assumptions ↪️ Expansion logic for multi-location rollout planning ↪️ Debt refinancing, investor dilution, and valuation modeling using EBITDA/revenue multiples ?Portfolio: (https://www.freelancer.pk/u/usmansharif362) Regards, Usman Sharif
€499 EUR in 5 days
4.1
4.1

I understand you need a detailed, bottom-up 5-Year Financial Model in Excel for a new Swiss fitness studio, specifically incorporating location-specific factors like kanton taxes, employer on-costs, and withholding tax. I have previously built a similar 5-year integrated financial model for a European retail expansion that successfully secured seed funding. My approach will be to construct a dynamic Excel model with a fully integrated 3-statement structure (P&L, Balance Sheet, Cash Flow). I will build out monthly projections for the first two years, followed by annual projections, explicitly modeling revenue drivers, operational costs, capital expenditures, financing, and Swiss tax implications as outlined. Given the emphasis on location specificities, how will the model account for varying rental costs and competitive pricing across different Swiss cities if the exact business city location is still being finalized? Ready to start as soon as you confirm scope.
€568 EUR in 21 days
3.7
3.7

Having spent a significant amount of time working within the realm of financial modelling, I have gained a thorough understanding of the complexities and real-time intricacies involved. My comprehensive and fully integrated 5-year financial models have assisted numerous companies in crafting effective business strategies while navigating Switzerland's unique financial landscape. This has also included employer on top cost calculations, withholding tax considerations, and location specificities. An expert in unit economics analysis, my models not only provide key business metrics but also delve into customer acquisition cost, lifetime value, churn rate and contribution margin per member. Furthermore, I am well-versed with various economic evaluations ranging from startup costs, operating expenses to capital expenditures incorporating possible project expansions that you anticipate like multi-site rollouts. As an experienced freelancer who has successfully delivered top-notch models in the Swiss finance market on time for investment raisings/deal analysis/market entry strategy projects , I guarantee that my work will be decision-ready over volume; prioritizing quality, depth, and outcomes.
€500 EUR in 7 days
3.2
3.2

hello, i can build a fully integrated 5-year investor-ready financial model for your swiss fitness studio with linked p&l, balance sheet, cash flow, scenario analysis, valuation metrics, and swiss-specific tax/cost assumptions. i have experience in advanced excel financial modeling and dashboard design. which swiss canton and city should the model be based on for accurate tax and salary calculations?
€251.99 EUR in 1 day
2.8
2.8

Drawing from my extensive programming, data analytics, and finance background, I am confident in my ability to exceed your expectations for this comprehensive 5-Year Financial Model project. Equipped with mastery in Excel and a deep understanding of accounting principles, I am well-suited to deliver an investor-ready financial model that fully integrates the Swiss context for your fitness studio venture here in Switzerland. My expertise extends to essential factors like local taxes, employer costs, and ongoing operational expenses specific to the Swiss market. Not only am I well-versed in cash flow management and P&L analysis but also adept at employing automation techniques for improved accuracy, efficiency, and ease-of-use within Excel models. That's why I consistently emphasize on creating integrated and easily accessible sheets where you can see all the data you need at a glance without getting lost.
€250 EUR in 7 days
2.9
2.9

Milan, Switzerland
Member since May 23, 2026
€250-750 EUR
€12-18 EUR / hour
$30-250 USD
€8-30 EUR
$250-750 USD
$250-750 USD
₹400-750 INR / hour
$10-30 USD
£250-750 GBP
$15-25 USD / hour
₹600-1500 INR
₹12500-37500 INR
£20-250 GBP
$10-30 USD
₹750-1250 INR / hour
$10-200 USD
₹1500-2000 INR
$15-25 USD / hour
₹100-400 INR / hour
$30-250 USD
$100-150 USD
$250-750 USD