please assist with formulas to put in excel

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 beriod of 30 davs