A detailed, investor-ready online coaching financial model for an edtech coaching and counseling platform — with a freemium-to-premium user funnel and five distinct revenue streams, plus platform-development and operation phases, an exit strategy and valuation, in one integrated Excel model.

An online coaching platform is a freemium business at heart. Most users arrive on a free tier and cost you money to serve; the business succeeds by converting a fraction of them into paying customers and monetising the rest through other means. Layer on live counseling and coaching sessions, merchandise and advertising, and you have a platform with five ways to earn — but only if the model separates the free users who cost from the premium users who pay, and tracks the conversion between them.

This online coaching financial model is built for exactly that structure. Downloads split into freemium and premium at the top of the funnel, retention compounds each cohort, and five revenue streams monetise the active base. Platform development is treated as the capitalised, amortised intangible it genuinely is, and the whole business flows through to a complete, investor-ready output set.

The output set is comprehensive: Project and Equity IRR and NPV (with and without terminal value), equity payback, a DCF valuation, an exit strategy and a fully linked dashboard.

The Freemium Funnel

The model builds its user base from monthly downloads split between freemium and premium users, each with its own retention rate and active-user percentage. That split is the strategic core of any freemium business: freemium users are a cost to serve and a marketing funnel at the same time, while premium users are where the subscription revenue comes from. Modelling them separately is what lets you see the true economics — the cost of carrying free users against the revenue converted premium users generate.

Because the freemium-to-premium mix is an explicit input, you can test the lever every edtech founder pulls: a generous free tier that grows the top of the funnel but costs more to serve, versus a tighter one that converts harder but carries less dead weight.

Five Revenue Streams

The model captures every way the platform earns, separately:

• Premium subscriptions — monthly charges from converted premium users
• Counseling sessions — driven by counselors available and sessions per counselor, at a fixed fee per session
• Coaching sessions — driven by teachers available and sessions per teacher, at a fixed fee per session
• Product sales — merchandise bought by a share of active users at an average price
• Advertising — impression-based revenue from sessions, minutes, impressions and CPM

The counseling and coaching streams are modelled as a two-sided service — supply is the number of counselors and teachers available, throughput is sessions per professional, and revenue is a fixed fee per session. That structure lets you scale the marketplace realistically: revenue grows as you onboard more professionals, not as a single abstract number.

Assumptions You Control

Every driver of the platform is an explicit, editable input. The assumptions cover:

Platform Development as an Intangible

The primary capital outlay for an edtech platform is software, and the model treats it correctly. Platform development cost — across UI/UX, native platform and app, backend, admin panel and DevOps — is capitalised as an intangible and amortised over its useful life, with refresh capex to fund the periodic rebuild. That treatment is what makes the early-year statements realistic and the valuation credible to an investor who understands how technology businesses are reported.

Valuation and a Defined Exit

The model derives a full DCF valuation — Project and Equity NPV and IRR, both with and without terminal value — and a dedicated exit strategy lets you set a holding period and model a sale of the platform. For an edtech venture built to scale and exit to a larger education or technology acquirer, that exit view is exactly the analysis that frames the investment case.

Five Years, Monthly, Three Scenarios

The model forecasts across development and operation on a monthly basis, with financial statements on both monthly and annual views. Every revenue and cost assumption can be entered across three scenarios and switched at the click of a button, so a conservative conversion case sits beside an optimistic one — and because the model uses no macros, every change flows through instantly.

Who This Online Coaching Financial Model Is For

• Edtech and online coaching founders building an investor-ready business plan and valuation
• Coaching, tutoring and counseling platforms modelling a freemium marketplace
• Venture and edtech investors assessing conversion, retention and monetisation
• Lenders and grant bodies evaluating an education-technology funding application
• Advisors and consultants preparing feasibility studies for digital platforms

Why This Model

New to these metrics? Read an overview of internal rate of return. For a model built to your own specification, see our financial advisory services, or browse the full range of business plan Excel models.