![]() |
Advanced | Simple | Early Payoff | Refinance | HELOC | Recast | Interest Only | Biweekly | Extra Payments | Mortgage Rates | Free Widget |
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.
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 |
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 | Amortization Schedule | Terms | Privacy | Disclaimer | Contact
©2023 Mortgage Calculator Excel