You will be able to account for the many moving parts that go into starting your own gym or fitness center. Here is the template instructions by Tab:
1. Start on the ‘Executive Summary’ tab by entering the start month in C2.
2. Enter the month you plan on revenue starting in box C3.
3. C13, C14, and C15 define the exit plan.
4. C25 defines the discount rate in order to get to a NPV of the future cash flows.
5. The primary data from the Annual P&L flows into here so you can get a clean picture of the revenues/expenses/cash flow and some visuals.
6. Note the IRR is a complex calculation that uses the assumption that the total loss for a given year is the max draw-down. In reality that may not be the case as you could have a draw-down on a monthly basis that requires more cash outlay. Generally, this won’t make a huge difference, but it is important to understand that calculation when looking at the project returns.
1. This is straight forward. You simply enter the description of each startup cost you plan on having, the count (if applicable or just put 1 if only 1 thing), and the $ amount.
1. If you are going to take out a loan, this is where you would enter the details of the loan as well as the month you plan on that debt repayment starting.
1. This is the planned monthly expenditures you will have in normal operations. These costs flow to the monthly P&L rows 19 – 64.
1. This lets you pick various months where you know you will have fixed one-time costs that ar enot regular on-going costs. Rows 80 – 125 on Monthly P&L.
1. You will define your starting members here, and then for each year you can define the amount of members you think you will gain per month, the price per month they will pay you, and the churn (amount of members that leave each month).
1. If you think there will be proceeds from a building, this is where you account for those proceeds. They will flow into the cash flow lines where applicable. If you are renting, this would not be applicable.