Last year, NoFall Technologies had credit sales of $5,076,419. On average 30 percent of the customers paid on the fifteenth day, 40 percent paid on the thirtieth day, and the remaining 30 percent paid 45 days after the purchase. Assume 365 days per year.

a. Calculate average collection period (ACP)

b. Calculate average daily sales (ADS)

c. Calculate average receivables balance

PLEASE USE EXCEL TO ANSWER THE QUESTION. PLEASE EXPLAIN WORK