Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Quarters: Budgeted Sales (Units) Q3-Y0 16,000 Q4-Y0 18,000 Q1-Y1 24,000 Q2-Y1 16,000 Q3-Y1 32,000 Q4-Y1 36,000 Q1-Y2 26,000 Q2-Y2 22,000 Sales Price: Sales Price Y0
| Quarters: | Budgeted Sales (Units) |
| Q3-Y0 | 16,000 |
| Q4-Y0 | 18,000 |
| Q1-Y1 | 24,000 |
| Q2-Y1 | 16,000 |
| Q3-Y1 | 32,000 |
| Q4-Y1 | 36,000 |
| Q1-Y2 | 26,000 |
| Q2-Y2 | 22,000 |
| Sales Price: | |
| Sales Price Y0 | $9.07 |
| Increase in Sales Price (each quarter Y1) | 1% |
| Quarter of Sale | 18% |
| 1 Quarter after Sale | 75% |
| 2 Quarters after Sale | 7% |
Using the above information how would I fill out the following chart?
| SCHEDULE OF EXPECTED CASH COLLECTIONS | ||||||||||
| Expected Collections | ||||||||||
| Sales Dollar Amount (for each qtr) | Q1-Y1 | Q2-Y1 | Q3-Y1 | Q4-Y1 | Total Cash Collections Y1 | Q1-Y2 | Q2-Y2 | |||
| Q3 -Y0 Sales | ||||||||||
| Q4 -Y0 Sales | ||||||||||
| Q1 - Y1 Sales | ||||||||||
| Q2 - Y1 Sales | ||||||||||
| Q3 - Y1 Sales | ||||||||||
| Q4 - Y1 Sales | ||||||||||
| Total | ||||||||||
| Accounts Receivable, Ending 12/31/Y1 | ||||||||||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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