EIKO_Fee calculator_Final.xlsx

	A	B	C	D	E	F
1	FEE CALCULATOR
2	Assumptions			Variables can be changed
3	Capital Contribution (Rs.)		a	2,500,000
4	Management Fee (% per annum)		b	2.50%
5
6
7	Date	Fixed Fee Illustration			Quarter 1
8					Quarter 1
9					GAIN/ (LOSS) OF	5.00%
10	1st April	Capital Contributed / Assets under Management	i	i = a	2,500,000
11		Gain / (Loss) on Investment based on the Scenario at end of 1st quarter	ii	ii= i* 5% (assumed return)	125,000
12	30th June	Gross Value of the Portfolio at the end of period	iii	iii= i + ii	2,625,000
13		Gross Return			5.0%
14
15	30th June	Management Fees	iv	iv= iii x (b/4)	16,406
16
17	1st July	Net Value of the Portfolio at the end of period	v	v= iii - iv	2,608,594
18		Net Return			4.3%
19					Quarter 2
20					Quarter 2
21					GAIN/ (LOSS) OF	5.00%
22	1st July	Capital Contributed / Assets under Management	vi	vi= iii	2,625,000
23		Gain / (Loss) on Investment based on the Scenario at end of six months	vii	vii= vi* 5% (assumed return)	131,250
24	30th Sept.	Gross Value of the Portfolio at the end of period	viii	viii= vi + vii	2,756,250
25		Gross Return			5.0%
26
27	30th Sept.	Management Fees	ix	ix= viii x (b/4)	17,227
28
29	1st Oct	Net Value of the Portfolio at the end of period	x	x= viii - ix	2,739,023
30		Net Return			4.3%
31					Quarter 3
32					Quarter 3
33					GAIN/ (LOSS) OF	5.00%
34	1st Oct	Capital Contributed / Assets under Management	xi	xi= viii	2,756,250
35		Gain / (Loss) on Investment based on the Scenario at end of six months	xii	xii= xi* 5% (assumed return)	137,813
36	31st Dec.	Gross Value of the Portfolio at the end of period	xiii	xiii= xi + xii	2,894,063
37		Gross Return			5.0%
38
39	31st Dec.	Management Fees	xiv	xiv= xiii x (b/4)	18,088
40
41	1st Jan	Net Value of the Portfolio at the end of period	xv	xv= xiii - xiv	2,875,975
42		Net Return			4.3%
43					Quarter 4
44					Quarter 4
45					GAIN/ (LOSS) OF	5.00%
46	1st Jan	Capital Contributed / Assets under Management	xvi	xvi= xiii	2,894,063
47		Gain / (Loss) on Investment based on the Scenario at end of six months	xvii	xvii= xvi* 5% (assumed return)	144,703
48	31st Mar	Gross Value of the Portfolio at the end of period	xviii	xiii= xvi + xvii	3,038,766
49		Gross Return			5.0%
50
51	31st Mar	Management Fees	xix	xix= xviii x (b/4)	18,992
52
53	1st Apr.	Net Value of the Portfolio at the end of period	xx	xx= xviii- xix	3,019,773
54		Net Return			4.3%
55
56		Net Annual Return %			20.8%
57		Total Management Fees			70,713
58
59
60		Notes:
61	1	In the illustration, Management fee is assumed to be charged quarterly (1st July, 1st October, 1st Jan & 1st April)
62	2	Fee will be charged on the portfolio value at the end of each quarter
63	3	Other Expenses includes Account Opening charges, stamp duty/ Bank charges / Fund Accounting charges / Custody Fee / demat charges or other miscellaneous expense. These are not included in the fee illustration above.
64	4	All Fees and charges are subject to GST.
65
66
67
68
69
70
71
72
73
74
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