Exercise 8-11 (Algo) Cash Budget Analysis (LO8-8] A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $10,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) X Answer is complete but not entirely correct. Quarter (000 omitted) (000 omitted) Year 1 2 3 4 Cash balance, beginning $ 7 $ 10$ 10$ 7 10$ 109 Add collections from customers 65 104 113 391 Total cash available 72 114 123 129 X 438 X Less disbursements: 52 62 53 28 195 Purchase of inventory Selling and administrative expenses 10 45 30 21 106 15 9 27 10 61 Equipment purchases Dividends 2 2 2 2 2 X 79 118 112 61 370 (7) (4) 11 68 X 68 X 17 14 11 X 0 (8) Total disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments (including interest) * Total financing Cash balance, ending *Interest will total $1,000 for the year. 0 0 0 X (31) 31 17 14 (1) 31 x (27) $ 10$ 10 $ 10$ 37 $ 37