![]() |
Advanced | Simple | Early Payoff | Refinance | HELOC | Recast | Interest Only | Biweekly | Extra Payments | Mortgage Rates | Free Widget |
Mortgage Payoff Calculator excel to calculate monthly mortgage payment and interest savings with accelerated payments and early mortgage payoff. The mortgage payoff calculator with extra payments shows an amortization schedule with the new accelerated monthly payment as well as interest and principal and you can export the result to excel. Get a comparison table that compares the original mortgage with the early payoff mortgage payments. To calculate mortgage payoff within a certain year instead of extra payments, please use the early mortgage payoff calculator.
Original vs. Early Payoff |
||||||
Original | Early Payoff | |||||
---|---|---|---|---|---|---|
Monthly Payment |
$2,000.00 | $2,300.00 |
||||
Expected Payoff Time |
122 months | 103 months |
||||
Total Interest |
$43,684.75 | $36,571.36 | ||||
Total Principal |
$200,000.00 | $200,000.00 | ||||
Total Payment |
$243,684.75 | $236,571.36 | ||||
Total Interest Savings |
$0 | $7,113.38 | ||||
Payoff Date |
Dec, 2033 | May, 2032 | ||||
Early Payoff Amortization Schedule |
||||||
Payment Date | Payment # | Interest Paid | Principal Paid | Total Payment | Remaining Balance | |
Nov, 2023 | 1 | $666.67 | $1,633.33 | $2,300.00 | $198,366.67 | |
Dec, 2023 | 2 | $661.22 | $1,638.78 | $2,300.00 | $196,727.89 | |
Jan, 2024 | 3 | $655.76 | $1,644.24 | $2,300.00 | $195,083.65 | |
Feb, 2024 | 4 | $650.28 | $1,649.72 | $2,300.00 | $193,433.93 | |
Mar, 2024 | 5 | $644.78 | $1,655.22 | $2,300.00 | $191,778.71 | |
Apr, 2024 | 6 | $639.26 | $1,660.74 | $2,300.00 | $190,117.97 | |
May, 2024 | 7 | $633.73 | $1,666.27 | $2,300.00 | $188,451.70 | |
Jun, 2024 | 8 | $628.17 | $1,671.83 | $2,300.00 | $186,779.87 | |
Jul, 2024 | 9 | $622.60 | $1,677.40 | $2,300.00 | $185,102.47 | |
Aug, 2024 | 10 | $617.01 | $1,682.99 | $2,300.00 | $183,419.48 | |
Sep, 2024 | 11 | $611.40 | $1,688.60 | $2,300.00 | $181,730.87 | |
Oct, 2024 | 12 | $605.77 | $1,694.23 | $2,300.00 | $180,036.64 | |
Nov, 2024 | 13 | $600.12 | $1,699.88 | $2,300.00 | $178,336.77 | |
Dec, 2024 | 14 | $594.46 | $1,705.54 | $2,300.00 | $176,631.22 | |
Jan, 2025 | 15 | $588.77 | $1,711.23 | $2,300.00 | $174,919.99 | |
Feb, 2025 | 16 | $583.07 | $1,716.93 | $2,300.00 | $173,203.06 | |
Mar, 2025 | 17 | $577.34 | $1,722.66 | $2,300.00 | $171,480.40 | |
Apr, 2025 | 18 | $571.60 | $1,728.40 | $2,300.00 | $169,752.00 | |
May, 2025 | 19 | $565.84 | $1,734.16 | $2,300.00 | $168,017.84 | |
Jun, 2025 | 20 | $560.06 | $1,739.94 | $2,300.00 | $166,277.90 | |
Jul, 2025 | 21 | $554.26 | $1,745.74 | $2,300.00 | $164,532.16 | |
Aug, 2025 | 22 | $548.44 | $1,751.56 | $2,300.00 | $162,780.60 | |
Sep, 2025 | 23 | $542.60 | $1,757.40 | $2,300.00 | $161,023.21 | |
Oct, 2025 | 24 | $536.74 | $1,763.26 | $2,300.00 | $159,259.95 | |
Nov, 2025 | 25 | $530.87 | $1,769.13 | $2,300.00 | $157,490.82 | |
Dec, 2025 | 26 | $524.97 | $1,775.03 | $2,300.00 | $155,715.79 | |
Jan, 2026 | 27 | $519.05 | $1,780.95 | $2,300.00 | $153,934.84 | |
Feb, 2026 | 28 | $513.12 | $1,786.88 | $2,300.00 | $152,147.95 | |
Mar, 2026 | 29 | $507.16 | $1,792.84 | $2,300.00 | $150,355.11 | |
Apr, 2026 | 30 | $501.18 | $1,798.82 | $2,300.00 | $148,556.30 | |
May, 2026 | 31 | $495.19 | $1,804.81 | $2,300.00 | $146,751.49 | |
Jun, 2026 | 32 | $489.17 | $1,810.83 | $2,300.00 | $144,940.66 | |
Jul, 2026 | 33 | $483.14 | $1,816.86 | $2,300.00 | $143,123.79 | |
Aug, 2026 | 34 | $477.08 | $1,822.92 | $2,300.00 | $141,300.87 | |
Sep, 2026 | 35 | $471.00 | $1,829.00 | $2,300.00 | $139,471.88 | |
Oct, 2026 | 36 | $464.91 | $1,835.09 | $2,300.00 | $137,636.78 | |
Nov, 2026 | 37 | $458.79 | $1,841.21 | $2,300.00 | $135,795.57 | |
Dec, 2026 | 38 | $452.65 | $1,847.35 | $2,300.00 | $133,948.22 | |
Jan, 2027 | 39 | $446.49 | $1,853.51 | $2,300.00 | $132,094.72 | |
Feb, 2027 | 40 | $440.32 | $1,859.68 | $2,300.00 | $130,235.03 | |
Mar, 2027 | 41 | $434.12 | $1,865.88 | $2,300.00 | $128,369.15 | |
Apr, 2027 | 42 | $427.90 | $1,872.10 | $2,300.00 | $126,497.05 | |
May, 2027 | 43 | $421.66 | $1,878.34 | $2,300.00 | $124,618.70 | |
Jun, 2027 | 44 | $415.40 | $1,884.60 | $2,300.00 | $122,734.10 | |
Jul, 2027 | 45 | $409.11 | $1,890.89 | $2,300.00 | $120,843.21 | |
Aug, 2027 | 46 | $402.81 | $1,897.19 | $2,300.00 | $118,946.02 | |
Sep, 2027 | 47 | $396.49 | $1,903.51 | $2,300.00 | $117,042.51 | |
Oct, 2027 | 48 | $390.14 | $1,909.86 | $2,300.00 | $115,132.65 | |
Nov, 2027 | 49 | $383.78 | $1,916.22 | $2,300.00 | $113,216.43 | |
Dec, 2027 | 50 | $377.39 | $1,922.61 | $2,300.00 | $111,293.82 | |
Jan, 2028 | 51 | $370.98 | $1,929.02 | $2,300.00 | $109,364.79 | |
Feb, 2028 | 52 | $364.55 | $1,935.45 | $2,300.00 | $107,429.34 | |
Mar, 2028 | 53 | $358.10 | $1,941.90 | $2,300.00 | $105,487.44 | |
Apr, 2028 | 54 | $351.62 | $1,948.38 | $2,300.00 | $103,539.07 | |
May, 2028 | 55 | $345.13 | $1,954.87 | $2,300.00 | $101,584.20 | |
Jun, 2028 | 56 | $338.61 | $1,961.39 | $2,300.00 | $99,622.81 | |
Jul, 2028 | 57 | $332.08 | $1,967.92 | $2,300.00 | $97,654.89 | |
Aug, 2028 | 58 | $325.52 | $1,974.48 | $2,300.00 | $95,680.40 | |
Sep, 2028 | 59 | $318.93 | $1,981.07 | $2,300.00 | $93,699.34 | |
Oct, 2028 | 60 | $312.33 | $1,987.67 | $2,300.00 | $91,711.67 | |
Nov, 2028 | 61 | $305.71 | $1,994.29 | $2,300.00 | $89,717.37 | |
Dec, 2028 | 62 | $299.06 | $2,000.94 | $2,300.00 | $87,716.43 | |
Jan, 2029 | 63 | $292.39 | $2,007.61 | $2,300.00 | $85,708.82 | |
Feb, 2029 | 64 | $285.70 | $2,014.30 | $2,300.00 | $83,694.52 | |
Mar, 2029 | 65 | $278.98 | $2,021.02 | $2,300.00 | $81,673.50 | |
Apr, 2029 | 66 | $272.24 | $2,027.76 | $2,300.00 | $79,645.74 | |
May, 2029 | 67 | $265.49 | $2,034.51 | $2,300.00 | $77,611.23 | |
Jun, 2029 | 68 | $258.70 | $2,041.30 | $2,300.00 | $75,569.93 | |
Jul, 2029 | 69 | $251.90 | $2,048.10 | $2,300.00 | $73,521.83 | |
Aug, 2029 | 70 | $245.07 | $2,054.93 | $2,300.00 | $71,466.91 | |
Sep, 2029 | 71 | $238.22 | $2,061.78 | $2,300.00 | $69,405.13 | |
Oct, 2029 | 72 | $231.35 | $2,068.65 | $2,300.00 | $67,336.48 | |
Nov, 2029 | 73 | $224.45 | $2,075.55 | $2,300.00 | $65,260.93 | |
Dec, 2029 | 74 | $217.54 | $2,082.46 | $2,300.00 | $63,178.47 | |
Jan, 2030 | 75 | $210.59 | $2,089.41 | $2,300.00 | $61,089.07 | |
Feb, 2030 | 76 | $203.63 | $2,096.37 | $2,300.00 | $58,992.70 | |
Mar, 2030 | 77 | $196.64 | $2,103.36 | $2,300.00 | $56,889.34 | |
Apr, 2030 | 78 | $189.63 | $2,110.37 | $2,300.00 | $54,778.97 | |
May, 2030 | 79 | $182.60 | $2,117.40 | $2,300.00 | $52,661.57 | |
Jun, 2030 | 80 | $175.54 | $2,124.46 | $2,300.00 | $50,537.10 | |
Jul, 2030 | 81 | $168.46 | $2,131.54 | $2,300.00 | $48,405.56 | |
Aug, 2030 | 82 | $161.35 | $2,138.65 | $2,300.00 | $46,266.91 | |
Sep, 2030 | 83 | $154.22 | $2,145.78 | $2,300.00 | $44,121.14 | |
Oct, 2030 | 84 | $147.07 | $2,152.93 | $2,300.00 | $41,968.21 | |
Nov, 2030 | 85 | $139.89 | $2,160.11 | $2,300.00 | $39,808.10 | |
Dec, 2030 | 86 | $132.69 | $2,167.31 | $2,300.00 | $37,640.79 | |
Jan, 2031 | 87 | $125.47 | $2,174.53 | $2,300.00 | $35,466.26 | |
Feb, 2031 | 88 | $118.22 | $2,181.78 | $2,300.00 | $33,284.48 | |
Mar, 2031 | 89 | $110.95 | $2,189.05 | $2,300.00 | $31,095.43 | |
Apr, 2031 | 90 | $103.65 | $2,196.35 | $2,300.00 | $28,899.08 | |
May, 2031 | 91 | $96.33 | $2,203.67 | $2,300.00 | $26,695.41 | |
Jun, 2031 | 92 | $88.98 | $2,211.02 | $2,300.00 | $24,484.40 | |
Jul, 2031 | 93 | $81.61 | $2,218.39 | $2,300.00 | $22,266.01 | |
Aug, 2031 | 94 | $74.22 | $2,225.78 | $2,300.00 | $20,040.23 | |
Sep, 2031 | 95 | $66.80 | $2,233.20 | $2,300.00 | $17,807.03 | |
Oct, 2031 | 96 | $59.36 | $2,240.64 | $2,300.00 | $15,566.39 | |
Nov, 2031 | 97 | $51.89 | $2,248.11 | $2,300.00 | $13,318.28 | |
Dec, 2031 | 98 | $44.39 | $2,255.61 | $2,300.00 | $11,062.67 | |
Jan, 2032 | 99 | $36.88 | $2,263.12 | $2,300.00 | $8,799.55 | |
Feb, 2032 | 100 | $29.33 | $2,270.67 | $2,300.00 | $6,528.88 | |
Mar, 2032 | 101 | $21.76 | $2,278.24 | $2,300.00 | $4,250.64 | |
Apr, 2032 | 102 | $14.17 | $2,285.83 | $2,300.00 | $1,964.81 | |
May, 2032 | 103 | $6.55 | $1,964.81 | $1,971.36 | $0.00 |
This is a mortgage payoff calculator with extra principal payment, if you want to pay off your mortgage earlier within a certain year, you can use the early mortgage payoff calculator. The early mortgage payoff calculator will find out how much more you would have to increase your monthly mortgage payment in order to pay off your debt earlier. For a regular mortgage calculator, please use the mortgage calculator with pmi and taxes.
Mortgage Calculator | Amortization Schedule | Terms | Privacy | Disclaimer | Contact
©2023 Mortgage Calculator Excel