Blog · Territory, capacity and quota planning · Education
Build an edtech planning workbook from learner counts, subscription revenue, delivery costs and collections. Follow a monthly example, test retention assumptions and reconcile profit to cash.
An edtech financial model connects retained learners and new enrollments to subscription revenue, delivery costs and cash. Build it by month and program, with separate schedules for earned revenue and collections, so growth does not hide a funding gap.
This illustrative US subscription business uses monthly contracts. Institutional agreements and annual prepayments need separate schedules.
Bring subscription movements, billing, collections, delivery expenses and the operating budget. Keep month, program, cohort and amount definitions consistent. Finance owns the workbook; enrollment operations confirms learner movements, and delivery managers confirm costs.
Use one row per anonymized cohort and month. Store opening, retained, new and billable learners, net monthly price and delivery cost per learner. Place this schedule inside your FP&A workbook.
For this example, retained and new learners receive a full month's service and are billed at the start of the month. There are no midmonth starts, pauses or refunds. Your workbook should add those movements if they occur.
For the broader funding schedule around a young company, use the startup financial model; keep this workbook focused on learning subscription economics.
Billable learners = Opening eligible learners × Retention rate + New paid learners
Operating result = Billable learners × (Net monthly price − Delivery cost per learner) − Fixed operating expenses
Use worksheet column A for metric labels, B for inputs and formulas, and C for calculation notes. The Row column below gives worksheet row numbers. Amounts are USD unless a row gives another unit.
| Row | Metric | Value | Calculation |
|---|---|---|---|
| 2 | Opening eligible learners | 1,000 | Subscription export |
| 3 | Monthly retention | 90% | Planning assumption |
| 4 | Retained learners | 900 | 1,000 × 90% |
| 5 | New paid learners | 200 | Enrollment assumption |
| 6 | Billable learners | 1,100 | 900 + 200 |
| 7 | Net monthly price (USD) | 80 | Billing assumption |
| 8 | Earned revenue (USD) | 88,000 | 1,100 × 80 |
| 9 | Delivery cost per learner (USD) | 18 | Delivery budget |
| 10 | Delivery cost (USD) | 19,800 | 1,100 × 18 |
| 11 | Fixed operating expenses (USD) | 60,000 | Operating budget |
| 12 | Operating result (USD) | 8,200 | 88,000 − 19,800 − 60,000 |
The spreadsheet formulas are:
B4 = B2*B3
B6 = B4+B5
B8 = B6*B7
B10 = B6*B9
B12 = B8-B10-B11
These are planning amounts before interest and taxes, with no depreciation assumed in this simplified example. Delivery costs include the variable teaching and service costs assigned to these subscriptions. Fixed expenses sit separately, so the same payroll is never included twice.
When several cohorts have different prices, calculate revenue from each cohort's learner count and price, then sum. The SUMPRODUCT function multiplies corresponding values and adds the products:
=SUMPRODUCT(Cohorts!B2:B20,Cohorts!C2:C20)
Here B contains billable learners and C contains net monthly prices. It avoids applying an unweighted average price to the whole population.
Assume 90% of current-month charges are collected this month. Another $6,000 arrives against opening receivables. All operating expenses are paid during the month; capital spending is separate.
| Cash or receivable movement | Amount (USD) | Calculation |
|---|---|---|
| Opening cash | 40,000 | Bank balance |
| Current-month collections | 79,200 | 88,000 × 90% |
| Collections of opening receivables | 6,000 | Receipt schedule |
| Total receipts | 85,200 | 79,200 + 6,000 |
| Delivery payments | 19,800 | Delivery schedule |
| Fixed operating payments | 60,000 | Expense schedule |
| Capital payments | 5,000 | Capital budget |
| Closing cash | 40,400 | 40,000 + 85,200 − 19,800 − 60,000 − 5,000 |
| Opening receivables | 8,000 | Ledger balance |
| Closing receivables | 10,800 | 8,000 + 88,000 − 85,200 |
Cash rose by $400 while the operating result was $8,200. The difference is $2,800 of additional receivables and $5,000 of capital spending: 8,200 − 2,800 − 5,000 = 400. That bridge proves the schedules agree under the stated assumptions.
Match the closing receivables to the ledger and closing cash to the bank reconciliation. Use education financial analysis for comparing contribution across programs rather than expanding this learner schedule into a full program review.
Keep budget and actual rows separate. If an Actuals sheet has month in column A, program in B and earned revenue in C, this formula totals the selected month and program held in E2 and F2:
=SUMIFS(Actuals!C2:C1000,Actuals!A2:A1000,E2,Actuals!B2:B1000,F2)
SUMIFS supports multiple matching criteria. Use consistent month-end dates rather than mixing dates and text. Covirage is not affiliated with Microsoft.
Test retention before changing the enrollment target. Holding every other assumption constant produces:
| Metric | Base case | Lower retention |
|---|---|---|
| Retention | 90% | 85% |
| Retained learners | 900 | 850 |
| Billable learners | 1,100 | 1,050 |
| Revenue (USD) | 88,000 | 84,000 |
| Delivery cost (USD) | 19,800 | 18,900 |
| Operating result (USD) | 8,200 | 5,100 |
| Total receipts (USD) | 85,200 | 81,600 |
| Closing cash (USD) | 40,400 | 37,700 |
The $4,000 revenue loss is partly offset by $900 less delivery cost. The operating result falls $3,100, while closing cash falls $2,700 because collections lag revenue. Dollar amounts are exact.
Upload your enrollment, billing and operating workbook or Google Sheet; Covirage maps the columns, and its tools compute and check the figures against your prepared plan. The external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for education for the supporting industry context.
Use enrollment or subscription exports, billing records, a collections summary, delivery expenses and the operating budget. Keep a common month and program identifier across the files. Learner counts should distinguish paid subscriptions, cancellations, pauses and new enrollments so the movement can be reconciled.
Use the commercial unit that earns revenue, such as paid learner subscriptions or contracted institutional seats. Registered users can include unpaid or inactive accounts. Keep those operational counts separately, and document how billable seats and delivery activity connect to the revenue schedule.
Keep an earned-revenue schedule separate from the receipt schedule. An annual payment can arrive before all the related service is delivered. Use the revenue amounts prepared under your accounting policy, and carry the remaining obligation in a separate balance rather than treating all receipts as current-month revenue.