Gym Business Financial Model
Gym Business Financial Model provides all financial information for opening gym or fitness studio. Excel template for a professional financial feasibility study!
As people around the world getting more and more concerned with a healthy life, it may be a good time to capitalize on that. The fitness industry to open gym is booming these days.
It may look quite competitive though, but successful businesses are constantly looking for new opportunities. And working out creative ways to render better service to their customers. If you manage to find out the right formula appealing to your target customer audience, you will turn your gym business or fitness studio into a cash machine.
The right pricing model is of no lesser importance. You should match pricing to the market you are going to serve and the services you are offering. Get this right and you will be set up for success. Get it wrong and it will be difficult for your business to survive.
Sound pricing models should offer incentives to the potential and existing customers to join and stay with you, as well as contribute to overall business profitability. The most expensive items your fitness business is going to pay for, besides trainer fees, are property lease and equipment purchase or lease. Make sure you can afford these expenses and cost of opening a gym with your projected sales.
Gym Business Financial Model Template provides you with all you need to create a professionally-looking financial section of the business plan. So, let’s go ahead and see how simple yet effective it is.
Gym Business Financial Model Template Features:
From the Dashboard, you can easily access any section of the model, such as revenue and cost input sections, and various reports. It also contains a Settings section that allows you to enter underlying settings and assumptions.
Use the model to:
- Create financial projections for up to 10 years and test them under different assumptions;
- Combine and test various business models: membership subscription, group training, selling supplementary products and services;
- Test different pricing models and see their impact on the performance of the business;
- Account for long-term price and cost trends;
- See the impact of taxation over the whole life of your project;
- Estimate the payback period;
- Calculate crucial investment metrics such as Net Present Value (NPV) and Internal Return Rate (IRR).
Input your membership subscription projections, classes schedule and extra sales projections to blue section and cost-related inputs to red sections. After completing the inputs, you will see the outcomes in green reports sections. Don’t forget to press Update Reports button on the top of the report window.
Basically settings part has 3 different subsections contains the base model settings:
- Membership Subscription Plans
- Model Configuration
- Group Classes
1. Membership Subscription Plans:
Table is here to allow you to manage your subscription plans.
- Membership Plan column: gives a meaningful mane to all your membership subscription plans;
- Duration column defines a fixed term of the subscription, from 1 month to 12 months, being the duration of the initial subscription period. After initial subscription period elapses, a subscription can be either renewed for the same term, or switched to the rolling monthly renewal scheme;
- Base Initiation Fee column: how much new members have to pay for the membership acquiring, in addition to the regular membership fee. Initiation fee covers cost of initial assessment for and consultation a new member. Initiation fee may be subject to time-related adjustment;
- Base Monthly Fee: it’s how much a member pays per month. Monthly Fee may be subject to time-related adjustment;
- Payment Terms: a dropdown list. An option chosen defines how membership fee is payable: upfront for the whole duration of the fixed term, or monthly. The monthly payments for a term length that one month normally requires signing a contract, or providing a credit card by a member;
- Renewal Rate shows how many members are going to renew their membership after an initial subscription term elapses. If a membership plan involves periodic renewal for the same fixed term (as opposed to rolling monthly renewal scheme), this rate applies for all subsequent renewals too;
- Renewal Discount: if you provide a discount to the existing members as an incentive to renew their memberships, renewal discount will apply upon the first renewal. Subsequently, members pay a discounted membership fee;
- Rolling Monthly Renewal: this drop-down, if set to ‘Yes’, switches subscription renewal scheme to rolling monthly renewal upon the first renewal after an initial fixed term elapses. It means that the members are charged for membership fee monthly unless a member cancels his/her membership. Rolling renewal scheme may require providing a credit card. The other scheme, Rolling Monthly Renewal differs from monthly payment term in that it be canceled at any time, while fixed-term subscriptions are normally non-cancellable, even where paid monthly;
- Rolling Monthly Drop Rate shows how many members involved in Rolling Monthly Renewal scheme drop their subscriptions monthly, on average.
2. Model Configuration
This section will allow you to set pricing models as flexible as possible.
- A length of the Projection Period (from 2 to 10 years): Pick a respective value from the drop-down list;
- The Start Date of the project;
- Currency code which all monetary amounts will be displayed in;
- Discount rate to be used in the NPV calculation;
- The tax rate will impact net profit after taxation;
- A drop-down to show or hide instructions.
3. Group Classes
This table allows you to enter key data for calculating the cost of running group classes:
- Class Name
- Session Length in minutes
- Trainer Hourly Fee Rate.
Revenue Model Inputs
Membership section intended to make projections for the number of members and subscription revenue.
Classes section intended to schedule group classes, and calculate associated cost and revenue.
Extra Sales sections to make projections for sales of supplementary products and services.
Normally, membership subscription revenue forms the main income stream of a gym or a fitness studio. This is why Membership section is so detailed.
In the New Membership Subscriptions table, add the expected number of new members who are going to join your members in each respective month. Make it for each membership plan.
The table called New Members Yet To Renew Their Memberships will show cumulative numbers of the new members during their initial subscription terms. When it elapses, each new member will be subject to renewal; respective numbers of members are shown in the table called New Members Due For Renewal.
The next table, New Members Who Renewed Their Membership Subscriptions, shows how many new members, out of previous table, are going to renew their first subscriptions.
Members Who Now Are On Monthly Rolling Renewal Schedule table shows cumulative numbers of members who switched from fixed terms to the rolling renewal schedule.
The next table, Members Who Dropped Their Monthly Rolling Subscriptions, shows how many of them are going to quit each month.
Similarly, Staying Members Who Are On Periodic Renewal Schedule table shows cumulative numbers of members who renew their memberships periodically (except for new members during their initial fixed terms), and Staying Members Due For Renewal table shows when they are expected to renew. How many of them are going to renew can be seen in the next table, Staying Members Who Renewed Their Membership Subscriptions.
Projections of lost and retained subscriptions will be calculated automatically accordingly to the assumptions that you have entered in the Dashboard. Finally, these calculations will lead us to the figures of the lost and active members, shown in the respective tables.
Since prices normally change over time, you can account for these changes by setting price increase rate and periodicity. It will apply to both the membership fee and initiation fee. Ultimately, we are going to obtain expected membership subscription revenue and initiation fee revenue.
If you’re going to run group classes in your fitness studio, go to the Class section and add respective projections here. In the Classes Schedule table, choose your planned classes from the drop-down list.
For each class, enter expected monthly numbers of sessions. Since you have already entered session’s length and trainer’s hourly fee, this will result in calculated trainer fee expenses (see respective table below).
You may want to sell punch cards allowing members whose subscriptions don’t cover attending particular classes, as well as people who aren’t regular members, to attend these classes. Enter a respective data to the Punch Card Monthly Sales table.
You can adjust punch card prices over time the same way as with membership fee.
You may also expect that trainer fees will increase over time. If so, enter respective increase rate along with its frequency into Fee Increase fields. Trainers Fee Rate Evolution table will contain actual fees adjusted for the time-related increase.
Sales revenues from punch card sales will be calculated automatically, along with trainer fee expenses.
If you are going to sell supplemental products and services, go to the Extra Sales section and add respective data to the Extra Sales Monthly table. For each extra sale item, enter a base price (it may be subject to time-related adjustment), variable cost (as percentage to a selling price) and expected monthly quantities.
Make time-related price adjustments, if necessary, using Price Increase fields.
You will get extra sales revenue and cost of extra sales in the respective tables below.
In the next step, you will enter the expected salaries and other fixed costs in the Fixed Costs section.
Start here from the Staff table. Enter names of employee positions along with base monthly salary. For each position, enter expected monthly numbers of employees.
As it is reasonable to expect that salaries will increase over time, enter an expected increase rate and frequency into Salary Increase fields. Finally enter other monthly expenses to the respective table.
Last, but not least step will be entering your startup costs into the respective section. The usefulness of the Gym Business Financial Model’s outcomes will greatly depend on the degree of accurateness in estimating the costs you will need to start your studio.
Now as you have entered all necessary data, go to the reports which are available from the Dashboard section. The model contains the following reports:
- Financial statements including Income statement, Balance sheet and Cash flow statement;
- Profit (EBITDA) report presenting breakdowns of income and expenses by line items;
- Breakeven reports giving you an estimation of the payback period;
- Net revenue report displaying revenues for each product and service grouped into income streamlines;
- Sales breakdown report displaying, for each revenue stream, expected numbers of products and services sold along with prices and revenue amounts;
- Subscription breakdown reports showing numbers of acquired, lost and retained members;
- Marketplaces Sales Breakdown, Revenue and Profit
- NPV and IRR calculation, presenting estimations of important investment metrics;
- Gross profit report for each income line, and overall;
- Gross profit breakdown report displaying, income, direct costs and profit margins for each revenue line
Gym Business Financial Model Features Summary:
- Financial Feasibility Study in Excel
- Innovative reporting system
- Inputs to learn cost of opening a gym
- Financial Statements, Breakeven reports and more report outputs
- Works both on Mac and Windows
- No installation needed, ready to use.
- Professional design and suitable for presentations
- On Sheet Instructions
- White Label
- Compatible with Excel 2010 and later versions