Revenue & Calc
Set qualified website sessions, checkout conversion, the nonrefunded share, launch timing, five course prices, and purchase mix. Calc converts the single demand pool into mutually exclusive monthly orders and sales by course.
Editable Online Course Financial Model in Excel
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Description
The Online Course Financial Model is an Excel template for planning monthly checkouts, course-level revenue, operating costs, staffing, and opening funding for a small U.S. publisher of self-paced business-skills courses. Editable assumptions feed monthly financial projections and reports across 2026 through 2030.
The documented case uses direct, prepaid single-course sales from one website audience, without subscriptions or enterprise invoices. The January 31, 2026 launch date activates the full launch month; amounts are in U.S. dollars, and all five years are illustrative forecasts rather than historical actuals.
- Forecast
- 5calendar years
- Course topics
- 5single-purchase offers
- Receivable days
- 0prepaid checkout case
MODEL CONTENTS
What Is Included in This Excel Model?
Connected worksheets take course demand and expense assumptions through monthly calculations, financial statements, and decision reports.
COGS & OPEX
Set content licensing, payment processing, acquisition and affiliate marketing, fraud losses, and monthly overhead. Expense effective dates, rates, and payment frequencies feed the operating forecast.
Payroll & CAPEX
Adjust staffing by role, annual base pay, hiring dates, and asset purchases. Payroll builds personnel costs while CAPEX schedules equipment spending and depreciation separately.
Funding & Statements
Enter equity in CapTable and potential borrowing through Dashboard Debt Controls. The Income Statement, Cash Flow, Balance Sheet, Sources & Uses, and Checks connect profitability, funding, liquidity, and reconciliations.
Analysis & Reporting
Review the Dashboard, Summary, Low/Base/High comparisons, Returns, Valuation, Benchmarks, Ratios, and revenue and expense composition. These reports draw on the supporting schedules, not separately assumed performance figures.
REVENUE ENGINE
How Is Online Course Revenue Forecast?
A single website-demand pool is converted into nonrefunded paid purchases and allocated across five exclusive course offerings.
In the example, qualified monthly sessions grow from 12,000 in 2026 to 26,000 in 2030; paid conversion rises from 1.5% to 1.8%, while the nonrefunded purchase share stays at 95%. Volume follows demand rather than classroom seats or instructor capacity.
Each checkout purchases one course only. You can change individual prices and topic allocation; the selected 30%, 25%, 20%, and 15% shares leave a calculated 10% residual for business writing.
Revenue Forecast
The Revenue Forecast organizes qualified sessions, conversion, refunds, course mix, prices, and launch timing, while Calc computes each course’s monthly revenue. Compare traffic growth, checkout performance, and pricing before changing the marketing plan.
| Course | Share of orders | Price per course |
|---|---|---|
| Excel and data analysis | 30% | $199 |
| Digital marketing | 25% | $249 |
| Project management | 20% | $229 |
| Business presentation design | 15% | $179 |
| Business writing | 10% residual | $149 |
Shares total 100% of nonrefunded purchases; the example weighted course price is $209.50.
2026 illustrative revenue build
12,000 monthly sessions × 1.5% paid conversion × 95% nonrefunded × $209.50 weighted course price × 12 months = $429,894.
OPERATING COSTS
How Do Course Expenses and Payroll Flow?
Content licensing, selling costs, monthly overhead, and role-based salaries are modeled separately and combined to calculate operating EBITDA.
Licensed learning content is direct COGS at 6% of revenue. Separately, variable expenses total 28.5%: payment processing at 3.3%, acquisition and affiliate marketing at 25%, and chargebacks and fraud at 0.2%.
COGS and Operating Expenses
The COGS and Operating Expenses forecast separates content licensing, revenue-linked selling costs, and monthly fixed overhead. It lets you evaluate gross margin and contribution after marketing without including salaries in those expense groups.
Selected fixed costs total $17,868 annually and cover the course platform, editing software, home studio occupancy, insurance, accounting, and equipment upkeep. The course platform alone is budgeted at $189 per month for 12 paid months.
Payroll Forecast by Staff Role
The Payroll Forecast plans annual-average FTE and fixed base salary for the publisher, instructional designer and editor, and learner support coordinator. Salary costs enter Payroll once, rather than being duplicated in direct, variable, or fixed expense inputs.
The publisher remains at 1.0 FTE with $72,000 base pay. Instructional design increases from 0.5 to 1.0 FTE, while learner support rises from 0.4 to 0.9 FTE by 2030; this case excludes employer taxes, benefits, and personal taxes.
2026 annual base payroll
1 × $72,000 publisher + 0.5 × $68,000 design/editor + 0.4 × $44,000 support = $123,600.
STARTUP FUNDING
How Are Opening Investments and Funding Treated?
Equipment purchases, distinct preopening cash items, working-capital assumptions, and owner contributions are kept separate from annual operating expenses.
Opening equipment includes $4,500 of computers and editing gear plus $2,500 of audio, video, and lighting equipment. Separate preopening cash items include curriculum and recording labor, website setup and launch media, and registration and intellectual-property legal work.
Capital Expenditure Plan
The Capital Expenditure Plan tracks dated equipment purchases and applicable depreciation. It distinguishes initial studio assets from repeat monthly operating charges, so investing cash requirements are not mistaken for the EBITDA expense forecast.
For this prepaid digital-sales case, accounts receivable, accounts payable, and inventory days are all set to zero. These remain editable working-capital controls, not evidence that monthly cash balances will always be sufficient.
Sources and Uses of Funds
The Sources and Uses of Funds report reconciles funding and cash allocation across operating, investing, and financing activities. The selected $104,445 initial owner contribution covers equipment, separate preopening payments, and an estimated three-month reserve, with no committed funding from other sources.
FIVE-YEAR PROJECTIONS
What Does the Illustrated Base Case Project?
The selected 2026–2030 demand, cost, and staffing assumptions produce the following annual operating forecast in U.S. dollars.
| Year | Revenue | Operating expenses | EBITDA |
|---|---|---|---|
| 2026 | $429,894 | $289,781 | $140,113 |
| 2027 | $573,192 | $350,419 | $222,773 |
| 2028 | $730,820 | $419,401 | $311,419 |
| 2029 | $945,767 | $510,358 | $435,409 |
| 2030 | $1,117,724 | $583,083 | $534,641 |
Selected scenario only; displayed figures are rounded to whole dollars and may not subtract exactly.
In the illustrative case, revenue rises from $429,894 in 2026 to $1,117,724 in 2030, while annual operating expenses increase from $289,781 to $583,083. EBITDA consequently increases from $140,113 to $534,641 before depreciation, interest, or tax.
These are calculated planning scenarios, not actual sales, sector benchmarks, or a performance guarantee. The documented operating illustration ends at EBITDA even though the workbook also includes broader financial-statement, financing, and cash-flow schedules.
Cash Flow Forecast
The Cash Flow Forecast separates operating receipts and payments from investment, financing, and changes in cash balances. Use it with the Income Statement to review liquidity, since positive EBITDA and prepaid customer checkouts do not establish cash sufficiency.
INVESTMENT DECISIONS
How Are Break-Even, Payback, and Returns Assessed?
The Returns reports distinguish sales break-even, cash break-even, project investment payback, and annual return on invested capital.
Sales break-even compares revenue with operating cost requirements; cash break-even looks at cash coverage. Investment payback tracks cumulative project cash flow, while annual ROIC relates returns to invested capital. None is equivalent to EBITDA or an assumed investor IRR.
Break-Even, Payback and ROIC
The Returns analysis presents operating break-even, cash break-even, investment payback, and annual ROIC from the linked schedules. The supplied illustration does not establish a specific payback month, achieved investor IRR, or investment-return figure.
Dashboard Low, Base, and High multipliers let you stress revenue, COGS, variable expenses, fixed expenses, and payroll; Scenarios compares operating outcomes. Valuation provides discounted cash-flow and terminal-assumption sensitivity, but no valuation amount is established by the supplied operating case.
MODEL APPLICATION
Who Is This Course Publisher Model For?
The template fits a small U.S. publisher selling individual prerecorded business-skills courses directly to consumers.
Use it to assess qualified traffic targets, customer acquisition spending, the timing of learner support hires, and funding for course production and studio equipment. Change the assumptions to reflect your own pricing and audience rather than treating the sample as verified industry demand.
Subscriptions, cohorts, accredited certificates, physical goods, and enterprise invoices are outside this documented course revenue design. Benchmarks compare model ratios against reference values entered in the workbook, not independently verified industry averages.
FREQUENTLY ASKED QUESTIONS
Online Course Financial Model Questions
Answers to common questions about the template’s assumptions, revenue mechanics, outputs, and operating scope.
Can I change prices and course mix?
Yes. Edit each course price, purchase share, qualified sessions, paid conversion, nonrefunded share, and launch timing in Revenue.
Does it support subscription revenue?
No. The documented revenue model uses direct prepaid, single-course checkouts with no subscription renewals, cohort retention, or enterprise billing.
How does the model handle refunds?
It applies the selected 95% nonrefunded share to converted purchases before distributing net course orders across the five topics.
Are employee salaries included twice?
No. Publisher, instructional design, and learner support base salaries enter through Payroll, separately from COGS, variable expenses, and fixed overhead.
Does the template contain financial statements?
Yes. Income Statement, Cash Flow, Balance Sheet, and Summary reports link to supporting monthly calculations; this brief provides illustrative figures only through EBITDA.
Is projected EBITDA the same as available cash?
No. EBITDA excludes investing and financing cash flows; consult Cash Flow, Sources & Uses, and Balance Sheet for liquidity analysis.
Can I test a weaker sales case?
Yes. Dashboard Low, Base, and High multipliers adjust revenue and cost assumptions, with comparative results in Scenarios.
Does the example promise a payback or ROIC?
No. Returns can calculate break-even, payback, and annual ROIC, but the supplied example provides no specific payback date or return.
What Does the Online Course Financial Model Contain?
Financial Dashboard
KPIs, forecasts, and cash flow at a glance.
Revenue Engine
Key assumptions and calculations driving revenue forecasts.
Sources & Uses
Funding sources, spending, and closing cash.
Returns & Break-Even
Cash break-even, payback, and ROIC.
Business Valuation
DCF valuation and sensitivity analysis.
Expense Breakdown
Largest costs and spending trends.
Financial Summary
Annual and monthly financial performance.
KPI Benchmarks
Compare margins and returns to benchmarks.
Trusted by 25,000+ startup founders, investors and CPAs
Better Cash-Flow Visibility
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
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
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.