Excel 30 Year Amortization Schedule Template [Free Download]

30-year amortization schedule is a great visualization tool to track one’s loan repayment process that was taken for 30 years. From this schedule, the borrower can visualize his principal paid, interest paid, and remaining balance after each payment. This table would also calculate the required regular payment amount and payment dates depending on multiple loan parameters.

Download our free 30-Year Amortization Schedule Excel template to generate your own amortization schedule for a 30-year loan. Read the article carefully to learn how to use the template efficiently.

This template would greatly help homeowners, business people, investors, financial planners, and all kinds of lenders and borrowers.

Click here to enlarge the image

Download Excel Template

For: Excel 2007 or later
License: Private Use

⏷What Is 30-Year Amortization Schedule?
⏷30-Year Amortization Schedule Excel Template
  ⏵How to Use This Template
  ⏵30-Year Amortization Schedule with Extra Payments (Regular/Irregular) Excel Template
⏷30-Year Amortization Schedule Excel Template Tips

What Is 30 Year Amortization Schedule?

30-year amortization schedule is a loan repayment visualization table that shows the due date, due payment, principal paid, interest paid, remaining balance, etc. after each payment of a 30-year loan. From this table, a borrower can easily get a continuous idea of how s/he is paying off his loan over the 30-year tenure.

30-Year Amortization Schedule Excel Template

In this template, you will be able to insert all your required loan parameters. According to the loan parameters, you will get your 30-year loan amortization table. You will get an output summary to summarize the amortization table results and a summary chart to get a quick visualization of interest paid, principal paid, and remaining balance after each payment over the loan tenure.

How to Use This Template

Follow the instructions below to use this template efficiently.

Instructions:

• Open the Payoff Calc. sheet and insert all your inputs in the blue-shaded area of the Input Values column. Here, the Original Loan Terms is fixed as 30 years. So, the required inputs are:

1. Loan Amount
2. Annual Percentage Rate
3. Loan Date
4. Payment Type
5. Regular Payment Frequency
6. Interest Compounding Frequency

Click here to enlarge the image

• After inserting all the required inputs, you will get your regular payment amount and an automatically completed amortization schedule.
• You will find an output summary containing-

1. Interest Rate (Per Period)
2. Total Amount to be Paid
3. Total Interest to be Paid
4. Total No. of Payments
5. Total Time

• You will find a summary chart showing the Principal Paid, Interest Paid, and Balance over the loan tenure.

Click here to enlarge the image

Read More: Loan Amortization Schedule with Variable Interest Rate in Excel

30-Year Amortization Schedule with Extra Payments (Regular/Irregular) Excel Template

This template is quite similar to the previous one. The only difference is you can add any regular or irregular extra payments in this template.

Say, a borrower has taken a loan for 30 years. After some time, his/her income increases, and s/he wants to pay off the loan quicker by making some extra payments. This will result in lesser interest to be paid over the loan term and repaying the loan quicker.

Click here to enlarge the image

How to Use This Template

Go through the instructions below to use this template.

Instructions:

• Open the Payoff Calc. (Extra Payments) template and insert all the required inputs in the blue shaded area of the Input Values column.

Click here to enlarge the image

• After inserting all the required inputs, you will find your regular payment amount and amortization table based on your input values and chosen dropdowns. You have to insert your additional irregular extra payments in the Extra Payment (Irregular) column of the amortization table.

Click here to enlarge the image

• You will get your final amortization table and an output summary containing the important outputs like estimated interest savings and time saved.
• You will also see a summary chart showing interest paid, principal paid, and remaining balance over the loan tenure.

Click here to enlarge the image

Read More: Excel Actual/360 Amortization Calculator Template

30-Year Amortization Schedule Excel Template Tips

• When working with the templates, insert all the required inputs correctly and choose all the required dropdowns properly.
• When inserting values, you can follow the given notes in the loan parameters to insert values properly.
• When choosing interest compounding frequency, remember to choose it as equal to or greater frequency than the regular payment frequency. That is, if you choose regular payment frequency as monthly, then choose the interest compounding frequency as monthly, bi-monthly, semi-annually, or yearly. Do not choose weekly, bi-weekly, or semi-monthly.
• When choosing extra regular payment frequency, choose it as multiple frequency of regular payment frequency. That is, if you choose regular payment as weekly, then choose extra payment frequency as weekly or bi-weekly. Do not choose semi-monthly, monthly, bi-monthly, or yearly.

Related Articles

• EIDL Loan Amortization Schedule Excel
• Excel Weekly Amortization Schedule
• Excel Bi-Weekly Amortization Schedule 
• Excel Quarterly Amortization Schedule
• Excel Monthly Amortization Schedule
• Loan Amortization Schedule in Excel with Moratorium Period

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