hello can you please do this in excel I need help on it thank you

The ABC Corporation has the following estimated quarterly sales for next year. 02 $8,600 el $8,100 Q3 $9,500 Sales $11,200 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