Mortgage_Calculator (1).xlsx

	B	C	D	E	F	G	I	J
1
2	Mortgage Payment Calculator
3
4	Payment Number	Balance	Payment	Principal	Interest	Balance	Mortgage Details
5	1	150,000.00	1,414.05	1,101.55	312.50	148,898.45	Mortgage Details
6	2	148,898.45	1,414.05	1,103.84	310.21	147,794.61	Mortgage Amount	150000.00
7	3	147,794.61	1,414.05	1,106.14	307.91	146,688.46	Interest Rate	2.5%
8	4	146,688.46	1,414.05	1,108.45	305.60	145,580.02	Amoritization Period (Years)	10
9	5	145,580.02	1,414.05	1,110.76	303.29	144,469.26	Number of payments per year	12
10	6	144,469.26	1,414.05	1,113.07	300.98	143,356.19	Total Number of Payments	120
11	7	143,356.19	1,414.05	1,115.39	298.66	142,240.80
12	8	142,240.80	1,414.05	1,117.71	296.33	141,123.09
13	9	141,123.09	1,414.05	1,120.04	294.01	140,003.04	Payment calculation
14	10	140,003.04	1,414.05	1,122.38	291.67	138,880.67	Payment calculation
15	11	138,880.67	1,414.05	1,124.71	289.33	137,755.95	Payment per Period	$1,414.05
16	12	137,755.95	1,414.05	1,127.06	286.99	136,628.90	Interest Payment	$19,685.82
17	13	136,628.90	1,414.05	1,129.40	284.64	135,499.49	Total Payment	$169,685.82
18	14	135,499.49	1,414.05	1,131.76	282.29	134,367.74
19	15	134,367.74	1,414.05	1,134.12	279.93	133,233.62
20	16	133,233.62	1,414.05	1,136.48	277.57	132,097.14
21	17	132,097.14	1,414.05	1,138.85	275.20	130,958.29
22	18	130,958.29	1,414.05	1,141.22	272.83	129,817.08
23	19	129,817.08	1,414.05	1,143.60	270.45	128,673.48
24	20	128,673.48	1,414.05	1,145.98	268.07	127,527.50
25	21	127,527.50	1,414.05	1,148.37	265.68	126,379.13
26	22	126,379.13	1,414.05	1,150.76	263.29	125,228.38
27	23	125,228.38	1,414.05	1,153.16	260.89	124,075.22
28	24	124,075.22	1,414.05	1,155.56	258.49	122,919.66
29	25	122,919.66	1,414.05	1,157.97	256.08	121,761.70
30	26	121,761.70	1,414.05	1,160.38	253.67	120,601.32
31	27	120,601.32	1,414.05	1,162.80	251.25	119,438.52
32	28	119,438.52	1,414.05	1,165.22	248.83	118,273.30
33	29	118,273.30	1,414.05	1,167.65	246.40	117,105.66
34	30	117,105.66	1,414.05	1,170.08	243.97	115,935.58
35	31	115,935.58	1,414.05	1,172.52	241.53	114,763.06
36	32	114,763.06	1,414.05	1,174.96	239.09	113,588.10
37	33	113,588.10	1,414.05	1,177.41	236.64	112,410.70
38	34	112,410.70	1,414.05	1,179.86	234.19	111,230.84
39	35	111,230.84	1,414.05	1,182.32	231.73	110,048.52
40	36	110,048.52	1,414.05	1,184.78	229.27	108,863.74
41	37	108,863.74	1,414.05	1,187.25	226.80	107,676.49
42	38	107,676.49	1,414.05	1,189.72	224.33	106,486.77
43	39	106,486.77	1,414.05	1,192.20	221.85	105,294.57
44	40	105,294.57	1,414.05	1,194.68	219.36	104,099.88
45	41	104,099.88	1,414.05	1,197.17	216.87	102,902.71
46	42	102,902.71	1,414.05	1,199.67	214.38	101,703.04
47	43	101,703.04	1,414.05	1,202.17	211.88	100,500.87
48	44	100,500.87	1,414.05	1,204.67	209.38	99,296.20
49	45	99,296.20	1,414.05	1,207.18	206.87	98,089.02
50	46	98,089.02	1,414.05	1,209.70	204.35	96,879.32
51	47	96,879.32	1,414.05	1,212.22	201.83	95,667.11
52	48	95,667.11	1,414.05	1,214.74	199.31	94,452.36
53	49	94,452.36	1,414.05	1,217.27	196.78	93,235.09
54	50	93,235.09	1,414.05	1,219.81	194.24	92,015.28
55	51	92,015.28	1,414.05	1,222.35	191.70	90,792.93
56	52	90,792.93	1,414.05	1,224.90	189.15	89,568.04
57	53	89,568.04	1,414.05	1,227.45	186.60	88,340.59
58	54	88,340.59	1,414.05	1,230.01	184.04	87,110.58
59	55	87,110.58	1,414.05	1,232.57	181.48	85,878.01
60	56	85,878.01	1,414.05	1,235.14	178.91	84,642.88
61	57	84,642.88	1,414.05	1,237.71	176.34	83,405.17
62	58	83,405.17	1,414.05	1,240.29	173.76	82,164.88
63	59	82,164.88	1,414.05	1,242.87	171.18	80,922.01
64	60	80,922.01	1,414.05	1,245.46	168.59	79,676.55
65	61	79,676.55	1,414.05	1,248.06	165.99	78,428.49
66	62	78,428.49	1,414.05	1,250.66	163.39	77,177.84
67	63	77,177.84	1,414.05	1,253.26	160.79	75,924.58
68	64	75,924.58	1,414.05	1,255.87	158.18	74,668.70
69	65	74,668.70	1,414.05	1,258.49	155.56	73,410.21
70	66	73,410.21	1,414.05	1,261.11	152.94	72,149.10
71	67	72,149.10	1,414.05	1,263.74	150.31	70,885.37
72	68	70,885.37	1,414.05	1,266.37	147.68	69,619.00
73	69	69,619.00	1,414.05	1,269.01	145.04	68,349.99
74	70	68,349.99	1,414.05	1,271.65	142.40	67,078.33
75	71	67,078.33	1,414.05	1,274.30	139.75	65,804.03
76	72	65,804.03	1,414.05	1,276.96	137.09	64,527.08
77	73	64,527.08	1,414.05	1,279.62	134.43	63,247.46
78	74	63,247.46	1,414.05	1,282.28	131.77	61,965.18
79	75	61,965.18	1,414.05	1,284.95	129.09	60,680.22
80	76	60,680.22	1,414.05	1,287.63	126.42	59,392.59
81	77	59,392.59	1,414.05	1,290.31	123.73	58,102.28
82	78	58,102.28	1,414.05	1,293.00	121.05	56,809.27
83	79	56,809.27	1,414.05	1,295.70	118.35	55,513.58
84	80	55,513.58	1,414.05	1,298.40	115.65	54,215.18
85	81	54,215.18	1,414.05	1,301.10	112.95	52,914.08
86	82	52,914.08	1,414.05	1,303.81	110.24	51,610.27
87	83	51,610.27	1,414.05	1,306.53	107.52	50,303.74
88	84	50,303.74	1,414.05	1,309.25	104.80	48,994.49
89	85	48,994.49	1,414.05	1,311.98	102.07	47,682.52
90	86	47,682.52	1,414.05	1,314.71	99.34	46,367.81
91	87	46,367.81	1,414.05	1,317.45	96.60	45,050.36
92	88	45,050.36	1,414.05	1,320.19	93.85	43,730.17
93	89	43,730.17	1,414.05	1,322.94	91.10	42,407.22
94	90	42,407.22	1,414.05	1,325.70	88.35	41,081.52
95	91	41,081.52	1,414.05	1,328.46	85.59	39,753.06
96	92	39,753.06	1,414.05	1,331.23	82.82	38,421.83
97	93	38,421.83	1,414.05	1,334.00	80.05	37,087.83
98	94	37,087.83	1,414.05	1,336.78	77.27	35,751.04
99	95	35,751.04	1,414.05	1,339.57	74.48	34,411.48
100	96	34,411.48	1,414.05	1,342.36	71.69	33,069.12