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

?

19. Lengthening the credit period Parker Tool is considering lengthening its credit period from 30 to 60 days. All customers will continue to pay on the net date. The rm currently bills $440,000 for sales and has $300,000 in variable costs. The change in credit terms is expwted to increase sales to 5500.000. Bad-debt expenses will increase from 1% to 1.5% of sales. The rm has a required rate of return on equal-risk investments of 20%. (Note: Assume a 365-day year.) a. What additionaipmt contribution from sales will be realized from the proposed change? b. What is the cost of the marginal investment in accounts receivable? c. What is the cost of the marginal bad debts? it. Do you recommend this change in credit terms? a. The additional prot contribution from an increase in sales is $ . (Round to the nearest dollar.) b. The interest cost of the marginal investment in AIR is $ . (Round to tFie nearest dollar.) c. The cost of the marginal bad debts is $ . (Round to the nearest dollar.) d. The net prot from the proposed change in credit terms is $ . (Round to the nearest dollar.) Do you recommend this change in credit terms? (Select the best answer below.) OYes ONo