Required information

TB Problem $10-218$ and $10-219($Static$)$

$[$The following information applies to the questions displayed below.$]$

On January $1,$ a company borrows $$100,000$ cash by signing a four$-$year, $7\%$ installment note. The note requires four equal payments of $$29,523,$ consisting of accrued interest and principal on December $31$ of each year.

TB Problem $10-218($ Static$)$ Installment note amortization table

Prepare an amortization table for this installment note.

Note: Round all amounts to the nearest dollar.

$\backslash$table$[[\backslash$table$[[$Period Ending$],[$Date$]],($A$),($B$),($C$),($D$),($E$)],[\backslash$table$[[$Beginning$],[$Balance$]],\backslash$table$[[$Debit Interest$],[$Expense$]],\backslash$table$[[$Debit Notes$],[$Payable$]],\backslash$table$[[$Credit$],[$Cash$]],\backslash$table$[[$Ending$],[$Balance$]]],[$December $31,$ Year $1,,,,,],[$December $31,$ Year $2,,,,,],[$December $31,$ Year $3,,,,,],[$December $31,$ Year $4,,,,,],[$Total$,,$$$,,,]]$