Compare Today's Home Equity Rates

Mortgage Payoff Calculator Excel

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.

Loan Payoff Calculator

Mortgage Balance
\$
Interest Rate
Current Monthly Payment
\$
Extra Monthly Payment
\$
OR
Desired Payoff Years
years

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
Aug, 2034 Jan, 2033

Early Payoff Amortization Schedule

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

Mortgage Payoff Calculator With Extra Payments

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.