Build a Pilates Business Budget |
|
Instructions |
|
While every effort has been made to create an accurate spreadsheet, this is for estimate purposes only. |
|
Any major financial decisions need to be made in conjunction with your financial professionals; accountants, lawyers etc |
|
|
|
|
|
Starting at the Lifestyle Budget Tab |
|
|
|
This has been designed so that whether you know the expenditure by the week, month or year you can |
|
complete this annual budget |
|
|
|
Example: |
if you spend $50 per week on food then put $50 against food in the weekly column |
|
If you spend $750 per year for car insurance then put that amount in the car insurance row in the annual column |
|
|
The totals will automatically add to the bottom of the columns and the Grand total will appear at the bottom of the annual column |
|
|
|
|
|
|
|
Go to The Business expenses Tab |
|
|
|
For some of these you may already have an idea of the cost each month or year |
|
|
|
You might need to estimate some of the costs through reseach, phone enquiries etc |
|
|
|
You will notice there are 2 lines for Instructor costs |
|
We have created a worksheet to calculate the Instructor costs involved in various scenarios. |
|
You may choose to use this worksheet and the $$ amounts will feed into Business costs |
|
If you already know how much your instructors costs then you would put this on the second Instructor costs line |
|
|
|
Regarding Major assets purchase. At the time of publication November 2016 - there is provision for expensing up to $20k per asset |
|
for each asset for applicable small businesses. NB: this does not apply to Sole Traders |
|
|
|
There are spare lines so that you can add expenses where necessary |
|
|
|
INCOME CALCULATIONS |
|
|
|
This spreadsheet provides some basic calculations for each of a variety of combinations of seeing clients. |
|
Amounts have been added just so you can see what the spreadsheet looks like |
|
The first thing you may want to do is erase all the numbers at each tab, so that you can start from scratch. |
|
The annual income is generally based on 50 weeks and 25 fortnights to take into account public holidays |
|
|
|
|
|
Go to Mat classes Tab - if you are offering mat classes |
|
|
|
The 2 numbers you will add to this sheet are: |
|
|
the amount for you to charge each month per mat class member |
|
how many members you will have in your mat class membership program |
|
|
Go to Reformer classes Tab - if you are offering Reformer classes |
|
|
|
The 2 numbers you will add to this sheet are: |
|
|
the amount for you to charge each month per Reformer class member |
|
how many members you will have in your Reformer class membership program |
|
|
Go to Private and semi private Clients Tab |
|
|
|
In this spreadsheet you can play around with the number of people who you see as Private clients |
|
and as Semi private clients. |
|
You can change the amount you charge |
|
There is also provision to set up 5 packs and 10 packs of sessions. |
|
You can change the number of clients you have in each of the different categories of |
|
|
weekly sessions |
|
fortnightly sessions |
|
monthly sessions |
|
|
Go to Clorporate Clients Tab |
|
|
|
In this spreadsheet you can calculate the amount to be gained by signing up Corporate clients |
|
|
|
Go to Working in Other Studios Tab |
|
|
|
In this spreadsheet you can calculate the amount to be earned working in other studios |
|
There is room for 3 other studios |
|
|
|
Go to Instructors Costs Tab |
|
|
|
The instructions for this spreadsheet are at the tab. |
|
It's a basic calculator for the costs of employing instructors and it feeds directly back to the Business Expense Worksheet |
|
|
|
The Income Summary Tab |
|
|
|
This spreadsheet pulls together all the information from the expense and revenue tabs |
|
You can add in additonal desired profit and aslo add in any additonal income |
|
example sale of minor equipmet, drinks etc |
|
or on-line revenue from online program etc |
|
|
|
|
|
This document is prepared as a working document only and we highly recommend you consult your accountant, |
|
the ATO - or the tax office in your country - and /or legal representative before making any permanent decisions. |
|
It does not take into account your individual objectives, financial situation or needs. |
|
It should not be used, relied upon or treated as a substitute for specific or professional advice. |
|
This document falls uneder the Terms and Condions as outlined at Healthy Numbers website and can be found here: |
|
http://www.healthynumbers.com.au/terms-conditions/ |
|