Smallcase Charges - By Assetyogi.xlsx

	B	C	D	E	F	G	H
1	Transaction & Demat Charges in Smallcase					By - AssetYogi
2
3	Assumption
4	Investment Amount (Rs.)	100,000
5	No. of Stocks	10
6	% Rise in Stock Portfolio in 2 Years	50%
7
8	Timeline		Day 0	6 months	12 months	18 months	24 months
9			Buy	Rebalance 1	Rebalance 2	Rebalance 3	Sell
10	Sell Amount (Rs.)		-	2,000	2,500	3,000	150,000
11	Buy Amount (Rs.)		100,000	2,000	2,500	3,000	-
12	No. of Scrips		10	4	6	3	10
13	Trading Amount (Buy + Sell) (Rs.)		100,000	4,000	5,000	6,000	150,000
14	Transaction Charges	100 + 18% GST	118	0	0	0	0
15	Brokerage (Discount Broker)	0	0	0	0	0	0
16	STT	0.10%	100	4	5	6	150
17	Exchange Txn Fee	0.00345%	3.45	0.138	0.1725	0.207	5.175
18	GST	18%	0.621	0.02484	0.03105	0.03726	0.9315
19	Stamp Duty (on Buying)	0.015%	15	0.6	0.75	0.9	22.5
20	SEBI Charges	0.0001%	0.1	0.004	0.005	0.006	0.15
21	DP Charges (on Selling) (per Stock)	13.5 + 18% GST		63.72	95.58	47.79	159.3
22
23	Total (Rs.)		237.171	68.48684	101.53855	54.94026	338.0565
24
25	Total Expenses (in Rs.)	800.19315
26	Total Expenses (%)	0.80%
27	Net Profit (Rs.)	49,199.81
28
29
30
31
32
33
34
35
36
37
38
39
40
41
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
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