---
title: "Loan Amortization Schedule Calculator | MCC Solutions"
description: "See each year's interest, principal and remaining balance for a fixed-rate loan. Free, private, runs in your browser."
url: "https://mcc-solutionsnj.com/bookkeeping/loan-amortization-schedule-calculator"
---

Free tool

# Loan amortization schedule calculator

## Overview

Enter a loan amount, an interest rate and the years to see the monthly payment and a year-by-year split of interest and principal.

[![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)

Want this tracked every month? Wrenfold keeps your budget on your own device. [See Wrenfold](/personal-finance)

Loan amount ($)

Interest rate (APR %)

Loan length (years, up to 40)

Excel workbook · $24

### Debt Avalanche & Amortization Matrix

Enter your debts and one monthly amount and see the order, the dates and the interest you avoid, in a file that never connects to your bank.

[See what is inside ($24)](/toolkits/debt-avalanche-amortization-matrix)14-day full refund

Share

## Put this tool on your own site

Free to use. Paste this where you want it to appear. It runs in the visitor's browser, so nothing they enter is sent to us.

[See every calculator you can embed](/embed)

How it works

## How it works

Each month the interest is the balance times the monthly rate, and the rest of the payment reduces the balance. Early payments are mostly interest, and later payments are mostly principal. The table adds up each year.

Want a second pair of eyes on your books? [A free bookkeeping health check](/bookkeeping/health-check).

FAQ

## About this calculator

**What is amortization?**

Paying a loan down in regular installments so the balance reaches zero at the end of the term.

**Why is so much of the early payment interest?**

Interest is charged on the remaining balance, which is highest at the start.

**Does an extra payment help?**

Extra principal lowers the balance, which lowers the interest charged afterward. Check that your lender applies it to principal and does not charge a prepayment fee.

**Is anything saved?**

No. The math runs in your browser and nothing you enter is sent to us.

**Is this a quote or advice?**

No. It is a calculator for general information. Check results against your own figures before you rely on them.

Read the guide: [How Car Loan Interest Works, Month by Month](/tools/guides/how-car-loan-interest-works). Related: [business loan payment calculator](/bookkeeping/business-loan-payment-calculator), [loan comparison calculator](/bookkeeping/loan-comparison-calculator). See [all free tools](/free-tools). More free tools: [NJ Sales Tax Splitter](/bookkeeping/nj-sales-tax-splitter-python-script), [Notary Journal Digitizer](/bookkeeping/notary-journal-digitizer-python-script), [Collections Manager](/bookkeeping/accounts-receivable-collections-python-script), or [see all free tools](/free-tools).

Free

### Month-End Close Checklist (PDF)

The five-day close, one page to print. Enter your email and we send a link to confirm it is yours, then the download. We may email you about new toolkits, and every email has an unsubscribe link.

General information, not tax or legal advice. [How we write and check our tools](/editorial-standards).

Excel workbook

### Debt Avalanche & Amortization Matrix

Enter your debts and one monthly amount and see the order, the dates and the interest you avoid, in a file that never connects to your bank.

[See what is inside ($24)](/toolkits/debt-avalanche-amortization-matrix)

Also in the [Home and Big Purchase Bundle](/toolkits/home-and-big-purchase-bundle): 4 products for $55 instead of $76 separately.

Wrenfold

### Keep this going in a budget you own

Wrenfold keeps accounts, budgets, bills and goals on your own computer or iPhone, with budgets that roll over each month. Bring in a bank CSV or your You Need A Budget file, or keep balances current through SimpleFIN Bridge, a separate service you sign up for. $79 once, with an optional $5 a month for updates; the app keeps working if you stop. The free trial records up to 60 entries.

[See Wrenfold](/personal-finance) [Compare the three apps](/software)

## Want your books and numbers handled?

[Free health check](/bookkeeping/health-check)[Call (908) 444-6373](tel:+19084446373)