Interest Rate IIM

	A	B	C	D	E	F	H	I	J	K	L	M	N	O	P	Q	R	T	U	V	W	Y	Z	AA	AB	AF
1
2				*Simple Interest will be charged during Moratorium and repayment months will include moratorium
3																		415055
4	Total Loan	2,000,000			Supreet good work. but problem in this is . if one person is entering his value then it is reflecting to others. so before checking our loan amount. it is modifying automatically as others are using same sheet																				2021
5	Interest Rate	8.50%	Include a % symbol	Cells in this colour must be filled						Yes, this came into my notice, the only way out is by downloading the sheet and using it on our own devices																415055
7						#N/A																				214221
8	How much would you be willing to pay per month			=	18,000	#N/A																				214064
9																										445961
10	Total Amount you will be repaying by the end of			all	Months	$4,606,024																				445603
11																										213504
12	Calculation																									444572
13	Year	Initial Amount	Interest Amount		Net Interest	Net Amount																				213044
14	2021	1,000,000	85000		85000	1,085,000	Simple Interest																			2606024.121
15	2022	2,000,000	170000		255000	2,255,000			2024					2025				2028				2030
16	2023 - Month 1	1,982,000	14039		269039	2251039	Moratorium		1	2,521,055.00	17,857.47	2,538,912.47		1	2,519,276	17844.87482	2537121	1	2,512,941	17799.99677	2530741	1	2,507,729	17763.07722	2525492
17	2023 - Month 2	1,964,000	13912		282951	2,246,951			2	2,520,912.47	17,856.46	2,538,768.94		2	2,519,121	17843.77602	2,536,965	2	2,512,741	17798.58008	2,530,539	2	2,507,492	17761.39901	2,525,253
18	2023 - Month 3	1,946,000	13784		296735	2,242,735			3	2,520,768.94	17,855.45	2,538,624.38		3	2,518,965	17842.66943	2,536,808	3	2,512,539	17797.15335	2,530,336	3	2,507,253	17759.70892	2,525,013
19	2023 - Month 4	1,928,000	13657		310392	2,238,392			4	2,520,624.38	17,854.42	2,538,478.81		4	2,518,808	17841.555	2,536,649	4	2,512,336	17795.71652	2,530,132	4	2,507,013	17758.00686	2,524,771
20	2023 - Month 5	1,910,000	13529		323921	2,233,921			5	2,520,478.81	17,853.39	2,538,332.20		5	2,518,649	17840.43269	2,536,490	5	2,512,132	17794.26951	2,529,926	5	2,506,771	17756.29274	2,524,527
21	2023 - Month 6	1,892,000	13402		337323	2,229,323			6	2,520,332.20	17,852.35	2,538,184.55		6	2,518,490	17839.30242	2,536,329	6	2,511,926	17792.81226	2,529,719	6	2,506,527	17754.56648	2,524,282
22	2023 - Month 7	1,874,000	13274		350597	2,224,597			7	2,520,184.55	17,851.31	2,538,035.86		7	2,518,329	17838.16414	2,536,167	7	2,511,719	17791.34468	2,529,511	7	2,506,282	17752.828	2,524,034
23	2023 - Month 8	1,856,000	13147		363743	2,219,743			8	2,520,035.86	17,850.25	2,537,886.11		8	2,518,167	17837.0178	2,536,004	8	2,511,511	17789.8667	2,529,300	8	2,506,034	17751.0772	2,523,786
24	2023 - Month 9	1,838,000	13019		376763	2,214,763			9	2,519,886.11	17,849.19	2,537,735.30		9	2,518,004	17835.86335	2,535,840	9	2,511,300	17788.37826	2,529,089	9	2,505,786	17749.31399	2,523,535
25	2023 - Month 10	1,820,000	12892		389654	2,209,654			10	2,519,735.30	17,848.13	2,537,583.43		10	2,517,840	17834.70071	2,535,675	10	2,511,089	17786.87927	2,528,876	10	2,505,535	17747.5383	2,523,282
26	2023 - Month 11	1,802,000	12764		402418	2,204,418			11	2,519,583.43	17,847.05	2,537,430.48		11	2,517,675	17833.52984	2,535,508	11	2,510,876	17785.36967	2,528,661	11	2,505,282	17745.75003	2,523,028
27	2023 - Month 12	1,784,000	12637		415055	2,199,055			12	2,519,430.48	17,845.97	2,537,276.44		12	2,517,508	17832.35068	2,535,341	12	2,510,661	17783.84937	2,528,445	12	2,505,028	17743.94909	2,522,772
28			415055								214221					214064		2029		213504				213044
29	Year	Principal	Amt at the end of the year					2026	1	2,517,341	17831.16316	2535172	2027	1	2,515,234	17816.23952	2533050	1	2,510,445	17782.3183	2528227
30	2024	2,199,055	2,537,276			Compound Interest			2	2,517,172	17829.96724	2,535,002		2	2,515,050	17814.93789	2,532,865	2	2,510,227	17780.77639	2,528,008
31	2025	2,537,276	2,535,341						3	2,517,002	17828.76284	2,534,831		3	2,514,865	17813.62703	2,532,679	3	2,510,008	17779.22355	2,527,787
32	2026	2,535,341	2,533,234						4	2,516,831	17827.54991	2,534,658		4	2,514,679	17812.30689	2,532,491	4	2,509,787	17777.65972	2,527,565
33	2027	2,533,234	2,530,941						5	2,516,658	17826.32839	2,534,484		5	2,514,491	17810.97739	2,532,302	5	2,509,565	17776.08481	2,527,341
34	2028	2,530,941	2528445						6	2,516,484	17825.09821	2,534,310		6	2,514,302	17809.63848	2,532,112	6	2,509,341	17774.49875	2,527,115
35	2029	2,528,445	2525729						7	2,516,310	17823.85932	2,534,133		7	2,514,112	17808.29009	2,531,920	7	2,509,115	17772.90144	2,526,888
36	2030	2,525,729	2522772						8	2,516,133	17822.61166	2,533,956		8	2,513,920	17806.93214	2,531,727	8	2,508,888	17771.29283	2,526,660
37			False Means loan cleared						9	2,515,956	17821.35516	2,533,777		9	2,513,727	17805.56458	2,531,532	9	2,508,660	17769.67282	2,526,429
38									10	2,515,777	17820.08976	2,533,597		10	2,513,532	17804.18733	2,531,337	10	2,508,429	17768.04134	2,526,197
39									11	2,515,597	17818.8154	2,533,416		11	2,513,337	17802.80032	2,531,139	11	2,508,197	17766.3983	2,525,964
40									12	2,515,416	17817.532	2,533,234		12	2,513,139	17801.40349	2,530,941	12	2,507,964	17764.74362	2,525,729
41											445961					445603				444572
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74	1972
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101