Bond Excel Problem

GoodFoods, Inc issued $$760,000$ of its $20-$vear, $8\%$ bonds on Janaury $1,2024.$

Bonds were priced to yield $10\%.$

GoodFoods uses the effective interest method to record its semi$-$annual interest payments.

$4.$ Prepare the amortization schedule through $12/31/26($not the full $20$ years$).$ Add or delete rows as necessary.

$\backslash$table$[[$Cash Pmt$,$Effective Interest,$\backslash$table$[[$Discount$/$Premium$],[$Amortization$]],$Carrying Value$],[,,,],[,,,],[,,,],[,,,],[,,,],[,,,],[,,,]]$

$20$

$21$

$225.$ Record June $30,2024$ interest payment

$23$

$24$

$25$

$26$

$27$

$28$

$6.$ Record December $31,2024$ interest payment

$29$

$30$