Available online at https://journal. com/index. php/ijqrm/index International Journal of Quantitative Research and Modeling e-ISSN 2721-477X p-ISSN 2722-5046 Vol. No. 3, pp. 256-261, 2024 Actuarial Pension Fund Using the Projected Unit Credit (PUC) Method: Case Study at PT Taspen Cirebon Branch Office Hana Safrina Amalia1*. Betty Subartini2. Sukono3 1,32 Department of Mathematics. Padjadjaran University. Bandung. Indonesia *Corresponding author email: hanasafrin28@gmail. Abstract The pension fund program is a program held by the government to ensure the welfare of Civil Servants (PNS) in retirement as old-age security. The pension program for civil servants is managed by a pension fund. PT Taspen (Perser. Actuarial calculations of pension funds need to be carried out to determine the amount of normal contributions and actuarial liabilities that must be paid by pension plan participants and companies. The actuarial calculation of pension funds used by PT Taspen in managing civil servant pension funds is the Accrued Benefit Cost which determines in advance the benefits that will be obtained by participants. The Projected Unit Credit (PUC) method is one part of the Accrued Benefit Cost. This study aims to determine normal contributions and actuarial liabilities using the Projected Unit Credit (PUC) method for civil servant pension program participants of PT Taspen (Perser. Cirebon Branch Office. The calculation results show that the PUC method provides a more accurate calculation of the estimated normal contributions and actuarial liabilities of the company. This study is expected to be a reference for other companies in managing employee pension funds using an actuarial approach. Keywords: pension funding. Projected Unit Credit (PUC), normal cost, actuarial liability Introduction Welfare in old age is something that is coveted for a worker. Islam et al . said that as a form of government concern in creating workers' welfare in old age, a pension program was created. According to Law Number 11 of 1992 concerning Pension Funds, a pension program is a program that seeks retirement benefits for participants. The pension program is managed and run by a pension fund institution. Based on Law Number 11 of 1992, a pension fund is a legal entity that manages and runs a pension program that promises benefits to participants at retirement. Pension funds are an important component in long-term financial planning, both for employees and companies. As a form of financial protection in retirement, pension funds are designed to ensure the welfare of employees after they are no longer actively working. One of the pension funds in Indonesia is PT Dana Tabungan dan Asuransi Pegawai Negara or commonly called PT Taspen (Perser. which is assigned by the government to manage and run pension programs for Civil Servants (PNS). Pension fund management companies or institutions, such as PT Taspen, are responsible for ensuring that sufficient funds are provided to meet future pension obligations. One actuarial method that is widely used to calculate pension fund liabilities is Projected Unit Credit (PUC). The PUC method takes into account employees' pension rights based on projected future salary increases, as well as years of service. This approach allows companies to calculate pension obligations more accurately and realistically, given the dynamics of salary increases and employee career development. Thus, this method provides a clearer picture of the costs that companies must prepare to meet future pension obligations. This case study aims to examine how the PUC method is applied in the calculation of actuarial liabilities at PT Taspen Cirebon Branch, as well as evaluate the extent to which this method is able to provide an appropriate calculation related to the company's pension obligations. Through this study, it is expected to gain a deeper understanding of the mechanism of calculating pension funds using the PUC method, as well as its contribution in facilitating corporate financial planning related to pension The findings of this study are also expected to provide insights for other institutions or companies that face similar challenges in managing employee pension funds. Amalia et al. / International Journal of Quantitative Research and Modeling. Vol. No. 3, pp. 256-261, 2024 Materials and Methods Materials The object used in this research is secondary data, namely data on Civil Servants (PNS) participating in the pension program at PT Taspen Cirebon Branch Office in 2022 which contains the gender of the participant, the age of the participant when appointed as a civil servant, retirement age, length of service, and last basic salary. In this study, pension benefits, present value of pension benefits, normal contributions, and actuarial liabilities will be determined using the Projected Unit Credit (PUC) method with the help of Microsoft Excel applications. Table 1: PT Taspen pension program participant data Participant Participants Length of Last Base Gender Retirement Entry Age Service Salary (IDR) Age Female Female Female Female Male Male Male Female Male Male Female Male Female Male Male Male Female Male Female Male The retirement age limit of different employees is adjusted to Government Regulation No. 17 of 2020 concerning Amendments to Government Regulation No. 11 of 2017 concerning Civil Servant Management. And the final basic salary of employees is adjusted to the latest regulation, namely Government Regulation No. 5 of 2024 concerning the Nineteenth Amendment to Government Regulation No. 7 of 1997 concerning Civil Servant Salary Regulations. The interest rate assumption used in this study is taken from the company's internal assumptions used by PT Taspen, which is 9. 7% ( = 9. 7%), and the proportion of civil servant salaries according to government regulations is 2. ( = 2. 5%). Methods This paper will determine the amount of normal contributions and actuarial liabilities using the Projected Unit Credit (PUC) method. This paper is conducted through the following steps: Compile the data obtained in the excel calculation table based on the Indonesian Mortalita Table IV 2019 with the assumption of the interest rate used by PT Taspen, which is 9. 7% ( = 9. 7%), Calculating the amount of pension benefits ( ) based on the last salary assumption, with the known age of entry into work, the retirement age of the participant, the last basic salary ( ) and the proportion of salary in accordance with government regulations which is 2. 5% ( = 2. 5%). Calculate the present value of pension benefits (PVFB) based on the amount of pension benefits that have been obtained previously, the initial lifetime annuity, the discount factor, and the chances of someone living today . ge year. until retirement age years. Amalia et al. / International Journal of Quantitative Research and Modeling. Vol. No. 3, pp. 256-261, 2024 Calculating normal contributions and actuarial liabilities using the Projected Unit Credit (PUC) method based on the present value of pension benefits (PVFB), total service period, and remaining service period of . Analyze and evaluate the calculation results, and draw conclusions. Results and Discussion Example of Actuarial Calculation of Pension Fund An example of an actuarial calculation of a pension fund that will be carried out by taking a random sample of data that has been obtained. The sample used is participant number 9 with male gender, which is assumed when the calculation is carried out to be 32 years old ( = . , appointed as a civil servant at the age of 29 years ( = . , retirement age of 58 years ( = . with the basic salary for the last year is IDR 49,297,200. 49,297,200. Next, we will find the normal contribution and actuarial liability of the participant. Calculation of Pension Benefits An example of calculating the amount of pension benefits based on the final salary assumption for presented below. = 58 is So, the amount of pension benefits received by participants when they retire at the age of 58 is IDR 35,740,470. Furthermore, the amount of pension benefits is used to calculate the present value of pension benefits. Calculation of Present Value of Future Benefits (PVFB) Example of calculating the present value of future benefits for participants at the age of entry and the age at which the calculation is made. Present value of future benefits at entry age ( = . The present value of pension benefits that participants will get at the entry age ( 21,272,839. Present value of pension benefits at calculation age ( = . = 29 year. is IDR The present value of pension benefits that participants will get at the calculation age of 32 years is IDR 28,146,683. The results of the calculation of the present value of subsequent pension benefits until the participant reaches pension age . = . with B_r = 35,740,470 using the excel application are shown in Table below. Then the present value of pension benefits that have been obtained will be used to calculate normal contributions and actuarial liabilities. Amalia et al. / International Journal of Quantitative Research and Modeling. Vol. No. 3, pp. 256-261, 2024 Table 2: Calculation of Present Value of Future Benefits (PVFB) with 21,272,839. 23,352,651. 25,637,086. 28,146,683. 30,903,797. 33,933,023. 37,261,416. 40,919,557. 44,940,885. 49,362,842. 54,226,412. 59,578,722. 65,471,123. 71,960,706. 79,111,776. 86,995,277. 95,692,187. 105,292,312. 115,897,400. 127,620,577. 140,587,429. 154,938,677. 170,835,573. 188,454,430. 208,001,238. 229,709,520. 253,836,737. 280,673,414. 310,528,915. 343,736,978. Projected Unit Credit (PUC) An example of calculating the normal contribution amount using the PUC method for participants when the calculation age is performed ( = . , with the known is presented as follows. The results obtained show that the amount of normal contributions that must be paid by participants when they are 32 years old is IDR827,843. The results of the calculation of the next normal contribution using the PUC method until the participant reaches retirement age ( = . are shown in Table 3 below. Amalia et al. / International Journal of Quantitative Research and Modeling. Vol. No. 3, pp. 256-261, 2024 Table 3: Calculation of normal contributions using the PUC method 21,272,839. 23,352,651. 25,637,086. 28,146,683. 30,903,797. 33,933,023. 37,261,416. 40,919,557. 44,940,885. 49,362,842. 54,226,412. 59,578,722. 65,471,123. 71,960,706. 79,111,776. 86,995,277. 95,692,187. 105,292,312. 115,897,400. 127,620,577. 140,587,429. 154,938,677. 170,835,573. 188,454,430. 208,001,238. 229,709,520. 253,836,737. 280,673,414. 310,528,915. 343,736,978. 625,671. 686,842. 754,031. 827,843. 908,935. 998,030. 1,095,924. 1,203,516. 1,321,790. 1,451,848. 1,594,894. 1,752,315. 1,925,621. 2,116,491. 2,326,816. 2,558,684. 2,814,476. 3,096,832. 3,408,747. 3,753,546. 4,134,924. 4,557,019. 5,024,575. 5,542,777. 6,117,683. 6,756,162. 7,465,786. 8,255,100. 9,133,203. 10,109,911. Conclussion Based on the calculation results and discussion from the previous chapter, the following conclusions are obtained: The total value of normal pension fund contributions calculated from the time the participant is appointed as a civil servant until the retirement age of 58 years using the Projected Unit Credit (PUC) method is IDR102,320,005. The actuarial liability value of pension funds that must be paid by PT Taspen when the participant is 57 years old using the Projected Unit Credit (PUC) method is IDR255,187,422. The Projected Unit Credit (PUC) method is more beneficial for pension plan participants and PT Taspen, because the total normal pension fund contributions that must be paid by participants using the Projected Unit Credit (PUC) method are smaller than the Attained Age Normal (AAN) method, and the value of actuarial liabilities that must be paid by PT Taspen using the Projected Unit Credit (PUC) method increases each year smaller than the Attained Age Normal (AAN) method. References