In: Finance
Elias Company has prepared a budget for the first six months of
2020. Monthly budgets for revenues are provided at left. Experience
indicates that Elias will collect 75% of sales in the month of
sale, 15% in the month following the sale, and 7.5% in the second
month after the sale. The remaining 2.5% of sales are expected to
be uncollectible.
Prepare a cash collections budget
for Elias for the months of March, April, and May
2020. Show your work.
Revenues budget: | |
January | 8,537,500 |
February | 9,748,615 |
March | 10,250,324 |
April | 8,904,561 |
May | 12,358,975 |
June | 14,548,289 |
64,348,264 | |
Collections experience: | |
Month of sale | 75.0% |
Month after sale | 15.0% |
2 months after sale | 7.5% |
Uncollectible | 2.5% |
100.0% |
Please so some calculations, I'm having difficulty trying to follow just numbered answers.