Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

20XX Projected Budget - Sydney Centre bounce fitness Jul Actual Nov Actual Dec Actual Jan Actual Feb Actual Mar Actual Apr Beginning Cash Balance

image text in transcribed

20XX Projected Budget - Sydney Centre bounce fitness Jul Actual Nov Actual Dec Actual Jan Actual Feb Actual Mar Actual Apr Beginning Cash Balance Cash Inflows (Income) 15,220 June Actual Total Total Budget Actual Actual Aug Actual Sep Actual Oct Actual May Actual 15220 $20,130 $45,270 $23,540 $64,320 $30,200 $92,370 $29,900 $117,420 $37,005 $149,470 $27,085 $171,520 $36,420 $209,670 $44,590 $240,320 $52,655 $271,970 $57,690 $299,620 $71,155 $330,770 $70,172 $379,420 Casual Attendance Memberships Equip & Clothing Sales 21,000 33000 19,500 25000 20,000 30000 30,000 35000 33,000 35000 38,000 40000 5,000 10000 2,500 7500 4,000 4,220 8000 3,500 18,000 30000 18,500 30000 10,000 30000 30,000 30000 17,500 30000 18,500 30000 20,000 20000 25,000 25000 21,847 30000 239,847 343,000 32,500 35000 35,000 40000 32,500 35000 34,000 50000 36,000 40000 33,500 40000 34,150 40000 36,360 40000 31,500 41000 406,510 471,000 6000 3,800 5,200 10000 2,210 4000 4,150 4000 5,000 11,470 5000 2,500 15000 53,550 82,500 0 0 Other: 0 Total Cash Inflows Available Cash Balance $56,000 $78,000 $55,000 $67,500 $62,000 $76,000 $54,300 $72,000 $57,720 $78,000 $47,700 $75,000 $66,210 $81,000 $57,000 $74,000 $56,150 $74,000 $59,150 $65,000 $72,830 $70,000 $55,847 $86,000 $699,907 $896,500 $71,220 $93,220 $75,130 $112,770 $85,540 $140,320 $84,500 $164,370 $87,620 $195,420 $84,705 $224,470 $93,295 $252,520 $93,420 $283,670 $100,740 $314,320 $111,805 $336,970 $130,520 $369,620 $127,002 $416,770 $770,079 $1,275,920 Cash Outflows (Expenses) Advertising 13,000 14000 13,000 14000 13,000 14000 13,000 12000 12,000 12000 10,000 10000 15,000 10000 12,000 10000 12,000 10000 13,000 10000 15,000 10000 15,000 10000 156,000 136,000 Bank Service Charges 840 500 840 500 840 500 850 500 840 500 845 500 850 500 855 500 835 500 840 500 840 500 830 500 10,105 6,000 Credit Card Fees 250 500 250 500 250 500 250 500 275 500 275 500 275 500 225 500 250 500 275 500 275 500 250 500 3,100 6,000 Insurances 1,200 2000 1,200 2000 1,200 2000 1,200 2000 1,200 2000 1,200 1000 1,200 1000 1,200 1000 1,200 1000 1,200 1000 1,200 1000 1,200 1000 14,400 17,000 Miscellaneous 50 100 50 100 50 100 50 100 50 100 50 100 50 0 50 0 50 0 50 0 50 0 50 0 600 600 Head Office Contribution 2,000 2500 2,000 2500 2,000 2500 2,000 2500 2,000 2500 2,000 2500 2500 Payroll 22,000 20000 22,000 20000 25,000 20000 25,000 20000 22,500 20000 22,500 30000 Team Building 1,000 1,000 500 1,000 500 1,000 Professional Fees 750 500 500 2,000 500 750 500 1000 1,000 500 10,000 500 1,000 500 1,000 2,000 25,000 15000 20,000 20000 20,000 500 1,000 2,000 2500 2,000 2500 2,000 2500 2,000 2500 2,000 2500 24,000 30,000 20000 25,000 15000 27,500 15000 25,000 15000 281,500 230,000 500 1,000 500 1,000 500 1,000 750 500 750 500 1,000 5000 1,000 500 750 500 750 Rent or Lease 4,500 3000 4,500 3000 4,500 3000 4,500 3000 4,500 3000 4,500 3000 4,500 3000 4,500 3000 4,500 3000 4,500 500 1,000 2000 3000 4,500 1,000 3000 4,500 Subscriptions & Dues 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 500 21,000 6,000 500 11,250 12,500 3000 54,000 36,000 3,000 3,000 Supplies 2,000 1000 2,500 1500 2,000 1000 2,500 1500 2,000 1000 2,000 1500 2,500 2000 2,500 2000 2,000 1000 2,000 1000 2,500 1000 2,500 1000 27,000 15,500 Taxes & Licences 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 2,400 2,400 Utilities & Telephone 1,500 1000 1,500 1000 1,500 1000 1,500 1000 1,500 1000 1,500 1000 1,500 1000 1,500 1000 1,500 1000 1,500 1000 1,500 1000 1,500 1000 18,000 12,000 Equipment Leases 1,050 900 1,050 900 1,050 900 1,050 900 1,050 900 1,050 900 1,050 900 1,050 900 1,050 900 1,050 900 1,050 900 1,050 900 12,600 10,800 Maintenance 500 1000 500 1000 500 1000 500 1000 500 1,000 500 500 500 500 500 500 500 500 500 500 500 500 500 500 6,000 8,500 Total Cash Outflows Ending Cash Balance $51,090 $47,950 $51,590 $48,450 $55,340 $47,950 $54,600 $46,950 $50,615 $45,950 $57,620 $52,950 $56,875 $42,850 $48,830 $43,350 $48,085 $42,350 $54,115 $37,350 $59,365 $38,850 $56,830 $37,350 $644,955 $532,300 $20,130 $45,270 $23,540 $64,320 $30,200 $92,370 $29,900 $117,420 $37,005 $149,470 $27,085 $171,520 $36,420 $209,670 $44,590 $240,320 $52,655 $271,970 $57,690 $299,620 $71,155 $330,770 $70,172 $379,420 $125,124 $743,620

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Venture capital and the finance of innovation

Authors: Andrew Metrick

2nd Edition

9781118137888, 470454709, 1118137884, 978-0470454701

More Books

Students also viewed these Finance questions

Question

What is self-awareness? (p. 44)

Answered: 1 week ago