# How To Create An Amortization Schedule With Extra Payments In Excel

Monday, April 17th 2023. | Excel Templates

## Introduction

If you’re looking to pay off your debt faster, extra payments can be a great way to do it. But how do you keep track of all the payments and make sure you’re paying down the right amount? The answer is an amortization schedule with extra payments in Excel.

### What is an Amortization Schedule?

An amortization schedule is a table that shows the breakdown of each payment on a loan. It includes the amount of each payment, the interest paid, and the principal paid. By looking at an amortization schedule, you can see how much of each payment is going toward the principal and how much is going toward interest.

### What are Extra Payments?

Extra payments are additional payments made on a loan or mortgage. These payments can be made at any time and are typically used to pay down the principal faster. By making extra payments, you can reduce the amount of interest you pay over the life of the loan and pay off the debt faster.

### Creating an Amortization Schedule with Extra Payments in Excel

To create an amortization schedule with extra payments in Excel, you’ll need to use the PMT function. This function calculates the payment for a loan based on the interest rate, number of payments, and loan amount. Once you have the payment amount, you can create a table that shows each payment and how much of it goes toward the principal and interest.

### Sample Amortization Schedules

Here are three sample amortization schedules with extra payments in Excel: 1. 30-year mortgage with \$200,000 principal, 4% interest rate, and \$100 extra payment each month. 2. 5-year car loan with \$10,000 principal, 6% interest rate, and \$50 extra payment each month. 3. 10-year personal loan with \$20,000 principal, 8% interest rate, and \$200 extra payment each month.

### Tips for Using an Amortization Schedule with Extra Payments

1. Make sure to include all extra payments in your schedule, even if they’re not made on a regular basis. 2. Update your schedule regularly to reflect any changes in your loan balance or interest rate. 3. Use your schedule to track your progress and motivate yourself to continue making extra payments. 4. Consider using a debt snowball or debt avalanche method to prioritize which debts to pay off first.