please answer ASAP show work in excel.

Resolute Health buys $600,000 of a particular item (at gross prices) from its major supplier, Cardinal Health, which offers Resolute terms of 2/10, net 30. Currently, the hospital is paying the supplier the full amount due on Day 30 , but it is considering taking the discount, paying on Day 10 and replacing the trade credit with a bank loan that has a 12 percent rate. Assume 360 days per year. What is the amount of free trade credit that the organization obtains from Cardinal Health?? Format is $Xx,xXX,xx What is the total amount of trade credit offered by Cardinal? Format is $x,xx,xx What is the approximate annual cost of the costly trade credit? Format is x.x% Should the organization replace a portion of the trade credit with the bank loan? Format is Yes or No If the bank loan is used, how much of the trade credit should be replaced? Format is $xx,xxx,xx