Answered step by step
Verified Expert Solution
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 &
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
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