$$

$$

$$

Quarter $(000$

omitted$)$

$$

$$

$1$

$2$

$3$

$4$

Year

Cash balance, beginning

$$8$

$$

$$

$$

$$

Add collections from

customers

$$

$$

$120$

$$

$420$

Total

cash available

$92$

$$

$123$

$$

$428$

Less

disbursements:

$$

$$

$$

$$

$$

Purchase

of inventory

$53$

$63$

$$

$29$

$$

Selling

and administrative expenses

$$

$45$

$30$

$$

$127$

Equipment

purchases

$8$

$9$

$28$

$$

$55$

Dividends

$2$

$2$

$2$

$2$

$$

Total

disbursements

$$

$119$

$$

$$

$$

Excess $($deficiency$)$ of cash

available over disbursements

$(1)$

$$

$9$

$$

$$

Financing:

$$

$$

$$

$$

$$

Borrowings

$$

$13$

$$

$$

$$

Repayments $($including interest$)$

$*$

$$

$$

$$

$(12)$

$$

Total financing

$$

$$

$$

$$

$$

Cash balance, ending

$$

$$

$$

$$

$$

$*$Interest

will total $$1,000$ for the year. A cash budget, by quarters, is given below for a retail company $(000$ omitted$).$ The company requires a minimum cash balance of $\backslash (\backslash$$ $3,000\backslash )$ 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$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline & $\backslash$multicolumn$\{4\}\{|$c$|\}\{$Quarter $(000$ omitted$)\}$ & $(000$ omitted$)\backslash \backslash$

$\backslash$hline & $1$ & $2$ & $3$ & $4$ & Year $\backslash \backslash$

$\backslash$hline Cash balance, beginning & $\backslash$$ $8$ & & & & $\backslash \backslash$

$\backslash$hline Add collections from customers & & & $110$ & & $400\backslash \backslash$

$\backslash$hline Total cash available & $94$ & & & & $\backslash \backslash$

$\backslash$hline Less disbursements: & & & & & $\backslash \backslash$

$\backslash$hline Purchase of inventory & $49$ & $59$ & & $33$ & $\backslash \backslash$

$\backslash$hline Selling and administrative expenses & & $45$ & $30$ & & $130\backslash \backslash$

$\backslash$hline Equipment purchases & $12$ & $9$ & $24$ & & $55\backslash \backslash$

$\backslash$hline Dividends & $2$ & $2$ & $2$ & $2$ & $\backslash \backslash$

$\backslash$hline Total disbursements & & $115$ & & & $\backslash \backslash$

$\backslash$hline Excess $($deficiency$)$ of cash available over disbursements & $(1)$ & & $5$ & & $\backslash \backslash$

$\backslash$hline Financing: & & & & & $\backslash \backslash$

$\backslash$hline Borrowings & & $17$ & & & $\backslash \backslash$

$\backslash$hline Repayments $($including interest$)*$ & & & & $(20)$ & $\backslash \backslash$

$\backslash$hline Total financing & & & & & $\backslash \backslash$

$\backslash$hline Cash balance, ending & & & & & $\backslash \backslash$

$\backslash$hline $*$Interest will total $\backslash (\backslash$$ $1,000\backslash )$ for the year. & & & & & $\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$