Sciamanna Corporation issued $$300,000$ of $16\%,10-$year bonds payable on January $1,2022.$ The market interest rate at the date of issuance was $14\%,$ and the bonds pay interest semiannually $($on June $30$ and December $31).$ Sciamanna Corporation's year$-$end is June $30.$

Read the requirements.

Using the PV function in Excel, calculate the issue price of the bonds. $($Round your answer to the nearest whole dollar.$)$

The issue price of the bonds is

$2.$ Prepare an effective$-$interest amortization table for the bond through the first three interest payments. Round amounts to the nearest dollar.

$\backslash$table$[[,,,,$Premium,Bond$],[$Semiannual$,$Interest,Interest,Premium,Account,Carrying$],[$Interest Date,Payment,Expense,Amortization,Balance,Amount$],[Jan1,2022,,,,31,782,331,782],[$Jun $30,2022,24,000,,,,]]$