EPF Investment Planner

	C	D	E	H	I	J	K	L	N	O	P	S	T	V
1
2				EPF Account 1 Estimation Workout									Yearly UT Investment (RM)	Average
3	Starting Year		Total Yearly EPF Contribution		Year	Age	Acc. 1 Balance	Investible Amount	Invest?	Contribution into UT/year	Yearly Deposits into Acc. 1	30	30,293.34	RM22,094.76
4	2024	30	RM14,400.00		2024	30	RM70,000.00	RM10,500.00	Yes	RM30,293.34	RM10,080.00	31	13,896.17
5		31	RM14,832.00			30	RM62,020.00	RM8,106.00	Yes			32	0.00
6	Retire at Age	32	RM15,276.96			30	RM56,434.00	RM6,430.20	Yes			33	0.00
7	55	33	RM15,735.27			30	RM52,523.80	RM5,257.14	Yes			34	0.00
8		34	RM16,207.33		2025	31	RM52,275.99	RM3,982.80	Yes	RM13,896.17	RM10,382.40	35	0.00
9	EPF Account 1	35	RM16,693.55			31	RM50,888.80	RM3,566.64	Yes			36	0.00
10	RM70,000.00	36	RM17,194.35			31	RM49,917.76	RM3,275.33	Yes			37	0.00
11		37	RM17,710.18			31	RM49,238.03	RM3,071.41	Yes			38	0.00
12	1st Investment in Which Quarter?	38	RM18,241.49		2026	32	RM51,200.33	RM0.00	No	RM0.00	RM10,693.87	39	0.00
13	1	39	RM18,788.73			32	RM53,873.80	RM0.00	No			40	0.00
14		40	RM19,352.40			32	RM56,547.27	RM0.00	No			41	0.00
15		41	RM19,932.97			32	RM59,220.74	RM0.00	No			42	0.00
16		42	RM20,530.96		2027	33	RM64,988.91	RM0.00	No	RM0.00	RM11,014.69	43	0.00
17	Current Monthly Salary	43	RM21,146.89			33	RM67,742.59	RM0.00	No			44	0.00
18	RM5,000.00	44	RM21,781.29			33	RM70,496.26	RM0.00	No			45	0.00
19		45	RM22,434.73			33	RM73,249.93	RM0.00	No			46	0.00
20	Salary Growth Rate	46	RM23,107.77		2028	34	RM79,803.78	RM0.00	No	RM0.00	RM11,345.13	47	0.00
21	3.00%	47	RM23,801.01			34	RM82,640.06	RM0.00	No			48	0.00
22		48	RM24,515.04			34	RM85,476.35	RM0.00	No			49	0.00
23	Bonus (months)	49	RM25,250.49			34	RM88,312.63	RM0.00	No			50	0.00
24	0	50	RM26,008.00		2029	35	RM95,706.36	RM0.00	No	RM0.00	RM11,685.48	51	0.00
25		51	RM26,788.24			35	RM98,627.73	RM0.00	No			52	0.00
26	EPF Rate	52	RM27,591.89			35	RM101,549.10	RM0.00	No			53	0.00
27	5.00%	53	RM28,419.65			35	RM104,470.47	RM0.00	No			54	0.00
28		54	RM29,272.24		2030	36	RM112,761.43	RM0.00	No	RM0.00	RM12,036.05	55	0.00
29	Total % EPF Contribution	55	0			36	RM115,770.44	RM0.00	No			56	0.00
30	24.00%	56	0			36	RM118,779.45	RM0.00	No			57	0.00
31		57	0			36	RM121,788.47	RM0.00	No			58	0.00
32		58	0		2031	37	RM131,037.35	RM0.00	No	RM0.00	RM12,397.13	59	0.00
33	Instructions	59	0			37	RM134,136.63	RM0.00	No			60	0.00
34		60	0			37	RM137,235.92	RM0.00	No			61	0.00
35		61	0			37	RM140,335.20	RM0.00	No			62	0.00
36		62	0		2032	38	RM150,606.20	RM0.00	No	RM0.00	RM12,769.04	63	0.00
37		63	0			38	RM153,798.47	RM0.00	No			64	0.00
38		64	0			38	RM156,990.73	RM0.00	No			65	0.00
39		65	0			38	RM160,182.99	RM0.00	No			66	0.00
40		66	0		2033	39	RM171,544.01	RM0.00	No	RM0.00	RM13,152.11	67	0.00
41		67	0			39	RM174,832.04	RM0.00	No			68	0.00
42		68	0			39	RM178,120.07	RM0.00	No			69	0.00
43		69	0			39	RM181,408.09	RM0.00	No			70	0.00
44		70	0		2034	40	RM193,930.93	RM0.00	No	RM0.00	RM13,546.68	71	0.00
45		71	0			40	RM197,317.60	RM0.00	No
46						40	RM200,704.27	RM0.00	No
47						40	RM204,090.94	RM0.00	No
48					2035	41	RM217,851.49	RM0.00	No	RM0.00	RM13,953.08
49						41	RM221,339.76	RM0.00	No
50						41	RM224,828.03	RM0.00	No
51						41	RM228,316.30	RM0.00	No
52					2036	42	RM243,394.79	RM0.00	No	RM0.00	RM14,371.67
53						42	RM246,987.71	RM0.00	No
54						42	RM250,580.63	RM0.00	No
55						42	RM254,173.54	RM0.00	No
56					2037	43	RM270,654.79	RM0.00	No	RM0.00	RM14,802.82
57						43	RM274,355.49	RM0.00	No
58						43	RM278,056.20	RM0.00	No
59						43	RM281,756.90	RM0.00	No
60					2038	44	RM299,730.49	RM0.00	No	RM0.00	RM15,246.90
61						44	RM303,542.21	RM0.00	No
62						44	RM307,353.94	RM0.00	No
63						44	RM311,165.66	RM0.00	No
64					2039	45	RM330,726.26	RM0.00	No	RM0.00	RM15,704.31
65						45	RM334,652.34	RM0.00	No
66						45	RM338,578.42	RM0.00	No
67						45	RM342,504.49	RM0.00	No
68					2040	46	RM363,752.10	RM0.00	No	RM0.00	RM16,175.44
69						46	RM367,795.96	RM0.00	No
70						46	RM371,839.82	RM0.00	No
71						46	RM375,883.68	RM0.00	No
72					2041	47	RM398,923.92	RM0.00	No	RM0.00	RM16,660.70
73						47	RM403,089.09	RM0.00	No
74						47	RM407,254.27	RM0.00	No
75						47	RM411,419.45	RM0.00	No
76					2042	48	RM436,363.85	RM0.00	No	RM0.00	RM17,160.53
77						48	RM440,653.98	RM0.00	No
78						48	RM444,944.12	RM0.00	No
79						48	RM449,234.25	RM0.00	No
80					2043	49	RM476,200.60	RM0.00	No	RM0.00	RM17,675.34
81						49	RM480,619.43	RM0.00	No
82						49	RM485,038.27	RM0.00	No
83						49	RM489,457.10	RM0.00	No
84					2044	50	RM518,569.73	RM0.00	No	RM0.00	RM18,205.60
85						50	RM523,121.14	RM0.00	No
86						50	RM527,672.54	RM0.00	No
87						50	RM532,223.94	RM0.00	No
88					2045	51	RM563,614.10	RM0.00	No	RM0.00	RM18,751.77
89						51	RM568,302.05	RM0.00	No
90						51	RM572,989.99	RM0.00	No
91						51	RM577,677.93	RM0.00	No
92					2046	52	RM611,484.17	RM0.00	No	RM0.00	RM19,314.32
93						52	RM616,312.75	RM0.00	No
94						52	RM621,141.33	RM0.00	No
95						52	RM625,969.91	RM0.00	No
96					2047	53	RM662,338.41	RM0.00	No	RM0.00	RM19,893.75
97						53	RM667,311.85	RM0.00	No
98						53	RM672,285.29	RM0.00	No
99						53	RM677,258.73	RM0.00	No
100					2048	54	RM716,343.77	RM0.00	No	RM0.00	RM20,490.56