Filetype Excel XLSX | Posted on 14 Aug 2022 | 4 years ago
Authentication
digital resources
336x Filetype XLSX File size 0.04 MB Source: s3-ap-southeast-2.amazonaws.com
Sheet 1: Instructions
| 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/ |
| Build a Pilates Business Budget | |||
| Income Summary | |||
| Based on the total of: | |||
| Lifestyle Budget, from spreadsheet | $55,000 | ||
| Business Expenses, from spreadsheet | $66,940 | ||
| Additional Desired Profit: you enter this amount | $1,000 | ||
| This is how much Income the business needs to generate | $122,940 | ||
| This Income will be made up of the following: | |||
| Mat Classes | $24,000 | ||
| Refeormer Classes | $10,200 | ||
| One on one sessions Private Clients | $110,625 | ||
| Sessions with Semi Private Clients | $119,618 | ||
| Income from Corporate Clients | $23,760 | ||
| Income from working in other studios | $47,675 | ||
| other forms of income; you enter this amount | $1,000 | ||
| Total Income to be generated for Viable Pilates Business | $336,878 | ||
| Profit and Loss | |||
| Revenue | $336,878 | ||
| less Expenses | $66,940 | ||
| Gross profit | $269,938 | ||
| less Lifestyle Budget | $55,000 | ||
| Profit or a Loss, before tax | $214,938 | Is the business viable? | |
| NB: This profit, or loss, amount is before taxes. Please consult your accountant or the ATO, | |||
| or the tax office in your country to establish the tax implications for you in relation | |||
| to this amount of profit, or loss |
| Build a Pilates Business Budget | |||
| Personal Lifestyle Budget | |||
| Weekly | Monthly | Annually | |
| House and related | |||
| Rent | |||
| Mortgage | |||
| Council Rates | |||
| Gas | |||
| Electricity | |||
| Water | |||
| Telephone | |||
| Internet | |||
| Netflicks, Stan etc | |||
| House Insurance | |||
| Contents Insurance | |||
| Cleaner | |||
| Gardener | |||
| Car | |||
| Paymets | |||
| Petrol | |||
| Insurance | |||
| Registration | |||
| Parking | |||
| Tolls | |||
| Repairs & maintenance/ tyres | |||
| Food and Beverage | |||
| Groceries | |||
| Wine/ alcohol | |||
| Eating out | |||
| Activities | |||
| Entertainment | |||
| Gym, sports | |||
| Gifts for birthdays and Christmas | |||
| Gadgets, electronics | |||
| Subscriptions | |||
| Holidays | |||
| Hobbies | |||
| Personal Maintenance | |||
| Hairdresser | |||
| Nails | |||
| Face, eyebrows | |||
| Makeup and creams | |||
| Dentist | |||
| Medical | |||
| Prescriptions | |||
| Optomotrist and glasses | |||
| Massages | |||
| Pets | |||
| Food | |||
| Vet: vacinations | |||
| Beauty treatments | |||
| Insurance | |||
| Insurace | |||
| Medical | |||
| Life | |||
| Income protection | |||
| Debt | |||
| Credit card | |||
| Personal Loans | |||
| Overdraft | |||
| Child support | |||
| $55,000 | |||
| Children | |||
| School fees | |||
| Uniforms and books | |||
| Gadgets | |||
| Pocket Money | |||
| Birthday gifts for other children | |||
| Shoes and clothes | |||
| Sport classes and sporst equipment | |||
| Extra activities | |||
| Tuck shop | |||
| Dentist visits | |||
| Medicine and medical | |||
| Total | $0 | $0 | $55,000 |
| Grand Total | $55,000 |
no reviews yet
Please Login to review.
