Stanford issues bonds dated January $1,2021,$ with a par value of $$500,000.$ The bonds' annual contract rate is $9\%,$ and interest is paid semiannually on June $30$ and December $31.$ The bonds mature in three years. The annual market rate at the date of issuance is $12\%,$ and the bonds are sold for $$463,120.$

$\backslash$table$[[$Par Value,$\backslash$table$[[$Contract$],[$rate$]],\backslash$table$[[$Term$],[($years$)]],\backslash$table$[[$Market$],[$rate$]],\backslash$table$[[$Issue$],[$Price$]],\backslash$table$[[$Payments$],[$per year$]]],[$$$500,000,9\%,3,12\%,$$$463,120,2]]$

Required:

What is the amount of the discount on these bonds at issuance?

$($Use cells A$2$ to L$5$ from the given information to complete this question.$)$

Discount

$2.$ How much total bond interest expense will be recognized over the life of these bonds?

$($Use cells A$2$ to L$5$ from the given information to complete this question. Negative amounts or amounts to be deducted should be input and displayed as negative values.$)$

$\backslash$table$[[$Total Bond Interest Expense Over Life of Bonds:$],[$Amount repaid:$],[$Par value at maturity$],[$Total repaid$],[$Less amount borrowed$],[$Total bond interest expense$]]$

Prepare an effective interest amortization table for these bonds.

$($Use cells A$2$ to L$5$ from the given information to complete this question.$)$

$\backslash$table$[[\backslash$table$[[$Semiannual$],[$Interest$],[$Period$-$End$]],\backslash$table$[[$Cash Interest$],[$Paid$]],\backslash$table$[[$Bond Interest$],[$Expense$]],\backslash$table$[[$Discount$],[$Amortization$]],\backslash$table$[[$Unamortized$],[$Discount$]]],[\frac{1}{1}\frac{?}{2021},,,,]]$ Kindly please do it correctly as no one did it and do it with all the calculations Specifically the last part how to calculate!

I would really appreciate who so ever gonna do this for me$!$