Notes Payable Amortization Table

Date Beginning Balance Principal Payment Interest Expense Total Payment Ending Balance

$01/02/23$

$03/31/23$

$06/30/23$

$09/30/23$

$12/31/23$

$03/31/24$

$06/30/24$

$09/30/24$

$12/31/24$

$03/31/25$

$06/30/25$

$09/30/25$

$12/31/25$

Total

Bonds Payable Amortization Table

Date Cash Paid Interest Expense Discount or Premium Amortized Carrying Amount

$1/2/23$

$3/31/23$

$6/30/23$

$9/30/23$

$12/31/23$

$3/31/24$

$6/30/24$

$9/30/24$

$12/31/24$

$3/31/25$

$6/30/25$

$9/30/25$

$12/31/25$

$3/31/26$

$6/30/26$

$9/30/26$

$12/31/26$

$3/31/27$

$6/30/27$

$9/30/27$

$12/31/27$

Total

Mortgages Payable Amortization Table

Date Beginning Balance Principal Payment Interest Expense Total Payment Ending Balance

$01/02/23$

$01/31/23$

$02/28/23$

$03/31/23$

$04/30/23$

$05/31/23$

$06/30/23$

$07/31/23$

$08/31/23$

$09/30/23$

$10/31/23$

$11/30/23$

$12/31/23$

$01/30/24$

$02/28/24$

$03/31/24$

Note: For the sake of brevity, you are only required to prepare this amortization table until the end of March $2024.$ In real practice, Allenby Honey would prepare an amortization table for the entire twenty$-$year term of the mortgage.