Using Excel functions, can you please show me the formulas and steps on how to find the following

Calculating Cash Collections [LO3] The following is the sales budget for Harp, Inc., for the first quarter of 2015:

Credit sales are collected as follows:

65 percent in the month of the sale

20 percent in the month after the sale

15 percent in the second month after the sale

The accounts receivable balance at the end of the previous quarter was $93,000 ($62,000 of which was uncollected December sales).

a.Compute the sales for November.

b.Compute the sales for December.

c.Compute the cash collections from sales for each month from January through March.

January February March Sales budget $216,000 $241,000 $257,000