Answered step by step
Verified Expert Solution
Question
1 Approved Answer
20XX Projected Budget - Sydney Centre bounce fitness Jul Actual Aug Actual Sep Actual Oct Actual Actual Dec Actual Jan Actual Feb Actual Mar
20XX Projected Budget - Sydney Centre bounce fitness Jul Actual Aug Actual Sep Actual Oct Actual Actual Dec Actual Jan Actual Feb Actual Mar Actual Apr Actual May Actual June Actual Total Total Budget Actual Beginning Cash Balance 15,220 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 Cash Inflows (Income) Casual Attendance Memberships Equip & Clothing Sales Other: 21,000 33000 19,500 25000 20,000 30000 18,000 30,000 35000 33,000 35000 38,000 40000 32,500 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 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 5,000 10000 2,500 7500 4,000 6000 3,800 7000 4,220 8000 5,200 10000 2,210 1000 3,500 4000 4,150 4000 5,000 5000 11,470 5000 2,500 15000 53,550 82,500 0 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 50 0 50 0 600 600 Head Office Contribution 2,000 2500 2,000 2500 Payroll 22,000 20000 22,000 20000 2,000 2500 25,000 2,000 2500 2,000 2500 2,000 2500 2,000 2500 2,000 2500 2,000 2500 2,000 2500 2,000 2500 2,000 2500 24,000 30,000 20000 25,000 20000 22,500 20000 22,500 30000 25,000 15000 Team Building 1,000 500 1,000 500 1,000 500 1,000 500 1,000 500 10,000 500 1,000 500 1,000 500 20,000 20000 20,000 20000 25,000 500 1,000 15000 27,500 15000 25,000 15000 281,500 230,000 1,000 500 1,000 500 1,000 Professional Fees 750 500 750 500 2,000 500 750 1000 750 500 750 500 1,000 5000 1,000 500 500 750 500 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 3000 1,000 2000 4,500 1,000 500 21,000 6,000 500 11,250 12,500 3000 4,500 3000 54,000 36,000 Subscriptions & Dues 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 250 3,000 3,000 Supplies 2,000 Taxes & Licences 200 200 1000 2,500 1500 200 2,000 1000 2,500 1500 2,000 1000 2,000 1500 2,500 2000 2,500 2000 2,000 1000 2,000 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 200 1000 2,500 200 1000 2,500 1000 27,000 15,500 200 200 200 Utilities & Telephone 1,500 1000 1,500 1000 Equipment Leases 1,050 900 1,050 900 1,500 1,050 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 200 2,400 2,400 1000 18,000 12,000 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Venture capital and the finance of innovation
Authors: Andrew Metrick
2nd Edition
9781118137888, 470454709, 1118137884, 978-0470454701
