Dome Metals has credit sales of $396,000 yearly with credit terms of net 45 days, which is also the average collection period. Assume the firm adopts new credit terms of 3/18, net 45 and all customers pay on the last day of the discount period. Any reduction in accounts receivable will be used to reduce the firm's bank loan which costs 10 percent. The new credit terms will increase sales by 15 percent because the discount will make the firm's price competitive.

a. If Dome earns 20 percent on sales before discounts, what will be the net change in income if the new credit terms are adopted? (Use a 360-day year.)

Please use excel spread sheet for answer