emi calculation
DESCRIPTION
Emi Calculation in ExcelTRANSCRIPT
Start Date ###End date ###
### 400000 400000 400000 2909531 01-Jan-05 -5292 -8000 -9045 -9047
2 01-Feb-05 -5292 -8000 -9045 -9047
3 01-Mar-05 -5292 -8000 -9045 -9047
4 01-Apr-05 -5292 -8000 -9045 -9047
5 01-May-05 -5292 -8000 -9045 -9047
6 01-Jun-05 -5292 -8000 -9045 -9047
7 01-Jul-05 -5292 -8000 -9045 -9047
8 01-Aug-05 -5292 -8000 -9045 -9047
9 01-Sep-05 -5292 -8000 -9045 -9047
10 01-Oct-05 -5292 -8000 -9045 -9047
11 01-Nov-05 -5292 -8000 -9045 -9047
12 01-Dec-05 -5292 -8000 -9045 -9047
13 01-Jan-06 -5292 -8000 -9045 -9047
14 01-Feb-06 -5292 -8000 -9045 -9047
15 01-Mar-06 -5292 -8000 -9045 -9047
16 01-Apr-06 -5292 -8000 -9045 -9047
17 01-May-06 -5292 -8000 -9045 -9047
18 01-Jun-06 -5292 -8000 -9045 -9047
19 01-Jul-06 -5292 -8000 -9045 -9047
20 01-Aug-06 -5292 -8000 -9045 -9047
21 01-Sep-06 -5292 -8000 -9045 -9047
22 01-Oct-06 -5292 -8000 -9045 -9047
23 01-Nov-06 -5292 -8000 -9045 -9047
24 01-Dec-06 -5292 -8000 -9045 -9047
25 01-Jan-07 -5292 -8000 -9045 -9047
26 01-Feb-07 -5292 -8000 -9045 -9047
27 01-Mar-07 -5292 -8000 -9045 -9047
28 01-Apr-07 -5292 -8000 -9045 -9047
29 01-May-07 -5292 -8000 -9045 -9047
30 01-Jun-07 -5292 -8000 -9045 -9047
31 01-Jul-07 -5292 -8000 -9045 -9047
32 01-Aug-07 -5292 -8000 -9045 -9047
33 01-Sep-07 -5292 -8000 -9045 -9047
34 01-Oct-07 -5292 -8000 -9045 -9047
35 01-Nov-07 -5292 -8000 -9045 -9047
36 01-Dec-07 -5292 -8000 -9045
37 01-Jan-08 -5292 -8000 -9045
38 01-Feb-08 -5292 -8000 -9045
39 01-Mar-08 -5292 -8000 -9045
40 01-Apr-08 -5292 -8000 -9045
41 01-May-08 -5292 -8000 -9045
42 01-Jun-08 -5292 -8000 -9045
43 01-Jul-08 -5292 -8000 -9045
44 01-Aug-08 -5292 -8000 -9045 6.26%
45 01-Sep-08 -5292 -8000 -9045
46 01-Oct-08 -5292 -8000 -9045
47 01-Nov-08 -5292 -8000 -9045
48 01-Dec-08 -5292 -8000 -9045
49 01-Jan-09 -5292 -8000
50 01-Feb-09 -5292 -8000
51 01-Mar-09 -5292 -8000 4.34%
52 01-Apr-09 -5292 -8000
53 01-May-09 -5292 -8000
54 01-Jun-09 -5292 -8000
55 01-Jul-09 -5292 -8000
56 01-Aug-09 -5292 -8000
57 01-Sep-09 -5292 -8000
58 01-Oct-09 -5292 -8000
59 01-Nov-09 -5292 -8000
60 01-Dec-09 -5292 -8000
61 01-Jan-10 -5292
62 01-Feb-10 -5292
63 01-Mar-10 -5292
64 01-Apr-10 -5292 7.97%
65 01-May-10 -5292
66 01-Jun-10 -5292
67 01-Jul-10 -5292
68 01-Aug-10 -5292
69 01-Sep-10 -5292
70 01-Oct-10 -5292
71 01-Nov-10 -5292
72 01-Dec-10 -5292
73 01-Jan-11 -5292
74 01-Feb-11 -5292
75 01-Mar-11 -5292
76 01-Apr-11 -5292
77 01-May-11 -5292
78 01-Jun-11 -5292
79 01-Jul-11 -5292
80 01-Aug-11 -5292
81 01-Sep-11 -5292
82 01-Oct-11 -5292
83 01-Nov-11 -5292
84 01-Dec-11 -5292
85 01-Jan-12 -5292
86 01-Feb-12 -5292
87 01-Mar-12 -5292
88 01-Apr-12 -5292
89 01-May-12 -5292
90 01-Jun-12 -5292
91 01-Jul-12 -5292
92 01-Aug-12 -5292
93 01-Sep-12 -5292
94 01-Oct-12 -5292
95 01-Nov-12 -5292
96 01-Dec-12 -5292
97 01-Jan-13 -5292
98 01-Feb-13 -5292
99 01-Mar-13 -5292
100 01-Apr-13 -5292
101 01-May-13 -5292
102 01-Jun-13 -5292
103 01-Jul-13 -5292
104 01-Aug-13 -5292
105 01-Sep-13 -5292
106 01-Oct-13 -5292
107 01-Nov-13 -5292
108 01-Dec-13 -5292
109 01-Jan-14 -5292
110 01-Feb-14 -5292
111 01-Mar-14 -5292
112 01-Apr-14 -5292
113 01-May-14 -5292
114 01-Jun-14 -5292
115 01-Jul-14 -5292
116 01-Aug-14 -5292
117 01-Sep-14 -5292
118 01-Oct-14 -5292
119 01-Nov-14 -5292
120 01-Dec-14 -5292
121 01-Jan-15 -5292
122 01-Feb-15 -5292
123 01-Mar-15 -5292
124 01-Apr-15 -5292
125 01-May-15 -5292
126 01-Jun-15 -5292
127 01-Jul-15 -5292
128 01-Aug-15 -5292
129 01-Sep-15 -5292
130 01-Oct-15 -5292
131 01-Nov-15 -5292
132 01-Dec-15 -5292
133 01-Jan-16 -5292
134 01-Feb-16 -5292
135 01-Mar-16 -5292
136 01-Apr-16 -5292
137 01-May-16 -5292
138 01-Jun-16 -5292
139 01-Jul-16 -5292
140 01-Aug-16 -5292
141 01-Sep-16 -5292
142 01-Oct-16 -5292
143 01-Nov-16 -5292
144 01-Dec-16 -5292
145 01-Jan-17 -5292
146 01-Feb-17 -5292
147 01-Mar-17 -5292
148 01-Apr-17 -5292
149 01-May-17 -5292
150 01-Jun-17 -5292
151 01-Jul-17 -5292
152 01-Aug-17 -5292
153 01-Sep-17 -5292
154 01-Oct-17 -5292
155 01-Nov-17 -5292
156 01-Dec-17 -5292
157 01-Jan-18 -5292
158 01-Feb-18 -5292
159 01-Mar-18 -5292
160 01-Apr-18 -5292
161 01-May-18 -5292
162 01-Jun-18 -5292
163 01-Jul-18 -5292
164 01-Aug-18 -5292
165 01-Sep-18 -5292
166 01-Oct-18 -5292
167 01-Nov-18 -5292
168 01-Dec-18 -5292
169 01-Jan-19 -5292
170 01-Feb-19 -5292
171 01-Mar-19 -5292
172 01-Apr-19 -5292
173 01-May-19 -5292
174 01-Jun-19 -5292
175 01-Jul-19 -5292
176 01-Aug-19 -5292
177 01-Sep-19 -5292
178 01-Oct-19 -5292
179 01-Nov-19 -5292
180 01-Dec-19 -5292
15.05%
ROI 0.065 Daysyrs 3 MonthsPrin.Am3E+05 Days in yr
Mths in y
Daily Reducing Method
Numerator 1947.79Denominator 0.21529Result 9047.31
Monthly Reducing Method
Numerator 1973.84Denominator 0.21467Result 9194.7
Yearly Reducing Method
Numerator 23555Denominator 2.4954Result 9439.39
Start Date ### ROIEnd date ### yrs
Prin.Am
### 35000001 01-Jan-15 -38407
2 01-Feb-15 -38407
3 01-Mar-15 -38407 Numerator4 01-Apr-15 -38407 Denominator5 01-May-15 -38407 Result6 01-Jun-15 -38407
7 01-Jul-15 -38407
8 01-Aug-15 -38407
9 01-Sep-15 -38407 Numerator10 01-Oct-15 -38407 Denominator11 01-Nov-15 -38407 Result12 01-Dec-15 -38407
13 01-Jan-16 -38407
14 01-Feb-16 -38407
15 01-Mar-16 -38407 Numerator16 01-Apr-16 -38407 Denominator17 01-May-16 -38407 Result18 01-Jun-16 -38407
19 01-Jul-16 -38407
20 01-Aug-16 -38407
21 01-Sep-16 -38407
22 01-Oct-16 -38407
23 01-Nov-16 -38407
24 01-Dec-16 -38407
25 01-Jan-17 -38407
26 01-Feb-17 -38407
27 01-Mar-17 -38407
28 01-Apr-17 -38407
29 01-May-17 -38407
30 01-Jun-17 -38407
31 01-Jul-17 -38407
32 01-Aug-17 -38407
33 01-Sep-17 -38407
34 01-Oct-17 -38407
35 01-Nov-17 -38407
36 01-Dec-17 -38407
37 01-Jan-18 -38407
38 01-Feb-18 -38407
39 01-Mar-18 -38407
40 01-Apr-18 -38407
41 01-May-18 -38407
42 01-Jun-18 -38407
43 01-Jul-18 -38407
44 01-Aug-18 -38407
45 01-Sep-18 -38407
46 01-Oct-18 -38407
47 01-Nov-18 -38407
48 01-Dec-18 -38407
49 01-Jan-19 -38407
50 01-Feb-19 -38407
51 01-Mar-19 -38407
52 01-Apr-19 -38407
53 01-May-19 -38407
54 01-Jun-19 -38407
55 01-Jul-19 -38407
56 01-Aug-19 -38407
57 01-Sep-19 -38407
58 01-Oct-19 -38407
59 01-Nov-19 -38407
60 01-Dec-19 -38407
61 01-Jan-20 -38407
62 01-Feb-20 -38407
63 01-Mar-20 -38407
64 01-Apr-20 -38407
65 01-May-20 -38407
66 01-Jun-20 -38407
67 01-Jul-20 -38407
68 01-Aug-20 -38407
69 01-Sep-20 -38407
70 01-Oct-20 -38407
71 01-Nov-20 -38407
72 01-Dec-20 -38407
73 01-Jan-21 -38407
74 01-Feb-21 -38407
75 01-Mar-21 -38407
76 01-Apr-21 -38407
77 01-May-21 -38407
78 01-Jun-21 -38407
79 01-Jul-21 -38407
80 01-Aug-21 -38407
81 01-Sep-21 -38407
82 01-Oct-21 -38407
83 01-Nov-21 -38407
84 01-Dec-21 -38407
85 01-Jan-22 -38407
86 01-Feb-22 -38407
87 01-Mar-22 -38407
88 01-Apr-22 -38407
89 01-May-22 -38407
90 01-Jun-22 -38407
91 01-Jul-22 -38407
92 01-Aug-22 -38407
93 01-Sep-22 -38407
94 01-Oct-22 -38407
95 01-Nov-22 -38407
96 01-Dec-22 -38407
97 01-Jan-23 -38407
98 01-Feb-23 -38407
99 01-Mar-23 -38407
100 01-Apr-23 -38407
101 01-May-23 -38407
102 01-Jun-23 -38407
103 01-Jul-23 -38407
104 01-Aug-23 -38407
105 01-Sep-23 -38407
106 01-Oct-23 -38407
107 01-Nov-23 -38407
108 01-Dec-23 -38407
109 01-Jan-24 -38407
110 01-Feb-24 -38407
111 01-Mar-24 -38407
112 01-Apr-24 -38407
113 01-May-24 -38407
114 01-Jun-24 -38407
115 01-Jul-24 -38407
116 01-Aug-24 -38407
117 01-Sep-24 -38407
118 01-Oct-24 -38407
119 01-Nov-24 -38407
120 01-Dec-24 -38407
121 01-Jan-25 -38407
122 01-Feb-25 -38407
123 01-Mar-25 -38407
124 01-Apr-25 -38407
125 01-May-25 -38407
126 01-Jun-25 -38407
127 01-Jul-25 -38407
128 01-Aug-25 -38407
129 01-Sep-25 -38407
130 01-Oct-25 -38407
131 01-Nov-25 -38407
132 01-Dec-25 -38407
133 01-Jan-26 -38407
134 01-Feb-26 -38407
135 01-Mar-26 -38407
136 01-Apr-26 -38407
137 01-May-26 -38407
138 01-Jun-26 -38407
139 01-Jul-26 -38407
140 01-Aug-26 -38407
141 01-Sep-26 -38407
142 01-Oct-26 -38407
143 01-Nov-26 -38407
144 01-Dec-26 -38407
145 01-Jan-27 -38407
146 01-Feb-27 -38407
147 01-Mar-27 -38407
148 01-Apr-27 -38407
149 01-May-27 -38407
150 01-Jun-27 -38407
151 01-Jul-27 -38407
152 01-Aug-27 -38407
153 01-Sep-27 -38407
154 01-Oct-27 -38407
155 01-Nov-27 -38407
156 01-Dec-27 -38407
157 01-Jan-28 -38407
158 01-Feb-28 -38407
159 01-Mar-28 -38407
160 01-Apr-28 -38407
161 01-May-28 -38407
162 01-Jun-28 -38407
163 01-Jul-28 -38407
164 01-Aug-28 -38407
165 01-Sep-28 -38407
166 01-Oct-28 -38407
167 01-Nov-28 -38407
168 01-Dec-28 -38407
169 01-Jan-29 -38407
170 01-Feb-29 -38407
171 01-Mar-29 -38407
172 01-Apr-29 -38407
173 01-May-29 -38407
174 01-Jun-29 -38407
175 01-Jul-29 -38407
176 01-Aug-29 -38407
177 01-Sep-29 -38407
178 01-Oct-29 -38407
179 01-Nov-29 -38407
180 01-Dec-29 -38407
181 01-Jan-30 -38407
182 01-Feb-30 -38407
183 01-Mar-30 -38407
184 01-Apr-30 -38407
185 01-May-30 -38407
186 01-Jun-30 -38407
187 01-Jul-30 -38407
188 01-Aug-30 -38407
189 01-Sep-30 -38407
190 01-Oct-30 -38407
191 01-Nov-30 -38407
192 01-Dec-30 -38407
193 01-Jan-31 -38407
194 01-Feb-31 -38407
195 01-Mar-31 -38407
196 01-Apr-31 -38407
197 01-May-31 -38407
198 01-Jun-31 -38407
199 01-Jul-31 -38407
200 01-Aug-31 -38407
201 01-Sep-31 -38407
202 01-Oct-31 -38407
0.101 Days 620517 Months 204
3,500,000.00 Days in yr 365Mths in y 12
Daily Reducing Method
161732.8661339524.5664777122953635417.4215497607
Monthly Reducing Method
162843.7931753954.5279364019936
35964.2403775143
Yearly Reducing Method
1814570.4770435449.597866264561436585.6560716622
XIRR 10.837% 11.403%
AXIS AXIS01-Feb-13 -5,000,000.00 -3,000,000.00
1 05-Feb-13 50,000.00 31,000.002 05-Mar-13 50,000.00 31,000.003 05-Apr-13 50,000.00 31,000.004 05-May-13 50,000.00 31,000.005 05-Jun-13 50,000.00 31,000.006 05-Jul-13 50,000.00 31,000.007 05-Aug-13 50,000.00 31,000.008 05-Sep-13 50,000.00 31,000.009 05-Oct-13 50,000.00 31,000.00
10 05-Nov-13 50,000.00 31,000.0011 05-Dec-13 50,000.00 31,000.0012 05-Jan-14 50,000.00 31,000.0013 05-Feb-14 50,000.00 31,000.0014 05-Mar-14 50,000.00 31,000.0015 05-Apr-14 50,000.00 31,000.0016 05-May-14 50,000.00 31,000.0017 05-Jun-14 50,000.00 31,000.0018 05-Jul-14 50,000.00 31,000.0019 05-Aug-14 50,000.00 31,000.0020 05-Sep-14 50,000.00 31,000.0021 05-Oct-14 50,000.00 31,000.0022 05-Nov-14 50,000.00 31,000.0023 05-Dec-14 50,000.00 31,000.0024 05-Jan-15 50,000.00 31,000.0025 05-Feb-15 50,000.00 31,000.0026 05-Mar-15 50,000.00 31,000.0027 05-Apr-15 50,000.00 31,000.0028 05-May-15 50,000.00 31,000.0029 05-Jun-15 50,000.00 31,000.0030 05-Jul-15 50,000.00 31,000.0031 05-Aug-15 50,000.00 31,000.0032 05-Sep-15 50,000.00 31,000.0033 05-Oct-15 50,000.00 31,000.0034 05-Nov-15 50,000.00 31,000.0035 05-Dec-15 50,000.00 31,000.0036 05-Jan-16 50,000.00 31,000.0037 05-Feb-16 50,000.00 31,000.0038 05-Mar-16 50,000.00 31,000.0039 05-Apr-16 50,000.00 31,000.0040 05-May-16 50,000.00 31,000.00
41 05-Jun-16 50,000.00 31,000.0042 05-Jul-16 50,000.00 31,000.0043 05-Aug-16 50,000.00 31,000.0044 05-Sep-16 50,000.00 31,000.0045 05-Oct-16 50,000.00 31,000.0046 05-Nov-16 50,000.00 31,000.0047 05-Dec-16 50,000.00 31,000.0048 05-Jan-17 50,000.00 31,000.0049 05-Feb-17 50,000.00 31,000.0050 05-Mar-17 50,000.00 31,000.0051 05-Apr-17 50,000.00 31,000.0052 05-May-17 50,000.00 31,000.0053 05-Jun-17 50,000.00 31,000.0054 05-Jul-17 50,000.00 31,000.0055 05-Aug-17 50,000.00 31,000.0056 05-Sep-17 50,000.00 31,000.0057 05-Oct-17 50,000.00 31,000.0058 05-Nov-17 50,000.00 31,000.0059 05-Dec-17 50,000.00 31,000.0060 05-Jan-18 50,000.00 31,000.0061 05-Feb-18 50,000.00 31,000.0062 05-Mar-18 50,000.00 31,000.0063 05-Apr-18 50,000.00 31,000.0064 05-May-18 50,000.00 31,000.0065 05-Jun-18 50,000.00 31,000.0066 05-Jul-18 50,000.00 31,000.0067 05-Aug-18 50,000.00 31,000.0068 05-Sep-18 50,000.00 31,000.0069 05-Oct-18 50,000.00 31,000.0070 05-Nov-18 50,000.00 31,000.0071 05-Dec-18 50,000.00 31,000.0072 05-Jan-19 50,000.00 31,000.0073 05-Feb-19 50,000.00 31,000.0074 05-Mar-19 50,000.00 31,000.0075 05-Apr-19 50,000.00 31,000.0076 05-May-19 50,000.00 31,000.0077 05-Jun-19 50,000.00 31,000.0078 05-Jul-19 50,000.00 31,000.0079 05-Aug-19 50,000.00 31,000.0080 05-Sep-19 50,000.00 31,000.0081 05-Oct-19 50,000.00 31,000.0082 05-Nov-19 50,000.00 31,000.0083 05-Dec-19 50,000.00 31,000.0084 05-Jan-20 50,000.00 31,000.0085 05-Feb-20 50,000.00 31,000.0086 05-Mar-20 50,000.00 31,000.00
87 05-Apr-20 50,000.00 31,000.0088 05-May-20 50,000.00 31,000.0089 05-Jun-20 50,000.00 31,000.0090 05-Jul-20 50,000.00 31,000.0091 05-Aug-20 50,000.00 31,000.0092 05-Sep-20 50,000.00 31,000.0093 05-Oct-20 50,000.00 31,000.0094 05-Nov-20 50,000.00 31,000.0095 05-Dec-20 50,000.00 31,000.0096 05-Jan-21 50,000.00 31,000.0097 05-Feb-21 50,000.00 31,000.0098 05-Mar-21 50,000.00 31,000.0099 05-Apr-21 50,000.00 31,000.00
100 05-May-21 50,000.00 31,000.00101 05-Jun-21 50,000.00 31,000.00102 05-Jul-21 50,000.00 31,000.00103 05-Aug-21 50,000.00 31,000.00104 05-Sep-21 50,000.00 31,000.00105 05-Oct-21 50,000.00 31,000.00106 05-Nov-21 50,000.00 31,000.00107 05-Dec-21 50,000.00 31,000.00108 05-Jan-22 50,000.00 31,000.00109 05-Feb-22 50,000.00 31,000.00110 05-Mar-22 50,000.00 31,000.00111 05-Apr-22 50,000.00 31,000.00112 05-May-22 50,000.00 31,000.00113 05-Jun-22 50,000.00 31,000.00114 05-Jul-22 50,000.00 31,000.00115 05-Aug-22 50,000.00 31,000.00116 05-Sep-22 50,000.00 31,000.00117 05-Oct-22 50,000.00 31,000.00118 05-Nov-22 50,000.00 31,000.00119 05-Dec-22 50,000.00 31,000.00120 05-Jan-23 50,000.00 31,000.00121 05-Feb-23 50,000.00 31,000.00122 05-Mar-23 50,000.00 31,000.00123 05-Apr-23 50,000.00 31,000.00124 05-May-23 50,000.00 31,000.00125 05-Jun-23 50,000.00 31,000.00126 05-Jul-23 50,000.00 31,000.00127 05-Aug-23 50,000.00 31,000.00128 05-Sep-23 50,000.00 31,000.00129 05-Oct-23 50,000.00 31,000.00130 05-Nov-23 50,000.00 31,000.00131 05-Dec-23 50,000.00 31,000.00132 05-Jan-24 50,000.00 31,000.00
133 05-Feb-24 50,000.00 31,000.00134 05-Mar-24 50,000.00 31,000.00135 05-Apr-24 50,000.00 31,000.00136 05-May-24 50,000.00 31,000.00137 05-Jun-24 50,000.00 31,000.00138 05-Jul-24 50,000.00 31,000.00139 05-Aug-24 50,000.00 31,000.00140 05-Sep-24 50,000.00 31,000.00141 05-Oct-24 50,000.00 31,000.00142 05-Nov-24 50,000.00 31,000.00143 05-Dec-24 50,000.00 31,000.00144 05-Jan-25 50,000.00 31,000.00145 05-Feb-25 50,000.00 31,000.00146 05-Mar-25 50,000.00 31,000.00147 05-Apr-25 50,000.00 31,000.00148 05-May-25 50,000.00 31,000.00149 05-Jun-25 50,000.00 31,000.00150 05-Jul-25 50,000.00 31,000.00151 05-Aug-25 50,000.00 31,000.00152 05-Sep-25 50,000.00 31,000.00153 05-Oct-25 50,000.00 31,000.00154 05-Nov-25 50,000.00 31,000.00155 05-Dec-25 50,000.00 31,000.00156 05-Jan-26 50,000.00 31,000.00157 05-Feb-26 50,000.00 31,000.00158 05-Mar-26 50,000.00 31,000.00159 05-Apr-26 50,000.00 31,000.00160 05-May-26 50,000.00 31,000.00161 05-Jun-26 50,000.00 31,000.00162 05-Jul-26 50,000.00 31,000.00163 05-Aug-26 50,000.00 31,000.00164 05-Sep-26 50,000.00 31,000.00165 05-Oct-26 50,000.00 31,000.00166 05-Nov-26 50,000.00 31,000.00167 05-Dec-26 50,000.00 31,000.00168 05-Jan-27 50,000.00 31,000.00169 05-Feb-27 50,000.00 31,000.00170 05-Mar-27 50,000.00 31,000.00171 05-Apr-27 50,000.00 31,000.00172 05-May-27 50,000.00 31,000.00173 05-Jun-27 50,000.00 31,000.00174 05-Jul-27 50,000.00 31,000.00175 05-Aug-27 50,000.00 31,000.00176 05-Sep-27 50,000.00 31,000.00177 05-Oct-27 50,000.00 31,000.00178 05-Nov-27 50,000.00 31,000.00
179 05-Dec-27 50,000.00 31,000.00180 05-Jan-28 50,000.00 31,000.00181 05-Feb-28 50,000.00 31,000.00182 05-Mar-28 50,000.00 31,000.00183 05-Apr-28 50,000.00 31,000.00184 05-May-28 50,000.00 31,000.00185 05-Jun-28 50,000.00 31,000.00186 05-Jul-28 50,000.00 31,000.00187 05-Aug-28 50,000.00 31,000.00188 05-Sep-28 50,000.00 31,000.00189 05-Oct-28 50,000.00 31,000.00190 05-Nov-28 50,000.00 31,000.00191 05-Dec-28 50,000.00 31,000.00192 05-Jan-29 50,000.00 31,000.00193 05-Feb-29 50,000.00 31,000.00194 05-Mar-29 50,000.00 31,000.00195 05-Apr-29 50,000.00 31,000.00196 05-May-29 50,000.00 31,000.00197 05-Jun-29 50,000.00 31,000.00198 05-Jul-29 50,000.00 31,000.00199 05-Aug-29 50,000.00 31,000.00200 05-Sep-29 50,000.00 31,000.00201 05-Oct-29 50,000.00 31,000.00202 05-Nov-29 50,000.00 31,000.00203 05-Dec-29 50,000.00 31,000.00204 05-Jan-30 50,000.00 31,000.00205 05-Feb-30 50,000.00 31,000.00206 05-Mar-30 50,000.00 31,000.00207 05-Apr-30 50,000.00 31,000.00208 05-May-30 50,000.00 31,000.00209 05-Jun-30 50,000.00 31,000.00210 05-Jul-30 50,000.00 31,000.00211 05-Aug-30 50,000.00 31,000.00212 05-Sep-30 50,000.00 31,000.00213 05-Oct-30 50,000.00 31,000.00214 05-Nov-30 50,000.00 31,000.00215 05-Dec-30 50,000.00 31,000.00216 05-Jan-31 50,000.00 31,000.00217 05-Feb-31 50,000.00 31,000.00218 05-Mar-31 50,000.00 31,000.00219 05-Apr-31 50,000.00 31,000.00220 05-May-31 50,000.00 31,000.00221 05-Jun-31 50,000.00 31,000.00222 05-Jul-31 50,000.00 31,000.00223 05-Aug-31 50,000.00 31,000.00224 05-Sep-31 50,000.00 31,000.00
1.294%
Others-2,000,000.00 6.00%
10,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.00
10,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.00
10,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.00
10,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.00
10,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.0010,000.00
5 Years 3Years 5 Years
01-Mar-11 -500000 -500000 -500000
1 01-Apr-11 10600 16110 10585
2 01-May-11 10600 16110 10585
3 01-Jun-11 10600 16110 10585
4 01-Jul-11 10600 16110 10585
5 01-Aug-11 10600 16110 10585
6 01-Sep-11 10600 16110 10585
7 01-Oct-11 10600 16110 10585
8 01-Nov-11 10600 16110 10585
9 01-Dec-11 10600 16110 10585
10 01-Jan-12 10600 16110 10585
11 01-Feb-12 10600 16110 10585
12 01-Mar-12 10600 16110 10585
13 01-Apr-12 10600 16110 10585
14 01-May-12 10600 16110 10585
15 01-Jun-12 10600 16110 10585
16 01-Jul-12 10600 16110 10585
17 01-Aug-12 10600 16110 10585
18 01-Sep-12 10600 16110 10585
19 01-Oct-12 10600 16110 10585
20 01-Nov-12 10600 16110 10585
21 01-Dec-12 10600 16110 10585
22 01-Jan-13 10600 16110 10585
23 01-Feb-13 10600 16110 10585
24 01-Mar-13 10600 16110 10585
25 01-Apr-13 10600 16110 10585
26 01-May-13 10600 16110 10585
27 01-Jun-13 10600 16110 10585
28 01-Jul-13 10600 16110 10585
29 01-Aug-13 10600 16110 10585
30 01-Sep-13 10600 16110 10585
31 01-Oct-13 10600 16110 10585
32 01-Nov-13 10600 16110 10585
33 01-Dec-13 10600 16110 10585
34 01-Jan-14 10600 16110 10585
35 01-Feb-14 10600 16110 10585
36 01-Mar-14 10600 16110 10585
37 01-Apr-14 10600 1058538 01-May-14 10600 1058539 01-Jun-14 10600 1058540 01-Jul-14 10600 10585
41 01-Aug-14 10600 10585
42 01-Sep-14 10600 10585
43 01-Oct-14 10600 10585
44 01-Nov-14 10600 10585
45 01-Dec-14 10600 10585
46 01-Jan-15 10600 10585
47 01-Feb-15 10600 10585
48 01-Mar-15 10600 10585
49 01-Apr-15 10600 10585
50 01-May-15 10600 10585
51 01-Jun-15 10600 10585
52 01-Jul-15 10600 10585
53 01-Aug-15 10600 10585
54 01-Sep-15 10600 10585
55 01-Oct-15 10600 10585
56 01-Nov-15 10600 10585
57 01-Dec-15 10600 10585
58 01-Jan-16 10600 10585
59 01-Feb-16 10600 10585
60 01-Mar-16 10600 10585
10.34% 10.33% 10.28%
3Years
-500000
15570 2120
15570
15570
15570
15570
15570
15570
15570
15570
15570
15570
15570
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785
15785