EXERCISE 8-11 Cash Budget Analysis 08-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 $5,000 to start cach quarter. Quarter 1 2 3 Year $ 6 $? $? 57 96 323 . Lele 71 I 35 45 7 Cash balance beginning Add collections from customers Total cash available Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends Total disbursements Excess (deficiency) of cash available over disbursements Financing 2 30 30 X & 10 2 he love low 2 85 ma (2) 2 11 1119181 ? 15 - (93 (17) Borrowings Repayments (including interest) Total financing Cash balance, ending Total cash available 71 le I 4 35 45 35 ? ? 30 ? 8 8 10 ? = 2 Less disbursements: Purchase of inventory Selling and administrative expenses Equipment purchases Dividends 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 yeat. 85 224191918 ? 13 1 (17) ' la 910 Required: Fill in the missing amounts in the above table