Capacity by Group
Set available places for each training group and schedule any capacity additions.
It is an editable five-year Excel workbook that models occupied training capacity, monthly fees, costs, scenarios, and linked financial statements.
Use the model to plan how available training places, occupancy, pricing, ancillary revenue, costs, staffing, and funding choices flow through a five-year forecast.
Change the operating assumptions in the input schedules, then review the resulting monthly and annual revenue, cash flow, profitability, and balance-sheet effects.
The model converts available places into occupied places, applies monthly fees and optional ancillary revenue, then aggregates active months into annual revenue.
Set available places for each training group and schedule any capacity additions.
Apply the occupancy rate or ramp to available places to calculate occupied places.
Multiply occupied places by the matching monthly fee for each group.
Add enabled extra monthly revenue per occupied place and sum all groups.
Apply launch timing, active months, and seasonality, then sum monthly revenue into annual revenue.
The Revenue Assumptions view organizes launch timing, occupancy, group capacity, monthly fees, and extra revenue inputs that feed the occupied-capacity calculation.
REVENUE ASSUMPTIONS
The COGS & Operational Expenses view separates direct delivery costs, variable expenses, and fixed operating costs for monthly planning.
COGS & OPERATIONAL EXPENSES
The Scenario Analysis view compares Low, Base, and High paths for revenue and profitability measures across the five-year forecast.
SCENARIO ANALYSIS
The Dashboard combines setup controls, scenario selection, key metrics, revenue mix, profitability, cash flow, and payback charts in one management view.
DASHBOARD
The ready-made model fits occupied-capacity training economics; choose custom modeling when your revenue logic, operating schedules, or reporting structure differs materially.
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 financial reporting.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable five-year financial model for download, with business inputs, scenario analysis, and linked financial reporting.
Open the fully editable Excel model and replace the pre-built assumptions with your own.
Plan monthly and annual results across the model’s five-year projection period.
Compare Low, Base, and High cases through the dedicated Scenario Analysis view.
Review the income statement, cash flow statement, balance sheet, dashboard, and other linked reports.
The essential answers are visible in full, with no accordion clicks required.
It calculates occupied places from available capacity and occupancy, applies monthly fees and optional extra revenue, then sums active monthly revenue into annual revenue.
You can change the launch date, group capacity, occupancy, monthly fees, extra revenue, capacity additions, active months, group definitions, and seasonality.
The Scenario Analysis view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across the forecast.
The workbook includes the income statement, cash flow statement, balance sheet, Dashboard, Scenario Analysis, Summary, and several management reports.
Yes. Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting.
It is a planning forecast driven by editable assumptions, not a guarantee of business performance or financial results.
This purchase gives you a comprehensive Excel financial model for sexual harassment training business, complete with a dynamic dashboard, detailed financial statements, and fully editable assumption sheets.
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 made advanced Excel feel manageable, with the formulas laid out clearly enough that I could build the model without second-guessing every cell. It saved me about 6 hours of trial and error.
I was stuck staring at a blank sheet, and this gave me a clean place to begin. I had the first draft of our training forecast done in one afternoon instead of losing a full day to setup.
The charts and statements were already organized, so I stopped bouncing between files to piece everything together. That cut my monthly reporting prep by roughly 3 hours and made the assumptions easier to explain.