Collaborate on Gym Bill Format for Planning with Ease Using airSlate SignNow

Gym bill format for Planning

[Music] [Applause] hey if you're looking to open a new gym and you are trying to raise some capital from potential investors or maybe talking to the bank and your lender has asked you for a set of financial projections and now you're kind of the dear in the headlights trying to figure out how to pull together a set of financial projections that are going to make sense to your potential investor or lender and tell the story of your gym and do that in a way that that looks good and makes sense to to those folks then you are in the right place because we have put together a gym financial projection template built specifically for this purpose my name is adam hooksema i'm the co-founder of projection hub and over the last decade we've helped thousands of entrepreneurs create financial projections uh for all sorts of different businesses but specifically today we're talking about our gym template and we have links to this template in the description of the video below so if you want to go grab that template and work alongside you can do that now but i'm going to dive into this template and just show you how to fill it out so the first thing i want to show you is really starting here at the end so this is our at a glance tab and we have you can see your potential revenue here projected revenue your some different graphs and tables you can see some key performance indicators for your gym like number of new members in a year your total ad spend cost to acquire a customer and your total members how many members you have and what your churn rate is going to look like as well you've got ongoing member lifetime value number here as well that's important to look at so a lot of key numbers as well as some startup graphs break even analysis and more so this is kind of what we get to at the end but in addition to that you'll get your projected financial statements so your projected income statement for five years cash flow balance sheet and you also get a projected income statement cash flow and balance sheet by month as well for each of the five years so let's jump back to the beginning here and and take a look at how we got here how did we fill this out and the first thing i want to mention is that any cell that you see highlighted in blue is is a assumption cell that you can change the data in there without breaking the template so put in the name of your gym the start month for your projections a personal investment if you're putting in personal investment or projected investment from from others here you can add those and then you'll put in your fixed assets so in this example we're assuming that you're leasing the gym building itself and then you have some leasehold improvements a hundred thousand dollars of leasehold improvements to the gym to get it ready as well as half a million dollars in gym equipment that you're purchasing so in this example we're assuming you're purchasing this equipment now you may lease some equipment you may purchase some equipment you may have a mix of both if you're leasing all of your equipment then you wouldn't want to enter it in here this is assuming you are purchasing it now with that in mind we're expecting a we're projecting a 650 000 sba loan we're going to take out to be able to help fund these startup costs we're going to jump into our input revenue tab zoom in here a little bit and so i'm going to actually show you two different templates here we have a we have a template that's more focused on membership based gyms so this could be like your planet fitness or anytime fitness style or even like a full service gym as well lifetime fitness as an example where you're paying memberships you may also have classes but it's really focused on membership model and then we have a separate template that's really more focused on a class-based model and i'll show you that in a second and when you buy one of our gem templates you're going to get access to both of these so i'm going to just show you both here in the same walkthrough now the first thing we're going to do is enter in the maximum number of members that our gym can support and we're going to enter in our monthly ad spend well we're going to assume some cost to attract one new gym customer we're also going to assume that some gym members are going to join through word of mouth or social media organically and this will give you your total new gym members each month here and then we we're assuming a churn rate now different gym models have different churn rate assumptions and so you know some models are very high churn where you have to kind of replace your membership you know every year um some have very loyal members and so it kind of depends on what your particular model is going to be what your focus is what we have right here is an annual churn rate meaning half of your members leave every year is what we have put in here as an assumption right now and now we have our different membership plans so you can um we have the ability to say okay we have an annual membership a monthly membership we have some add-on services and even a pay-per-class option and you can put how much you expect one of those [Music] regular customers to spend per month on these items and here you're going to put in what percentage of your regular customers are kind of in each bucket so you might have some customers that don't become members but maybe you have some individual classes that you sell and that's and you just have 10 of your regular customers just come for a class and that's all you know and 40 percent have the annual membership for example so that's going to give you your gym uh revenue here from the classes and membership now we also have the ability to add in food and drink revenue and merchandise and other revenue as well now i'm going to jump over to our class-based template so everything else in this template is really the same except we have a more of a focus on classes and making sure that we really dive into the details of this so if you're um if your business is more like an orange theory or maybe a yoga studio that's heavily based on group classes then you probably want to use a class-based template and so you can put in your different classes that you have how many per week you have how long the session is the maximum number of students the fee the instructor pay and then if there's any commission to the instructor as a percentage of revenue as well and then again you'll have the ability to enter in your capacity that's capacity filled by month and so this is going to calculate you know how many students per per month and per class that you're estimated to have based on these assumptions and and whether you will have enough capacity to fulfill those the demand as well and this option also does allow you to put in membership options as well it's just a little bit more focused on the class-based model so that's really the main difference between the two templates i'm going to jump back to the one we are working on initially here and take a look at our operating expense tab so here you can see we've entered in things like our rent i also entered equipment at least so we spent a half a million dollars to buy equipment but maybe some of the equipment we're also leasing and so we put in that expense there as well also point out this here that you can select from this drop down that your expenses can be either a percentage of total revenue or a fixed dollar amount and so most of them we have as a fixed salary amount but here we are saying our transaction fee this could be a credit card fee is point zero three or three percent so if you have a three percent credit card fee you'd wanna enter that in as point zero three and it will create an expense line of three percent for of total revenue for those transaction fees now jumping into the input salaries tab you can add individual salary positions they could be part-time or full-time you can enter in what month those positions are going to start so they don't have to all start in month one of the projection some could start let's say you're going to add a trainer in month 13 as the business grows and you can add the number of those particular employees here as well how many front desk part-time workers you have we're saying we have three we're saying we have three class instructors one director one marketing person two trainers that are starting in month 13. so that's what how this is filled out and you can see there's plenty of slots for you to be able to add more employees as you wish that really brings us back to where we started the profit and loss at a glance and and really at that point you're done and you can see based on the numbers that we input we were starting out just under half a million in revenue in year one going up to 1.1 million in revenue in year five with a 20 net income income of 235 000. so you'll need to do all of your own research here of course your particular gym model is the key here for all these assumptions you know what size of space are you what what are you going to charge what do you think your churn rate's going to be are you going to be able to retain members or are you going to have to constantly replace them lots of key assumptions here that are really based on your specific business plan so if you have questions uh leave a question down in the comment section of the video uh the youtube video below and we can reach out to you and and answer questions that way you can also reach us at support projectionhub.com all right best of luck