St$.$ Davids buys $$700,000$ of a particular item $($at gross prices$)$ from its major supplier Cardinal Health, which offers St$.$ Davids terms of $2/10,$ net $45.$ Currently, the hospital is paying the supplier the gull amount due on Day $45,$ but it is considering taking the discount, paying on Day $10$ and replacing the trade credit with a bank loan that has a $12\%$ interest rate. Assume $360$ days per year.

$1.$ What is the amount of free trade credit that the orginization obtains from Cardinal Health?

$2.$What is the total amount of free trade credit offered by Cardinal?

$3.$ What is the approximate annual cost of the costly trade credit?

$4.$ Should the organization replace a portion of the trade credit with the bank loan?

$5.$ If the bank loan is used, how much of the trade credit should be replaced?

please show your work in Excell or provide formulas.