Question: A cash budget, by quarters, is given below for a retail company ( 0 0 0 omitted ) . The company requires a minimum cash

A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of \(\$ 8,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.
\begin{tabular}{|c|c|c|c|c|c|}
\hline & \multicolumn{4}{|c|}{Quarter (000 omitted)} & \multirow[t]{2}{*}{\begin{tabular}{l}
(000 omitted)\\
Year
\end{tabular}}\\
\hline & 1 & 2 & 3 & 4 & \\
\hline Cash balance, beginning & \$ 6 & \$ 8 & \$ 8 & \$ 8 & \$ 6\\
\hline Add collections from customers & 73 & & 120 & & 415\\
\hline Total cash available & 79 & & 128 & & \\
\hline Less disbursements: & & & & & \\
\hline Purchase of inventory & 55 & 65 & & 31 & \\
\hline Selling and administrative expenses & & 45 & 30 & & 119\\
\hline Equipment purchases & 13 & 9 & 30 & & 62\\
\hline Dividends & 2 & 2 & 2 & 2 & \\
\hline Total disbursements & & 121 & & & \\
\hline Excess (deficiency) of cash available over disbursements & (11) & & 11 & & \\
\hline Financing: & & & & & \\
\hline Borrowings & & 11 & & & \\
\hline Repayments (including interest)* & & & & (28) & \\
\hline Total financing & & & & & \\
\hline Cash balance, ending & & & & & \\
\hline *Interest will total \(\$ 1,000\) for the year. & & & & & \\
\hline
\end{tabular}
A cash budget, by quarters, is given below for a

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!