You may be asked to complete a short optional and anonymous consumer survey prior to accessing your free download. Click on the SKIP button to skip the survey. Thank you for supporting Vertex42! See the Google Surveys Overview for privacy info.

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:

Excel Tips and Templates Newsletter - Subscribe