$3$

Exercise $9-7$ Cash Budget Analysis $[$LO$2]$

$5$

A cash budget, by quarter, is given below for a retail company $(000$ omitted$).$ The company requires a minimum cash balance of $$5,000$ to start each quarter.

points

$01$:$02$:$05$

Required:

Fill in the missing amounts in the table that follows: $($Enter your answers in thousands of dollars. Input all amounts as positive values except cash deficiency, repayments, total financing $($wherever negative$)$ which should be indicated by a minus sign.$)$

References

$\backslash$table$[[,$Quarter,Year$],[,1,2,3,4],[$Cash balance, beginning,$6,,,,],[$Add collections from customers,,,$96,,323],[$Total cash available,$71,,,,],[$Less disbursements:$],[$Purchase of inventory,$35,45,,35,],[$Selling and administrative expenses,,$30,30,,113],[$Equipment purchases,$8,8,10,,36],[$Dividends$,2,2,2,2,],[$Total disbursements,,$85,,,],[$Excess $($deficiency$)$ of cash available over disbursements,$(2),,11,,],[$Financing:$],[$Borrowings$,,15,,,],[$Repayments$*,,,,(16),],[$Total financing$],[$Cash balance, ending,,,,,$]]$