Loan Amortization Schedule Excel with Extra Payments | Loan Calculator Template

See exactly how much interest your extra payments save - and the month your loan is paid off.

This loan amortization schedule Excel template with extra payments shows every monthly payment of your loan split into principal and interest, side by side with the same loan without extra payments.

WHAT'S INCLUDED

• Loan Inputs: loan amount, annual interest rate, term (up to 40 years), first payment date

• Extra payment every month plus an optional one-time lump sum in the payment number you choose

• Schedule: up to 480 payments with date, beginning balance, payment, extra, principal, interest, ending balance and cumulative interest

• Comparison columns for the same loan with no extra payments

• Dashboard: monthly payment, total interest with and without extra, interest saved, months saved, payoff date, total extra paid

• Year-by-year summary table, balance line chart and principal vs interest chart

• Start Here sheet with step-by-step instructions and a sample loan

BEST FOR

• Homeowners planning extra mortgage payments

• Car, student and personal loan borrowers with a fixed rate

• Anyone deciding between paying off debt early or saving

HOW IT WORKS

1. Type your loan details in the yellow cells

2. Add an extra monthly payment or a lump sum

3. Read the interest saved and new payoff date on the Dashboard

IMPORTANT

For information only - not financial advice. Covers principal and interest only (no taxes, insurance, PMI or escrow); your lender's figures can differ slightly because of rounding and day count.

FORMAT / DELIVERY

• Microsoft Excel .xlsx (no macros) - also opens in Google Sheets

• Instant digital download - no physical item is shipped

FAQ

What exactly do I get?

Loan amortization schedule Excel template with extra payments: every payment, principal vs interest, interest saved, payoff date.

What do I need to use it?

Microsoft Excel on Windows or Mac (Excel 2016 or newer, or Microsoft 365). It also opens in free Google Sheets, though Excel is recommended.

How do I get it?

It is an instant digital download: right after payment you get the file on the page and by email. No physical item is shipped.

What if it is not right for me?

Contact me through my Payhip store within 30 days and I will refund you - no hard feelings.

I have a question

Use the contact link on my Payhip store page and I will help.