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		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

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.

Today's Home Equity Rates



Check Today's Mortgage Rates

Mortgage Calculators

Refinance Calculators

Early Mortgage Payoff Calculators

Real Estate Investment Calculators

Mortgage Related Calculators

Auto Loan Calculators

Loan Calculators

Savings & Investments Calculators

Credit Card Calculators

Mortgage Guide

Mortgage Calculator Widget