Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of $3,000 to start
A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of $3,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{2}{*}{\begin{tabular}{c} (000 omitted) \\ Year \end{tabular}} \\ \hline & 1 & 2 & 3 & 4 & \\ \hline Cash balance, beginning & $ & & & & \\ \hline Add collections from customers & & & 124 & & 431 \\ \hline Total cash available & 97 & & & & \\ \hline \multicolumn{6}{|l|}{ Less disbursements: } \\ \hline Purchase of inventory & 54 & 64 & & 30 & \\ \hline Selling and administrative expenses & & 45 & 30 & & 137 \\ \hline Equipment purchases & 7 & 9 & 29 & & 55 \\ \hline Dividends & 2 & 2 & 2 & 2 & \\ \hline Total disbursements & & 120 & & & \\ \hline Excess (deficiency) of cash available over disbursements & (5) & & 12 & & \\ \hline \multicolumn{6}{|l|}{ Financing: } \\ \hline Borrowings & & 12 & & & \\ \hline Repayments (including interest)* & & & & (12) & \\ \hline \multicolumn{6}{|l|}{ Total financing } \\ \hline Cash balance, ending & & & & & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started