XIRR - Google Sheets

	B	C	F	G	J	K	L	N	O	P
1
2	Kasus Pertama		Kasus Kedua		Kasus Ketiga			Kasus Keempat
3	1/1/2015	-10,000,000	1/1/2015	-10,000,000	1/1/2015	10,000,000	deposit	1/1/2013	10,000,000	deposit
4	2/1/2015	-1,000,000	2/3/2015	-1,000,000	2/3/2015	500,000	deposit	2/25/2013	1,000,000	deposit
5	3/1/2015	-1,000,000	2/25/2015	-2,000,000	2/25/2015	500,000	deposit	4/1/2013	500,000	deposit
6	4/1/2015	-1,000,000	3/30/2015	-500,000	3/30/2015	2,000,000	deposit	6/1/2013	1,500,000	deposit
7	5/1/2015	-1,000,000	4/1/2015	-500,000	4/1/2015	1,000,000	deposit	10/30/2015	1,000,000	deposit
8	6/1/2015	-1,000,000	4/3/2015	-1,000,000	4/3/2015	100,000	dividend	12/15/2013	100,000	dividend
9	7/1/2015	-1,000,000	4/15/2015	-1,000,000	4/15/2015	300,000	dividend	4/3/2014	300,000	dividend
10	8/1/2015	-1,000,000	4/30/2015	-1,000,000	4/30/2015	1,000,000	deposit	6/15/2014	1,000,000	deposit
11	9/1/2015	-1,000,000	5/30/2015	-2,000,000	5/30/2015	1,000,000	deposit	9/15/2014	1,000,000	deposit
12	10/1/2015	-1,000,000	6/15/2015	-500,000	6/15/2015	1,500,000	deposit	12/11/2014	1,500,000	deposit
13	11/1/2015	-1,000,000	7/30/2015	-500,000	7/30/2015	-1,500,000	withdraw	3/3/2015	-1,500,000	withdraw
14	12/1/2015	-1,000,000	10/30/2015	-1,000,000	10/30/2015	2,000,000	deposit	10/30/2015	2,000,000	deposit
15	12/31/2015	23,000,000	12/31/2015	23,000,000	11/5/2015	100,000	dividend	11/5/2015	100,000	dividend
16	Return	13.03%	Return	11.65%	11/30/2015	2,000,000	deposit	11/30/2015	2,000,000	deposit
17					12/20/2015	500,000	deposit	12/20/2015	500,000	deposit
18					12/31/2015	-23,000,000	jumlah akhir tahun	12/22/2015	-23,000,000	Jumlah saat ini
19					Return	13.09%		Return	4.56%
20
21
22
23
24
25
26
27
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