You might 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.

1 Download the Amortization Chart

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

⤓ Download

Filename: amortization-chart.xls

Return to the Amortization Chart page to learn more about this template.

2 Mention it or Like it!

"I just got an awesome Amortization Chart from @Vertex42"

To share this resource, please link to the Amortization Chart page.

3 Try More Templates

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.

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.

4 Stay Connected ...

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

Excel Tips and Templates Newsletter - Subscribe