Amortization schedule is a great tool for borrowers to visualize their loan repayment process. This schedule will give him/her regular due payment, principal paid, interest paid, and remaining loan balance after each payment period. Now, if the borrower has some extra money and makes some extra payments along with regular payments, s/he will have to pay lesser interest eventually and will be able to repay the loan quicker than the initial deadline. So, now, s/he will need an amortization schedule with extra payments template to get his/her regular due payment, principal paid, interest paid, and remaining loan balance after each payment period.
Download our free amortization schedule with extra payments template to generate your own amortization schedule with regular or irregular extra payments and read the following article to learn how to use this template efficiently.
This template will be greatly helpful to homeowners, investors, business persons, students, financial planners, and all kinds of borrowers and lenders who are looking forward to taking or giving a loan.
Click here to enlarge the image
Download Excel Template
Download Excel TemplateFor: Excel 2007 or later
License: Private Use
What is an Amortization Schedule?
An amortization schedule is a schedule to visualize the loan repayment process. A borrower can visualize his due payment, principal paid, interest paid, and remaining loan balance over the loan terms after each payment period.
What are Extra Payments?
Extra payments are the payments that a borrower makes along with his regular due payments. S/he can make extra payments both regularly and irregularly. Making extra payments is a good approach to repay the loan quicker than the fixed loan terms which results in lesser interest to be paid.
Read More: Amortization Schedule with Irregular Payments in Excel
Amortization Schedule with Extra Payments Excel Template
In this template, you can insert all your required inputs and choose the required dropdowns. After inserting inputs, you will get an amortization schedule along with an output summary and a summary chart to show your principal paid, interest paid, and balance trends. In the output summary, you will find all your necessary outputs along with time saved and estimated interest savings.
How to Use This Template
To use this template properly, go through the following instructions:
Instructions:
- Open the template and insert all the required inputs and choose all the dropdowns in the blue shaded area according to the loan parameters.
Click here to enlarge the image
- After inserting inputs, you will get your regular payment amount based on all of your inputs. If you want to input extra irregular payments, you have to do it manually in the amortization schedule in the Extra Payments (Irregular) column.
Click here to enlarge the image
- Based on all inputs you will find 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 necessary outputs that you may require such as estimated interest savings, time saved, total interest to be paid, total principal to be paid, etc.
Click here to enlarge the image
Read More: Amortization Schedule with Balloon Payment and Extra Payments in Excel
Amortization Schedule with Extra Payments Excel Template Tips
- Insert all the required inputs and choose all the required dropdowns.
- Follow the given notes in the loan parameters to understand the terms better and insert values properly.
- When choosing dropdowns, remember that you have to choose interest compounding frequency as greater than or equal to your chosen regular payment frequency.
- When choosing an extra payment frequency, choose it as a multiple of your regular payment frequency to match your payment dates properly.
Related Articles
- Loan Amortization Schedule in Excel with Moratorium Period
- Preparing Bond Amortization Schedule in Excel
- Loan Amortization Schedule with Variable Interest Rate in Excel
- Interest Only Amortization Schedule with Balloon Payment Template Excel
- EIDL Loan Amortization Schedule Excel
- Multiple Loan Amortization Schedule Excel Template
- Excel Car Loan Amortization Schedule with Extra Payments Template
