Amortization Schedule Excel Template with Extra Payments – Free Download

In the Amortization schedule borrowers can visualize their loan repayment process. This schedule shows: regular due payment, principal paid, interest paid, and remaining loan balance after each payment period.

If the borrower makes extra payments, less interest will be paid and the initial deadline is reduced.

Click here to enlarge the image

Download Excel Template

For: Excel 2007 or later
License: Private Use

Read More: Amortization Schedule with Irregular Payments in Excel

Amortization Schedule with Extra Payments Excel Template

How to Use This Template

Follow the instructions:

• Open the template and enter data.
• Choose all the dropdowns in the blue shaded area according to the loan parameters.

Click here to enlarge the image

• You will get your regular payment amount based on your inputs. If you want to input extra irregular payments, you have to do it manually in the Extra Payments (Irregular) column.

Click here to enlarge the image

• You will see an amortization schedule for your loan and a summary chart displaying your principal paid, interest paid, and balance trends.
• You will also find an output summary reflecting all outputs, such as estimated interest savings, time saved, total interest to be paid, total principal to be paid.

Click here to enlarge the image

Read More: Amortization Schedule with Balloon Payment and Extra Payments in Excel

Related Articles

• Preparing Bond Amortization Schedule in Excel
• Interest Only Amortization Schedule with Balloon Payment Template Excel
• Multiple Loan Amortization Schedule Excel Template
• Excel Car Loan Amortization Schedule with Extra Payments Template
• Excel Car Loan Amortization Schedule Template
• Excel Student Loan Amortization Schedule
• ARM Amortization Schedule Excel Template 

<< Go Back to Amortization Schedule | Finance Template | Excel Templates