Clean Dashboard At Last
I finally had all the statements and charts in one place, so I stopped bouncing between files. It saved me about 4 hours a week and made the model much easier to review with my team.
I finally had all the statements and charts in one place, so I stopped bouncing between files. It saved me about 4 hours a week and made the model much easier to review with my team.
The template made it much easier to trust the formulas, and I spent less time checking every linked cell. One clean one-liner: I cut my model review from half a day to under an hour.
Low, base, and high case planning was spread out before, but this setup kept it simple. I built all three versions in one sitting and got a clearer planning meeting booked the same day.
This is a five-year forecast of Excel and Google Sheets, built around daily visits, a combination of services, prices, seasonality, scenarios and related financial statements.
Use the workbook to translate the Hammam and Steam Bath business plan into structured financial forecasts for revenue, costs, cash flow and profitability.
Editable assumptions are the source of monthly model calculations, which include annual forecasts, three planning cases, panel opinions and basic financial statements.
Revenue starts with one single pool of service visits, transforms them on working days and seasonality, allocates services calls, uses prices and once adds extra included.
Determine the average number of visits per day or operating period from the start date.
Convert visits to the size of the period using working days or periods and seasonality.
Divide the common pool of non-substituted service units into categories using a service combination.
Multiple units allocated by price category and add possible additional income once.
Total revenue of categories and allowances in each forecast period.
The income sheet shall organise a start, average daily visits, working days, seasonality, service prices, a combination of services and additional revenue for the visit.
GROUNDS FOR THE REVENUE
The COGS & OPEX card separates direct service costs, variable costs and fixed operating costs over the forecast periods.
COGS & OPEX
The Scenarios compared low, base and high results in terms of revenues, gross margin, premium margins and EBITDA in the five-year forecast.
SCENARIOS
The board includes a set of models, selection of scenarios, key finances, revenue mix, profitability, cash flow and return on investment in one management view.
DASHBOARD
It fits with companies that provide for a single visit to the group of services and prices; significant differences in the revenue structure may require non-standard modelling.
The template is the starting point of planning, not a guarantee of performance.
The Financial Models Laboratory can build or customize a model when your company needs a different revenue logic, operating schedules or reporting than a ready-made workbook.
ORDER A CUSTOM FINANCIAL MODELAfter you complete your order, you will receive a five-year financial model for Excel and Google Sheets with monthly and annual forecasts, scenarios, declarations and reporting on the dashboard.
Download the fully editable financial model and change the assumptions into your own.
Build five years of forecast with detailed monthly and annual reports.
Compare low, base and high cases through controls and model scenario reports.
Desktop overview, P&L, cash flow, balance sheet, summary and other included outputs.
The basic answers are visible in their entirety, without clicking on the accordion.
It provides for a single pool of service visits, applies operating periods and seasonality, allocates the number of services, multiplys the categories at price and adds the included allowances once.
You can change the start date, average visits, days or periods of work, monthly seasonality, combination of services, category prices and allow additional revenue for the visit or service unit.
The three cases may be compared with the change in revenue, gross margin, premium premium margin and EBITDA in the five-year forecast.
The workbook contains a dashboard, P&L, cash flow, balance sheet, scenarios, summary, break-even, ROIC, charts, KPIs, factors, valuation and related reports.
Yes. Financial Models Lab offers custom modeling for different revenue logic, operational schedules, or reporting requirements.
This is a planning forecast based on the assumptions you are making, not a guarantee of the results of business or financial results.
This pre-written steam room business plan template provides everything you need to build a comprehensive financial plan, from initial investment analysis to five-year profit projections.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark