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.

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