John borrows $150,000. The terms of the loan are 7.5% over the next 5 years. It is important to note that he makes annual rather than monthly payments.

Construct a loan amortization schedule that shows the 5 payments of John's loan.

EXCEL TEMPLATE