This assessment will require you to review the Bounce Fitness Operating Statement of Aug & Sept 2021 (2 months comparison in one spreadsheet).
Download the Operating Statement here:
Operating-statement-AUG & SEPT 2021
You are to perform a financial analysis basedon the information provided in the Operating Statement of Aug & Sep 2021 and answer the questions provided in the following template:
BSBFIN501 Task 4 Financial Analysis Report Template
· Completed Financial Analysis Report Template
Profit & Loss Sheet1 Bounce FitnessBounce Fitness 17B Evergreen Avenue17B Evergreen Avenue Cairns 4870Cairns 4870 Operating StatementOperating Statement August 2021September 2021 BudgetedBudgeted IncomeIncome Membership Fees$17,523.64Membership Fees$18,403.63 Clothing Sales$540.91Clothing Sales$395.45 10 Session cards$4,218.1810 Session cards$9,227.28 Casual attendance fees$776.36Casual attendance fees$534.55 PT sessions$14,018.18PT sessions$19,607.27 Hi Protein Shakes$500.00Hi Protein Shakes$950.00 Hi Protein Snacks$450.00Hi Protein Snacks$675.00 Promotion 12W Fitness Challenge$12,409.10Total Income$49,793.18 Total Income$50,436.37 Cost of Sales Cost of SalesCost of Sales - Clothing$1,136.36 Hi Protein brand items$3,019.96 Gross Profit$50,436.37Total Cost of Sales$4,156.32 ExpensesGross Profit$45,636.86 General & Administrative Exp Phone and Internet$113.64Expenses Total General & Administrative Exp$113.64General & Administrative Exp Advertising$5,318.19Phone and Internet$113.64 Operating ExpensesTotal General & Administrative Exp$113.64 Lease of Gym Machines$23,000.00Operating Expenses Professional Fees$86.36Lease of Gym Machines$23,000.00 Supplies for members$23.00Professional Fees$86.36 Total Operating Expenses$23,109.36Supplies for members$23.00 Employment ExpensesTotal Operating Expenses$23,109.36 Wages & Salaries$21,675.64Employment Expenses Other Employer Expenses$1,950.81Wages & Salaries$21,075.64 Total Employment Expenses$23,626.45Other Employer Expenses$1,896.81 Occupancy CostsTotal Employment Expenses$22,972.45 Rent$1,000.00Occupancy Costs Water$260.32Rent$1,000.00 Total Occupancy Costs$1,260.32Water$260.32 Total Expenses$53,427.96Total Occupancy Costs$1,260.32 Total Expenses$47,455.77 Operating Profit($2,991.59) Operating Profit($1,818.91) Other Income Other Income Other Expenses Other Expenses Net Profit / (Loss)($2,991.59) Net Profit / (Loss)($1,818.91) &8&D&8MYOB / Excel&8&T FINANCIAL ANALYSIS REPORT – BSBFIN501 – Task 4 BSBFIN501 Task 4 FINANCIAL ANALYIS Using the supplied report called ‘Operating Statement AUG & SEPT 2021’ - analyse the figures and answer the following questions IN DETAIL. Questions Operating Statement AUG & SEPT 2021 1) Perform an overall analysis of the 2 months. What areas of INCOME clearly altered over that time period? 2) What areas of EXPENSES clearly altered over that time period? 3) What COSTS have occurred in August that did not appear in September? 4) Explain WHY the salaries have decreased in September when the PT sessions increased? What managerial decision may have affected this? 5) Is operating at this level VIABLE? Consider the net profit and (loss) in your answer. 1 BSBFIN501 – Financial Analysis Template Capital College RTO: 41593 | CRICOS: 03537J | CAN: 606 797 611 | ABN: 16 606 797