mortgage calculator
Compare Today's Home Equity Rates

Loan Payoff Calculator Excel

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

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
Jan, 2027 May, 2026

Early Payoff Amortization Schedule

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

Mortgage Calculator | Terms | Privacy | Disclaimer | Contact

©2024 Mortgage Calculator