Modeling out the process of filling up classes during the week in various time slots as well as weekend time slots can actually present some pretty complex logic. This model does a great job at letting the user define a few key assumptions about each class and then seeing what the resulting financial performance is as well as some cool visuals that make it easy to see how/when full capacity is reached and configurable all the variables therein.

The model was built for a cycling studio that has a limited number of available seats per session and sessions per week. It gets as granular as possible for all relevant operating costs, staff, as well as providing key summaries on a 3-year timeline.

The model includes a 3-statement model (Income Statement, Balance Sheet, and Statement of Cash Flows as well as a dynamic cap table. All the assumption areas are easy to input data into and define.

The granularity is pretty deep. The user can define the number of classes that will be going on in 3 time slots (morning/mid-day/evening) and based on the capacity of each class, once the full capacity is reached, a new ‘session’ opens up. For example, you can model the morning class having 1 session, and then once it reaches maximum capacity based on the defined inputs, a second session will open up and start to fill. Once that is full, the model moves to a 3rd. That logic works for each time slot Monday through Friday and then there are two weekend slots available with the same logic.