Streamline Your Gym Bill Format for Production with airSlate SignNow

Gym bill format for Production

hello and welcome to some a khadeem financial model template this tool mainly displays you the analysis of the Jim you are going to establish based on your assumptions it is constructed by four parts these are the dashboard the revenue model inputs the cost inputs and the report outputs so let's start with a dashboard in the dashboard type your membership plants and it details in this section so as an example let's say we decided to launch a membership plan of a 12 month version of this membership which the duration is 12 months once you complete type in the group classes that you're going to provide which can only be joined by the punch card that you're going to sell so let's say Jumba for 60 minutes forty dollars later on set the model configuration ing to your preferences the projection period can be adjusted from 2 years to 10 years in this case let's make it 5 years define your start date your currency and your discounting rate the discounting rate will be used in the NPV and IRR calculation to be able to find the net present value of the project adjust the tax rate and once you read all the instructions in every sheet you may hide them by switching this from show to hide now let's start with the revenue model inputs select your membership type from the drop down menu and type in your assumptions for each month so let's say you think that there won't be any popular demand to this membership plan so your assumption is that there is going to be additionally one people for every month until August 2022 and let's say from the September 2022 to end of your projection period which is December 2023 there are going to be two additional people and each month please press plus sign to get additional rows you can apply this procedure for any table which there is a plus sign right next to a table please only input your data into the white cells the gray cells in this template are set to give you the output of your assumptions you input into the white cells so let's carry on with the output tables so this table gives the cumulative sum of people whose contracts will be determined on a monthly basis all the tables and here starting from this table are for informative purposes and shouldn't be changed this table in here shows the number of contracts for members to continue to their memberships on a monthly basis this table shows the number of members who are willing to continue and renew their contracts depending on the renewal rates you determine on the dashboard this table on here shows the number of members who ended their standard contract and continuing with the monthly rolling renewal this table in here shows the number of members who ended their standard contract and dropping the monthly rolling renewal this table in here shows the numbers of members who are in a periodic renewal schedule this table in here shows the numbers of number of members who ended their fixed or off-peak contract and has to renew their contract this table in here shows the number of members who ended their fixed or off-peak contract and renewed their contract depending on the renewal rate this table in here shows the number of lost members on a monthly basis and this table in here shows the number of active members on a monthly basis in this table you can set the price increase of the membership types with its period type change it ing to your preferences if it's gonna be annually semi-annually quarterly or monthly let's say we're going to increase samy annually and it is going to be 2% for each term we determine in this case it is semi-annually the tables are dynamic once you set it it is going to change with the values you choose and this table in here shows the price increase of the base in each initiation fee for each month with the terms you determine and finally these two tables shows the revenue generated by memberships and initiation fee which also includes the price evolution you set on the previous table now we may carry on with the classes select the group classes from the drop-down menu which you input in the dashboard and write down your assumptions for each month so let's say you're expecting the exact number with a cardio input the punch card type and the base price for each punch card type you have with the amount of punch card do you think you will be able to sell in each month this table like in the previous one sets the term and the price increase let's say we make the semi-annually and three percent this table shows you the revenue generated by punch cards for each month trainers get paid for the classes they give and the group sessions and you input the trainer fee per hour for every class in the dashboard already this table sets the term and the fee increase of the trainers and shows us how much to pay for each class per hour and how much to pay to trainers in each month ing to the price increase we set let's say we decided to set the term Samuli and let's make this 0.5% now we may carry on with extra sales this is the place where you can list your extra income input the item price and a variable cost if there is any and sales per month based on your assumptions so let's say sports water the base price is $2 and let's say that we're getting it from $1 so the variable cost in this case is 50% and let's say we're going to sell 150 bottles per month after that the structure of the template is the same with the previous tabs set the price evolution for extra income the tables will show you the price evolution and extra income revenue depending on the rate and term you determine a bow and finally the last table shows the cost of extra sales for each period now we can carry on where the cost inputs so let's start with the fixed costs the only two tables you have to set as the first two the first shows the salaries and amount of employees to work in that title for each month so let's say we decided to get a professional Fitness advisor on August 2019 and only one and let's say the salary is going to be two thousand and five hundred and we're going to keep him till the end of our projection period later on in put your other monthly expenses like rent utilities insurance and so on type down their expenses for each month set the salary evolution to determine the cost of salary for each employee and the total salaries to be paid for each title so let's say we decided to give them raise semi-annually and 1% now we can carry on with the startup costs startup costs are the expenses which are made prior to start your sales so type down each startup cost you had to build up this gene once you're done with this section now we may see the results of the inputs in the report outputs the reports are also dynamic ing to the valley you choose and the projection period on the dashboard so let's start with the financial statements financial statements show the income statement the balance sheet and the cash flow statement of your project when you hit the profits because of the change of inputs you need you need to update the reports click on the update reports button to be able to update all the pivot tables so the profit section shows you your income statement through the years by adding depreciation and amortisation in the end you may press two minus signs they only see the conclusion for each year in each pivot table and the report outputs the break-even analysis shows the cumulative profit from the beginning to the end of your projection period with the main data's below the net revenue report shows you all of your net income generated by all of your income sources and quarterly periods sales breakdown breaks down all of your income resources into their quantity price and their revenue and quarterly periods subscription breakdown shows you the subscription status of new lost and retained members for each period NPV IRR calculator shows you the cumulative discounted cash flow chart with the net present value and internal rate of return of your project the gross profit report shows you your revenue lines gross profit and gross profit percentage gross profit breakdown shows you the net profit of each quarter segmented by the business lines and lastly the data source is shows you the data all the data you input to be able to see the outputs thanks for watching and don't forget to check our other templates at .thermocalc.com you