Prepayment Analyzer and EPR.xlsx

	A	B	C	D	E	F	G	H	J	K	L	M	N	O
1	Extra Payment Mortgage Calculator
2
3
4		Loan Information							Investment Comparison
5			Loan Amount	$ 450,000
6			Annual Interest Rate	7.50%	5.60%	Est. Effective Rate				After Tax Investment Return	7.50%
7			Remaining Term of Loan (in Years)	30
8			Extra Monthly Payment	$ 250
9										Months to Display	375
10
11		Loan Summary		Extra Payments	No Extra Payments					Years	31.25
12			Monthly Payment	$3,396.47	$3,146.47
13			Number of Payments	283	360						Loan 1	Loan 2
14			Total Payments	$959,786.78	$1,132,727.50					Home Equity	450,000	450,000
15			Total Interest	$509,786.78	$682,727.50					Investment	420,593	423,099
16
17			Payoff (in Years)	23.6
18			Interest Savings	$172,940.73
19
20								[42]
21	Month	Payment	Interest	Cumulative Interest	Principal	Cumulative Principal	Balance	Saved Interest	Investment Repayment	Interest Gained	Investment Value	Investment Overflow	Interest Gained	Investment Value
22							$450,000.00
23	1	3,396.47	2,812.50	2,812.50	583.97	583.97	449,416.03	0.00	250.00	0.00	250.00	0.00	0.00	0.00
24	2	3,396.47	2,808.85	5,621.35	587.62	1,171.58	448,828.42	1.56	250.00	1.56	501.56	0.00	0.00	0.00
25	3	3,396.47	2,805.18	8,426.53	591.29	1,762.87	448,237.13	3.13	250.00	3.13	754.70	0.00	0.00	0.00
26	4	3,396.47	2,801.48	11,228.01	594.98	2,357.85	447,642.15	4.72	250.00	4.72	1,009.41	0.00	0.00	0.00
27	5	3,396.47	2,797.76	14,025.77	598.70	2,956.55	447,043.45	6.31	250.00	6.31	1,265.72	0.00	0.00	0.00
28	6	3,396.47	2,794.02	16,819.79	602.44	3,559.00	446,441.00	7.91	250.00	7.91	1,523.63	0.00	0.00	0.00
29	7	3,396.47	2,790.26	19,610.05	606.21	4,165.21	445,834.79	9.52	250.00	9.52	1,783.16	0.00	0.00	0.00
30	8	3,396.47	2,786.47	22,396.52	610.00	4,775.20	445,224.80	11.14	250.00	11.14	2,044.30	0.00	0.00	0.00
31	9	3,396.47	2,782.65	25,179.17	613.81	5,389.01	444,610.99	12.78	250.00	12.78	2,307.08	0.00	0.00	0.00
32	10	3,396.47	2,778.82	27,957.99	617.65	6,006.66	443,993.34	14.42	250.00	14.42	2,571.50	0.00	0.00	0.00
33	11	3,396.47	2,774.96	30,732.95	621.51	6,628.17	443,371.83	16.07	250.00	16.07	2,837.57	0.00	0.00	0.00
34	12	3,396.47	2,771.07	33,504.02	625.39	7,253.56	442,746.44	17.73	250.00	17.73	3,105.30	0.00	0.00	0.00
35	13	3,396.47	2,767.17	36,271.19	629.30	7,882.86	442,117.14	19.41	250.00	19.41	3,374.71	0.00	0.00	0.00
36	14	3,396.47	2,763.23	39,034.42	633.23	8,516.09	441,483.91	21.09	250.00	21.09	3,645.80	0.00	0.00	0.00
37	15	3,396.47	2,759.27	41,793.70	637.19	9,153.28	440,846.72	22.79	250.00	22.79	3,918.59	0.00	0.00	0.00
38	16	3,396.47	2,755.29	44,548.99	641.17	9,794.46	440,205.54	24.49	250.00	24.49	4,193.08	0.00	0.00	0.00
39	17	3,396.47	2,751.28	47,300.27	645.18	10,439.64	439,560.36	26.21	250.00	26.21	4,469.29	0.00	0.00	0.00
40	18	3,396.47	2,747.25	50,047.53	649.21	11,088.85	438,911.15	27.93	250.00	27.93	4,747.22	0.00	0.00	0.00
41	19	3,396.47	2,743.19	52,790.72	653.27	11,742.12	438,257.88	29.67	250.00	29.67	5,026.89	0.00	0.00	0.00
42	20	3,396.47	2,739.11	55,529.83	657.35	12,399.47	437,600.53	31.42	250.00	31.42	5,308.31	0.00	0.00	0.00
43	21	3,396.47	2,735.00	58,264.84	661.46	13,060.94	436,939.06	33.18	250.00	33.18	5,591.49	0.00	0.00	0.00
44	22	3,396.47	2,730.87	60,995.70	665.60	13,726.53	436,273.47	34.95	250.00	34.95	5,876.43	0.00	0.00	0.00
45	23	3,396.47	2,726.71	63,722.41	669.76	14,396.29	435,603.71	36.73	250.00	36.73	6,163.16	0.00	0.00	0.00
46	24	3,396.47	2,722.52	66,444.94	673.94	15,070.23	434,929.77	38.52	250.00	38.52	6,451.68	0.00	0.00	0.00
47	25	3,396.47	2,718.31	69,163.25	678.15	15,748.38	434,251.62	40.32	250.00	40.32	6,742.00	0.00	0.00	0.00
48	26	3,396.47	2,714.07	71,877.32	682.39	16,430.78	433,569.22	42.14	250.00	42.14	7,034.14	0.00	0.00	0.00
49	27	3,396.47	2,709.81	74,587.13	686.66	17,117.43	432,882.57	43.96	250.00	43.96	7,328.10	0.00	0.00	0.00
50	28	3,396.47	2,705.52	77,292.64	690.95	17,808.38	432,191.62	45.80	250.00	45.80	7,623.91	0.00	0.00	0.00
51	29	3,396.47	2,701.20	79,993.84	695.27	18,503.65	431,496.35	47.65	250.00	47.65	7,921.55	0.00	0.00	0.00
52	30	3,396.47	2,696.85	82,690.69	699.61	19,203.27	430,796.73	49.51	250.00	49.51	8,221.06	0.00	0.00	0.00
53	31	3,396.47	2,692.48	85,383.17	703.99	19,907.25	430,092.75	51.38	250.00	51.38	8,522.45	0.00	0.00	0.00
54	32	3,396.47	2,688.08	88,071.25	708.39	20,615.64	429,384.36	53.27	250.00	53.27	8,825.71	0.00	0.00	0.00
55	33	3,396.47	2,683.65	90,754.91	712.81	21,328.45	428,671.55	55.16	250.00	55.16	9,130.87	0.00	0.00	0.00
56	34	3,396.47	2,679.20	93,434.10	717.27	22,045.72	427,954.28	57.07	250.00	57.07	9,437.94	0.00	0.00	0.00
57	35	3,396.47	2,674.71	96,108.82	721.75	22,767.47	427,232.53	58.99	250.00	58.99	9,746.93	0.00	0.00	0.00
58	36	3,396.47	2,670.20	98,779.02	726.26	23,493.73	426,506.27	60.92	250.00	60.92	10,057.85	0.00	0.00	0.00
59	37	3,396.47	2,665.66	101,444.68	730.80	24,224.53	425,775.47	62.86	250.00	62.86	10,370.71	0.00	0.00	0.00
60	38	3,396.47	2,661.10	104,105.78	735.37	24,959.90	425,040.10	64.82	250.00	64.82	10,685.52	0.00	0.00	0.00
61	39	3,396.47	2,656.50	106,762.28	739.96	25,699.86	424,300.14	66.78	250.00	66.78	11,002.31	0.00	0.00	0.00
62	40	3,396.47	2,651.88	109,414.16	744.59	26,444.45	423,555.55	68.76	250.00	68.76	11,321.07	0.00	0.00	0.00
63	41	3,396.47	2,647.22	112,061.38	749.24	27,193.70	422,806.30	70.76	250.00	70.76	11,641.83	0.00	0.00	0.00
64	42	3,396.47	2,642.54	114,703.92	753.93	27,947.62	422,052.38	72.76	250.00	72.76	11,964.59	0.00	0.00	0.00
65	43	3,396.47	2,637.83	117,341.75	758.64	28,706.26	421,293.74	74.78	250.00	74.78	12,289.37	0.00	0.00	0.00
66	44	3,396.47	2,633.09	119,974.83	763.38	29,469.64	420,530.36	76.81	250.00	76.81	12,616.18	0.00	0.00	0.00
67	45	3,396.47	2,628.31	122,603.15	768.15	30,237.79	419,762.21	78.85	250.00	78.85	12,945.03	0.00	0.00	0.00
68	46	3,396.47	2,623.51	125,226.66	772.95	31,010.74	418,989.26	80.91	250.00	80.91	13,275.94	0.00	0.00	0.00
69	47	3,396.47	2,618.68	127,845.34	777.78	31,788.53	418,211.47	82.97	250.00	82.97	13,608.91	0.00	0.00	0.00
70	48	3,396.47	2,613.82	130,459.17	782.64	32,571.17	417,428.83	85.06	250.00	85.06	13,943.97	0.00	0.00	0.00
71	49	3,396.47	2,608.93	133,068.10	787.54	33,358.70	416,641.30	87.15	250.00	87.15	14,281.12	0.00	0.00	0.00
72	50	3,396.47	2,604.01	135,672.10	792.46	34,151.16	415,848.84	89.26	250.00	89.26	14,620.37	0.00	0.00	0.00
73	51	3,396.47	2,599.06	138,271.16	797.41	34,948.57	415,051.43	91.38	250.00	91.38	14,961.75	0.00	0.00	0.00
74	52	3,396.47	2,594.07	140,865.23	802.39	35,750.96	414,249.04	93.51	250.00	93.51	15,305.26	0.00	0.00	0.00
75	53	3,396.47	2,589.06	143,454.29	807.41	36,558.37	413,441.63	95.66	250.00	95.66	15,650.92	0.00	0.00	0.00
76	54	3,396.47	2,584.01	146,038.30	812.46	37,370.83	412,629.17	97.82	250.00	97.82	15,998.74	0.00	0.00	0.00
77	55	3,396.47	2,578.93	148,617.23	817.53	38,188.36	411,811.64	99.99	250.00	99.99	16,348.73	0.00	0.00	0.00
78	56	3,396.47	2,573.82	151,191.05	822.64	39,011.00	410,989.00	102.18	250.00	102.18	16,700.91	0.00	0.00	0.00
79	57	3,396.47	2,568.68	153,759.73	827.78	39,838.79	410,161.21	104.38	250.00	104.38	17,055.29	0.00	0.00	0.00
80	58	3,396.47	2,563.51	156,323.24	832.96	40,671.75	409,328.25	106.60	250.00	106.60	17,411.89	0.00	0.00	0.00
81	59	3,396.47	2,558.30	158,881.54	838.16	41,509.91	408,490.09	108.82	250.00	108.82	17,770.71	0.00	0.00	0.00
82	60	3,396.47	2,553.06	161,434.61	843.40	42,353.31	407,646.69	111.07	250.00	111.07	18,131.78	0.00	0.00	0.00
83	61	3,396.47	2,547.79	163,982.40	848.67	43,201.99	406,798.01	113.32	250.00	113.32	18,495.10	0.00	0.00	0.00
84	62	3,396.47	2,542.49	166,524.88	853.98	44,055.96	405,944.04	115.59	250.00	115.59	18,860.69	0.00	0.00	0.00
85	63	3,396.47	2,537.15	169,062.03	859.32	44,915.28	405,084.72	117.88	250.00	117.88	19,228.57	0.00	0.00	0.00
86	64	3,396.47	2,531.78	171,593.81	864.69	45,779.96	404,220.04	120.18	250.00	120.18	19,598.75	0.00	0.00	0.00
87	65	3,396.47	2,526.38	174,120.19	870.09	46,650.05	403,349.95	122.49	250.00	122.49	19,971.24	0.00	0.00	0.00
88	66	3,396.47	2,520.94	176,641.13	875.53	47,525.58	402,474.42	124.82	250.00	124.82	20,346.06	0.00	0.00	0.00
89	67	3,396.47	2,515.47	179,156.59	881.00	48,406.58	401,593.42	127.16	250.00	127.16	20,723.23	0.00	0.00	0.00
90	68	3,396.47	2,509.96	181,666.55	886.51	49,293.09	400,706.91	129.52	250.00	129.52	21,102.75	0.00	0.00	0.00
91	69	3,396.47	2,504.42	184,170.97	892.05	50,185.14	399,814.86	131.89	250.00	131.89	21,484.64	0.00	0.00	0.00
92	70	3,396.47	2,498.84	186,669.81	897.62	51,082.76	398,917.24	134.28	250.00	134.28	21,868.92	0.00	0.00	0.00
93	71	3,396.47	2,493.23	189,163.04	903.23	51,985.99	398,014.01	136.68	250.00	136.68	22,255.60	0.00	0.00	0.00
94	72	3,396.47	2,487.59	191,650.63	908.88	52,894.87	397,105.13	139.10	250.00	139.10	22,644.70	0.00	0.00	0.00
95	73	3,396.47	2,481.91	194,132.54	914.56	53,809.43	396,190.57	141.53	250.00	141.53	23,036.23	0.00	0.00	0.00
96	74	3,396.47	2,476.19	196,608.73	920.27	54,729.70	395,270.30	143.98	250.00	143.98	23,430.20	0.00	0.00	0.00
97	75	3,396.47	2,470.44	199,079.17	926.03	55,655.73	394,344.27	146.44	250.00	146.44	23,826.64	0.00	0.00	0.00
98	76	3,396.47	2,464.65	201,543.82	931.81	56,587.54	393,412.46	148.92	250.00	148.92	24,225.56	0.00	0.00	0.00
99	77	3,396.47	2,458.83	204,002.65	937.64	57,525.18	392,474.82	151.41	250.00	151.41	24,626.97	0.00	0.00	0.00
100	78	3,396.47	2,452.97	206,455.62	943.50	58,468.68	391,531.32	153.92	250.00	153.92	25,030.89	0.00	0.00	0.00