Set Capacity
Enter available places for each training group or category and time future capacity additions.
This editable five-year workbook models training-place capacity, occupancy, monthly fees, ancillary revenue, costs, scenarios, financial statements, and dashboard reporting.
Use the workbook to translate group capacity, occupancy ramps, pricing, ancillary revenue, staffing, costs, and funding choices into a structured training-program forecast.
Editable operating assumptions feed linked monthly calculations, scenarios, financial statements, and management reports across the five-year forecast.
The model calculates occupied places by group, applies monthly fees and optional extra revenue per place, then sums active revenue after launch, ramp, and seasonality.
Enter available places for each training group or category and time future capacity additions.
Multiply each group’s available places by its occupancy rate or ramp to calculate occupied places.
Multiply occupied places by the matching monthly fee to calculate base monthly revenue.
Add occupied places times extra monthly revenue per place when that option is enabled.
Sum group revenue across active months after launch timing, occupancy ramp, and seasonality to produce monthly and annual revenue.
The Revenue Assumptions view connects launch timing, occupancy, group capacity, monthly fees, and extra revenue inputs to the model’s training revenue calculations.
REVENUE ASSUMPTIONS
The COGS & Operational Expenses worksheet separates direct revenue-linked costs, variable expenses, and fixed spending so operating assumptions remain editable across the forecast.
COGS & OPERATIONAL EXPENSES
The Scenario Analysis view compares Low, Base, and High outcomes for revenue and key margins, helping users see how alternative assumptions change forecast performance.
SCENARIO ANALYSIS
The Dashboard consolidates scenario controls, core financials, revenue mix, profitability, cash flow, and investment-payback reporting into one management view for review.
DASHBOARD
The template fits planning built around finite training capacity and occupied places; structurally different revenue logic or reporting 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 you need different revenue logic, operating schedules, or financial reporting than this template provides.
ORDER A CUSTOM FINANCIAL MODELThe download provides an editable Excel and Google Sheets financial model with five-year monthly and annual forecasting, scenarios, statements, and dashboard reporting.
Change business-specific assumptions and operating inputs directly in the Excel financial model.
Review five years of monthly and annual financial projections linked to your inputs.
Compare Low, Base, and High cases using the model’s scenario analysis framework.
Use the Income Statement, Cash Flow, Balance Sheet, Dashboard, and other confirmed reports.
The essential answers are visible in full, with no accordion clicks required.
It calculates occupied places by group from available capacity and occupancy, then applies monthly fees and optional extra revenue per occupied place. Monthly revenue is summed across groups and annualized across active months.
You can edit launch date, places by group, occupancy, monthly fees, extra revenue per place, capacity additions, group definitions, active months, and seasonality when used.
You can compare how alternative scenario assumptions change revenue, gross margin, contribution margin, EBITDA, and related forecast outcomes.
The product page confirms Income Statement, Cash Flow, Balance Sheet, Dashboard, Scenario Analysis, Summary, charts, KPIs, and additional financial reports.
Yes. Financial Models Lab offers custom financial modeling when different revenue logic, operating schedules, or reporting structures are required.
It is a planning forecast based on editable assumptions, not a guarantee of financial or operating performance.
This pre-written Excel financial template for mental health training provides everything you need to build a comprehensive financial plan, from initial startup cost analysis to a full five-year forecast.
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
This template gave me a clean structure for what investors expect, so I could explain the plan without guessing at the right outputs. It saved me a full day of rework before our next meeting.
I had pricing, costs, and growth scattered across notes and spreadsheets. This model pulled everything into one place, and I was able to tighten the assumptions in under two hours.
Building the financials by hand was taking forever, and I kept losing time fixing formulas. With this template, I finished the first full draft the same afternoon and moved on to the pitch.