Please solve in Excel and show workings.

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 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.) Quarter 1 Quarter 2 Quarter 3 Quarter 4 (000 omitted) (000 omitted) (000 omitted) (000 omitted) $ 6 Year (000 omitted) Cash balance, beginning 96 323 Add collections from customers Total cash available 71 Less disbursements: 35 45 35 Purchase of inventory 30 30 113 Selling and administrative expenses Equipment purchases 8 8. 10 36 2 2 2. 2 Dividends 85 (2) 11 15 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. (17)