Exercise $8-11($Algo$)$ Cash Budget Analysis $[$LO$8-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 $$4,000$ to start each quarter.

Required:

Fill in the missing amounts. $($Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.$)$

$\backslash$table$[[,$Quarter $(000$ omitted$),\backslash$table$[[$ omitted$)],[$Year$]]],[,1,2,3,4],[$Cash balance, beginning,$$,4,,,],[$Add collections from customers,,,$109,,392],[$Total cash available,$89,,-,,],[\backslash$table$[[$Total cash available$],[$Less disbursements:$]]],[$Purchase of inventory,$48,58,,32,],[$Selling and administrative expenses,,$45,30,,127],[$Equipment purchases,$11,9,23,,53],[$Dividends$,2,2,2,2,],[$Total disbursements,,$114,,,],[$Excess $($deficiency$)$ of cash available over disbursements,$(2),,7,,],[\backslash$table$[[$Excess $($deficiency$)$ of cash available over disbursements$],[$Financing:$]]],[$Borrowings$,,18,,,],[$Repayments $($including interest$)*,,,,(22),],[\backslash$table$[[$Repayments $($including interest$)],[$Total financing$]]],[$Cash balance, ending ff$,,,,,]]$