Please help! Please show excel formulas so I understand how to get to the right answer. TIA!!

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