*** Please show to solve in excel with formulas****

The ABC Corporation has the following estimated quarterly sales for next year.

	Q1	Q2	Q3	Q4
Sales	8100	8600	9500	11200

The average collection period is 30 days. Purchases are equal to 64 percent of the following quarter's sales. Suppliers are normally paid in 60 days.

Determine the a. Cash received from customers in Quarter 2

b. Ending Accounts Receivables Balance in Quarter 2

c. Cash paid to suppliers in Quarter 2

d. Ending Accounts Payable Balance in Quarter 2

e. Cash received from customers in Quarter 3

f. Ending Accounts Receivables Balance in Quarter 3

g. Cash paid to suppliers in Quarter 3

h. Ending Accounts Payable Balance in Quarter 3