Scribd
Upload
77 views15 pages

IRR Calculator

The document details a loan with the following key information: - Original loan amount: Rs. 152,000 - Loan term: 18 months - Interest rate: 28% - Monthly installment: Rs. 10,438 - Total interest paid: Rs. 35,889 - Total payment: Rs. 187,889 The document then provides a monthly breakdown of the interest and principal portions of each installment over the 18 month loan term.

Uploaded by

Aman Garg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
77 views15 pages

IRR Calculator

The document details a loan with the following key information: - Original loan amount: Rs. 152,000 - Loan term: 18 months - Interest rate: 28% - Monthly installment: Rs. 10,438 - Total interest paid: Rs. 35,889 - Total payment: Rs. 187,889 The document then provides a monthly breakdown of the interest and principal portions of each installment over the 18 month loan term.

Uploaded by

Aman Garg
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 15

Loan Amount 152000 190000

Loan Term (Months) 18


Rate of Interest 28.00%
Monthly Installment 10438 347.94246
Total Interest 35889
Total Payment 187889

S.No Monthly Installment Interest Principal


0
1 10438 3547 6892
2 10438 3386 7052
3 10438 3221 7217
4 10438 3053 7385
5 10438 2881 7558
6 10438 2704 7734
7 10438 2524 7914
8 10438 2339 8099
9 10438 2150 8288
10 10438 1957 8482
11 10438 1759 8679
12 10438 1556 8882
13 10438 1349 9089
14 10438 1137 9301
15 10438 920 9518
16 10438 698 9740
17 10438 471 9968
18 10438 238 10200
19 0 0 0
20 0 0 0
21 0 0 0
22 0 0 0
23 0 0 0
24 0 0 0
25 0 0 0
26 0 0 0
27 0 0 0
28 0 0 0
29 0 0 0
30 0 0 0
31 0 0 0
32 0 0 0
33 0 0 0
34 0 0 0
35 0 0 0
36 0 0 0
37 0 0 0
38 0 0 0
39 0 0 0
40 0 0 0
41 0 0 0
42 0 0 0
43 0 0 0
44 0 0 0
45 0 0 0
46 0 0 0
47 0 0 0
48 0 0 0
49 0 0 0
50 0 0 0
51 0 0 0
52 0 0 0
53 0 0 0
54 0 0 0
55 0 0 0
56 0 0 0
57 0 0 0
58 0 0 0
59 0 0 0
60 0 0 0
61 0 0 0
62 0 0 0
63 0 0 0
64 0 0 0
65 0 0 0
66 0 0 0
67 0 0 0
68 0 0 0
69 0 0 0
70 0 0 0
71 0 0 0
72 0 0 0
73 0 0 0
74 0 0 0
75 0 0 0
76 0 0 0
77 0 0 0
78 0 0 0
79 0 0 0
80 0 0 0
81 0 0 0
82 0 0 0
83 0 0 0
84 0 0 0
85 0 0 0
86 0 0 0
87 0 0 0
88 0 0 0
89 0 0 0
90 0 0 0
91 0 0 0
92 0 0 0
93 0 0 0
94 0 0 0
95 0 0 0
96 0 0 0
97 0 0 0
98 0 0 0
99 0 0 0
100 0 0 0
101 0 0 0
102 0 0 0
103 0 0 0
104 0 0 0
105 0 0 0
106 0 0 0
107 0 0 0
108 0 0 0
109 0 0 0
110 0 0 0
111 0 0 0
112 0 0 0
113 0 0 0
114 0 0 0
115 0 0 0
116 0 0 0
117 0 0 0
118 0 0 0
119 0 0 0
120 0 0 0
121 0 0 0
122 0 0 0
123 0 0 0
124 0 0 0
125 0 0 0
126 0 0 0
127 0 0 0
128 0 0 0
129 0 0 0
130 0 0 0
131 0 0 0
132 0 0 0
133 0 0 0
134 0 0 0
135 0 0 0
136 0 0 0
137 0 0 0
138 0 0 0
139 0 0 0
140 0 0 0
141 0 0 0
142 0 0 0
143 0 0 0
144 0 0 0
145 0 0 0
146 0 0 0
147 0 0 0
148 0 0 0
149 0 0 0
150 0 0 0
151 0 0 0
152 0 0 0
153 0 0 0
154 0 0 0
155 0 0 0
156 0 0 0
157 0 0 0
158 0 0 0
159 0 0 0
160 0 0 0
161 0 0 0
162 0 0 0
163 0 0 0
164 0 0 0
165 0 0 0
166 0 0 0
167 0 0 0
168 0 0 0
169 0 0 0
170 0 0 0
171 0 0 0
172 0 0 0
173 0 0 0
174 0 0 0
175 0 0 0
176 0 0 0
177 0 0 0
178 0 0 0
179 0 0 0
180 0 0 0
181 0 0 0
182 0 0 0
183 0 0 0
184 0 0 0
185 0 0 0
186 0 0 0
187 0 0 0
188 0 0 0
189 0 0 0
190 0 0 0
191 0 0 0
192 0 0 0
193 0 0 0
194 0 0 0
195 0 0 0
196 0 0 0
197 0 0 0
198 0 0 0
199 0 0 0
200 0 0 0
201 0 0 0
202 0 0 0
203 0 0 0
204 0 0 0
205 0 0 0
206 0 0 0
207 0 0 0
208 0 0 0
209 0 0 0
210 0 0 0
211 0 0 0
212 0 0 0
213 0 0 0
214 0 0 0
215 0 0 0
216 0 0 0
217 0 0 0
218 0 0 0
219 0 0 0
220 0 0 0
221 0 0 0
222 0 0 0
223 0 0 0
224 0 0 0
225 0 0 0
226 0 0 0
227 0 0 0
228 0 0 0
229 0 0 0
230 0 0 0
231 0 0 0
232 0 0 0
233 0 0 0
234 0 0 0
235 0 0 0
236 0 0 0
237 0 0 0
238 0 0 0
239 0 0 0
240 0 0 0
Balance
152000
145108
138056
130839
123454
115896
108162
100247
92148
83860
75379
66699
57817
48728
39427
29908
20168
10200
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Transaction Type Transaction TAG Value (Sample Case)
Credit Approved Loan Amount 100000
Credit Approved Loan Tenure 5 Yrs
Credit Approved Interest Rate 15%
Credit Approved Monthly EMI INS 2379
Kotak Life Insurrance KLI 5000 Pass Through
Stamp Duty STR 333 Pass Through
Processing Fee / Service Charge SCR 666 Income
Acquisition Cost CAR 2000 Income
One Assist OAR 3000 Income
Brokerage Pay BP 555 Expense

Gross Payable to Customer DIS -100000


Agreement Value AGR_VALUE 110000
Amount Credited to Customer A/C 99001

Cust IRR cust_interest_rate 16.08%


Deal IRR 18.86%
Cashflows Cust IRR Deal IRR
0 -100000 -94889
1 2379 2379
2 2379 2379
3 2379 2379
4 2379 2379
5 2379 2379
6 2379 2379
7 2379 2379
8 2379 2379
9 2379 2379
10 2379 2379
11 2379 2379
12 2379 2379
13 2379 2379
14 2379 2379
15 2379 2379
16 2379 2379
17 2379 2379
18 2379 2379
19 2379 2379
20 2379 2379
21 2379 2379
22 2379 2379
23 2379 2379
24 2379 2379
25 2379 2379
26 2379 2379
27 2379 2379
28 2379 2379
29 2379 2379
30 2379 2379
31 2379 2379
32 2379 2379
33 2379 2379
34 2379 2379
35 2379 2379
36 2379 2379
37 2379 2379
38 2379 2379
39 2379 2379
40 2379 2379
41 2379 2379
42 2379 2379
43 2379 2379
44 2379 2379
45 2379 2379
46 2379 2379
47 2379 2379
48 2379 2379
49 2379 2379
50 2379 2379
51 2379 2379
52 2379 2379
53 2379 2379
54 2379 2379
55 2379 2379
56 2379 2379
57 2379 2379
58 2379 2379
59 2379 2379
60 2379 2379

You might also like