posted by sweet on .
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.
Here are some tutorials for Excel Template: