D G H Year 2 Year 3 $ 275,000 111,300 5,350 391,650 395,000 126,000 6,140 527,140 $ 1 Better You Fitness Center 2 Profit and Loss Statement 3 4 Year 1 5 Income 6 Memberships $ 100,000 $ 7 Clothing Merchandise 85,000 8 Other 4,250 9 Total Income $ 189,250 $ 10 Expenses 11 Cost of Sales $ 75,000 $ 12 Payroll 75,000 13 Advertising 15,270 14 Education & Training 10,000 15 Insurance 15,000 16 Rent 25,000 17 Repairs & Maintenance 5,000 18 Utilities 12,000 19 Supplies 3,000 20 Total Operating Expenses $ $ 235,270 21 $ $ Net Operating Profit (46,020) 22 23 24 25 26 27 28 29 30 31 32 Income Balance Membership Summary 92,500 180,000 17,163 12,000 15,000 25,000 10,000 13,200 3,200 368,063 23,587 $ 65,000 250,000 15,879 10,000 15,000 25,000 3,000 14,520 3,800 $ 402,199 $ 124,941 RI Search Prajapati Exp 19.Excel Ch63 Cap Gym Protected Vie - Excel File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Erabile Editing D E F H Year 2 Year 3 $ 147,907 65.667 8,000 55,000 276,574 260,409 74,340 9,000 60,000 403,749 $ $ A1 f Better You Fitness Center 1 Better You Fitness Center 2 Balance Sheet 3 4 Year 1 5 Assets 6 Bank Account $ 81,696 $ Accounts Receivable 41,300 8 Gym Equipment 15,095 9 Merchandise Inventory 40,000 10 Total Assets $ 178,091 $ 11 Liabilities 12 Accounts Payable $ 18,134 $ 13 Current Loans Due 26.000 14 Long Term Equipment Loan 174,000 15 Total Liabilities $ 218,134 $ 16 Retained Earnings (40,043) 17 Net Worth $ 178,091 $ 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Income Summary Balance Membership 16,244 26,000 148,000 190,244 86,330 276,574 $ 18,213 26,000 122,000 166,213 237,536 403,749 $ Search VIEW PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit ale to stay in Protected View Help Tell me what you want to do A1 Enable Editing fo Better You Fitness Center A B 1 E H C Better You Fitness Center Year 3 Daily Attendance Trends 2 3 4 5 6 Friday 30 120 100 8 9 10 11 12 13 14 15 Monday 50 125 100 90 75 62 125 125 75 4am - 6am 6am - Bam Bam - 10am 10am-12pm 12pm - 2pm 2pm - 4pm 4pm - 6pm 6pm - 8pm 8pm - 10pm Weekday Tuesday Wednesday 50 45 100 85 100 110 100 100 65 70 50 55 140 150 150 105 20 40 Thursday 40 110 90 90 50 50 85 150 30 100 Better You Fitness Center 3-Year Membership Totals Year 1 Year 2 250 560 250 560 255 560 275 575 275 575 260 575 250 585 275 750 275 750 325 765 500 925 550 930 Mar Apr May Jun Jul Aug Sep Oct Dec Jan Feb Year: 935 948 960 990 990 990 1,025 1,025 1,050 1,100 25 35 35 20 20 16 17 18 19 20 21 22 23 24 25 6am - Bam 8am - 10am 10am-12pm 12pm-2pm 2pm - 4pm Saturday 100 125 75 50 25 Weekend Sunday 90 100 75 25 25 26 27 28 29 30 Membership Summary Income Balanke Search 20 A1 Unless you need to edit, it's safe to stay in Protected View Enable Editing B 1 F G H 2 3 N 0 P 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Balance Membership Income Summary BI O Search thp D G H Year 2 Year 3 $ 275,000 111,300 5,350 391,650 395,000 126,000 6,140 527,140 $ 1 Better You Fitness Center 2 Profit and Loss Statement 3 4 Year 1 5 Income 6 Memberships $ 100,000 $ 7 Clothing Merchandise 85,000 8 Other 4,250 9 Total Income $ 189,250 $ 10 Expenses 11 Cost of Sales $ 75,000 $ 12 Payroll 75,000 13 Advertising 15,270 14 Education & Training 10,000 15 Insurance 15,000 16 Rent 25,000 17 Repairs & Maintenance 5,000 18 Utilities 12,000 19 Supplies 3,000 20 Total Operating Expenses $ $ 235,270 21 $ $ Net Operating Profit (46,020) 22 23 24 25 26 27 28 29 30 31 32 Income Balance Membership Summary 92,500 180,000 17,163 12,000 15,000 25,000 10,000 13,200 3,200 368,063 23,587 $ 65,000 250,000 15,879 10,000 15,000 25,000 3,000 14,520 3,800 $ 402,199 $ 124,941 RI Search Prajapati Exp 19.Excel Ch63 Cap Gym Protected Vie - Excel File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View Erabile Editing D E F H Year 2 Year 3 $ 147,907 65.667 8,000 55,000 276,574 260,409 74,340 9,000 60,000 403,749 $ $ A1 f Better You Fitness Center 1 Better You Fitness Center 2 Balance Sheet 3 4 Year 1 5 Assets 6 Bank Account $ 81,696 $ Accounts Receivable 41,300 8 Gym Equipment 15,095 9 Merchandise Inventory 40,000 10 Total Assets $ 178,091 $ 11 Liabilities 12 Accounts Payable $ 18,134 $ 13 Current Loans Due 26.000 14 Long Term Equipment Loan 174,000 15 Total Liabilities $ 218,134 $ 16 Retained Earnings (40,043) 17 Net Worth $ 178,091 $ 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Income Summary Balance Membership 16,244 26,000 148,000 190,244 86,330 276,574 $ 18,213 26,000 122,000 166,213 237,536 403,749 $ Search VIEW PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit ale to stay in Protected View Help Tell me what you want to do A1 Enable Editing fo Better You Fitness Center A B 1 E H C Better You Fitness Center Year 3 Daily Attendance Trends 2 3 4 5 6 Friday 30 120 100 8 9 10 11 12 13 14 15 Monday 50 125 100 90 75 62 125 125 75 4am - 6am 6am - Bam Bam - 10am 10am-12pm 12pm - 2pm 2pm - 4pm 4pm - 6pm 6pm - 8pm 8pm - 10pm Weekday Tuesday Wednesday 50 45 100 85 100 110 100 100 65 70 50 55 140 150 150 105 20 40 Thursday 40 110 90 90 50 50 85 150 30 100 Better You Fitness Center 3-Year Membership Totals Year 1 Year 2 250 560 250 560 255 560 275 575 275 575 260 575 250 585 275 750 275 750 325 765 500 925 550 930 Mar Apr May Jun Jul Aug Sep Oct Dec Jan Feb Year: 935 948 960 990 990 990 1,025 1,025 1,050 1,100 25 35 35 20 20 16 17 18 19 20 21 22 23 24 25 6am - Bam 8am - 10am 10am-12pm 12pm-2pm 2pm - 4pm Saturday 100 125 75 50 25 Weekend Sunday 90 100 75 25 25 26 27 28 29 30 Membership Summary Income Balanke Search 20 A1 Unless you need to edit, it's safe to stay in Protected View Enable Editing B 1 F G H 2 3 N 0 P 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 Balance Membership Income Summary BI O Search thp