Cash Budget Analysis

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.) (000 omitted) Year 1 4 $ Quarter (000 omitted) 2 3 91 $ 10 $ 10 111 80 $ 10 [ 389 50 60 34 30 9 13 2 2 5 2 21 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 Borrowings Repayments including interest) * Total financing Cash balance, ending *Interest will total $1,000 for the year. 2 116 (30)