please show all the work in detail with formulas on EXCEL.

22 PROBLEM 2 23 Northeast Baptist buys $500,000 of a particular item (at gross prices) from its major supplier, 24 Cardinal Health, which offers NE Baptist terms of 3/20, net 60. Currently, the hospital is paying the 25 supplier the full amount due on Day 60, but it is considering taking the discount, paying on Day 20 and 26 replacing the trade credit with a bank loan that has a 12 percent rate. 27 a. What is the amount of free trade credit that Baptist obtains from Cardinal Health? (Assume 28 360 days per year throughout this problem.) 29 b. What is the amount of costly trade credit? 30 c. What is the approximate annual cost of the costly trade credit? 31 d. Should Baptist replace its trade credit with the bank loan? Explain your answer. 32 e. If the bank loan is used, how much of the trade credit should be replaced? 33 24