Recent Upgrades: Fully integrated 3-statement model that is connected to all assumptions, capex schedule with depreciation, cap table (for investors and insiders if applicable), and brand new revenue logic that is driven off of total stations and an optimal member count strategy (sources in file).
Opening a gym or fitness center will generally have common things that need to be accounted for no matter where you are and what kind of gym you are starting. There is going to be an initial investment in workout equipment / machines / building or renting of some sort. And then there is some sort of membership fee that your customers will pay each month to use the space.
In general, the point of this template is to test various pricing strategies and drive down to the base unit economics of the endeavor. The user can see what kind of initial investment will be required, how many customers need to be added over time (and churn is accounted for with a defined average monthly rate) and what the revenue looks like against expected operating expenses.
Final outputs include an annual financial summary / cash flow analysis, and IRR of the entire project. In order to do a proper DCF Analysis, the model lets the user input a potential exit value of the business and the resulting cash proceeds therein.
An investor / owner distribution schedule was also built. The user can define proceeds from investors and how much of the profit share goes to these investors based on that investment. Cash contributions / distributions will then display on a project basis as well as per the investor pool cash flows and owner cash flows.