Trusted by 25,000+ startup founders, investors and CPAs
Clearer Modeling Fast
Megan Carter, TX
I’m not a spreadsheet expert, so this template kept the modeling from feeling too technical. I finished my first draft in about two hours instead of hiring help.
Runway Made Easy
Daniel Brooks, FL
The cash flow tabs made it much easier to see where the school might come up short. I mapped out runway and funding needs in one afternoon, which saved me a lot of guesswork before our board meeting.
Simple Scenario Planning
Lauren Mitchell, NJ
I used to dread building low, base, and high cases by hand. This template made the comparisons easy, and I had all three scenarios ready for review in less than a day.
MODEL OVERVIEW
What Is the Private School Financial Model?
The financial model of the Private School is an editable five-year Excel workbook, which provides for tuition income based on skills and combines them with scenarios, statements and management reporting.
Use the workbook to plan school capacity by dividing, covering, tuition monthly, additional income, operating costs, staff, capital expenditure and time-based financing.
The editable assumptions are the basis for monthly and annual calculations, while the scenarios and reporting opinions translate into revenue, profitability, cash flow and financial position.
Built for recruitment planningChange of start time, places by school breakdown, betting, monthly fees, additional income, capacity increase, active months and seasonality to reflect your plan.
ENGINE OF PRIVATE REVENUE
How Does the Private School Model Calculate the Revenue?
The revenue starts with available places by school breakdown, the betting, monthly fees and optional additional income is applied and then sums up the active months after the start, ramp and seasonality.
01
Set Capacity
Enter available places according to school breakdown and schedule of any capacity allowances.
02
Apply Class
The space occupied is equal to the available seats multiplied by the overlay or ramp ratio.
03
Apply Fees
The monthly base income is the seats taken by the monthly fees of each group.
04
Add Extras
Taking into account the possibilities, the additional revenue shall be added to the additional monthly revenue for each occupied seat.
05
Calculate Income
Total revenue shall be added up to all groups within months of the start, ramp and seasonality.
FORM OF CORRECTIONRevenue = occupied places × Monthly fee + occupied places × Additional income
01 / REVENUE RESULTS
Where Are the Income Sets from Private School?
View Revenue assumptions organizes the launch of schedule, occupancy, school division, monthly fees and additional revenue, with schedule and seasonality shaping the active months of forecasts.
GROUNDS FOR THE REVENUE
The worksheet sets out the assumptions for the start-up, enrolment, distribution of schools, monthly fees and additional revenue.
02 / COGS & OPERATIONAL EXPENDITURE
How Are Private School and Operating Costs Planned?
View COGS & Operating expenditure separates direct costs, variable costs and fixed operating costs, so that expenditure assumptions can be consistent with the school's business plan.
OPERATING EXPENDITURE COGS
The cost plan shall present direct, variable and fixed expenditure, including monthly deadlines and forecasts.
03 / SCENARIO ANALYSIS
What Can Be Compared to Scenario Analysis?
The analysis of the scenario compared low, base and high cases in relation to revenues, gross margin, premium margins and EBITDA to show how alternative assumptions change the results.
ANALYSIS SCENARIO
View scenario charts Low, Base, and High revenues and margins in five years.
04 / DASHBOARD
What Does the Distribution Board Have in Common?
The table contains global settings, scenario control, key financial results, revenue mix, profitability, cash flow and returns in one management view.
DASHBOARD
The dashboard combines configuration controls, scenario settings, financial KPIs, revenue, cash flow and return charts.
FIT OF PRODUCTS
Is the Private School Finance Model Suitable for You?
The model is designed to fit the planning of a private school with occupied capacity, while significant differences in revenue logic, business schedules or reporting structures may require custom modelling.
MODEL BY MADA READY
Good Example
Revenues are driven by available places, occupancy, monthly fees and additional income for the occupied place.
You plan many school divisions or categories of different character and monthly tuition.
You need a time-editable start time, a occupancy frame, capacity additives, active months and seasonality.
You want low, base and high cases with related statements and management reports.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your revenue logic is not based on occupied places and fixed fees.
Operational schedules are needed which differ significantly from the existing capacity-based structure.
You require the results of reporting organised around other management frameworks or investments.
You need a model architecture that is based on specialized business requirements or calculations.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
The financial models of Lab can build or customize a model when your company needs a different revenue logic, operating schedules or reporting than the ready template provides.
You will receive an editable Excel financial model with five-year forecasts, a low/Basy/High scenario analysis and related financial statements and management reports.
01
Editable workbook
Updating school opportunities, enrolment, tuition fees, costs, staff, capital, financing and reporting assumptions.
02
Five-year forecast
Revenue, expenditure and cash flow of the plan within the framework of monthly and annual forecasts.
03
Analysis of scenarios
Compare low, basic and high levels of key performance measures.
04
Financial statements
Overview of Income Statement, Cash Flow Statement, Balance Sheet, Dashboard and Management Results.
BEFORE BUYING IMPORTANT INFORMATION
Private School Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the model calculate the income from a private school?
It multiplys the seats available by covering for the calculation of the seats occupied, applies monthly fees and optional additional income, and then adds up the active months after the adjustments.
02
What are the assumptions I can change?
You can change start time, group capacity, cover or ramp, monthly fees, additional revenue per place, capacity allowances, group definitions, active months and seasonality when used.
03
What can I compare in Low, Base and High scenarios?
Three cases in different incomes, gross margin, premium premium and EBITDA can be compared to see alternative assumptions change the forecast.
04
What financial results are taken into account?
The products include income statement, cash flow report, balance sheet, dashboard, scenario analysis and additional management reports presented in the workbook.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. The financial models Lab offers a custom financial modeling when different revenue logic, operational schedules or reporting structures are required.
06
Is this a forecast or a guarantee?
This is a forecast built on the possible editing assumptions, not a guarantee of the results of business activity or financial results.
What Does the Private School Financial Model Contain?
You get a comprehensive, five-year private school financial model template covering everything from tuition revenue to detailed expenses and cash flow analysis.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
GROUNDS FOR THE REVENUE
OPERATING EXPENDITURE COGS
ANALYSIS SCENARIO
DASHBOARD
