(Cash budget) The accountant for Georgia Pizza prepared the following cash budget for the third quarter of 2000. When the owner was reviewing it, he was eating a deep-dish pizza loaded with extra cheese. Some of the topping inadvertently spilled onto the page and smeared the figures. Complete the missing numbers on the cash budget, assuming that the accountant has projected a minimum cash balance at the start of each month of $2,500. All borrowings, repayments, and investments are made in even $500 amounts.

Transcribed Image Text:

July August September Total Beginning cash balance Cash receipts Total cash available Cash disbursements: Payments on account Wages expense Overhead costs Total disbursements Cash excess (deficiency) $ 4,500 8,200 $ ? $ ? 10,100 $13,000 $ ? ? $ ? ? $19,500 $39,400 69 ? $ 3,900 $ 5,700 $ ? 5,000 4,000 6,100 17,200 4,600 13,000 $10,300 $ 60/69 $16,200 $ $ $ 60/60 Minimum cash balance (2,500) (2,500) ? ? Cash available (needed) $ $ (4,100) $ ? $ (4,200) Financing: Borrowings (repayments) Acquire (sell) investments Receive (pay) interest $ 500 69 $ 0 0 Ending cash balance 2005 $ (500) $ ? ? $ 2,900 $ $ 2 ? (50) $ 2,750 ??