GP Fund Annual Mark-Up Profit - Interest Calculator.xlsx

	C	D	E	F	H
1
2
3
4	GENERAL PROVIDENT FUND (GPF)
5	ANNUAL MARK-UP PROFIT CALCULATOR
6	ANNUAL INTEREST CALCULATOR
7
8	GPF June Balance			17340
9	Profit / Interest on GPF Balance Last Year			400
10
11	GPF Balance in June			17740
12
13	Year	Months	GPF Monthly Subscription	GPF Progressive Balance
14	2021	July	2890	20630
15		August	2890	23520
16		Septmber	2890	26410
17		October	2890	29300
18		November	2890	32190
19		December	2890	35080
20	2022	January	2890	37970
21		February	2890	40860
22		March	2890	43750
23		April	2890	46640
24		May	2890	49530
25		June	2890	52420
26
27	Total		34680	438300
28
29	GPF Balance in June			17740
30
31	GPF Monthly Subscription Total			34680
32
33	GPF Progressive Balance Total			438300	Mark-Up Profit Rate %
34					Mark-Up Profit Rate %
35	GPF Profit		Progressive Total * Interest Rate % / 12	4529.1	12.40%
36
37	GPF Balance		GPF Balance June + Total Monthly Subscriptions + Profit	56949.1
38
39
40
41	Current General Provident Fund (GPF) Balance Check
42
43	Year	Months	GPF Monthly Subscription	GPF Balance
44	2022	July	2890	59839.10
45		August	2890	62729.10
46		Septmber	2890	65619.10
47		October	4290	69909.10
48		November	4290	74199.10
49		December	4290	78489.10
50	2023	January	4290	82779.10
51		February	4290	87069.10
52		March	4290	91359.10
53		April	4290	95649.10
54		May	4290	99939.10
55		June	4290	104229.10
56
57	Total		47280	104229.10
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