Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what is the minimum cash balance based on above - begin{tabular}{|c|c|c|c|c|} hline multicolumn{5}{|l|}{ Cash Schedule } hline & October & November & December &

image text in transcribed

what is the minimum cash balance based on above -

\begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{5}{|l|}{ Cash Schedule } \\ \hline & October & November & December & Quarter \\ \hline Beginning cash balance & $20,600 & $20,285 & $20,575 & $20,600 \\ \hline Cash receipts & $315,400 & $320,300 & $328,500 & $964,200 \\ \hline Cash available & $336,000 & $340,585 & $349,075 & $984,800 \\ \hline \multicolumn{5}{|l|}{ Cash disbursements for: } \\ \hline DM purchases & $44,000 & $41,800 & $40,800 & $126,600 \\ \hline DL and MOH & $149,500 & $150,100 & $149,500 & $449,100 \\ \hline SG\&A expenses & $121,200 & $123,100 & $120,900 & $365,200 \\ \hline Purchase of long-term investments & $0 & $3,000 & $17,200 & $20,200 \\ \hline Total cash disbursements & $314,700 & $318,000 & $328,400 & $961,100 \\ \hline Cash surplus (deficieny) & $21,300 & $22,585 & $20,675 & $23,700 \\ \hline Loan balance beginning of period & $3,000 & $2,000 & $0 & $3,000 \\ \hline Loan withdrawals/ (payments) & $1,000 & $2,000 & $0 & $3,000 \\ \hline Loan balance end of period & $2,000 & $0 & $0 & $0 \\ \hline Interest payments & $15 & $10 & $0 & $25 \\ \hline Budgeted ending cash balance & $20,285 & $20,575 & $20,675 & $20,675 \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions