put in excel formula for each square please

The Morning Jolt Coffee Company has projected the following quarterly sales amounts for the coming year. a. Accounts receivable at the beginning of the year are $335. The company has a 45 -day collection period. Calculate cash collections in each of the four quarters by completing the following. b. Rework part (a) assuming a collection period of 60 days.c. Rework part (a) assuming a collection period of 30 days. c. Rework part (a) assuming a collection period of 30 days. (Use cells A6 to E11 from the given information to complete this question.) 45-day collection period