Define Capacity
Set available training places by group and schedule capacity additions when needed.
This editable five-year Power BI training workbook forecasts occupied-place revenue from capacity, occupancy, monthly fees, ancillary revenue, scenarios, and core financial statements.
Use the model to translate course places, occupancy, monthly fees, ancillary revenue, capacity timing, active months, and seasonality into a structured training-business forecast.
Editable assumptions feed revenue, operating costs, scenario comparisons, the dashboard, and financial statements so changes flow through one connected planning structure.
The model calculates occupied places by training group, applies monthly fees and enabled ancillary revenue, then sums active monthly revenue across groups.
Set available training places by group and schedule capacity additions when needed.
Multiply available places by the occupancy rate or occupancy ramp for each group.
Multiply occupied places by the monthly fee per occupied place for each group.
Add enabled ancillary revenue per occupied place and apply launch, active-month, and any seasonality timing.
Sum group revenue by month, then total active months to calculate annual revenue.
The Revenue Assumptions view organizes launch timing, available places, occupancy, monthly fees, group definitions, and extra revenue per occupied place.
REVENUE ASSUMPTIONS
The COGS & OPEX view separates revenue-linked course costs, variable expenses, and fixed operating costs with timing and periodicity assumptions.
COGS & OPEX
The Scenario Analysis view compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
SCENARIO ANALYSIS
The Dashboard consolidates setup controls, scenario multipliers, key financial metrics, revenue mix, profitability, cash flow, and investment payback in one view.
DASHBOARD
The ready-made workbook fits training businesses that sell finite monthly places by group; materially different revenue logic or operating schedules may need custom work.
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 reporting for your training business.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive the editable five-year Excel and Google Sheets model with monthly projections, Low/Base/High scenarios, and core financial statements.
Edit launch date, places, occupancy, monthly fees, extra revenue, capacity timing, seasonality, costs, staffing, CAPEX, and financing assumptions.
Review projected training operations and financial results across 60 monthly periods.
Compare Low, Base, and High cases using the workbook scenario structure.
Review the income statement, cash flow statement, balance sheet, dashboard, summary, and related reports.
The essential answers are visible in full, with no accordion clicks required.
It multiplies available places by occupancy for each training group, applies monthly fees and enabled ancillary revenue per occupied place, then totals active monthly revenue.
You can edit launch date, places by group, occupancy, monthly fees, extra revenue per place, capacity additions, active months, and seasonality.
The Scenario Analysis view compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
The workbook includes a Dashboard, Income Statement, Cash Flow Statement, Balance Sheet, Summary, Break-Even, ROIC, Charts, KPIs, Valuation, Ratios, and additional supporting reports.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, calculations, or reporting.
It is a planning forecast based on editable assumptions, not a guarantee of revenue, profitability, funding, valuation, or business performance.
This template provides a comprehensive, five-year financial model with a dynamic dashboard, detailed cost breakdowns, and investor-ready reports specifically for a Power BI training business.
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 pulled pricing, costs, and growth into one place, so I stopped chasing numbers across tabs. I saved about 4 hours on my last planning update and could explain every assumption without extra cleanup.
I used to build low, base, and high cases by hand, which took forever. With this model, I set up all three in one pass and finished my forecast review a day early.
I’m not strong in advanced modeling, so this was a relief. The structure made the Power BI training course forecast easy to follow, and I was able to book a partner meeting without asking for help.