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 $$3,000$ to start each quarter.

Required:

Fill in the missing amounts.

Note: 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$[[(000$ omitted$)],[$Year$]]],[,1,2,3,4],[$Cash balance, beginning,$$,,,,],[$Add collections from customers,,,$110,,400],[$Total cash available,$94,,,,],[$Less disbursements:$],[$Purchase of inventory,$49,59,,33,],[$Selling and administrative expenses,,$45,30,,130],[$Equipment purchases,$12,9,24,,55],[$Dividends$,2,2,2,2,],[$Total disbursements,,$115,,,],[\backslash$table$[[$Excess $($deficiency$)$ of cash available over$],[$disbursements$]],(1),,5,,],[$Financing:$],[$Borrowings$,,17,,,],[$Repayments $($including interest$)*,,,,(20),],[$Total financing$],[$Cash balance, ending$],[*$Interest will total $$1,000$ for the year.,,,,,$]]$