 |
| Advanced | Simple | Home Equity | Refinance | HELOC | Recast | Early Payoff | Widget |
Credit Card Payoff Calculator Excel
Credit Card Payoff Calculator Excel to calculate early payoff for your credit card. Enter the current balance, interest rate, monthly payment, and the number of years that you wish to pay off your credit card. You will be shown a new credit card amortization schedule which is exportable to excel.
Original vs. Early Payoff |
||||||
| Original | Early Payoff | |||||
|---|---|---|---|---|---|---|
Monthly Payment |
$200.00 | $300.00 |
||||
Expected Payoff Time |
62 months | 35 months |
||||
Total Interest |
$4,308.98 | $2,293.42 | ||||
Total Principal |
$8,000.00 | $8,000.00 | ||||
Total Payment |
$12,308.98 | $10,293.42 | ||||
Total Interest Savings |
$0 | $2,015.56 | ||||
Payoff Date |
Sep, 2031 | Jun, 2029 | ||||
Early Payoff Amortization Schedule |
||||||
| Payment Date | Payment # | Interest Paid | Principal Paid | Total Payment | Remaining Balance | |
| Aug, 2026 | 1 | $120.00 | $180.00 | $300.00 | $7,820.00 | |
| Sep, 2026 | 2 | $117.30 | $182.70 | $300.00 | $7,637.30 | |
| Oct, 2026 | 3 | $114.56 | $185.44 | $300.00 | $7,451.86 | |
| Nov, 2026 | 4 | $111.78 | $188.22 | $300.00 | $7,263.64 | |
| Dec, 2026 | 5 | $108.95 | $191.05 | $300.00 | $7,072.59 | |
| Jan, 2027 | 6 | $106.09 | $193.91 | $300.00 | $6,878.68 | |
| Feb, 2027 | 7 | $103.18 | $196.82 | $300.00 | $6,681.86 | |
| Mar, 2027 | 8 | $100.23 | $199.77 | $300.00 | $6,482.09 | |
| Apr, 2027 | 9 | $97.23 | $202.77 | $300.00 | $6,279.32 | |
| May, 2027 | 10 | $94.19 | $205.81 | $300.00 | $6,073.51 | |
| Jun, 2027 | 11 | $91.10 | $208.90 | $300.00 | $5,864.61 | |
| Jul, 2027 | 12 | $87.97 | $212.03 | $300.00 | $5,652.58 | |
| Aug, 2027 | 13 | $84.79 | $215.21 | $300.00 | $5,437.37 | |
| Sep, 2027 | 14 | $81.56 | $218.44 | $300.00 | $5,218.93 | |
| Oct, 2027 | 15 | $78.28 | $221.72 | $300.00 | $4,997.22 | |
| Nov, 2027 | 16 | $74.96 | $225.04 | $300.00 | $4,772.17 | |
| Dec, 2027 | 17 | $71.58 | $228.42 | $300.00 | $4,543.76 | |
| Jan, 2028 | 18 | $68.16 | $231.84 | $300.00 | $4,311.91 | |
| Feb, 2028 | 19 | $64.68 | $235.32 | $300.00 | $4,076.59 | |
| Mar, 2028 | 20 | $61.15 | $238.85 | $300.00 | $3,837.74 | |
| Apr, 2028 | 21 | $57.57 | $242.43 | $300.00 | $3,595.31 | |
| May, 2028 | 22 | $53.93 | $246.07 | $300.00 | $3,349.24 | |
| Jun, 2028 | 23 | $50.24 | $249.76 | $300.00 | $3,099.47 | |
| Jul, 2028 | 24 | $46.49 | $253.51 | $300.00 | $2,845.97 | |
| Aug, 2028 | 25 | $42.69 | $257.31 | $300.00 | $2,588.66 | |
| Sep, 2028 | 26 | $38.83 | $261.17 | $300.00 | $2,327.49 | |
| Oct, 2028 | 27 | $34.91 | $265.09 | $300.00 | $2,062.40 | |
| Nov, 2028 | 28 | $30.94 | $269.06 | $300.00 | $1,793.33 | |
| Dec, 2028 | 29 | $26.90 | $273.10 | $300.00 | $1,520.23 | |
| Jan, 2029 | 30 | $22.80 | $277.20 | $300.00 | $1,243.04 | |
| Feb, 2029 | 31 | $18.65 | $281.35 | $300.00 | $961.68 | |
| Mar, 2029 | 32 | $14.43 | $285.57 | $300.00 | $676.11 | |
| Apr, 2029 | 33 | $10.14 | $289.86 | $300.00 | $386.25 | |
| May, 2029 | 34 | $5.79 | $294.21 | $300.00 | $92.04 | |
| Jun, 2029 | 35 | $1.38 | $92.04 | $93.42 | $0.00 | |
Mortgage Calculator | Terms | Privacy | Disclaimer | Contact
©2026 Mortgage Calculator