Include any excel formulas used to arrive at the answer.

(16-15) Cash Discounts Suppose a firm makes purchases of $3.65 million per year under terms of 2/10, net 30, and takes discounts. a. What is the average amount of accounts payable net of discounts? (Assume the $3.65 million of purchases is net of discountsthat is, gross purchases are $3,724,489.80, discounts are $74,489.80, and net purchases are $3.65 million.) Answer b. Is there a cost of the trade credit the firm uses? Answer c. If the firm did not take discounts but did pay on the due date, what would be its average payables and the nominal and effective costs of this nonfree trade credit? Answer d. What would be the firm's nominal and effective costs of not taking discounts if it could stretch its payments to 40 days? Answer +