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

	C	D	E	F	G	H	J
1
2
3
4	Advance General Provident Fund (GPF)
5	ANNUAL MARK-UP PROFIT CALCULATOR
6	ANNUAL INTEREST CALCULATOR
7
8	GPF June Balance					413216
9	Profit / Interest on GPF Balance Last Year					31388
10
11	GPF Balance in June					444604
12
13	Year	Months	GPF Monthly Subscription	GPF Advance Refund	GPF Advance Amount	GPF Progressive Balance
14	2021	July	2890			447494
15		August	2890			450384
16		September	2890		360000	93274
17		October	2890	10000		106164
18		November	2890	10000		119054
19		December	2890	10000		131944
20	2022	January	2890	10000		144834
21		February	2890	10000		157724
22		March	2890	10000		170614
23		April	2890	10000		183504
24		May	2890	10000		196394
25		June	2890	10000		209284
26
27	Total		34680	90000	360000	2410668
28
29	GPF Balance in June					444604
30
31	GPF Subscription Total		GPF Monthly Subscription + GPF Advance Refund			124680
32
33	GPF Progressive Balance Total					2410668	Mark-Up Profit Rate %
34							Mark-Up Profit Rate %
35	GPF Profit		Progressive Total * Interest Rate % / 12			24910.24	12.40%
36
37	GPF Advance Amount					360000
38
39	GPF Balance		GPF Balance June + Total GPF Subscriptions + Profit - GPF Advance			234194.24
40
41
42
43	Current General Provident Fund (GPF) Balance Check
44
45	Year	Months	GPF Monthly Subscription	GPF Advance Refund	GPF Balance
46	2022	July	2890	10000	247084.24
47		August	2890	10000	259974.24
48		September	2890	10000	272864.24
49		October	4290	10000	287154.24
50		November	4290	10000	301444.24
51		December	4290	10000	315734.24
52	2023	January	4290	10000	330024.24
53		February	4290	10000	344314.24
54		March	4290	10000	358604.24
55		April	4290	10000	372894.24
56		May	4290	10000	387184.24
57		June	4290	10000	401474.24
58
59	Total		47280	120000	401474.24
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