Use these buttons to give a +1 or Like!

You may be asked to complete a short anonymous consumer survey prior to accessing your free download. Thank you for supporting Vertex42!

Excel Amortization Formulas

Click once on the green button to download the file, then save to your computer or device.


Filename: amortization-formulas.xls

Return to the Excel Amortization Formulas page to learn more about this template.

More Loan Calculators


Please Note ...

This amortization spreadsheet is mainly for demonstration. If you want to do a more in-depth analysis of a loan, I'd suggest using either the Loan Amortization Schedule or Home Mortgage Calculator. If you want to analyze a loan that accrues interest daily, try the Simple Interest Loan calculator.

But, before you consider taking on a debt, make sure you have a good handle on your finances. To help with that, use our budget spreadsheets and financial calculators.

Related Templates by ...

Create and print a professionally formatted loan amortization schedule.
The ultimate all-in-one mortgage calculator for Excel. Fixed or variable rate. Optional extra payments.
Yearly budget planner with categories for a single individual.
Estimate the future value your retirement savings.

Stay Connected ...

If you like our templates, stay connected using one or more of the following methods:

Subscribe to the Vertex42 Blog Follow the Vertex42 Blog