Thank you in advance for your help; could you please provide an excel spreadsheet solution too, to help in my understanding?

?

8/9/2021 Assignment 7-Kenneth Covey 17. Initiating a cash discount Gardner Company currently makes all sales on credit and offers no cash discount. The firm is considering offering a 5% cash discount for payment within 15 days. The firm's current average collection period is 60 days, sales are 40,000 units, selling price is $42 per unit, and variable cost per unit is $36. The firm expects that the change in credit terms will result in an increase in sales to 41,000 units, that 70% of the sales will take the discount, and that the average collection period will fall to 30 days. If the firm's required rate of return on equal-risk investments is 10%, should the proposed discount be offered? (Note: Assume a 365-day year.) The additional profit contribution from additional sales is $ (Round to the nearest dollar.) The amount of cost that will be saved due to the reduction in average A/R is $ (Round to the nearest dollar.) The cost of extending the cash discount to customer is $ (Round to the nearest dollar.) The net profit from the proposed cash discount is $ (Round to the nearest dollar.) Should the proposed cash discount be offered? (Select the best answer below.) Yes O No