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

	C	D	E	F	H
1
2
3
4
5
6	GENERAL PROVIDENT FUND (GPF)
7	ANNUAL MARK-UP PROFIT CALCULATOR
8	ANNUAL INTEREST CALCULATOR
9
10	GPF June Balance			0
11	Profit / Interest on GPF Balance Last Year			0
12
13	GPF Balance in June			0
14
15	Year	Months	GPF Monthly Subscription	GPF Progressive Balance
16	2021	July	0	0
17		August	0	0
18		Septmber	0	0
19		October	0	0
20		November	0	0
21		December	0	0
22	2022	January	0	0
23		February	0	0
24		March	0	0
25		April	0	0
26		May	0	0
27		June	0	0
28
29	Total		0	0
30
31	GPF Balance in June			0
32
33	GPF Monthly Subscription Total			0
34
35	GPF Progressive Balance Total			0	Mark-Up Profit Rate %
36					Mark-Up Profit Rate %
37	GPF Profit		Progressive Total * Interest Rate % / 12	0	0.00%
38
39	GPF PROFIT BONUS		Bonus = 30% of Profit	0
40	GPF PROFIT BONUS		Bonus = 30% of Profit	0
41
42	GPF Balance		GPF Balance June + Total Monthly Subscriptions + Profit + Bonus	0
43
44
45
46	Current General Provident Fund (GPF) Balance Check
47
48	Year	Months	GPF Monthly Subscription	GPF Balance
49	2022	July	0	0.00
50		August	0	0.00
51		Septmber	0	0.00
52		October	0	0.00
53		November	0	0.00
54		December	0	0.00
55	2023	January	0	0.00
56		February	0	0.00
57		March	0	0.00
58		April	0	0.00
59		May	0	0.00
60		June	0	0.00
61
62	Total		0	0.00
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