Trusted by 25,000+ startup founders, investors and CPAs
Better Cash-Flow Visibility
Megan Collins, NY
This template made runway planning much easier. I could see shortfalls months ahead and saved about 6 hours of manual forecasting each week.
Cleaner Scenario Planning
Brian Hayes, CA
I stopped rebuilding low, base, and high cases by hand. The model let me compare assumptions in minutes, and I booked a planning meeting the same day.
One Place For Reporting
Lauren Pierce, TX
All the statements and charts finally live in one file. I cut reporting prep by 4 hours and had a cleaner deck for our next update.
MODEL OVERVIEW
What Is the Financial Model of the Online Course?
The Financial Course Online is an edition of five-year Excel and Google Sheets forecast combining customer purchase, cohort retention, valuation, costs, statements and scenarios.
Use the workbook to plan how the marketing of customer expenses and acquisition costs translate into new customers, active cohorts, level income, expenditure, cash flow and profitability over time.
The editable operational assumptions are the source of model calculations which then flow to financial statements, scenario comparisons, management charts and summary reports.
Built for fixed exchange rate revenuesThe revenue engine shall comply with the active customer cohorts, the allocation of tiers, the customer lifetime or lifetime and monthly fees.
REVENUE FROM THE ENGINE CLIENT
How Does the Online Course Model Calculate Revenue?
The model converts marketing spending into new customers, allocates it at all levels, preserves cohorts for their model life and charges monthly fees from active customers.
01
Buy Clients
New customers are equally spending marketing expenditure divided into the costs of purchasing the customer.
02
Horizontal
New customers are divided into levels using the allocation assumptions to be edited.
03
Stop the Cohorts
Each customer cohort shall remain active with regard to its established life-cycle or chorn convention.
04
Active Number
Active customers are customers starting business and any cohort of customers that has not expired.
05
Calculate Income
Active customers multiply by monthly licence fees and then add up revenues in different levels and months.
FORM OF CORRECTIONRevenue = Active customers × Monthly fee for active customers
01 / REVENUE RESULTS
Which Entrances do the Internet Course Revenues Run?
This appropriation is intended to cover the financing of the European Social Fund (EFF) and the European Social Fund (EFF) programme. CAC, allocation of levels, life period of the customer, clients starting business, seasonality and monthly fees for cohort income.
GROUNDS FOR THE REVENUE
Revenue assumes that the acquisition managers, allocation levels, cohort activity, fees, seasonality and number of customers.
02 / COGS & OPEX
How Course Costs and Operating Costs Are Modelled?
The COGS & OPEX card separates direct course costs, variable costs and fixed overhead costs, allowing the operational assumptions to flow to margins and monetary needs.
COGS & OPEX
COGS & OPEX organizes direct costs, variable expenditure, fixed overheads, schedule and projected monthly expenditure.
03 / SCENARIOS
What Can Be Compared in Low, Basic and High Cases?
The Scenarios compared the low, base and high cases in terms of revenue, gross margin, premium margin and EBITDA in the five-year forecast.
SCENARIOS
The scenarios compare low, base and high revenue trajectory, gross margin, premium margin and EBITDA.
04 / DASHBOARD
What Does the Dashboard Contain?
The data table introduces scenario control, basic finances, revenue mix, profitability, cash flow, cost reimbursement and selected operational indicators into one view.
DASHBOARD
The navigation desk combines settings, scenario checks, financial summaries, income statement, profitability, cash flow and return charts.
FIT OF PRODUCTS
Is the Financial Model of the Online Course Suitable for You?
The template matches the recurring revenues of customers active with monthly level fees; structurally different revenue engines or reporting needs may require a non-standard modelling.
MODEL BY MADA READY
Good Example
You charge active customers periodic monthly fees in different levels of services or products.
Marketing expenses and CAC are significant drivers of new purchases of customers.
The duration of the customer or churn determines how long each taken cohort remains active.
You want a five-year, low, base and high planning with related financial reports.
CUSTOMS STRUCTURE
Consider Custom Pattern
Your income depends primarily on one-off purchases, not monthly fees of active customers.
You need a user-based, market-based, license-based or other revenue logic beyond customer levels.
You require operational schedules that differ considerably from customer cohorts, COGS and OPEX, wages and CAPEX.
You need reporting or funding structures outside the current architecture of the workbook.
The template is the starting point of planning, not a guarantee of performance.
FINANCIAL MODEL SERVICE
Do You Need a Model Built Around Your Requirements?
The Financial Models Laboratory can build or adapt a model where the revenue logic, operational schedules, financing structure or reporting requirements differ from this template.
After making your payment, you receive an editable financial model Excel and Google Sheets with five-year forecasts, scenario analysis and related financial reports.
01
Editable workbook
Update of assumptions concerning specific enterprises, operating factors, costs, personnel, capital and financial outlays.
02
year forecast 5
Review of five years of forecast with monthly and annual financial details.
03
Analysis of scenarios
Compare low, base and high cases using the framework of the model scenario.
04
Financial statements
Review of related revenue, cash flow, balance sheet, dashboard and summary of results.
BEFORE BUYING IMPORTANT INFORMATION
Online Course Financial Model FAQ
The basic answers are visible in their entirety, without clicking on the accordion.
01
How does the financial model of the online exchange rate calculate revenue?
It converts marketing expenditure and CAC into new customers, allocates them at all levels, preserves cohorts and multiplys active customers with monthly fees.
02
What are the assumptions of the online course?
You can edit launch date, customer start, annual marketing budget, seasonality, CAC, level allocation, customer or churn life, and monthly level fees.
03
What can I compare in Low, Base and High scenarios?
The Scenarios compared low, base and high incomes, gross margin, premium margins and EBITDA in the whole forecast.
04
What financial results are taken into account?
The product contains a statement of revenue, a statement of cash flows, a balance sheet, a dashboard, a summary, charts and other related opinions.
05
Can the Financial Models Lab adapt it to its own requirements?
Yes. The Financial Models Laboratory can build or adapt a model for different revenue logic, operational schedules, financing structures, or reporting needs.
06
Is this a forecast or a guarantee?
This is a planned forecast based on the assumptions to be edited, not a guarantee of future financial or operational results.
What Does the Online Course Financial Model Contain?
You get a pre-written Excel template for online course financials, complete with a dashboard, financial statements, and detailed assumptions for your digital course revenue forecast.
All-in-one Dashboard
Core inputs and core outputs
Low/Base/High
Three scenario analysis
Professional Charts
Presentation ready
ROE Components
DuPont analysis
Revenue Inputs
Researched revenue assumptions
Bank-Ready Reports
Lender-friendly financial outputs
Revenue Breakdown
Revenue stream detailed view
KPI Dashboard
Performance metrics benchmark
Choosing a selection results in a full page refresh.
GROUNDS FOR THE REVENUE
COGS & OPEX
SCENARIOS
DASHBOARD
