Question

You have borrowed $100,000 on a 40-year mortgage with monthly payments. The annual interest rate is 16 percent. How much will you pay over the course of the loan? With four years left on the loan, how much will you still owe?

Excel

Answer 1

The calculation in excel of $ 100000 loan with annual interest rate of 16% and time period of 40 year is as follow:

Here we will use PMT formula,to first calculate monthly payments

i.e. = pmt(rate,nper,pv,fv, type)

Here rate is to be divided by 12 because of monthly payments.

nper, means no. of payment.In our case it is 480(40*12)

pv is $ 100000 which is to be shown in negative.

fv is 0

Type is either 0 or 1. 0 means payment at end of period and 1 means at the begining of period.In our case it is 0.

See the formula bar in below image:

Now to calculate interest, formula is:

=ipmt(rate,per,nper,pv,(fv),type)

Here rate is to be divided by 12 because of monthly payments.

per means period for which you want to calculate interest.

nper, means no. of payment.In our case it is 480(40*12)

pv is $ 100000 which is to be shown in negative.

fv is 0

Type is either 0 or 1. 0 means payment at end of period and 1 means at the begining of period.In our case it is 0.

See the formula bar in below image for reference.

Here you can see that I have use dollar sign for all cells, because I want cells to freeze, otherwise while dragging down formula will not work properly. But I dont use freezing for per i.e. E14 cell, because I want period to be changed while dragging.

Now to calculate principal payment, formula is:

=ppmt(rate,per,nper,pv,(fv),type)

Here rate is to be divided by 12 because of monthly payments.

per means period for which you want to calculate interest.

nper, means no. of payment.In our case it is 480(40*12)

pv is $ 100000 which is to be shown in negative.

fv is 0

Type is either 0 or 1. 0 means payment at end of period and 1 means at the begining of period.In our case it is 0.

See the formula bar in below image for reference.

Here you can see that I have use dollar sign for all cells, because I want cells to freeze, otherwise while dragging down formula will not work properly. But I dont use freezing for per i.e. E14 cell, because I want period to be changed while dragging.

Now the amortization with 4 years left on loan is as follow:

Period	EMI	Interest component	Principal Component	Outstanding Balance
0	-	-	-	100000.00
1	1335.65	1333.33	2.32	99997.68
2	1335.65	1333.30	2.35	99995.34
3	1335.65	1333.27	2.38	99992.96
4	1335.65	1333.24	2.41	99990.55
5	1335.65	1333.21	2.44	99988.11
6	1335.65	1333.17	2.47	99985.64
7	1335.65	1333.14	2.51	99983.13
8	1335.65	1333.11	2.54	99980.59
9	1335.65	1333.07	2.57	99978.02
10	1335.65	1333.04	2.61	99975.41
11	1335.65	1333.01	2.64	99972.77
12	1335.65	1332.97	2.68	99970.09
13	1335.65	1332.93	2.71	99967.37
14	1335.65	1332.90	2.75	99964.62
15	1335.65	1332.86	2.79	99961.84
16	1335.65	1332.82	2.82	99959.01
17	1335.65	1332.79	2.86	99956.15
18	1335.65	1332.75	2.90	99953.25
19	1335.65	1332.71	2.94	99950.31
20	1335.65	1332.67	2.98	99947.34
21	1335.65	1332.63	3.02	99944.32
22	1335.65	1332.59	3.06	99941.26
23	1335.65	1332.55	3.10	99938.16
24	1335.65	1332.51	3.14	99935.02
25	1335.65	1332.47	3.18	99931.84
26	1335.65	1332.42	3.22	99928.62
27	1335.65	1332.38	3.27	99925.35
28	1335.65	1332.34	3.31	99922.04
29	1335.65	1332.29	3.35	99918.69
30	1335.65	1332.25	3.40	99915.29
31	1335.65	1332.20	3.44	99911.84
32	1335.65	1332.16	3.49	99908.35
33	1335.65	1332.11	3.54	99904.81
34	1335.65	1332.06	3.58	99901.23
35	1335.65	1332.02	3.63	99897.60
36	1335.65	1331.97	3.68	99893.92
37	1335.65	1331.92	3.73	99890.19
38	1335.65	1331.87	3.78	99886.41
39	1335.65	1331.82	3.83	99882.58
40	1335.65	1331.77	3.88	99878.70
41	1335.65	1331.72	3.93	99874.77
42	1335.65	1331.66	3.98	99870.78
43	1335.65	1331.61	4.04	99866.74
44	1335.65	1331.56	4.09	99862.65
45	1335.65	1331.50	4.15	99858.50
46	1335.65	1331.45	4.20	99854.30
47	1335.65	1331.39	4.26	99850.04
48	1335.65	1331.33	4.31	99845.73
49	1335.65	1331.28	4.37	99841.36
50	1335.65	1331.22	4.43	99836.93
51	1335.65	1331.16	4.49	99832.44
52	1335.65	1331.10	4.55	99827.89
53	1335.65	1331.04	4.61	99823.28
54	1335.65	1330.98	4.67	99818.61
55	1335.65	1330.91	4.73	99813.87
56	1335.65	1330.85	4.80	99809.08
57	1335.65	1330.79	4.86	99804.22
58	1335.65	1330.72	4.93	99799.29
59	1335.65	1330.66	4.99	99794.30
60	1335.65	1330.59	5.06	99789.24
61	1335.65	1330.52	5.13	99784.12
62	1335.65	1330.45	5.19	99778.92
63	1335.65	1330.39	5.26	99773.66
64	1335.65	1330.32	5.33	99768.33
65	1335.65	1330.24	5.40	99762.92
66	1335.65	1330.17	5.48	99757.45
67	1335.65	1330.10	5.55	99751.90
68	1335.65	1330.03	5.62	99746.27
69	1335.65	1329.95	5.70	99740.58
70	1335.65	1329.87	5.77	99734.80
71	1335.65	1329.80	5.85	99728.95
72	1335.65	1329.72	5.93	99723.02
73	1335.65	1329.64	6.01	99717.01
74	1335.65	1329.56	6.09	99710.93
75	1335.65	1329.48	6.17	99704.76
76	1335.65	1329.40	6.25	99698.50
77	1335.65	1329.31	6.34	99692.17
78	1335.65	1329.23	6.42	99685.75
79	1335.65	1329.14	6.51	99679.24
80	1335.65	1329.06	6.59	99672.65
81	1335.65	1328.97	6.68	99665.97
82	1335.65	1328.88	6.77	99659.20
83	1335.65	1328.79	6.86	99652.34
84	1335.65	1328.70	6.95	99645.39
85	1335.65	1328.61	7.04	99638.35
86	1335.65	1328.51	7.14	99631.21
87	1335.65	1328.42	7.23	99623.98
88	1335.65	1328.32	7.33	99616.65
89	1335.65	1328.22	7.43	99609.23
90	1335.65	1328.12	7.53	99601.70
91	1335.65	1328.02	7.63	99594.08
92	1335.65	1327.92	7.73	99586.35
93	1335.65	1327.82	7.83	99578.52
94	1335.65	1327.71	7.93	99570.58
95	1335.65	1327.61	8.04	99562.54
96	1335.65	1327.50	8.15	99554.39
97	1335.65	1327.39	8.26	99546.14
98	1335.65	1327.28	8.37	99537.77
99	1335.65	1327.17	8.48	99529.29
100	1335.65	1327.06	8.59	99520.70
101	1335.65	1326.94	8.71	99512.00
102	1335.65	1326.83	8.82	99503.17
103	1335.65	1326.71	8.94	99494.23
104	1335.65	1326.59	9.06	99485.18
105	1335.65	1326.47	9.18	99476.00
106	1335.65	1326.35	9.30	99466.69
107	1335.65	1326.22	9.43	99457.27
108	1335.65	1326.10	9.55	99447.72
109	1335.65	1325.97	9.68	99438.04
110	1335.65	1325.84	9.81	99428.23
111	1335.65	1325.71	9.94	99418.29
112	1335.65	1325.58	10.07	99408.22
113	1335.65	1325.44	10.21	99398.01
114	1335.65	1325.31	10.34	99387.67
115	1335.65	1325.17	10.48	99377.19
116	1335.65	1325.03	10.62	99366.57
117	1335.65	1324.89	10.76	99355.81
118	1335.65	1324.74	10.90	99344.91
119	1335.65	1324.60	11.05	99333.86
120	1335.65	1324.45	11.20	99322.66
121	1335.65	1324.30	11.35	99311.32
122	1335.65	1324.15	11.50	99299.82
123	1335.65	1324.00	11.65	99288.17
124	1335.65	1323.84	11.81	99276.36
125	1335.65	1323.68	11.96	99264.40
126	1335.65	1323.53	12.12	99252.28
127	1335.65	1323.36	12.28	99239.99
128	1335.65	1323.20	12.45	99227.54
129	1335.65	1323.03	12.61	99214.93
130	1335.65	1322.87	12.78	99202.14
131	1335.65	1322.70	12.95	99189.19
132	1335.65	1322.52	13.13	99176.07
133	1335.65	1322.35	13.30	99162.76
134	1335.65	1322.17	13.48	99149.29
135	1335.65	1321.99	13.66	99135.63
136	1335.65	1321.81	13.84	99121.79
137	1335.65	1321.62	14.02	99107.76
138	1335.65	1321.44	14.21	99093.55
139	1335.65	1321.25	14.40	99079.15
140	1335.65	1321.06	14.59	99064.56
141	1335.65	1320.86	14.79	99049.77
142	1335.65	1320.66	14.98	99034.78
143	1335.65	1320.46	15.18	99019.60
144	1335.65	1320.26	15.39	99004.21
145	1335.65	1320.06	15.59	98988.62
146	1335.65	1319.85	15.80	98972.82
147	1335.65	1319.64	16.01	98956.81
148	1335.65	1319.42	16.22	98940.59
149	1335.65	1319.21	16.44	98924.14
150	1335.65	1318.99	16.66	98907.49
151	1335.65	1318.77	16.88	98890.60
152	1335.65	1318.54	17.11	98873.50
153	1335.65	1318.31	17.34	98856.16
154	1335.65	1318.08	17.57	98838.59
155	1335.65	1317.85	17.80	98820.79
156	1335.65	1317.61	18.04	98802.76
157	1335.65	1317.37	18.28	98784.48
158	1335.65	1317.13	18.52	98765.96
159	1335.65	1316.88	18.77	98747.19
160	1335.65	1316.63	19.02	98728.17
161	1335.65	1316.38	19.27	98708.89
162	1335.65	1316.12	19.53	98689.36
163	1335.65	1315.86	19.79	98669.57
164	1335.65	1315.59	20.05	98649.52
165	1335.65	1315.33	20.32	98629.20
166	1335.65	1315.06	20.59	98608.61
167	1335.65	1314.78	20.87	98587.74
168	1335.65	1314.50	21.15	98566.59
169	1335.65	1314.22	21.43	98545.17
170	1335.65	1313.94	21.71	98523.45
171	1335.65	1313.65	22.00	98501.45
172	1335.65	1313.35	22.30	98479.16
173	1335.65	1313.06	22.59	98456.56
174	1335.65	1312.75	22.89	98433.67
175	1335.65	1312.45	23.20	98410.47
176	1335.65	1312.14	23.51	98386.96
177	1335.65	1311.83	23.82	98363.14
178	1335.65	1311.51	24.14	98339.00
179	1335.65	1311.19	24.46	98314.54
180	1335.65	1310.86	24.79	98289.75
181	1335.65	1310.53	25.12	98264.63
182	1335.65	1310.20	25.45	98239.18
183	1335.65	1309.86	25.79	98213.38
184	1335.65	1309.51	26.14	98187.25
185	1335.65	1309.16	26.49	98160.76
186	1335.65	1308.81	26.84	98133.92
187	1335.65	1308.45	27.20	98106.73
188	1335.65	1308.09	27.56	98079.17
189	1335.65	1307.72	27.93	98051.24
190	1335.65	1307.35	28.30	98022.94
191	1335.65	1306.97	28.68	97994.27
192	1335.65	1306.59	29.06	97965.21
193	1335.65	1306.20	29.45	97935.76
194	1335.65	1305.81	29.84	97905.93
195	1335.65	1305.41	30.24	97875.69
196	1335.65	1305.01	30.64	97845.05
197	1335.65	1304.60	31.05	97814.00
198	1335.65	1304.19	31.46	97782.54
199	1335.65	1303.77	31.88	97750.66
200	1335.65	1303.34	32.31	97718.35
201	1335.65	1302.91	32.74	97685.62
202	1335.65	1302.47	33.17	97652.44
203	1335.65	1302.03	33.62	97618.83
204	1335.65	1301.58	34.06	97584.76
205	1335.65	1301.13	34.52	97550.24
206	1335.65	1300.67	34.98	97515.27
207	1335.65	1300.20	35.44	97479.82
208	1335.65	1299.73	35.92	97443.90
209	1335.65	1299.25	36.40	97407.51
210	1335.65	1298.77	36.88	97370.62
211	1335.65	1298.27	37.37	97333.25
212	1335.65	1297.78	37.87	97295.38
213	1335.65	1297.27	38.38	97257.00
214	1335.65	1296.76	38.89	97218.11
215	1335.65	1296.24	39.41	97178.71
216	1335.65	1295.72	39.93	97138.77
217	1335.65	1295.18	40.46	97098.31
218	1335.65	1294.64	41.00	97057.31
219	1335.65	1294.10	41.55	97015.75
220	1335.65	1293.54	42.11	96973.65
221	1335.65	1292.98	42.67	96930.98
222	1335.65	1292.41	43.24	96887.75
223	1335.65	1291.84	43.81	96843.94
224	1335.65	1291.25	44.40	96799.54
225	1335.65	1290.66	44.99	96754.55
226	1335.65	1290.06	45.59	96708.96
227	1335.65	1289.45	46.20	96662.77
228	1335.65	1288.84	46.81	96615.96
229	1335.65	1288.21	47.44	96568.52
230	1335.65	1287.58	48.07	96520.45
231	1335.65	1286.94	48.71	96471.74
232	1335.65	1286.29	49.36	96422.39
233	1335.65	1285.63	50.02	96372.37
234	1335.65	1284.96	50.68	96321.69
235	1335.65	1284.29	51.36	96270.33
236	1335.65	1283.60	52.04	96218.28
237	1335.65	1282.91	52.74	96165.54
238	1335.65	1282.21	53.44	96112.10
239	1335.65	1281.49	54.15	96057.95
240	1335.65	1280.77	54.88	96003.07
241	1335.65	1280.04	55.61	95947.47
242	1335.65	1279.30	56.35	95891.12
243	1335.65	1278.55	57.10	95834.02
244	1335.65	1277.79	57.86	95776.15
245	1335.65	1277.02	58.63	95717.52
246	1335.65	1276.23	59.41	95658.11
247	1335.65	1275.44	60.21	95597.90
248	1335.65	1274.64	61.01	95536.89
249	1335.65	1273.83	61.82	95475.07
250	1335.65	1273.00	62.65	95412.42
251	1335.65	1272.17	63.48	95348.94
252	1335.65	1271.32	64.33	95284.61
253	1335.65	1270.46	65.19	95219.42
254	1335.65	1269.59	66.06	95153.36
255	1335.65	1268.71	66.94	95086.43
256	1335.65	1267.82	67.83	95018.60
257	1335.65	1266.91	68.73	94949.86
258	1335.65	1266.00	69.65	94880.21
259	1335.65	1265.07	70.58	94809.63
260	1335.65	1264.13	71.52	94738.11
261	1335.65	1263.17	72.47	94665.64
262	1335.65	1262.21	73.44	94592.20
263	1335.65	1261.23	74.42	94517.78
264	1335.65	1260.24	75.41	94442.37
265	1335.65	1259.23	76.42	94365.95
266	1335.65	1258.21	77.44	94288.52
267	1335.65	1257.18	78.47	94210.05
268	1335.65	1256.13	79.51	94130.54
269	1335.65	1255.07	80.57	94049.96
270	1335.65	1254.00	81.65	93968.31
271	1335.65	1252.91	82.74	93885.57
272	1335.65	1251.81	83.84	93801.73
273	1335.65	1250.69	84.96	93716.77
274	1335.65	1249.56	86.09	93630.68
275	1335.65	1248.41	87.24	93543.44
276	1335.65	1247.25	88.40	93455.04
277	1335.65	1246.07	89.58	93365.46
278	1335.65	1244.87	90.78	93274.68
279	1335.65	1243.66	91.99	93182.70
280	1335.65	1242.44	93.21	93089.49
281	1335.65	1241.19	94.46	92995.03
282	1335.65	1239.93	95.71	92899.32
283	1335.65	1238.66	96.99	92802.32
284	1335.65	1237.36	98.28	92704.04
285	1335.65	1236.05	99.59	92604.45
286	1335.65	1234.73	100.92	92503.52
287	1335.65	1233.38	102.27	92401.26
288	1335.65	1232.02	103.63	92297.62
289	1335.65	1230.63	105.01	92192.61
290	1335.65	1229.23	106.41	92086.20
291	1335.65	1227.82	107.83	91978.36
292	1335.65	1226.38	109.27	91869.09
293	1335.65	1224.92	110.73	91758.37
294	1335.65	1223.44	112.20	91646.16
295	1335.65	1221.95	113.70	91532.46
296	1335.65	1220.43	115.22	91417.25
297	1335.65	1218.90	116.75	91300.50
298	1335.65	1217.34	118.31	91182.19
299	1335.65	1215.76	119.89	91062.30
300	1335.65	1214.16	121.48	90940.82
301	1335.65	1212.54	123.10	90817.71
302	1335.65	1210.90	124.75	90692.97
303	1335.65	1209.24	126.41	90566.56
304	1335.65	1207.55	128.09	90438.46
305	1335.65	1205.85	129.80	90308.66
306	1335.65	1204.12	131.53	90177.13
307	1335.65	1202.36	133.29	90043.84
308	1335.65	1200.58	135.06	89908.78
309	1335.65	1198.78	136.86	89771.91
310	1335.65	1196.96	138.69	89633.22
311	1335.65	1195.11	140.54	89492.69
312	1335.65	1193.24	142.41	89350.27
313	1335.65	1191.34	144.31	89205.96
314	1335.65	1189.41	146.24	89059.73
315	1335.65	1187.46	148.19	88911.54
316	1335.65	1185.49	150.16	88761.38
317	1335.65	1183.49	152.16	88609.22
318	1335.65	1181.46	154.19	88455.02
319	1335.65	1179.40	156.25	88298.77
320	1335.65	1177.32	158.33	88140.44
321	1335.65	1175.21	160.44	87980.00
322	1335.65	1173.07	162.58	87817.42
323	1335.65	1170.90	164.75	87652.67
324	1335.65	1168.70	166.95	87485.72
325	1335.65	1166.48	169.17	87316.55
326	1335.65	1164.22	171.43	87145.12
327	1335.65	1161.93	173.71	86971.41
328	1335.65	1159.62	176.03	86795.38
329	1335.65	1157.27	178.38	86617.00
330	1335.65	1154.89	180.76	86436.25
331	1335.65	1152.48	183.17	86253.08
332	1335.65	1150.04	185.61	86067.48
333	1335.65	1147.57	188.08	85879.39
334	1335.65	1145.06	190.59	85688.80
335	1335.65	1142.52	193.13	85495.67
336	1335.65	1139.94	195.71	85299.97
337	1335.65	1137.33	198.32	85101.65
338	1335.65	1134.69	200.96	84900.69
339	1335.65	1132.01	203.64	84697.05
340	1335.65	1129.29	206.35	84490.70
341	1335.65	1126.54	209.11	84281.59
342	1335.65	1123.75	211.89	84069.70
343	1335.65	1120.93	214.72	83854.98
344	1335.65	1118.07	217.58	83637.40
345	1335.65	1115.17	220.48	83416.91
346	1335.65	1112.23	223.42	83193.49
347	1335.65	1109.25	226.40	82967.09
348	1335.65	1106.23	229.42	82737.67
349	1335.65	1103.17	232.48	82505.19
350	1335.65	1100.07	235.58	82269.61
351	1335.65	1096.93	238.72	82030.89
352	1335.65	1093.75	241.90	81788.99
353	1335.65	1090.52	245.13	81543.86
354	1335.65	1087.25	248.40	81295.46
355	1335.65	1083.94	251.71	81043.75
356	1335.65	1080.58	255.07	80788.69
357	1335.65	1077.18	258.47	80530.22
358	1335.65	1073.74	261.91	80268.31
359	1335.65	1070.24	265.40	80002.90
360	1335.65	1066.71	268.94	79733.96
361	1335.65	1063.12	272.53	79461.43
362	1335.65	1059.49	276.16	79185.27
363	1335.65	1055.80	279.84	78905.42
364	1335.65	1052.07	283.58	78621.85
365	1335.65	1048.29	287.36	78334.49
366	1335.65	1044.46	291.19	78043.30
367	1335.65	1040.58	295.07	77748.23
368	1335.65	1036.64	299.01	77449.23
369	1335.65	1032.66	302.99	77146.23
370	1335.65	1028.62	307.03	76839.20
371	1335.65	1024.52	311.13	76528.08
372	1335.65	1020.37	315.27	76212.80
373	1335.65	1016.17	319.48	75893.32
374	1335.65	1011.91	323.74	75569.59
375	1335.65	1007.59	328.05	75241.53
376	1335.65	1003.22	332.43	74909.10
377	1335.65	998.79	336.86	74572.24
378	1335.65	994.30	341.35	74230.89
379	1335.65	989.75	345.90	73884.99
380	1335.65	985.13	350.52	73534.47
381	1335.65	980.46	355.19	73179.28
382	1335.65	975.72	359.92	72819.36
383	1335.65	970.92	364.72	72454.64
384	1335.65	966.06	369.59	72085.05
385	1335.65	961.13	374.51	71710.54
386	1335.65	956.14	379.51	71331.03
387	1335.65	951.08	384.57	70946.46
388	1335.65	945.95	389.70	70556.76
389	1335.65	940.76	394.89	70161.87
390	1335.65	935.49	400.16	69761.71
391	1335.65	930.16	405.49	69356.22
392	1335.65	924.75	410.90	68945.32
393	1335.65	919.27	416.38	68528.95
394	1335.65	913.72	421.93	68107.02
395	1335.65	908.09	427.55	67679.46
396	1335.65	902.39	433.26	67246.21
397	1335.65	896.62	439.03	66807.17
398	1335.65	890.76	444.89	66362.29
399	1335.65	884.83	450.82	65911.47
400	1335.65	878.82	456.83	65454.64
401	1335.65	872.73	462.92	64991.72
402	1335.65	866.56	469.09	64522.63
403	1335.65	860.30	475.35	64047.28
404	1335.65	853.96	481.68	63565.60
405	1335.65	847.54	488.11	63077.49
406	1335.65	841.03	494.62	62582.88
407	1335.65	834.44	501.21	62081.67
408	1335.65	827.76	507.89	61573.77
409	1335.65	820.98	514.66	61059.11
410	1335.65	814.12	521.53	60537.58
411	1335.65	807.17	528.48	60009.10
412	1335.65	800.12	535.53	59473.57
413	1335.65	792.98	542.67	58930.91
414	1335.65	785.75	549.90	58381.00
415	1335.65	778.41	557.24	57823.77
416	1335.65	770.98	564.66	57259.10
417	1335.65	763.45	572.19	56686.91
418	1335.65	755.83	579.82	56107.09
419	1335.65	748.09	587.55	55519.53
420	1335.65	740.26	595.39	54924.14
421	1335.65	732.32	603.33	54320.82
422	1335.65	724.28	611.37	53709.45
423	1335.65	716.13	619.52	53089.92
424	1335.65	707.87	627.78	52462.14
425	1335.65	699.50	636.15	51825.99
426	1335.65	691.01	644.64	51181.35
427	1335.65	682.42	653.23	50528.12
428	1335.65	673.71	661.94	49866.18
429	1335.65	664.88	670.77	49195.42
430	1335.65	655.94	679.71	48515.71
431	1335.65	646.88	688.77	47826.93
432	1335.65	637.69	697.96	47128.98

You can also refer below balance period of amortization:

Period

EMI

Interest component

Principal Component

Outstanding Balance

434	1335.65	618.96	716.69	45705.02
435	1335.65	609.40	726.25	44978.78
436	1335.65	599.72	735.93	44242.84
437	1335.65	589.90	745.74	43497.10
438	1335.65	579.96	755.69	42741.41
439	1335.65	569.89	765.76	41975.65
440	1335.65	559.68	775.97	41199.68
441	1335.65	549.33	786.32	40413.36
442	1335.65	538.84	796.80	39616.55
443	1335.65	528.22	807.43	38809.13
444	1335.65	517.46	818.19	37990.93
445	1335.65	506.55	829.10	37161.83
446	1335.65	495.49	840.16	36321.67
447	1335.65	484.29	851.36	35470.31
448	1335.65	472.94	862.71	34607.60
449	1335.65	461.43	874.21	33733.39
450	1335.65	449.78	885.87	32847.52
451	1335.65	437.97	897.68	31949.84
452	1335.65	426.00	909.65	31040.19
453	1335.65	413.87	921.78	30118.41
454	1335.65	401.58	934.07	29184.34
455	1335.65	389.12	946.52	28237.81
456	1335.65	376.50	959.14	27278.67
457	1335.65	363.72	971.93	26306.74
458	1335.65	350.76	984.89	25321.84
459	1335.65	337.62	998.02	24323.82
460	1335.65	324.32	1011.33	23312.49
461	1335.65	310.83	1024.82	22287.67
462	1335.65	297.17	1038.48	21249.19
463	1335.65	283.32	1052.33	20196.87
464	1335.65	269.29	1066.36	19130.51
465	1335.65	255.07	1080.57	18049.94
466	1335.65	240.67	1094.98	16954.95
467	1335.65	226.07	1109.58	15845.37
468	1335.65	211.27	1124.38	14720.99
469	1335.65	196.28	1139.37	13581.63
470	1335.65	181.09	1154.56	12427.07
471	1335.65	165.69	1169.95	11257.11
472	1335.65	150.09	1185.55	10071.56
473	1335.65	134.29	1201.36	8870.20
474	1335.65	118.27	1217.38	7652.82
475	1335.65	102.04	1233.61	6419.21
476	1335.65	85.59	1250.06	5169.15
477	1335.65	68.92	1266.73	3902.42
478	1335.65	52.03	1283.62	2618.81
479	1335.65	34.92	1300.73	1318.07
480	1335.65	17.57	1318.07	0.00

Further you can reduce outstanding balance like below and drag it.