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

?

18. Shortening the credit period A firm is contemplating shortening its credit period from 40 to 30 days and believes that, as a result of this change, its average collection period will decline from 45 to 36 days. Bad-debt expenses are expected to decrease from 1.7% to 0.9% of sales. The firm is currently selling 11,500 units but believes that as a result of the proposed change, sales will decline to 9,500 units. The sale price per unit is $54, and the variable cost per unit is $47. The firm has a required return on equal-risk investments of 11.7%. Evaluate this decision, and make a recommendation to the firm. (Note: Assume a 365-day year.) The reduction in profit contribution from a decline in sales is $ (Round to the nearest dollar. Enter as a negative number.) The benefit from the reduced marginal investment in A/R is $ (Round to the nearest dollar.) The cost savings from the reduction in bad debts is $ (Round to the nearest dollar.) The net profit or loss from implementing the proposed plan is $ (Round to the nearest dollar. Enter a negative number for a loss.) Is the proposed plan recommended? (1) (Select from the drop-down menu.) (1) Yes O No