Loan Lab

Loan Lab provides free tools to help you understand your student loans.

  • Home
  • Calculators
  • Guide to Refinancing
  • Blog

Downloadable, Excel-Based Student Loan Amortization Table With Option to Include Extra Payments

Updated on November 8, 2017 by Nathan Crabtree Leave a Comment

Excel-Based Amortization Table for Student Loans

This downloadable student loan amortization table will make it easy to visualize your repayment schedule and how interest expenses factor into each payment.

What is Amortization?

Amortization is the systematic repayment of a debt, paying it down over time.

For borrowers, this typically means making fixed monthly payments, which consist of both interest and principal. Many types of consumer loans, including mortgages, car loans, and student loans, are amortized over a fixed term, during which borrowers pay the same amount each month.

While payments are fixed, the ratio of interest to principal will change over time. At the beginning of the repayment term, when the balance is highest, a greater portion of each payment will go toward paying the interest expense. This makes sense, since interest is calculated by multiplying the outstanding balance for the previous period by the periodic interest rate. As time goes on and the borrower pays down the balance a greater portion of each payment will go toward principal. To make sure this is clear, let’s look at an example.

Let’s say that you have a student loan for $40,000 and an interest rate of 6.5%, and you plan to stick to a 10 year repayment plan. Using our Basic Student Loan Calculator, you’d be able to quickly determine that you’d owe approximately $454 each month over the repayment term. But, as noted, the ratio of interest to principal will change over time.

Payment 1: $39,762.47 ($216.67 goes to interest, and $237.53 goes to principal)

Payment 2: $39,523.66 ($215.38 goes to interest, and $238.81 goes to principal)

…

Payment 24: $33,659.37 ($183.79 goes to interest, and $270.41 goes to principal)

Payment 25: $33,387.50 ($182.32 goes to interest, and $271.87 goes to principal)

…

Payment 105: Balance = $6,526.50 ($37.61 goes to interest, and $416.58 goes to principal)

Payment 106: Balance = $6,107.66 ($35.35 goes to interest, and $418.84 goes to principal)

The Pros and Cons of Amortization

On the one hand, amortization makes it easy for borrowers to understand their repayment obligations. That is, an amortized loan requires a fixed payment over a fixed term, making it easy for borrowers to decide whether they can afford to take on new debt.

However, what’s not apparent to many borrowers is how interest expenses impact the amount they will pay over the life of the loan. An amortization table makes it easy to visualize the repayment schedule, and how interest expenses factor into each payment.

What Does an Amortization Table Show?

The calculations of an amortized loan are best displayed in an amortization table.

Each period (e.g., month) is displayed as a single row in the table. For each period, the table shows the total monthly payment, the amount paid to interest, and the amount paid to principal as well as the outstanding balance. The outstanding balance at the end of one period is used to calculate the interest expense for the next period.

How to Use this Excel-based Student Loan Amortization Table

This Excel-based amortization schedule will help you determine the following:

  • The amount you’ll owe every month on your student loans
  • How much of each payment will go toward interest and principal
  • How a lower interest rate will change your payment
  • The impact of making extra payments at any time during your repayment period

DOWNLOAD THE EXCEL-BASED STUDENT LOAN AMORTIZATION SCHEDULE HERE

SCREENSHOT:

Student Loan Amortization Schedule Preview

Filed Under: Excel, Tools Tagged With: Excel, Tools

Considering refinancing your student loans?

Advertising Disclosure We sometimes earn sales commissions and advertising fees when we make recommendations to you. While we do our best to recommend only products and services that offer real benefits, you should be sure to thoroughly research any product or service prior to making a purchase. Loan Lab is not a lender, nor an investment advisor. We cannot influence the outcome of your loan application. If you have questions about which financial products are best for you, you should consult a qualified professional.
Partner Interest Rates No Hard Credit Check
LendKey Logo As low as 2.67% APR ✔
Purefy Logo As low as 2.79% APR
Credible Logo As low as 2.78% APR ✔

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Sign Up for Our Newsletter

Enter your email address below to receive periodic updates when new content is added to the site.

RECENT POSTS:

  • Loan Amortization Calculator: See The Full Amortization Table For Your Loan
  • Future Value Calculator: Calculate The Future Value Of An Investment
  • Should You Get An MBA? This Excel-based MBA ROI Calculator Can Help You Decide
  • Does Planet Fitness Charge Hidden Fees?
  • Three Job Interview Questions Every MBA Grad Should Be Ready to Answer
  • Answers to Frequently Asked Resume Questions
  • Saving $1,000 A Month – 10 Ideas for Frugal Living
  • How Do You Know If You Have a Lemon?
  • Income-Based Student Loan Repayment for Freelancers and Contract Workers
  • The Complete List of Student Loan Servicers

LOAN LAB

  • Home
  • About
  • Contact
  • Blog
  • Write for Us

RESOURCES

  • Student Loan Calculators
  • Excel Resources
  • Refinancing
  • Student Loan Charts

SIGN UP FOR OUR NEWSLETTER

Enter your email address below to receive periodic updates when new content is added to the site.

© Copyright 2016 Loan Lab · All Rights Reserved