Blog · Finance metrics and formulas · Education
Compare education program revenue, delivery costs and enrollment against budget. Build a contribution table from operating exports and reconcile the variance to the institution's financial results.
Education financial analysis compares each program's earned revenue and delivery costs with its enrollment assumptions and approved budget. Start with contribution before shared expenses, then reconcile the program totals to the ledger so a favorable enrollment story does not conceal a weaker operating result.
This method is for education providers and institutions reviewing operating performance. The worked example uses an illustrative US continuing education provider and one monthly service period, with all money in USD.
Use the enrollment summary, revenue ledger, payroll or instructor-cost export, delivery expense report and approved budget. Match them on program, cohort and service month. Finance should own the reconciliation; program leaders should confirm that enrolled units and delivery costs describe the same service.
Define an enrolled unit before counting it. A course registration, a unique learner and a full-time-equivalent measure answer different questions. In this example, an enrollment is one paid place in a monthly program, and the price is earned revenue per place after discounts.
Keep cash receipts in a separate schedule. They may relate to earlier or later teaching periods. The broader financial analysis guide covers the institution-level statements; this worksheet isolates which programs explain the operating movement.
Start the input table below in A1. Columns B through D hold actual inputs; E through G hold the budget approved for the same period.
| Program | Actual places | Actual fee (USD) | Actual delivery cost (USD) | Budget places | Budget fee (USD) | Budget delivery cost (USD) |
|---|---|---|---|---|---|---|
| Business certificate | 120 | 500 | 36,000 | 130 | 500 | 37,000 |
| Technical certificate | 80 | 750 | 42,000 | 80 | 750 | 40,000 |
The business program missed its enrollment budget while the technical program met it. That is the operating question to investigate, rather than treating every revenue variance as a collection problem.
Program contribution = Earned program revenue − Assigned delivery costs
Contribution variance = Actual contribution − Budget contribution
Add calculated columns H through M. These spreadsheet formulas use the input table above and copy down from row 2 to row 3:
H2 = B2*C2
I2 = H2-D2
J2 = E2*F2
K2 = J2-G2
L2 = I2-K2
M2 = I2/H2
H is actual revenue; I is actual contribution; J is budget revenue; K is budget contribution; L is the contribution variance; M is actual contribution margin. Check that revenue is positive before dividing. A program with no revenue needs a separate explanation rather than a fabricated percentage.
| Program | Actual revenue (USD) | Budget revenue (USD) | Actual contribution (USD) | Budget contribution (USD) | Contribution variance (USD) | Actual margin |
|---|---|---|---|---|---|---|
| Business certificate | 60,000 | 65,000 | 24,000 | 28,000 | -4,000 | 40% |
| Technical certificate | 60,000 | 60,000 | 18,000 | 20,000 | -2,000 | 30% |
| Total | 120,000 | 125,000 | 42,000 | 48,000 | -6,000 | 35% |
Calculate the total margin from dollars:
=SUM(I2:I3)/SUM(H2:H3)
The check is a revenue-weighted average of program margins:
=SUMPRODUCT(H2:H3,M2:M3)/SUM(H2:H3)
SUMPRODUCT multiplies corresponding range values and sums the products. Both formulas return 35% here. The displayed margins are exact; keep full precision when other program rows produce rounded percentages.
The contribution shortfall has a short bridge:
| Movement from budget | Contribution effect (USD) | Explanation |
|---|---|---|
| Budget contribution | 48,000 | 28,000 + 20,000 |
| Business revenue shortfall | -5,000 | (120 − 130) × 500 |
| Business delivery cost saving | 1,000 | 37,000 − 36,000 |
| Technical delivery cost overrun | -2,000 | 40,000 − 42,000 |
| Actual contribution | 42,000 | 48,000 − 5,000 + 1,000 − 2,000 |
The enrollment owner investigates the missing business places. The technical program manager explains the delivery overrun. There was no fee change in either program, so this example does not need a price explanation.
Do not translate the business program's delivery saving into a constant cost per missing learner. Instructor sections and room costs may remain after enrollment falls. Ask which costs actually changed, and which were simply deferred to the next month.
For a subscription provider that needs a forward enrollment schedule, use the separate edtech financial model. For an institution comparing how groups develop over time, keep the cohort dates consistent with its purchase-cohort analysis.
Actual delivery costs total $78,000; budget costs total $77,000. The revenue shortfall of $5,000 plus the cost overrun of $1,000 explains the $6,000 contribution shortfall.
Assume shared operating expenses are $30,000 in both cases. Actual operating result is 42,000 − 30,000 = $12,000; budget is 48,000 − 30,000 = $18,000. These are simplified operating results before financing and taxes, with no other income or expenses assumed.
For a longer ledger export, use a revenue sheet with month in A, program in B and signed earned-revenue amount in C. With the selected month in P2 and program in Q2:
=SUMIFS(Revenue!C2:C1000,Revenue!A2:A1000,P2,Revenue!B2:B1000,Q2)
SUMIFS adds amounts that meet multiple criteria. Reconcile the sum of all program revenue to the revenue ledger and program costs to the included expense accounts. Covirage is not affiliated with Microsoft.
Upload your program, cohort and budget workbook or Google Sheet; Covirage maps the columns, and its tools compute and check contribution and variances. The external AI model explains the results with every figure traced to its rows, as described in education analytics. Create a free Covirage account and bring a sample of your own data.
See Covirage for education for the supporting industry context.
Program contribution is earned program revenue less the delivery costs assigned to that program. It shows the amount available for shared services and other institution expenses. Define included costs consistently, and label the result clearly because it is not the same as the institution's final surplus or operating profit.
Show contribution before allocations first, then show any allocated result separately. Document the allocation driver, such as occupied space or supported enrollment. A program can appear to improve merely because another program takes a larger share of common expenses, even when delivery economics have not changed.
Yes. Growth may bring discounts, additional sections or higher instructor and support costs. Compare net revenue per enrolled unit with the cost of serving the additional cohort. Review the staffing or section threshold instead of assuming every additional enrollment has the same marginal cost.