# Flight School Model Model the flight school the way its constraint actually works: the binding resource is not aircraft or classrooms but certificated flight instructors, and the school manufactures them itself. Commercial graduates become CFIs the year after they finish and leave for a regional airline about eighteen months later, so a live instructor roll-forward drives an instruction capacity that continuing students consume first and new enrolments take what is left. A training ladder carries each cohort from private through instrument to commercial, a pooled engine overhaul reserve accrues per flight hour and discharges when the fleet crosses TBO, and an unlevered DCF with a normalised terminal year bridges to enterprise value and value per share. - Canonical: https://finamodel.com/templates/flight-school - Excel download: https://finamodel.com/templates/flight-school.xlsx - Category: Operating Businesses - Model type: Operating model - Difficulty: Intermediate - Audiences: Founders & operators, Investors & analysts, Flight school owners and operators, Aviation training investors, Search-fund and small-cap buyers, Lenders and analysts - Tags: flight-school, aviation-training, capacity-constraint, workforce-pipeline, dcf ## Overview A seven-year operating model and unlevered DCF for a Part 141 flight training academy at a single regional airport, covering ab-initio training from zero time through the commercial pilot certificate, aircraft rental to already-certificated pilots between lessons, and ground school. The model's first signature mechanic is an endogenous instructor loop: almost every certificated flight instructor on the line is a commercial graduate of the school itself, hired the year after finishing and lost to a regional airline roughly eighteen months later, so the school's scarcest resource is manufactured by its own output three stages upstream rather than bought from a market. Students already in training are never abandoned mid-certificate, so continuing cohorts consume instruction capacity first and new enrolments take whatever is left, which produces a double squeeze - the school turns away 21.1 then 16.7 enrolments in Years 2 and 3, appears to recover fully in Year 4, then rations another 17.1 in Year 5 purely because the Year 2 shortfall arrives as a smaller graduating class three years later - while revenue rises every single year and never reveals the constraint at all. The second mechanic is a usage-metered engine overhaul reserve: piston trainers run to a 2,000-hour time between overhauls and accrue a per-hour reserve set at Year 1 to exactly fund one overhaul, but that rate is escalated at 2.0% a year while the overhaul work it buys inflates at 4.0%, so the funding ratio decays from 100.0% to 89.0% and the liability drains from 399,475 to 137,262 even as flight hours grow 59%. Working capital is built from real balances - block-time prepayments, fuel and parts inventory, and the engine reserve - rather than a percent-of-revenue plug, and the model closes with a terminal value normalised to maintenance capital expenditure and a one-page dashboard. ## What's included - Demand and training ladder: Year-1 enrolment demand, demand growth, the private-to-instrument, instrument-to-commercial and checkride pass rates, and pre-horizon cohort seeds - Dual and solo hours: hours per new, instrument and commercial student, plus a certificated-pilot rental line and its growth - Instructor pipeline: seed instructors, seed prior graduates, annual attrition to the airlines, and billable dual hours per CFI - Instructor policy schedule: a per-year graduate retention share and a per-year external hiring input - Fleet: a per-year aircraft addition schedule, opening fleet, dispatch hours per aircraft, unit cost and escalation, airframe life - Engine reserve: time between overhauls, overhaul cost and escalation, the per-hour reserve rate and its escalation, opening cycle hours and opening liability - Rate card: wet rate, instruction rate, ground school fee, and a single billing escalator - Direct cost: fuel burn and price, routine maintenance, ramp and landing fees, instructor pay per dual hour, ground school courseware and testing, each with its own escalator - Operating expense: per-aircraft insurance and hangar, management and dispatch payroll, systems, marketing, G&A - Working capital: receivable days, inventory days, payable days, and prepaid block-time days - Valuation: tax rate, WACC, terminal growth, net debt, shares outstanding - Operations sheet: training ladder, instructor roll-forward, enrolment rationing, flight hours, fleet, PP&E, engine reserve, working capital - Revenue sheet: rate card and the five revenue lines with per-hour and per-student metrics - P&L sheet: escalated unit cost rates, the six-line direct stack, opex, EBITDA to net income - FCF sheet: NOPAT, depreciation add-back, capex, change in NWC, unlevered FCF, and cash conversion - Valuation sheet: discounted explicit forecast, a normalised terminal year, enterprise value, equity value, value per share, implied multiples - Dashboard with enrolments turned away, instructor utilisation, instructors against graduates, revenue against flight hours, the reserve funding ratio and liability, margins, EV and value per share ## Flight School Financial Model for Instructor-Constrained Training Capacity This flight school financial model is a seven-year operating projection and unlevered DCF for a Part 141 academy at a single regional airport. It captures the unusual loop where certificated flight instructors are both the scarce resource and the school's own product, and it shows how enrolment rationing today becomes an instructor shortage three years later. Rates and financial results described here reflect illustrative model settings, not industry benchmarks. ### How Enrolment and Graduation Drive Instructor Supply The model starts with annual demand for new enrolments, then passes each cohort through a three-stage ladder. A share of private students advances to instrument training, a further share to commercial, and a final share graduates. - Continuing students from earlier cohorts consume instruction hours before new applicants are considered, because students already mid-certificate are never abandoned. The remaining capacity, divided by the hours a new student requires, sets how many new students can actually enrol. - Any excess demand is recorded as enrolments turned away. This rationing rule links enrolment decisions directly to future graduate numbers, so a shortfall in one year propagates through the pipeline and constrains instructor hiring three years later. ### The Instructor Roll-Forward and Why Retention Is the Binding Lever A year-by-year instructor roll-forward begins with opening headcount, subtracts attrition to regional airlines, adds graduates retained as instructors, and adds a small number of external hires. The closing total, multiplied by billable dual hours per instructor, sets instruction capacity. - The arithmetic is sharply sensitive: with 55% annual attrition, the pool holds steady only when roughly 12.6% of commercial graduates stay. Each additional percentage point of retention adds around 4.4 percentage points to instructor pool growth. - Because the school cannot hire its way out of a shortage, the retention share is entered as a visible annual policy row, not a fixed constant, and it is the single most powerful lever in the model. ### The Engine Overhaul Reserve and Its Funding Gap A pooled engine reserve tracks accumulated fleet flight hours against a 2,000-hour time between overhauls. Every 2,000 hours, one overhaul is triggered and its cost is paid from the reserve. - The reserve accrues per flight hour at a rate initially set to cover the overhaul exactly, then escalated at 2% annually. But overhaul costs inflate at 4% annually, so the funding ratio falls from 100% to 89% over seven years. - The reserve liability draws down every year even as flight hours grow. This is a usage-metered accrual that discharges in lumpy cash outflows, and the model deliberately leaves the underfunded balance visible rather than smoothing it. ### Revenue, Cost Structure and the Rate Race Five revenue lines are driven by flight hours, active students and a wet rental rate, an instruction rate and a ground-school fee, all escalating at 3% annually. Direct operating costs are hours-driven, including fuel, maintenance, landing fees, instructor pay and the engine reserve accrual, with ground school courseware cost metered per active student. - Because fuel and instructor pay escalate faster than the 3% billing rate, gross margin compresses each year, while EBITDA margin rises as fixed costs spread over a larger revenue base. This captures a real tension: unit economics weaken even as the overall business becomes more profitable. - The model also builds working capital from actual balances, including prepaid block-time liability and the engine reserve, producing negative net working capital that finances operations. ## A constraint the business manufactures itself Every other capacity model treats the scarce resource as something management buys. Here the instructors are commercial graduates of the school's own pipeline, hired a year after they certificate and lost to the airlines about eighteen months later, so the pool is set by enrolment decisions three years earlier. The school can raise the retention share and hire one to three career instructors a year, but it cannot buy its way out of a shortage. ## Rationing that echoes three years later Students already in training are never abandoned mid-certificate, so continuing cohorts take instruction capacity first and new enrolments take the remainder. The Year-2 shortfall becomes a smaller instrument class in Year 3, a smaller commercial class in Year 4 and a smaller graduating class in Year 4, which returns fewer instructors in Year 5 despite a higher retention share - and Year 5 rations again on assumptions that never changed. ## A reserve metered by hours, not by the calendar Piston trainers run to a fixed time between overhauls, so the reserve accrues per flight hour and discharges when pooled fleet time crosses TBO. The per-hour rate is set at Year 1 to exactly fund an overhaul but escalates below the cost of the work it buys, so the funding ratio decays from 100% to 89% and the liability drains by two thirds while flight hours grow 59%. ## Workbook structure ### Cover Workbook overview, sheet legend, units, and tab-colour key. - Title and scope framing - Sheet-by-sheet purpose summary - Units and tab-colour legend ### Dashboard Headline KPIs, a seven-year operating summary, six charts and a bridge. - Enrolments turned away in the two squeeze years and instructor utilisation - Instructors, reserve funding ratio and reserve liability at the horizon - Revenue, EBITDA, enterprise value and value per share - Charts for rationing, the instructor loop, hours, the reserve and the two margins - Revenue to net income waterfall bridge ### Assumptions Every driver in one sheet: ladder, instructor policy, fleet, reserve, rates, costs, valuation. - Year-1 enrolment demand, demand growth, advance and pass rates, cohort seeds - Dual and solo hours per student stage, certificated-pilot hours and growth - Seed instructors and graduates, airline attrition, billable hours per CFI - Per-year graduate retention share, external hires and aircraft additions - Fleet economics, airframe life, and the engine reserve inputs - Rate card, direct cost rates and escalators, operating expense - Working capital days, tax rate, WACC, terminal growth, net debt, shares ### Operations Training ladder, instructor roll-forward, rationing, hours, fleet, PP&E, reserve, working capital. - Instrument and commercial cohorts advance one stage a year off the prior cohort - Instructors roll forward from Year-0 seeds: opening, attrition, own graduates retained, external hires - Instruction capacity equals closing instructors times billable dual hours per CFI - Capacity for new students is capacity less continuing dual hours, floored at zero, over hours per new student - New enrolments are the lesser of demand and that capacity; the gap is reported as turned away - Dual, solo and certificated-pilot hours build to total flight hours - Pooled cycle hours drive overhauls performed, the reserve accrual and the funding ratio - Working capital is receivables, inventory, payables, prepaid block time and the reserve liability ### Revenue Rate card and the five revenue lines. - Wet rate, instruction rate and ground school fee escalate on one billing rate - Dual, solo and certificated-pilot rental price the three hours lines at the wet rate - Instruction fees price dual hours at the instruction rate - Ground school and testing prices active students at the fee - Revenue growth, revenue per flight hour and revenue per active student ### P&L Escalated unit rates, an hours-driven direct stack, opex, and earnings. - Fuel, maintenance, ramp and instructor pay carried as explicit per-hour rates - Six direct cost lines including the reserve accrual and ground school courseware - Gross profit and gross margin compressing as input rates outrun the billing escalator - Per-aircraft insurance and hangar, payroll, systems, marketing and G&A - EBITDA and EBITDA margin rising as fixed cost spreads over more revenue - Depreciation on a long airframe life, EBIT, tax on positive EBIT, net income ### FCF Unlevered free cash flow bridge and cash metrics. - EBIT less unlevered tax to NOPAT - Depreciation added back, capital expenditure and the change in working capital deducted - Unlevered free cash flow positive in every year - FCF margin, capex as a share of EBITDA, and cash conversion ### Valuation Discounted cash flow with a normalised terminal year. - Explicit forecast discounted at a WACC over seven periods - A terminal year rebuilt from EBIT, tax, depreciation and maintenance capex - Gordon-growth terminal value discounted at the final-year factor - Enterprise value, net debt, equity value and value per share - Implied EV/EBITDA, EV/revenue and terminal value as a share of EV ## Features - **A constraint the business manufactures itself:** Every other capacity model treats the scarce resource as something management buys. Here the instructors are commercial graduates of the school's own pipeline, hired a year after they certificate and lost to the airlines about eighteen months later, so the pool is set by enrolment decisions three years earlier. The school can raise the retention share and hire one to three career instructors a year, but it cannot buy its way out of a shortage. - **Rationing that echoes three years later:** Students already in training are never abandoned mid-certificate, so continuing cohorts take instruction capacity first and new enrolments take the remainder. The Year-2 shortfall becomes a smaller instrument class in Year 3, a smaller commercial class in Year 4 and a smaller graduating class in Year 4, which returns fewer instructors in Year 5 despite a higher retention share - and Year 5 rations again on assumptions that never changed. - **A reserve metered by hours, not by the calendar:** Piston trainers run to a fixed time between overhauls, so the reserve accrues per flight hour and discharges when pooled fleet time crosses TBO. The per-hour rate is set at Year 1 to exactly fund an overhaul but escalates below the cost of the work it buys, so the funding ratio decays from 100% to 89% and the liability drains by two thirds while flight hours grow 59%. ## Use cases - **Size an instructor retention programme:** The break-even retention share is arithmetic: attrition times instructors needed per unit of enrolment against graduates produced per unit. Flex the per-year retention share and the external hiring row and watch enrolments turned away, utilisation and the graduating class move together, with a three-year lag before any fix reaches enrolments. - **Diligence a flight academy's capacity:** Revenue rises every single year in this model even through two years of rationing, because continuing cohorts keep flying while new intake is throttled. Utilisation and enrolments turned away are the rows that reveal the constraint, and both are on the dashboard next to the top line that hides it. - **Test whether the engine reserve is funded:** Move the reserve rate escalator against the overhaul cost escalator and watch the funding ratio and the liability balance. The balance stays comfortably positive right up until it does not, which is why the ratio rather than the balance is the row to monitor. ## Frequently asked questions ### What is a flight school financial model? A flight school financial model captures the seven-year operating economics and intrinsic value of a Part 141 flight training academy that takes ab-initio students from zero time through the commercial pilot certificate, rents aircraft to already-certificated pilots between lessons, and sells ground school. This one is built around the constraint that actually binds such a business: certificated flight instructors. It runs a training ladder, a live instructor roll-forward with airline attrition, a rationing rule for new enrolments, an hours-driven cost stack, a usage-metered engine overhaul reserve, and an unlevered DCF to enterprise value and value per share. ### Why are instructors the constraint rather than aircraft? Aircraft can be bought; instructors largely cannot. Almost every CFI on a training line is a commercial graduate of the school itself, hired the year after certificating and gone to a regional airline roughly eighteen months later. That makes the instructor pool endogenous - it is produced by the school's own student pipeline two stages upstream - so the size of this year's graduating class was fixed by enrolment decisions three years ago. The model keeps the fleet as a policy schedule that never binds, with a derived aircraft-required row sitting below the fleet in every year, so there is exactly one live constraint and it is unambiguous which mechanic produced which result. ### What does the model do when instruction capacity runs short? It rations new enrolments, not students already in training. Continuing instrument and commercial cohorts consume their dual hours first; whatever instruction capacity remains is divided by the hours a private student needs, and new enrolments are the lesser of demand and that figure. The shortfall is reported as enrolments turned away and as a percentage of demand. Because the turned-away students are the instrument class the school does not have next year, the commercial class it does not have the year after and the graduating class it does not have after that, a single squeeze produces a second squeeze three years later on assumptions that never changed. ### How does the engine overhaul reserve work? Piston training engines run to a manufacturer's time between overhauls measured in flight hours, not calendar time, and then need an overhaul regardless of the date. The model pools cycle hours across the fleet, counts overhauls with a ROUNDDOWN of opening cycle hours plus the year's flight hours over TBO, carries the remainder forward, accrues a reserve at a per-hour rate on every hour flown, and pays out at an escalating overhaul cost. The rate is set in Year 1 to exactly fund an overhaul but is escalated below the inflation of the work it buys, so the funding ratio decays and the liability drains - a disclosed structural under-funding rather than a modelling error. ### Why is the terminal value normalised? Year 7 capex runs well above depreciation because the fleet is still being expanded by two aircraft a year. Capitalising that raw cash flow into perpetuity would charge the business forever for a growth programme it only undertakes while scaling. The Valuation sheet therefore rebuilds a terminal-year cash flow explicitly - terminal EBIT, less unlevered tax, plus depreciation, less maintenance capex defined as closing fleet at cost over the airframe life - and excludes growth working capital on the same reasoning, so the perpetuity capitalises maintenance economics only. ### Can I use this for my own flight school? Yes. Every driver is a labelled input on the Assumptions sheet wired through named ranges, so you can replace the demand, advance and pass rates, cohort seeds, instructor attrition and billable hours, the per-year retention and hiring policy rows, the fleet schedule, the rate card, every cost escalator, the working capital days and the valuation inputs with your own. The workbook recalculates end to end, and the dashboard reports enrolments turned away, instructor utilisation, the reserve funding ratio, margins, enterprise value and value per share. ## Related templates - [Driving School Operator Model](https://finamodel.com/templates/driving-school) - [Tutoring Center Model](https://finamodel.com/templates/tutoring-center) - [Private School Operating and Financial Model](https://finamodel.com/templates/private-school-model)