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