Mortgage Comparison

	A	B	C	D	E	G	H	I	J	K	L	N
1		EXISTING MORTGAGE					NEW MORTGAGE
2
3		$450,000.00	current				$462,500.00	loan amount		12,500.00	closing costs
4		312	term remaining (months)				360	term (months)
5		7.50%	annual interest rate				6.25%	annual interest rate
6
7		$3,282.33	P&I payment				$2,847.69	P&I payment
8
9	month	interest	principal	balance	total interest paid	month	interest	principal	balance	total interest paid	interest + costs	difference

10	0	0.00	0.00	450,000.00	0.00	0	0.00	0.00	462,500.00	0.00	12,500.00	12,500.00
11	1	2,812.50	469.83	449,530.17	2,812.50	1	2,408.85	438.84	462,061.16	2,408.85	14,908.85	12,096.35
12	2	2,809.56	472.77	449,057.40	5,622.06	2	2,406.57	441.12	461,620.04	4,815.42	17,315.42	11,693.36
13	3	2,806.61	475.72	448,581.67	8,428.67	3	2,404.27	443.42	461,176.62	7,219.69	19,719.69	11,291.02
14	4	2,803.64	478.70	448,102.97	11,232.31	4	2,401.96	445.73	460,730.89	9,621.66	22,121.66	10,889.35
15	5	2,800.64	481.69	447,621.28	14,032.95	5	2,399.64	448.05	460,282.84	12,021.30	24,521.30	10,488.34
16	6	2,797.63	484.70	447,136.58	16,830.58	6	2,397.31	450.39	459,832.45	14,418.60	26,918.60	10,088.02
17	7	2,794.60	487.73	446,648.85	19,625.19	7	2,394.96	452.73	459,379.72	16,813.56	29,313.56	9,688.37
18	8	2,791.56	490.78	446,158.08	22,416.74	8	2,392.60	455.09	458,924.63	19,206.17	31,706.17	9,289.42
19	9	2,788.49	493.85	445,664.23	25,205.23	9	2,390.23	457.46	458,467.17	21,596.40	34,096.40	8,891.17
20	10	2,785.40	496.93	445,167.30	27,990.63	10	2,387.85	459.84	458,007.33	23,984.25	36,484.25	8,493.61
21	11	2,782.30	500.04	444,667.26	30,772.93	11	2,385.45	462.24	457,545.09	26,369.70	38,869.70	8,096.77
22	12	2,779.17	503.16	444,164.10	33,552.10	12	2,383.05	464.64	457,080.44	28,752.75	41,252.75	7,700.65
23	13	2,776.03	506.31	443,657.79	36,328.12	13	2,380.63	467.06	456,613.38	31,133.38	43,633.38	7,305.25
24	14	2,772.86	509.47	443,148.32	39,100.99	14	2,378.19	469.50	456,143.88	33,511.57	46,011.57	6,910.59
25	15	2,769.68	512.66	442,635.66	41,870.66	15	2,375.75	471.94	455,671.94	35,887.32	48,387.32	6,516.66
26	16	2,766.47	515.86	442,119.80	44,637.14	16	2,373.29	474.40	455,197.54	38,260.61	50,760.61	6,123.48
27	17	2,763.25	519.08	441,600.71	47,400.38	17	2,370.82	476.87	454,720.67	40,631.43	53,131.43	5,731.05
28	18	2,760.00	522.33	441,078.39	50,160.39	18	2,368.34	479.36	454,241.31	42,999.77	55,499.77	5,339.38
29	19	2,756.74	525.59	440,552.79	52,917.13	19	2,365.84	481.85	453,759.46	45,365.61	57,865.61	4,948.48
30	20	2,753.45	528.88	440,023.91	55,670.58	20	2,363.33	484.36	453,275.10	47,728.94	60,228.94	4,558.36
31	21	2,750.15	532.18	439,491.73	58,420.73	21	2,360.81	486.88	452,788.22	50,089.75	62,589.75	4,169.02
32	22	2,746.82	535.51	438,956.22	61,167.56	22	2,358.27	489.42	452,298.79	52,448.02	64,948.02	3,780.46
33	23	2,743.48	538.86	438,417.36	63,911.03	23	2,355.72	491.97	451,806.83	54,803.74	67,303.74	3,392.71
34	24	2,740.11	542.22	437,875.14	66,651.14	24	2,353.16	494.53	451,312.29	57,156.90	69,656.90	3,005.76
35	25	2,736.72	545.61	437,329.52	69,387.86	25	2,350.58	497.11	450,815.19	59,507.49	72,007.49	2,619.63
36	26	2,733.31	549.02	436,780.50	72,121.17	26	2,348.00	499.70	450,315.49	61,855.48	74,355.48	2,234.31
37	27	2,729.88	552.46	436,228.04	74,851.05	27	2,345.39	502.30	449,813.19	64,200.88	76,700.88	1,849.83
38	28	2,726.43	555.91	435,672.14	77,577.47	28	2,342.78	504.92	449,308.28	66,543.65	79,043.65	1,466.18
39	29	2,722.95	559.38	435,112.75	80,300.42	29	2,340.15	507.54	448,800.73	68,883.80	81,383.80	1,083.38
40	30	2,719.45	562.88	434,549.87	83,019.88	30	2,337.50	510.19	448,290.54	71,221.31	83,721.31	701.43
41	31	2,715.94	566.40	433,983.48	85,735.82	31	2,334.85	512.85	447,777.70	73,556.15	86,056.15	320.34
42	32	2,712.40	569.94	433,413.54	88,448.21	32	2,332.18	515.52	447,262.18	75,888.33	88,388.33	(59.88)
43	33	2,708.83	573.50	432,840.04	91,157.05	33	2,329.49	518.20	446,743.98	78,217.82	90,717.82	(439.23)
44	34	2,705.25	577.08	432,262.96	93,862.30	34	2,326.79	520.90	446,223.08	80,544.61	93,044.61	(817.69)
45	35	2,701.64	580.69	431,682.27	96,563.94	35	2,324.08	523.61	445,699.47	82,868.69	95,368.69	(1,195.25)
46	36	2,698.01	584.32	431,097.95	99,261.96	36	2,321.35	526.34	445,173.13	85,190.04	97,690.04	(1,571.92)
47	37	2,694.36	587.97	430,509.98	101,956.32	37	2,318.61	529.08	444,644.04	87,508.65	100,008.65	(1,947.67)
48	38	2,690.69	591.65	429,918.33	104,647.00	38	2,315.85	531.84	444,112.21	89,824.50	102,324.50	(2,322.50)
49	39	2,686.99	595.34	429,322.99	107,333.99	39	2,313.08	534.61	443,577.60	92,137.59	104,637.59	(2,696.41)
50	40	2,683.27	599.06	428,723.92	110,017.26	40	2,310.30	537.39	443,040.21	94,447.89	106,947.89	(3,069.37)
51	41	2,679.52	602.81	428,121.11	112,696.79	41	2,307.50	540.19	442,500.02	96,755.39	109,255.39	(3,441.40)
52	42	2,675.76	606.58	427,514.54	115,372.54	42	2,304.69	543.00	441,957.01	99,060.08	111,560.08	(3,812.47)
53	43	2,671.97	610.37	426,904.17	118,044.51	43	2,301.86	545.83	441,411.18	101,361.94	113,861.94	(4,182.57)
54	44	2,668.15	614.18	426,289.99	120,712.66	44	2,299.02	548.68	440,862.50	103,660.95	116,160.95	(4,551.71)
55	45	2,664.31	618.02	425,671.97	123,376.97	45	2,296.16	551.53	440,310.97	105,957.11	118,457.11	(4,919.86)
56	46	2,660.45	621.88	425,050.08	126,037.42	46	2,293.29	554.41	439,756.56	108,250.40	120,750.40	(5,287.03)
57	47	2,656.56	625.77	424,424.31	128,693.99	47	2,290.40	557.29	439,199.27	110,540.80	123,040.80	(5,653.19)
58	48	2,652.65	629.68	423,794.63	131,346.64	48	2,287.50	560.20	438,639.07	112,828.29	125,328.29	(6,018.35)
59	49	2,648.72	633.62	423,161.01	133,995.36	49	2,284.58	563.11	438,075.96	115,112.87	127,612.87	(6,382.48)
60	50	2,644.76	637.58	422,523.44	136,640.11	50	2,281.65	566.05	437,509.91	117,394.52	129,894.52	(6,745.59)
61	51	2,640.77	641.56	421,881.87	139,280.88	51	2,278.70	568.99	436,940.92	119,673.21	132,173.21	(7,107.67)
62	52	2,636.76	645.57	421,236.30	141,917.64	52	2,275.73	571.96	436,368.96	121,948.95	134,448.95	(7,468.70)
63	53	2,632.73	649.61	420,586.70	144,550.37	53	2,272.76	574.94	435,794.03	124,221.70	136,721.70	(7,828.67)
64	54	2,628.67	653.67	419,933.03	147,179.04	54	2,269.76	577.93	435,216.09	126,491.46	138,991.46	(8,187.57)
65	55	2,624.58	657.75	419,275.28	149,803.62	55	2,266.75	580.94	434,635.15	128,758.21	141,258.21	(8,545.40)
66	56	2,620.47	661.86	418,613.41	152,424.09	56	2,263.72	583.97	434,051.18	131,021.94	143,521.94	(8,902.15)
67	57	2,616.33	666.00	417,947.42	155,040.42	57	2,260.68	587.01	433,464.18	133,282.62	145,782.62	(9,257.80)
68	58	2,612.17	670.16	417,277.25	157,652.60	58	2,257.63	590.07	432,874.11	135,540.25	148,040.25	(9,612.35)
69	59	2,607.98	674.35	416,602.90	160,260.58	59	2,254.55	593.14	432,280.97	137,794.80	150,294.80	(9,965.78)
70	60	2,603.77	678.57	415,924.34	162,864.35	60	2,251.46	596.23	431,684.74	140,046.26	152,546.26	(10,318.08)
71	61	2,599.53	682.81	415,241.53	165,463.87	61	2,248.36	599.33	431,085.41	142,294.62	154,794.62	(10,669.25)
72	62	2,595.26	687.07	414,554.46	168,059.13	62	2,245.24	602.46	430,482.95	144,539.86	157,039.86	(11,019.27)
73	63	2,590.97	691.37	413,863.09	170,650.10	63	2,242.10	605.59	429,877.36	146,781.96	159,281.96	(11,368.14)
74	64	2,586.64	695.69	413,167.40	173,236.74	64	2,238.94	608.75	429,268.61	149,020.90	161,520.90	(11,715.84)
75	65	2,582.30	700.04	412,467.36	175,819.04	65	2,235.77	611.92	428,656.69	151,256.68	163,756.68	(12,062.36)
76	66	2,577.92	704.41	411,762.95	178,396.96	66	2,232.59	615.11	428,041.59	153,489.26	165,989.26	(12,407.70)
77	67	2,573.52	708.82	411,054.13	180,970.48	67	2,229.38	618.31	427,423.28	155,718.65	168,218.65	(12,751.83)
78	68	2,569.09	713.25	410,340.89	183,539.57	68	2,226.16	621.53	426,801.75	157,944.81	170,444.81	(13,094.76)
79	69	2,564.63	717.70	409,623.19	186,104.20	69	2,222.93	624.77	426,176.98	160,167.74	172,667.74	(13,436.46)
80	70	2,560.14	722.19	408,901.00	188,664.34	70	2,219.67	628.02	425,548.96	162,387.41	174,887.41	(13,776.93)
81	71	2,555.63	726.70	408,174.30	191,219.97	71	2,216.40	631.29	424,917.67	164,603.81	177,103.81	(14,116.17)
82	72	2,551.09	731.24	407,443.05	193,771.06	72	2,213.11	634.58	424,283.09	166,816.92	179,316.92	(14,454.14)
83	73	2,546.52	735.81	406,707.24	196,317.58	73	2,209.81	637.88	423,645.21	169,026.73	181,526.73	(14,790.85)
84	74	2,541.92	740.41	405,966.82	198,859.50	74	2,206.49	641.21	423,004.00	171,233.21	183,733.21	(15,126.29)
85	75	2,537.29	745.04	405,221.78	201,396.79	75	2,203.15	644.55	422,359.46	173,436.36	185,936.36	(15,460.43)
86	76	2,532.64	749.70	404,472.09	203,929.43	76	2,199.79	647.90	421,711.55	175,636.15	188,136.15	(15,793.28)
87	77	2,527.95	754.38	403,717.70	206,457.38	77	2,196.41	651.28	421,060.28	177,832.56	190,332.56	(16,124.82)
88	78	2,523.24	759.10	402,958.60	208,980.62	78	2,193.02	654.67	420,405.61	180,025.59	192,525.59	(16,455.03)
89	79	2,518.49	763.84	402,194.76	211,499.11	79	2,189.61	658.08	419,747.53	182,215.20	194,715.20	(16,783.91)
90	80	2,513.72	768.62	401,426.15	214,012.83	80	2,186.19	661.51	419,086.02	184,401.38	196,901.38	(17,111.44)
91	81	2,508.91	773.42	400,652.73	216,521.74	81	2,182.74	664.95	418,421.07	186,584.12	199,084.12	(17,437.62)
92	82	2,504.08	778.25	399,874.47	219,025.82	82	2,179.28	668.42	417,752.65	188,763.40	201,263.40	(17,762.42)
93	83	2,499.22	783.12	399,091.35	221,525.03	83	2,175.80	671.90	417,080.75	190,939.19	203,439.19	(18,085.84)
94	84	2,494.32	788.01	398,303.34	224,019.35	84	2,172.30	675.40	416,405.36	193,111.49	205,611.49	(18,407.87)
95	85	2,489.40	792.94	397,510.40	226,508.75	85	2,168.78	678.91	415,726.44	195,280.27	207,780.27	(18,728.48)
96	86	2,484.44	797.89	396,712.51	228,993.19	86	2,165.24	682.45	415,043.99	197,445.51	209,945.51	(19,047.68)
97	87	2,479.45	802.88	395,909.63	231,472.64	87	2,161.69	686.00	414,357.99	199,607.20	212,107.20	(19,365.45)
98	88	2,474.44	807.90	395,101.73	233,947.08	88	2,158.11	689.58	413,668.41	201,765.31	214,265.31	(19,681.77)
99	89	2,469.39	812.95	394,288.78	236,416.47	89	2,154.52	693.17	412,975.24	203,919.83	216,419.83	(19,996.63)
100	90	2,464.30	818.03	393,470.76	238,880.77	90	2,150.91	696.78	412,278.46	206,070.75	218,570.75	(20,310.02)