SmartHelping / 10-Year Financial Model / Excel
Educational Courses
Build a financial forecast for an online or in-person education business. Connect course pricing, class expansion, seat utilization and course length to revenue, costs, cash flow and investment returns.
Immediate download after purchase. By purchasing, you agree to the Terms of Service.
See the model in action
Follow the course plan through the financial forecast.
Watch the walkthrough to review the course assumptions, expansion schedule, capacity calculations and financial outputs. Open the screenshots below for a closer look at the workbook.
What the model includes
Plan the business from the classroom to the financial statements.
Use monthly and annual views to assess a small course business or a larger operation adding classes and locations over time.
10-year, integrated financial statements
Project the income statement, balance sheet and statement of cash flows for up to 10 years, with monthly and annual views and built-in sanity checks for all statements.
DCF, IRR and MOIC analysis
Review discounted cash flow valuation and investment returns. Adjust the launch year, exit timing and terminal value multiple to reflect the plan you want to evaluate.
Capital spending and funding
Use the capex schedule, cap table and optional debt utilization to connect the operating plan with investment and financing requirements.
Class scheduling across locations
Use the scheduling tab and its conditional formatting to plan class time slots and available capacity across multiple classrooms or locations.
Capacity and utilization charts
See total seats available, seats filled and utilization rates over time for each course type. Visualizations update as the underlying assumptions change.
Annual executive summary
Review high-level financial metrics in the annual executive summary, supported by dynamic visualizations of the financial projections.
Build the operating plan
Control how classes launch, fill and expand.
Configure each course type separately so pricing, capacity and expansion can reflect different offerings.
Up to 3 course types
Set each course type’s pricing, class expansion, variable costs, capex, capacity and course length assumptions.
10 expansion tranches per course type
Define up to 10 phases of class additions for each course type, including the number of classes added in each phase.
Utilization over the first 36 months
Enter the percentage of full class capacity reached over time. The utilization pattern applies relative to each expansion tranche’s launch and supports reaching capacity within the first 36 months.
Course length in weeks
Define how many weeks a course takes to complete. The model converts that duration into courses per month for the monthly revenue and variable-cost calculations.
Costs tied to course activity
Configure course-specific variable costs and capital requirements alongside pricing and seat capacity to assess the economics of each offering.
3 fixed-expense sections
Enter monthly fixed expenses by cost type and start month across three main sections. Use the timing inputs to plan expenses such as additional rent when opening new locations.
Course length, seats and monthly activity
Make the utilization plan match the course cycle.
Revenue and variable costs are driven by courses completed per month. The model translates course duration in weeks into monthly activity while accounting for class capacity, utilization and expansion across the three course types.
Start with seats and duration
For example, one class could offer 25 seats and run for four weeks. Course price and the percentage of those seats filled determine the projected sales activity, alongside the course-length calculation.
Align utilization with completion
A month averages approximately 4.33 weeks. When a course lasts longer, set utilization changes to reflect when students finish and seats become available again. For a course spanning two monthly periods, for example, utilization could remain at 20% in months one and two, then rise to 30% in month three.
Apply the pattern to new classes
The utilization assumptions follow the start of each class expansion tranche. This lets new classes build toward capacity over their own first 36 months while the existing classes continue operating.
How to use the model
Turn the course schedule into a business plan.
Define the course offerings
Set up to three course types with their own prices, seat capacities, course lengths, variable costs and capital spending.
Schedule the class additions
Set the class count added in each expansion tranche and plan time slots and classroom capacity with the scheduling tab.
Set utilization and overhead timing
Enter the capacity ramp for newly launched classes and time fixed expenses to match the locations and operating capacity you plan to add.
Review the financial outcome
Evaluate the monthly and annual statements, executive summary, capacity charts, cash flow valuation and investment-return metrics. Adjust assumptions to compare alternative plans.
Online or in-person courses
Adapt the assumptions to the subject you teach.
Originally inspired by an elder tech academy, the model can support a wide range of businesses that sell educational courses or classes.
Technology and lifelong learning
Model an elder tech academy teaching phone, television and computer use, or courses in programming, web development, data science, machine learning, network administration and cybersecurity. Other examples include adult literacy, GED preparation, language learning and financial literacy or retirement planning.
Academic and business education
Plan classes in mathematics, science, humanities, social sciences and languages, including algebra, calculus, biology, chemistry, physics, history, literature, philosophy, sociology and psychology. Business offerings can cover marketing, finance, accounting, human resources, project management and entrepreneurship.
Arts, hobbies and personal development
Examples include painting, drawing, sculpture, dance, music, drama and theater, as well as photography, cooking, baking, gardening, DIY crafts and creative writing.
Vocational and professional training
Use the model for course businesses teaching Automotive Repair, carpentry, woodworking, culinary arts, welding or Plumbing. Other examples include Real Estate Licensing, aviation and pilot training, scuba certification, and first aid or CPR.
Health and fitness courses
Plan yoga, Pilates, martial arts, personal training, fitness, nutrition and dietetics courses around their class capacity, duration and pricing.
Culture and sustainability
Examples include indigenous studies, cultural anthropology, religious studies and regional studies, along with Organic Farming, renewable energy, conservation and wildlife management.
Also available in these bundles
Need models for more than one business?
This template is included in the Industry-Specific bundle and the Super Smart Bundle.
Industry-Specific Financial Models
Explore financial models built around the operating assumptions of different businesses and industries.
View the Industry-Specific bundleSuper Smart Bundle
Access the complete public SmartHelping template collection across industries and financial-analysis needs.
View the Super Smart BundleQuestions before you buy
A few useful details.
Can I use this for online and in-person courses?
Yes. The operating assumptions can be used for online or in-person educational courses. The scheduling tab also supports planning class time slots and capacity across physical classrooms or locations.
How many courses and expansion phases can I model?
Configure up to three course types, each with up to 10 class expansion tranches and its own pricing, costs, course duration and capacity assumptions.
How does the model handle classes that take more than a month?
Course duration is entered in weeks and converted into monthly course activity. Set the utilization ramp to reflect the course completion cycle so increases in occupied seats align with when those seats become available again.
What financial outputs are included?
The model includes up to 10 years of monthly and annual three-statement projections, a capex schedule, a cap table, optional debt utilization, DCF analysis, IRR, MOIC, an annual executive summary and dynamic visualizations.
Can I phase in fixed expenses as the business expands?
Yes. Three main fixed-expense sections let you configure monthly costs by cost type and start month, including expenses associated with future location expansions.
Plan the next stage of your education business
Connect the class plan to the financial outcome.
Get the Educational Courses Financial Model for $75 and build a forecast around your course mix, expansion schedule and utilization assumptions.
