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