I need this answered by Monday at 10pm so I can hand in my work. Any & all help

Question

I need this answered by Monday at 10pm so I can hand in my work.  Any & all help is appreciated.

40 day avg collection period, maintain minimum cash balance $25 million which is also Q1 cash on hand, current receivables $182 with the following sales and cash disbursement budget:

I've completed the question in excel. 

I know that my Q4 cash balance should be $89 with a cumulative Surplus of $64 but I don't know where I'm going wrong in Q2, Q3 & Q4 calculations.  If you can help by providing the formulas in excel it would be great.

Thanks!

Explanation / Answer

Since your collection period is 40 days, the ending receivable balance should be as: Q 2 - 173.33 and Q 3 - 211.11 Please check if your calcultion gets right ?

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.