A corporation issued $$800,000$ of $9\%$ bonds on August $1,2024,$ due on August $1,2029.$

The interest is to be paid twice a year on February $1$ and August $1.$ The bonds were sold

to yield $11\%$ effective annual interest. The corporation closes its books annually on

December $31.$

$($a$)$ Complete an amortization schedule for the above bond $($for all periods$)$ in a similar

format as below using Excel. You can round to the nearest dollar or penny. Use

the effective$-$interest method.

Bond Amortization Table:

YOU MUST SHOW THE WORK IN EXCEL AND HOW TO USE THE FORMULAS $($c$)$ Compute the interest expense to be reported in the income statement for the year ended December $31,2024$ and December $31,2025.$

$($d$)$ Complete an amortization schedule for the above bond $($for all periods$)$ using the straight$-$line amortization method $($entries are not required$).$