Quarters: Budgeted Sales (Units) Q3-Y0 16,000 ...

60.1K

Verified Solution

Question

Accounting

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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students