Revenue & Calc
Classroom counts, seats, teaching hours, language allocations and hourly tuition feed monthly calculations and annual revenue, keeping all five languages within one shared capacity pool.
Foreign Language School Financial Model Template in Excel
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
The Foreign Language School Financial Model is an Excel template for projecting revenue, operating expenses and EBITDA for an independent adult language school in Austin, Texas. It connects classroom capacity, occupied student-hours, language mix and net tuition across 2026–2030.
The illustrated school leases an approximately 1,500-square-foot, three-classroom site for resident adult English, Spanish, French, German and Mandarin group classes. The stated launch date is January 31, 2026, and all illustrated selections are estimated planning inputs.
- Forecast
- 5years
- Classrooms
- 3teaching rooms
- Languages
- 5group class streams
WORKBOOK CONTENTS
Editable Inputs Connect Capacity to Financial Reports
Adjust capacity, utilization, tuition, expenses, staffing and funding inputs to evaluate how your school’s operating plan changes its financial projections.
COGS & OPEX and Payroll
Revenue-linked costs, monthly overhead and salaried staffing feed the expense forecast separately, so instructor compensation is counted once.
Dashboard & Scenarios
Dashboard controls set Low, Base and High multipliers for revenue, COGS, variable expenses, fixed expenses and payroll; scenario comparisons show their effects on margins and EBITDA.
IS, CF, BS & Summary
The declared workbook reports profitability, cash movements and financial position, with combined annual and selected-year monthly reporting; the supplied numerical case establishes operating results through EBITDA only.
REVENUE FORECAST
Shared Classroom Capacity Drives Tuition Revenue
Revenue equals occupied student seat-hours allocated once across five languages and multiplied by each language’s net hourly tuition.
Three classrooms with eight seats each and 100 scheduled teaching hours per room provide 2,400 available student seat-hours monthly. Occupied utilization rises from 45% to 55%, 65%, 70% and 75% across the five forecast years.
The language shares below allocate student-hours, not revenue, and total 100%. There is no independent demand forecast or separate capacity pool for each language.
| Language | Student-hour share | Tuition per student-hour |
|---|---|---|
| English | 35% | $18 |
| Spanish | 30% | $20 |
| French | 15% | $22 |
| German | 10% | $22 |
| Mandarin | 10% | $24 |
Estimated allocations and tuition remain constant in this illustrative case.
Revenue Forecast
The Revenue Forecast connects classroom inputs, occupied student-hours and language-specific tuition to projected sales. Changing utilization tests how much of the shared teaching capacity must be filled to support the school’s expense base.
2026 revenue at weighted tuition of $20.20 per student-hour
3 classrooms × 8 seats × 100 hours/month × 45% utilization × $20.20 × 12 months = $261,792 annual revenue.
At 45% utilization, the school sells 1,080 student-hours monthly; at 75%, it sells 1,800. Tuition is prepaid and recognized as instruction is delivered, so cash receipt timing and revenue recognition serve different purposes.
OPERATING COSTS
Fixed Staffing Shapes the EBITDA Ramp
The case combines revenue-linked costs with $72,600 of annual fixed expenses and $225,000 of annual payroll.
COGS and Operating Expenses
The COGS and Operating Expenses forecast separates direct costs, variable spending and fixed overhead. Course printing and consumables use 1.5% of revenue, learning-content licenses use 2%, payment processing uses 3%, and enrollment-linked promotion uses 2%.
Lease and occupancy cost $3,500 monthly for 12 paid months. Other fixed coverage includes utilities, internet, insurance, cleaning, maintenance, administration software, baseline marketing, accounting and recurring compliance.
COGS totals 3.5% of revenue and variable operating costs total 5%. Salaries are excluded from both categories and from fixed operating expenses to prevent double counting.
Payroll Forecast by Staff Role
The Payroll Forecast plans staffing FTE and fixed base pay by role. Three instructor FTE at $55,000 each and one working director FTE at $60,000 produce $225,000 of annual payroll throughout the case.
STARTUP & FUNDING
Opening Funding Covers More Than Classroom Assets
Estimated initial owner funding is $142,614, covering startup assets, separate opening cash items, materials stock and the stated operating reserve.
Capital Expenditure Plan
The Capital Expenditure Plan schedules asset purchases and depreciation. Listed startup assets total $33,000: $10,000 for furniture and whiteboards, $8,000 for computers and audiovisual equipment, and $15,000 for qualifying classroom improvements.
Separate opening cash items cover refundable premises and utility deposits, permits and professional setup, launch marketing, and preopening training and occupancy. These items and asset purchases are distinct from the annual operating expense forecast.
Sources and Uses of Funds
Sources and Uses of Funds reconciles funding sources and cash allocation over selected forecast months. Compare owner contributions, operating payments and investment spending; no confirmed outside financing is assumed in this school case.
Working-capital controls use zero receivable days, zero payable days and six inventory days. The funding estimate includes a three-month operating reserve, but the supplied case does not establish tested cash sufficiency.
ILLUSTRATIVE RESULTS
Higher Utilization Produces Positive EBITDA From 2028
The supplied 2026–2030 forecast grows revenue with occupied classroom capacity while maintaining the same payroll and fixed expense base.
| Year | Revenue | Operating Expenses | EBITDA |
|---|---|---|---|
| 2026 | $261,792 | $319,852 | −$58,060 |
| 2027 | $319,968 | $324,797 | −$4,829 |
| 2028 | $378,144 | $329,742 | $48,402 |
| 2029 | $407,232 | $332,215 | $75,017 |
| 2030 | $436,320 | $334,687 | $101,633 |
Illustrative projections, not historical results or industry averages; amounts are rounded to whole dollars, which can create small displayed differences.
Annual EBITDA turns positive at 65% utilization in 2028, reaching $101,633 by 2030. This reflects more paid student-hours supporting unchanged fixed expenses and payroll; it does not establish net profit, cash break-even or investment recovery.
Cash Flow Forecast
The Cash Flow Forecast reports operating, investing and financing cash movements and reconciles opening to closing cash. Use it to review prepaid tuition receipts, opening asset spending and owner funding separately from operating earnings.
BREAK-EVEN & RETURNS
Evaluate Operating Coverage and Investment Recovery Separately
Returns, financing and valuation reports support different decisions from the annual EBITDA forecast.
Break-Even, Payback and ROIC
The Returns report distinguishes sales break-even, cash break-even timing, investment payback and annual ROIC. Sales break-even evaluates operating cost coverage; cash break-even considers cash flows, payback measures investment recovery, and ROIC relates annual returns to invested capital.
Dashboard Debt Controls and the Debt schedule allow financing terms to be entered and their repayment effects reviewed. The Valuation report supports discounted cash flow and sensitivity analysis, but no borrowing terms, valuation, payback period or ROIC result is established by this case.
MODEL FIT
Designed for Resident Adult Group Language Classes
This capacity-based model fits an independent school planning scheduled group teaching in a shared classroom site.
The illustrated scope excludes visa sponsorship, accredited degrees, housing, travel, private lessons and textbook retail. A school relying on those activities would need its revenue and cost assumptions adapted before using these projections.
COMMON QUESTIONS
Foreign Language School Financial Model FAQ
These answers clarify the editable assumptions, forecast scope and interpretation of the illustrated case.
Can I change the classroom size and timetable?
Yes, classroom count, seats per room and scheduled teaching hours are operating inputs that determine available student seat-hours before utilization is applied.
Can I adjust language mix and tuition?
Yes, edit each language’s share and net hourly tuition while keeping all shares at 100% so the shared student-hour pool is allocated once.
Are instructors paid per teaching hour?
No, this case uses fixed annual instructor salaries through Payroll; utilization changes revenue without automatically changing teacher compensation.
Which periods and currency does the case use?
The illustrated forecast covers 2026 through 2030 in US dollars, using the supplied annual results and a stated launch date of January 31, 2026.
Does positive EBITDA mean the investment is repaid?
No, investment payback depends on cumulative project cash flow, while EBITDA excludes depreciation, interest, taxes and investing and financing cash movements.
Are these Austin assumptions verified market benchmarks?
No, the selections are estimated planning inputs, and the companion references do not independently verify them as local market benchmarks.
What Does the Language School Financial Model Contain?
Financial Dashboard
KPIs, forecasts, and cash flow at a glance.
Revenue Engine
Key assumptions and calculations driving revenue forecasts.
Sources & Uses
Funding sources, spending, and closing cash.
Returns & Break-Even
Cash break-even, payback, and ROIC.
Business Valuation
DCF valuation and sensitivity analysis.
Expense Breakdown
Largest costs and spending trends.
Financial Summary
Annual and monthly financial performance.
KPI Benchmarks
Compare margins and returns to benchmarks.
Trusted by 25,000+ startup founders, investors and CPAs
Simple Modeling At Last
I usually avoid advanced spreadsheets, but this template made the setup easy to follow and saved me hours of trial and error. I could build the model without calling in a finance consultant.
Runway Was Easy To See
The cash flow section gave me a clear view of runway and shortfalls in minutes, which helped me plan our next hiring step sooner. It was the first time our numbers felt manageable.
Everything In One Place
The assumptions tabs kept pricing, costs, and growth organized, so I spent less time hunting through cells and more time testing scenarios. I had a cleaner draft ready for our planning meeting the same day.