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 $$10,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,$$,7,,,,],[$Add collections from customers,,,,$113,,391],[$Total cash available,,$72,,,,],[$Less disbursements:$],[$Purchase of inventory,,$52,62,,28,],[$Selling and administrative expenses,,,$45,30,,106],[$Equipment purchases,,$15,9,27,,61],[$Dividends$,,2,2,2,2,],[$Total disbursements,,,$118,,,],[$Excess $($deficiency$)$ of cash available over disbursements,,$(7),,11,,],[$Financing:$],[$Borrowings$,,,14,,,],[$Repayments $($including interest$)*,-,,,,(31),],[$Total financing$],[$Cash balance, ending,,,,,,$],[$Interest will total $$1,000$ for the year.,,,,,,$]]$