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

14. Forrester Fashions has annual credit sales of 250,000 units with an average collection period of 70 days. The company has a per-unit variable cost of $23 and a per-unit sale price of $34.50. Bad debts currently are 4% of sales. The rm estimates that a proposed relaxation of credit standards would not attest its 70-day average collection period but would increase bad debts to 6.00% of sales. which would increase to 300.000 units per year. Forrester requires a 12% return on investments. Show all necessary calculations required to evaluate Forrester's proposed relaxation of credit standards. (Note: Assume a 365-day year.) The additional prot contribution from an increase in sales is $ . (Round to the nearest dollar.) The cost from the increased marginal investment in AIR is $ . (Round to the nearest dollar.) The cost from the increase in bad debts is $ . (Round to the nearest dollar.) The net prot 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) O Yes C) No \"---__._______