Mortgage Amortization Schedule

This is a standard amortizing loan calculator that offers export and print capabilities.

No script required for this screen.

Monthly compounding/payments are assumed.

The monthly payment is calculated using the time value of money PMT function.

Monthly Payment = PMT(Annual Loan Rate / 12, Loan Term in Months, Initial Loan Amount, 0, 0)

Monthly Interest = Balance at Beginning of Month * (Annual Loan Rate / 12).

Monthly Principal = Monthly Payment - Monthly Interest.

Balance at End of Month = Balance at Beginning of Month - Monthly Principal payment.