It is so simple to calculate GP Fund with the help of most easiest type of GPF calculator in excel format (Sheet) for all the Government employees of Federal and provinces like Punjab, KPK, Sindh, Balochistan.
If you can remember the formula of how to calculate GPF interest in excel in the fiscal year 2020-21 then it is so simple check your GP fund statement at home.
This GP Fund calculator is prepared with the efforts of Mr. Zia Mustafa. This subscription of GP fund ratio is deducted on monthly basis and will be reflected in the salary slip of employee.
Everyone can get the GP fund statement on yearly basis from their concerned accounts department. Mostly, the the rate of interest of GP fund is being changed after every budget. The new interest rate of GP fund 2020 will be announced in upcoming budget 2021-22.
GPF Interest Calculator 2021 in Excel Formula
GP fund is the amount which is deducted of every Govt employee in monthly basis according to the implemented interest rate. Rate of GPF interest calculation formula varies normally on yearly basis. Every year new rates of the GP Fund Interest are issued by the Govt department.
GPF Interest = (Rate of Subscription x 6.50 + Opening Balance) x Rate of Interest