Actual share calculation example

	A	B	C	D	E	G	H	I	J	K
1	Example 1					Example 2
2
3			Wallet balance	Balance that is taken into account	Actual share			Wallet balance	Balance that is taken into account	Actual share
4	01.04.2015	1	10250	10250	10250	01.04.2015	1	10250	10250	10250
5		2	9800	0	5125		2	9800	0	5125
6		3	15200	15200	8483		3	7500	0	3417
7		4	16800	16800	10563		4	9400	0	2563
8	02.04.2015	1	18500	18500	12150	02.04.2015	1	9500	0	2050
9		2	5210	0	10125		2	12000	12000	3708
10		3	19800	19800	11507		3	12000	12000	4893
11		4	21500	21500	12756		4	12000	12000	5781
12	03.04.2015	1	21500	21500	13728	03.04.2015	1	12000	12000	6472
13		2	21500	21500	14505		2	10000	10000	6825
14		3	22100	22100	15195		3	10000	10000	7114
15		4	22100	22100	15771		4	10000	10000	7354
16	..............					..............
17	30.06.2015	1	110500	110500	23058	30.06.2015	1	11000	11000	7635
18		2	110600	110600	29311		2	11000	11000	7875
19		3	111000	111000	34757		3	12000	12000	8150
20		4	111500	111500	39553		4	12000	12000	8391
21
22	At the end of the quarter dividends are paid based on a resulting ACTUAL SHARE (marked light green)
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