Startup Financial Model: Educational Classes

Description
I got the idea for this model when I came across the prospective venture of offering elder tech classes with in-person instructors. This would be classes that specialize in helping older individuals learn how to use cell phones, TVs, and general electronic usage. It is a large market as many older individuals didn't grow up with the technology. Also, as technology continues to evolve, there are constantly older individuals that need teaching as far as new tech usage goes.

So, the tough thing is figuring out how to scale this model and properly capture any relevant capex, revenues, and variable costs. I build the revenue assumption in a way that makes this seamless. The user can define the starting class count, capacity, pricing, the length of time it takes to complete, and new classes added over time for up to three course types. There is also a schedule to input how long it takes to get a class to maximum / stabilized occupancy.

The types of variable costs are configured on a per class length basis and that runs off the number of weeks a given class takes to complete. To get the math right on scaling, all the unit economics are measured on a monthly basis. So, if a class takes 8 weeks, 0.54~ of the total revenue for that class will flow in per month, each month since roughly 54% of the class is completed per month. Don't be afraid of decimals. It will even out as you scale over time so that the right amounts are populating per occupancy over time, price per seat, and how long a class takes to complete.

I've also got a fixed cost schedule / OPEX, one-time startup costs, option for debt financing, a cap table with options to raise month through multiple funds or just a single owner / operator, and more.

Output reports include 3-statement modeling integration, a DCF Analysis, and IRR. The model solves for the minimum equity required to launch the new venture and keep the cash balance above 0.

This template is also included in two bundles:
- All Models Bundle: https://www.eloquens.com/tool/P8Y4TX4v/finance/financial-forecasting-models/financial-models-120-useful-and-usable-logic
- Industry-Specific: https://www.eloquens.com/tool/lrNGt2jL/strategy/business-plans/business-sector-bundle-35-bottom-up-financial-models