Buy Now

Loan
Amortization Schedule
Excel Template

Calculate your loans (business, mortgage, auto, etc.) with our Loan Amortization Schedule spreadsheet. Equipped with a fully automated dashboard to view up to 5 loans and your payment + interest data. 
 
Unlock Access
 

What's Inside the Loan Amortization Schedule Template?

Details | 7 Sheets 

Supported Versions | Excel 2007, 2010, 2013, 2016, 2019, Office 365 (Mac)

Category | Accounting, Personal Finance

Tags | Monthly Payment Calculator

Why Professionals Choose Simple Sheets

It's simple. Access to the largest library of premium Excel Templates, plus world-class training.

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Our Loan Amortization Schedule Excel Template

Easily log invoices in the table of the Enter Invoice sheet of our Accounts Receivable Template for Excel and Google Sheets.

Albert Einstein once said, “Compound interest is the 8th wonder of the world… he who understands it earns it… he who doesn’t… pays it.” Basically, you can’t afford to not know how debt plays into your financial future.

In some cases it will be inevitable. Paying cash for a house, car or 4-year degree isn’t exactly pocket change you’d find stuffed in-between your couch cushions. 

That’s where our Loan Amortization Schedule Excel Template comes in handy. It calculates interest payments, principal, beginning and ending balances as well as extra payments based on the specific details of your loan for up to five loans. 

This template is equally suited for businesses and personal use. 

Popular ways to use the template are for auto loans, mortgage, student debt or a business loan. This is a wildly helpful tool to use when comparing loan terms or negotiating with a car dealer who wants to put you in a new Buick for 84 months but “only” a $200 payment (just say no). 

Before we dive into this spreadsheet, you may also want to check out our Net Worth Calculator or Personal Budget Analysis Templates to take control of your finances. 

Record customer payments made in this sheet
The Open Invoices sheet displays which companies still have a balance that needs to be paid

In the Loan Schedule sheet, input data related to your loan like Loan Amount, Annual Interest Rate, Loan Period in Years, Number of Payments Per Year, Start Date of Loan and Optional Extra Payments. 

The template will auto populate the Loan Summary and every payment, showing the balance, interest and cumulative interest. 

Your information from the Loan Schedule sheet will automatically sync to the Dashboard sheet. The Dashboard allows you to visualize your loan data with graphs and charts that display your payment breakdowns by month and principal payments vs. interest payments. 

As you add other Loan Schedules to the template, you will get a clear picture of what your financial debt looks like and can plan accordingly. 

More Accounting Templates For You

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.

Limited

$49

(no bundle savings)

  • 45+ Customizable Excel Templates
  • One User
  • One-Time Payment
BUY NOW

Premium + University

$199

($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment
BUY NOW

Premium

$99

($299 bundle savings)

  • 100+ Customizable Excel Templates
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment
BUY NOW