Debt Issued at a Discount $($Straight Line$)$

On January $1,2024,$ Drew Company issued $5-$year bonds with a face value of $$35,000,000$ for $$32,000,000.$ The stated rate of interest was $7\%$ and interest is paid annually on December $31.$

Required:

Prepare the amortization table for Drew Company's bonds. If an amount box does not require an entry, leave it blank and if the answer is zero, enter $"0".$

Drew Company

Amortization Table

$\backslash$table$[[$Period$,\backslash$table$[[$Cash$],[$Payment$],[($Credit$)]],\backslash$table$[[$Interest$],[$Expense$],[($Debit$)]],\backslash$table$[[$Discount on$],[$Bonds Payable$],[($Credit$)]],\backslash$table$[[$Discount on$],[$Bonds Payable$],[$Balance$]],\backslash$table$[[$Carrying$],[$Value$]]],[$At issue,$$,$$$,$$$,$$$,$$