Donald Company Has the Following Information Donald Company Wants to Keep a Minimum Cash Balance of May

Essay

Donald Company has the following information:
$\begin{array}{ll}\text { Cash Balance, May } 31&\$45,000\\\text { Dividends paid in June } & 12,000 \\\text { Cash paid for operating expenses in June } & 36,800 \\\text { Equipment depreciation expense in June } & 4,500\\\text { Patent amortization expense in June } & 2,000 \\\text { Cash collections on sales in June } & 99,000 \\\text { Merchandise purchases paid in June } & 56,200 \\\text { Purchase equipment for cash in June } & 17,500\end{array}$
Donald Company wants to keep a minimum cash balance of $10,000.Assume that borrowing occurs at the beginning of the month and repayments occur at the end of the month.Interest of 1% is paid in cash at the end of each month when debt is outstanding.Borrowing and repayments are carried out in multiples of $1,000.
Required:
Prepare a cash budget for June.