Amortization Schedules Formula and Excel Mortgage Loan Spreadsheets

amortization formula

This is the amortization formula of a single periodic payment. The same one is used by our amortization schedule calculator.

amortization formula

A - single periodic payment amount
i - the periodic interest rate
P - principal (the loan amount)
n - the number of payment periods

It's complicated to calculate amortizing loan schedules on paper, so use our online calc!

download amortization schedules

If you want to calculate your schedules offline, you can download these loan spreadsheet templates for OpenOffice and Microsoft Excel.

OpenOffice:
A free and open source Office Suit. It's compatible with almost all Office Suites, so it's a perfect replacement for Microsoft Excel.

Download amortizations spreadsheet for OpenOffice Calc.

Microsoft Office:
This is the most widely used Office Suit today. You can run Excel on Microsoft Windows and Mac OSX operating systems as well.

Download amortizations spreadsheet for Microsoft Office Excel.

We recommend you to try our new Mozilla Firefox Loan Calculator plugin with free online amortization schedule.

Amortization Schedules Excel Mortgage Loan Spreadsheets.Loan Calculator templates with amortization formula.

Amortization Schedules Excel Mortgage Loan Spreadsheets.
Loan Calculator templates with amortization formula.