INSTRUCTIONS: Waldron Inc. issued $$400,000$ bonds with a stated rate of $7\%$ when the market rate was $5\%.$ They are $3-$year bonds with interest to be paid annually. Assume that the bonds were issued for $$421,840.$ Prepare an amortization table for the first three payments.

$\backslash$table$[[\backslash$table$[[$Annual$],[$Interest$],[$Period$]],\backslash$table$[[$Annual Interest$],[$Expense$]],\backslash$table$[[$Annual Interest$],[$Payment$]],\backslash$table$[[$Amortization of$],[$Premium$]],\backslash$table$[[$Ending$],[V$INSTRUCTIONS: Waldron Inc. issued $$400,000$ bonds with a stated rate of $7\%$ when the market rate was $5\%.$ They are $3-$year bonds with interest to be paid annually. Assume that the bonds were issued for $$421,840.$ Prepare an amortization table for the first three payments.

Annual Interest Period Annual Interest Expense Annual Interest Payment Amortization of Premium Ending Carrying Value

$1$

$2$

$3$

PLEASE NOTE: All dollar amounts will be rounded to whole dollars with $"$$$"$ and commas as needed $($i$.$e$.$ $$12,345).$

$[$HINT $-$ You definitely will want to use this EXCEL spreadsheet Chapter$13$ HW$-02$ #$1$ #$2$ Worksheets.xlsx Download Chapter$13$ HW$-02$ #$1$ #$2$ Worksheets.xlsx to assist in your calculations. In order to use the worksheet, you will also need to calculate the Market Price of Bonds $(\%$ of Face$).]$