XIRR_ Updated.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	FY	Date	Account	Stock Name	Buy/ Sell	Qtys	Div/ Share	Net Buy, Sell / Net Div Rate	Amount	TDS	Taxes	Tax 2B Paid

2	2020-21	1-Oct-20	HDFC Sec	United Spirits	Buy	1000		(812)	(812,000)
3	2020-21	1-Jan-21	HDFC Sec	HDFC Life	Buy	2500		(476)	(1,190,000)
4	2020-21	1-Jan-21	ICICI Direct	HDFC Life	Buy	500		(476)	(238,000)
5	2020-21	1-Jan-21	HDFC Sec	Reliance	Buy	1500		(2,254)	(3,381,000)
6	2020-21	1-Jan-21	ICICI Direct	Reliance	Buy	250		(2,254)	(563,500)
7	2020-21	1-Mar-21	HDFC Sec	ITC Ltd	Buy	5000		(235)	(1,174,200)
8	2020-21	1-Mar-21	HDFC Sec	United Spirits	Sell	500		550	275,000
9	2021-22	1-Apr-21	HDFC Sec	KPIT Tech	Buy	2500		(353)	(882,125)
10	2021-22	1-Apr-21	HDFC Sec	Vedanta	Buy	2500		(298)	(743,875)
11	2021-22	1-Apr-21	HDFC Sec	Vedanta	Buy	500		(298)	(148,775)
12	2021-22	1-Oct-21	HDFC Sec	HDFC Life	Sell	250		570	142,500
13	2021-22	31-Dec-21	HDFC Sec	KPIT Tech	Dividend	2500	1.5	0.99	2,463	-	1,287	1,287
14	2021-22	31-Dec-21	HDFC Sec	Reliance	Sell	250		2,575	643,750
15	2021-22	15-Jan-22	HDFC Sec	Tata Comm	Buy	500		(1,493)	(746,500)
16	2021-22	15-Mar-22	HDFC Sec	KPIT Tech	Dividend	2500	1.25	0.82	2,053	-	1,073	1,073
17	2022-23	5-Apr-22	HDFC Sec	Tata Comm	Buy	100		(1,262)	(126,200)
18	2022-23	5-Apr-22	ICICI Direct	ITC Ltd	Buy	500		(259)	(129,725)
19	2022-23	1-Jun-22	HDFC Sec	Vedanta	Dividend	2500	31.5	20.69	51,723	7,875	27,027	19,152
20	2022-23	1-Jun-22	ICICI Direct	Vedanta	Dividend	500	31.5	31.50	15,750	1,575	5,405	3,830
21	2022-23	1-Jun-22	HDFC Sec	Tata Comm	Dividend	600	20.7	13.60	8,157	1,242	4,263	3,021
22	2022-23	1-Jun-22	HDFC Sec	HDFC Life	Dividend	2500	1.7	1.12	2,791	-	1,459	1,459
23	2022-23	1-Jun-22	ICICI Direct	HDFC Life	Dividend	500	1.7	1.70	850	-	292	292
24	2022-23	1-Jun-22	HDFC Sec	KPIT Tech	Dividend	2500	1.85	1	3,038	-	1,587	1,587
25	2022-23	1-Jun-22	HDFC Sec	Reliance	Dividend	1500	8	5	7,882	1,200	4,118	2,918
26	2022-23	1-Jun-22	ICICI Direct	Reliance	Dividend	250	8	8	2,000	-	686	686
27	2022-23	1-Jun-22	HDFC Sec	ITC Ltd	Dividend	5000	6.25	4.11	20,525	3,125	10,725	7,600
28	2022-23	1-Jun-22	ICICI Direct	ITC Ltd	Dividend	500	6.25	6	3,125	-	1,073	1,073
29
30
31	2022-23	5-Jun-22	HDFC Sec	Total PF Value					10,000,000
32	2022-23	5-Jun-22	ICICI Direct	Total PF Value					2,500,000
33					XIRR				28%
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