Curious About Your Provident Fund Growth? Try This Easy Excel Calculator!

Here is an Excel file attached, in which you can calculate your Provident Fund interest. Just input your contribution for any year and the interest rate for that year, and the calculation will be done by the file itself.

Thanks & Regards,
Nitesh Barman

Hi Nitesh Barman, Is this the correct format? It seems to be wrong when I calculate my PF+EPF by adding it and putting interest (9.50%) on the whole figure, I am getting a very small amount as interest. As per my knowledge, PF is calculated only once a year (after April). But in this format, it is being calculated every month. How is this possible?

Regards,
Vinay Kumar

Hi, maybe you are right that interest is credited to your account in the month of April, but the calculation is made each month of contribution. It's called compound calculation of interest; I think you have heard about it.

Hi, please find the file attached to this post. I have attached my PF contribution, where I do not have an opening balance in my account because this is a new account. In the attachment, you can find my estimated amount, which will be the output at the year-end (April).

I joined Zenara Pharma on 13th May, and at that time, my basic was 5818, and my PF was 698. Please verify if this information is correct.

Also, please provide me with the calculation for each month. What percentage are we going to add each month?

Regards,
Vinay Kumar

I have attached the file. In my view, it should be like this. If I am wrong, please suggest to me.

Regards

The Excel sheet you prepared is excellent. However, there is one drawback that I would like to bring to your attention. When calculating PF accumulation and interest with an opening balance, it works excellently. But when attempting the same with a new account, it fails to calculate the accurate interest. You can either edit it yourself or provide me with the password or an unprotected file, and I can do it. Nevertheless, I genuinely appreciate your efforts in creating it.

With lots of compliments,

Abhijit.

My name is Arpan Srivastava. My PF EE amount is Rs. 32,377, and the ER amount is Rs. 9,889. I left my previous organization on 30th October 2011, and now I want to withdraw my PF. I have also generated a PF E-Passbook which shows Employee Contribution as Rs. 32,377 and Employer Contribution as Rs. 9,889 under the Deposit Column, with Rs. 16,724 diverted to the Pension Fund Column as of 31st March 2013. I would like to know the amount that will be transferred to my account.

Regards,
Arpan Srivastava
[Phone Number Removed For Privacy Reasons]

My name is Arpan Srivastava. My PF EE amount is Rs. 32,377, and the ER amount is Rs. 9,889. I left my previous organization on 30th October 2011. Now, I want to withdraw my PF. I have also generated a PF E-Passbook, which shows Employee Contribution as Rs. 32,377 and Employer Contribution as Rs. 9,889 under the Deposit column, with Rs. 16,724 diverted to the Pension Fund column as of 31st March 2013. I just want to know the amount that will be transferred to my account.

Regards,
Arpan Srivastava
Mobile: [Phone Number Removed For Privacy Reasons]
Email: [Email Removed For Privacy Reasons]