ak 3-20 804 8.00 OT 01. EXCEL ALGO 02 Personal Budget *the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September October, November, and December The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget: Cash balance, September 1 (from a summer sob) 59,250 Purchase set football tickets in September 160 Additional entertainment for each months 250 Pay fall semester tuition in September 4,800 Payment at the beginning of each month 600 Pay for food each month 550 Pay apartment deposit on September 2(to be returned December 15) 600 Part-time job earnings each month (net of taxes) 1,200 02 EXCEL ALGO 09 08.EXCEL ALGO 028 . Prepare a cash budget for September October November, and December. Use the minus sign to indicate cash outflows, a decrease in cash or cash sement Craig Kovar Cash Budget For the Four Months Ending December 31 September October November December Esmashes from 1.200 on 3 at 12.20 >-20 1804 Show Me How Craig Kovar Cash Budget For the Four Months Ending December 31 September October Estimated cash receipts from Part-time job November December 18.05 CI 1.2005 60 DT EXCEL ALGO 10 100 10 1.0 10,00 02 EXCEL ALGO Total cash receipts Less estimated cash payments for Season football tickets Additional entertainment Tuition - 10X 09 25 x 390 X 250 X 250 x 4.400 x OG EXCEL ALGO Rent X 400 x 600 x Onesti 028 350 x 50 X 550 X 950 X X X 1,400 X 1.400 X 1,100X Total payments Chinese (decrease) Lash balance at beginning of month 1 x 200 x 200 X 400 floatir x 29 34 S Il Change sted of month 3200 3,090 490