PLEASE INCLUDE AN EXCEL SPREADSHEET TO SHOW CALCULATIONS!! THANK YOU!

Kyoto Joe, Inc., sells earnings forecasts for Japanese securities. Its credit terms are 2/10, net 90. Based on experience, 40 percent of all customers will take the discount. a. What is the average collection period for the company? (Use 365 days a year. Do not round intermediate calculations.) b. If the company sells 750 forecasts every month at a price of $1,625 each, what is its average balance sheet amount in accounts receivable? (Use 365 days a year. Do not round intermediate calculations and enter your answer in dollars, not millions of dollars, rounded to 2 decimal places, e.g., 1,234,567.89.) a. days Average collection period Average balance b