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 $$6,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 $(0$C$,00$ omitted$),,(000$ omitted$)],[,.,,2,3,4,$Year$],[$Cash balance, beginning,$$,6,,[,$T$,$t$],[$Add collections from customers,,,F$,104,,370],[$Total cash available,,$86,,,|,],[$Less disbursements:,,,,,,$],[$Purchase of inventory,,$43,53,,35,],[$Selling and administrative expenses,$7,,32,30,,118],[$Equipment purchases,,$15,8,18,,51],[$Dividends$,,2,2,2,2,],[$Total disbursements,$7,,95,,$P$,],[$Excess $($deficiency$)$ of cash available over disbursements,,$(8),,11,,],[$Financing:$,,,,,,],[$Borrowings$,,,9,,$F$,1],[$Repayments $($including interest$)*,,,,,(19),],[$Total financing,,,$P,,$r$,$t$],[$Cash balance, ending,,,,,$1,],[*$Interest will total $$1,000$ for the year.,,,,,,$]]$