mortgage calculator

Loan Payoff Calculator Excel

Loan Payoff Calculator Excel to calculate early payoff for your loan. You can use our Early Loan Payoff Calculator with amortization schedule for any type of loans, such as student loans, personal loans, home loans, personal loans, credit cards, and auto loans.

Early Loan Payoff Calculator

Loan Balance
$
Interest Rate
Current Monthly Payment
$
Extra Monthly Payment
$
OR
Desired Payoff Years
years

Original vs. Early Payoff

Original Early Payoff
Monthly Payment
$400.00
$530.00
Expected Payoff Time
32 months
24 months
Total Interest
$718.15 $537.46
Total Principal
$12,000.00 $12,000.00
Total Payment
$12,718.15 $12,537.46
Total Interest Savings
$0 $180.69
Payoff Date
Apr, 2026 Aug, 2025

Early Payoff Amortization Schedule

Payment Date Payment # Interest Paid Principal Paid Total Payment Remaining Balance
Sep, 2023 1 $43.00 $487.00 $530.00 $11,513.00
Oct, 2023 2 $41.25 $488.75 $530.00 $11,024.25
Nov, 2023 3 $39.50 $490.50 $530.00 $10,533.76
Dec, 2023 4 $37.75 $492.25 $530.00 $10,041.50
Jan, 2024 5 $35.98 $494.02 $530.00 $9,547.49
Feb, 2024 6 $34.21 $495.79 $530.00 $9,051.70
Mar, 2024 7 $32.44 $497.56 $530.00 $8,554.13
Apr, 2024 8 $30.65 $499.35 $530.00 $8,054.79
May, 2024 9 $28.86 $501.14 $530.00 $7,553.65
Jun, 2024 10 $27.07 $502.93 $530.00 $7,050.72
Jul, 2024 11 $25.27 $504.73 $530.00 $6,545.98
Aug, 2024 12 $23.46 $506.54 $530.00 $6,039.44
Sep, 2024 13 $21.64 $508.36 $530.00 $5,531.08
Oct, 2024 14 $19.82 $510.18 $530.00 $5,020.90
Nov, 2024 15 $17.99 $512.01 $530.00 $4,508.89
Dec, 2024 16 $16.16 $513.84 $530.00 $3,995.05
Jan, 2025 17 $14.32 $515.68 $530.00 $3,479.36
Feb, 2025 18 $12.47 $517.53 $530.00 $2,961.83
Mar, 2025 19 $10.61 $519.39 $530.00 $2,442.44
Apr, 2025 20 $8.75 $521.25 $530.00 $1,921.20
May, 2025 21 $6.88 $523.12 $530.00 $1,398.08
Jun, 2025 22 $5.01 $524.99 $530.00 $873.09
Jul, 2025 23 $3.13 $526.87 $530.00 $346.22
Aug, 2025 24 $1.24 $346.22 $347.46 $0.00

Early Loan Payoff Calculator

The loan amortization schedule is exportable in an excel format. You can pay off your loan by increasing your monthly payment or using the desired payoff time.

Check Today's Mortgage Rates
Today's Home Equity Rates



Mortgage Calculators

Refinance Calculators

Early Mortgage Payoff Calculators

Real Estate Investment Calculators





Mortgage Related Calculators

Auto Loan Calculators

Loan Calculators

Savings & Investments Calculators

Credit Card Calculators

Mortgage Guide

Mortgage Calculator Widget

Mortgage Calculator | Amortization Schedule | Terms | Privacy | Disclaimer | Contact

©2023 Mortgage Calculator Excel