Need calculation for bonds sold at $170,864$

Prepare a seaight$-$line amortization table for these bonds.

$29$

$30$

$\backslash$table$[[$Amount of semi$-$annual discount amortization,c############$],[$Semiannual Unamortized$],[,$Period$-$End,Discount,Carrying Value$],[(0),1/1/2025,$############$,$############$],[(1),6/30/2025,$###########$,$a###########$],[(2),12/31/2025,$###########$,$###########$],[(3),6/30/2026,$############$,$#############$],[(4),12/31/2026,$Z##########$,$###########$],[(5),6/30/2027,$Z###########$,$###########$],[(6),12/31/2027,$Z###########$,"$############$]]$

Check Answers

Legend

Graded cell: Leave blank if no answer is needed.

Scratchpad: Use as a non$-$graded workspace

Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work

Nothing in this area will be graded, but it will be submitted with your assignment.