Set Capacity
Enter available places by group, category definitions, launch timing, and planned capacity additions.
An editable five-year Excel and Google Sheets workbook that converts training-place capacity, occupancy, monthly fees, and ancillary revenue into financial statements and management reports.
Use it to plan how many places each training group can offer, how quickly occupancy ramps, what each occupied place earns, and how those decisions flow into revenue and cash needs.
Update launch timing, group capacity, occupancy, fees, extra revenue, seasonality, operating costs, staffing, and capital inputs; linked calculations update the forecast and reports.
The model turns available training places into occupied places, applies monthly fees and optional extra revenue, then aggregates active monthly revenue across groups.
Enter available places by group, category definitions, launch timing, and planned capacity additions.
Multiply available places by the occupancy rate or ramp to calculate occupied places.
Multiply occupied places by the monthly fee per place for base monthly revenue.
Add enabled extra revenue per occupied place and apply launch, active-month, and seasonality timing.
Sum group revenue each month, then sum active months to calculate annual revenue.
The Revenue Assumptions sheet links group capacity, occupancy, monthly fees, and extra revenue inputs to the model’s occupied-place revenue logic.
REVENUE ASSUMPTIONS
The COGS & OPEX sheet separates direct costs, variable expenses, and fixed operating costs with timing and forecast assumptions for budgeting.
COGS & OPEX
The Scenario Analysis view compares Low, Base, and High outcomes across revenue, gross margin, contribution margin, and EBITDA over five years.
SCENARIO ANALYSIS
The Dashboard combines scenario controls, headline KPIs, core financials, revenue mix, profitability, cash flow, and investment-payback visuals in one view.
DASHBOARD
It fits businesses earning recurring fees from finite training places; structurally different monetization or reporting needs may require custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your business needs different revenue logic, operating schedules, or reporting structures.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive an editable Excel and Google Sheets financial model with five-year forecasts, scenarios, and linked financial reports.
Change business assumptions directly in the model and review the linked forecast outputs.
Plan revenue, costs, cash flow, and profitability across the model’s five-year horizon.
Compare Low, Base, and High cases using the workbook’s scenario analysis.
Review the income statement, cash flow statement, balance sheet, Dashboard, and Summary outputs.
The essential answers are visible in full, with no accordion clicks required.
Revenue starts with available places by group multiplied by occupancy to get occupied places, then applies monthly fees and optional extra revenue per occupied place. Monthly group revenue is summed and annual revenue follows active months, launch timing, ramp, and seasonality.
You can change the launch date, group definitions, available places, occupancy ramp, monthly fees, extra revenue per place, capacity additions, active months, and seasonality.
The Scenario Analysis view compares Low, Base, and High trajectories for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
The product shows an income statement, cash flow statement, balance sheet, Dashboard, Summary, scenario analysis, charts, KPIs, and additional management reports.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structures.
It is a forecast, not a guarantee. Results depend on the assumptions you enter, and actual business performance can differ.
This powerful spreadsheet provides everything you need to build a comprehensive financial plan for your reaction time training program, from startup costs 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
Building the forecast by hand would’ve taken me days, and this template cut that down fast. I had a clean model ready to review in a couple of hours.
I’m not deep in Excel, so the simple tabs and clear inputs were a relief. I filled it in without getting stuck on formulas and had our numbers ready for the meeting.
The pricing, cost, and growth inputs were finally all in one place instead of scattered everywhere. That made the whole plan easier to explain and tightened up our projections.