ABCDEFGHIJKLMNOPQRSTUVW
1
MONTHContributionContributionBalanceTotalDividend
2
MajikanPekerjaAccount 1Account 2Account 1Account 2Account 1Account 2
3
1/1/2013Penyata Tahun Lepas:70%30%$7,000.00$3,000.00$10,000.00$36.65$15.71
4
31/1/2013$390.00$330.00$504.00$216.00$7,504.00$3,216.00$10,720.00
5
28/2/2013$390.00$330.00$504.00$216.00$8,008.00$3,432.00$11,440.00$35.49$15.21
6
31/3/2013$390.00$330.00$504.00$216.00$8,512.00$3,648.00$12,160.00$41.91$17.96
7
30/4/2013$390.00$330.00$504.00$216.00$9,016.00$3,864.00$12,880.00$43.11$18.48
8
31/5/2013$390.00$330.00$504.00$216.00$9,520.00$4,080.00$13,600.00$47.18$20.22
9
30/6/2013$390.00$330.00$504.00$216.00$10,024.00$4,296.00$14,320.00$48.21$20.66
10
31/7/2013$390.00$330.00$504.00$216.00$10,528.00$4,512.00$15,040.00$52.44$22.48
11
31/8/2013$390.00$330.00$504.00$216.00$11,032.00$4,728.00$15,760.00$55.08$23.60
12
30/9/2013$390.00$330.00$504.00$216.00$11,536.00$4,944.00$16,480.00$55.85$23.94
13
31/10/2013$390.00$330.00$504.00$216.00$12,040.00$5,160.00$17,200.00$60.34$25.86
14
30/11/2013$390.00$330.00$504.00$216.00$12,544.00$5,376.00$17,920.00$60.94$26.12
15
31/12/2013$390.00$330.00$504.00$216.00$13,048.00$5,592.00$18,640.00$65.61$28.12
16
17
YEAR:Dividend:$602.80$258.34
18
20126.15%Total Balance:$13,650.80$5,850.34
19
- Input the Year you would like to check (currently support from year 2000 - 2013)
20
- Input all the necessarily amount into "Red Cell". Spreadsheet will do the rest for you.
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