2.Based on your projected cash budget, how much funding is required to field a new Varsity team?3.Revise your cash budget (base case) to reflect an increase in registration fees. Based on these results, would you increase registration fees?4.Revise your cash budget(base case) to reflect the decision that the new Varsity team?s players must purchase their own equipment. Based on these results, would you implement this change?5.What effect does combining both of these options have on your cash budget?6.Would you recommend adding a new Varsity team to the executive members?

February Inflows Fundraising Registration Admission Concession Total Cash In Outflows Equipment Equipment Depreciation Facilities Enrollment Insurance Field Rental Referees Bus Food Apparel Interest on BL Concession Total Cash Out Surplus/Deficit Opening Cash Balance Closing Cash Balance March April May Outflows Equipment Facilities Enrollment Insurance Field Rental Referees Bus Food Apparel Interest on BL Concession Total Cash Out Surplus/Deficit Opening Cash Balance Closing Cash Balance Outflows Equipment Facilities Enrollment Insurance Field Rental Referees Bus Food Apparel Interest on BL Concession Total Cash Out Surplus/Deficit Opening Cash Balance August Total 0 0 0 0 0 0 0 0 0 0 2500 0 0 0 2500 0 0 1000 1000 2000 0 0 1000 1000 2000 0 0 0 0 0 0 0 0 0 0 0 0 0 160 0 0 0 0 0 500 900 0 0 0 160 1000 0 20400 0 300 0 0 0 0 0 160 0 0 0 0 300 0 0 0 0 0 160 0 47 0 0 300 0 0 400 400 2300 400 0 36 0 0 300 0 0 400 400 4600 400 0 49 0 0 300 0 0 0 0 2300 160 0 74 0 0 0 0 450 450 0 160 14715 2560 -2560 20860 -20860 507 1993 4286 -2286 6599 -4599 2834 -2834 0 14715 12155 -8705 -6712 -8998 14715 12155 -8705 -6712 -8998 -13597 BASE CASE -13597 -16431 May June July August 2500 14875 2000 2000 21375 0 0 20400 0 *Depreciation is non-cash* 1500 500 900 800 800 9200 1600 1000 206 900 37806 Total 0 16500 0 0 16500 0 0 0 0 0 0 0 0 0 0 2100 0 0 0 2100 0 0 1000 1000 2000 0 0 1000 1000 2000 0 0 0 0 0 2100 16500 2000 2000 22600 0 0 0 0 0 0 0 140 0 0 0 0 500 900 0 0 0 140 1000 0 17850 300 0 0 0 0 0 140 0 0 0 300 0 0 0 0 0 140 0 24 0 300 0 0 400 400 2300 350 0 15 0 300 0 0 400 400 4600 350 0 27 0 300 0 0 0 0 2300 140 0 52 0 0 0 0 450 450 0 140 16360 2540 -2540 18290 -18290 464 1636 4215 -2215 6527 -4527 2792 -2792 17850 1500 500 900 800 800 9200 1400 1000 118 900 34968 0 16360 13820 -4470 -2834 -5049 -9576 16360 13820 -4470 -2834 -5049 -9576 -12368 Players Purchase their own Equipment February March April May Inflows Fundraising Registration Admission Concession Total Cash In July 0 14875 0 0 14875 Increasing Registration Fee to $550 February March April Inflows Fundraising Registration Admission Concession Total Cash In June June July August Total 0 14875 0 0 14875 0 0 0 0 0 0 0 0 0 0 2500 0 0 0 2500 0 0 1000 1000 2000 0 0 1000 1000 2000 0 0 0 0 0 2500 14875 2000 2000 21375 0 0 0 0 0 0 0 160 0 0 0 0 500 900 0 0 0 160 1000 0 4800 300 0 0 0 0 0 160 0 0 0 300 0 0 0 0 0 160 0 47 0 300 0 0 400 400 2300 400 0 36 0 300 0 0 400 400 4600 400 0 49 0 300 0 0 0 0 2300 160 0 74 0 0 0 0 450 450 0 160 14715 2560 -2560 5260 -5260 507 1993 4286 -2286 6599 -4599 2834 -2834 4800 1500 500 900 800 800 9200 1600 1000 206 900 22206 0 14715 12155 6895 8888 6602 2003 Closing Cash Balance 14715 12155 6895 8888 6602 2003 -831 Increasing Registration Fee to $550 & Players Purchase their Own Equipment February March April May June July August Inflows Fundraising Registration Admission Concession Total Cash In Outflows Equipment Facilities Enrollment Insurance Field Rental Referees Bus Food Apparel Interest on BL Concession Total Cash Out Surplus/Deficit Opening Cash Balance Closing Cash Balance Total 0 16500 0 0 16500 0 0 0 0 0 0 0 0 0 0 2100 0 0 0 2100 0 0 1000 1000 2000 0 0 1000 1000 2000 0 0 0 0 0 2100 16500 2000 2000 22600 0 0 0 0 0 0 0 140 0 0 0 0 500 900 0 0 0 140 1000 0 4200 300 0 0 0 0 0 140 0 14 0 300 0 0 0 0 0 140 0 29 0 300 0 0 400 400 2300 350 0 0 0 300 0 0 400 400 4600 350 0 12 0 300 0 0 0 0 2300 140 0 25 0 0 0 0 450 450 0 140 16360 2540 -2540 4654 -4654 469 1631 4200 -2200 6512 -4512 2765 -2765 4200 1500 500 900 800 800 9200 1400 1000 80 900 21280 0 16360 13820 9166 10797 8597 4085 16360 13820 9166 10797 8597 4085 1320