Financial model template

Online school financial model

An online school buys traffic and turns it into students. The template goes from ad spend to leads, from leads to paying students, pays experts a share and the platform a fee, and shows the September and January peaks.

Try free for 7 days Open the demo
The model answers
  • What a student costs in ads
  • Which conversion makes the funnel pay off
  • How seasonality moves cash through the year
Open this template

What is inside the template

Each line is a block with plain fields. Change the numbers, delete blocks or add new ones.

  • A sales funnel: ad budget, cost per lead and conversion
  • Course sales at your price
  • Experts paid a share of revenue
  • Learning platform and services
  • Curators and support
  • Academic seasonality

Numbers to watch

Cost per lead
What one application costs in ads.
Conversion to purchase
The share of leads who pay. Small changes here move profit the most.
Cost per student
Ad spend divided by students. Compare with the course price minus expert share.
Refunds
Courses usually have a refund window. Put a percentage.

Common mistakes in this kind of model

Conversion from a webinar promise

Use the conversion you actually see, not the best-case number.

Flat year

Summer is quiet for education. Seasonality shifts cash gaps.

Forgetting curators

Support for students is a cost that grows with the number of students.

AI assistant

Check the template against your market

Tell the assistant your city and format. It looks up prices, rent and salaries online, compares them with the template and proposes changes as cards with the effect on profit and cash. You decide what to apply.

How the assistant works

Questions

How do I model a sales funnel?

Use the funnel block: ad budget, cost per lead and conversion to purchase. FinModel calculates students and revenue every month.

Can experts be paid a percentage?

Yes. Add an expense as a percentage of revenue and name it after the expert.

Related reading

Unit economics in plain words Unit economics explained with examples: contribution margin per order, customer acquisition cost (CAC), lifetime value (LTV), LTV/CAC and CAC payback for e-commerce and SaaS. Break-even point: how to calculate it and use it What the break-even point is, the formula in units and in money, a worked example, and why monthly break-even differs from payback. Plus how to lower it.

Similar templates

Software development agency A team on hourly rates, utilization, support retainers and payment delays. SaaS startup Subscriptions with churn, a dev team, an investment round and runway.

Open the online school template now

The demo works without sign-up. To save your model, start the free trial.

Start free trial Open the demo