Home > Money > Question
Need Expert Advice?Our Gurus Can Help

Confused about PF calculation? A financial advisor answers your questions

Milind

Milind Vadjikar  |541 Answers  |Ask -

Insurance, Stocks, MF, PF Expert - Answered on Oct 31, 2024

Milind Vadjikar is an independent MF distributor registered with Association of Mutual Funds in India (AMFI) and a retirement financial planning advisor registered with Pension Fund Regulatory and Development Authority (PFRDA).
He has a mechanical engineering degree from Government Engineering College, Sambhajinagar, and an MBA in international business from the Symbiosis Institute of Business Management, Pune.
With over 16 years of experience in stock investments, and over six year experience in investment guidance and support, he believes that balanced asset allocation and goal-focused disciplined investing is the key to achieving investor goals.... more
Bhagwan Question by Bhagwan on Sep 27, 2024Hindi
Listen
Money

I want excel sheet for calculation of PF 12%, if basic pay is 20000 and 12% pf to be deducted on less than or equal to 15000

Ans: Hello;

Not possible to share excel sheet here but calculation is given below;

Employee contribution (EPF): 12% of basic(20000)= 2400

Employer contribution (EPF): 3.67% of basic(20000)=734

Employer contribution (EPS): 8.33% of Basic or 15K= 1250

Best wishes;
DISCLAIMER: The content of this post by the expert is the personal view of the rediffGURU. Users are advised to pursue the information provided by the rediffGURU only as a source of information to be as a point of reference and to rely on their own judgement when making a decision.
Money

You may like to see similar questions and answers below

Ramalingam

Ramalingam Kalirajan  |6861 Answers  |Ask -

Mutual Funds, Financial Planning Expert - Answered on May 19, 2024

Listen
Money
My name ANJAN KUMAR SAHU , 2013 MY PF DEDUCTED TOTAL 22000 IN L&T BUT I DONT KNOW THE PF NO HOW I WILL WITHDRAW I LEFT COMPANY IN 2013
Ans: Hello Anjan,

I understand that you left your company, L&T, in 2013 and are now looking to withdraw your provident fund (PF) amounting to ?22,000. Not knowing your PF number can be challenging, but there are ways to retrieve it and proceed with your withdrawal.

Steps to Retrieve Your PF Number
1. Contact Your Previous Employer
Reach out to the Human Resources (HR) or Payroll department of L&T. They should have records of your employment and can provide your PF number. Explain your situation and provide details such as your employee ID, the period of your employment, and any other relevant information.

2. Check Your Payslips
If you have access to your old payslips, they might contain your PF number. Payslips usually have detailed breakdowns of your salary, including deductions for PF.

3. Use the UAN Portal
If your Universal Account Number (UAN) was generated during your employment, you can retrieve your PF details through the UAN portal.

Visit the EPFO website: UAN Portal

Activate UAN: If not already done, activate your UAN by clicking on 'Activate UAN' and following the steps. You will need your Member ID, Aadhaar, or PAN.

Check PF Details: Once your UAN is activated, you can log in to the portal and view your PF account details.

4. EPFO Helpdesk
Contact the Employee Provident Fund Organisation (EPFO) helpdesk. They can assist you in retrieving your PF number using your personal details and employment history.

EPFO Helpdesk Number: 1800 118 005

Email: Contact your regional EPFO office via email. Find the contact details on the EPFO website.

Steps to Withdraw Your PF
Once you have retrieved your PF number, you can proceed with the withdrawal process.

1. Fill Out the Composite Claim Form
There are two types of forms based on whether you have an Aadhaar:

Composite Claim Form (Aadhaar): If your UAN is Aadhaar-seeded and KYC-compliant, you can submit this form directly to the EPFO office without employer attestation.

Composite Claim Form (Non-Aadhaar): If your UAN is not Aadhaar-seeded, you need your employer's attestation before submitting this form to the EPFO office.

2. Submit the Form
Submit the filled form to your regional EPFO office. Ensure you attach all necessary documents such as your identity proof, bank account details, and cancelled cheque.

3. Online Submission (if UAN is Active)
If your UAN is active and Aadhaar-seeded, you can also apply for PF withdrawal online:

Log in to UAN Member Portal: UAN Portal

Go to Online Services: Select 'Claim (Form-31, 19, 10C & 10D)'.

Enter Bank Account Details: Verify your bank account details linked with UAN.

Submit Claim: Select the claim you require (PF withdrawal, pension withdrawal, etc.), and submit.

4. Track Your Claim
After submission, you can track the status of your claim through the UAN portal or by contacting the EPFO helpdesk.

Conclusion
By following these steps, you can retrieve your PF number and proceed with the withdrawal process. It may take some time, but persistence will help you access your funds.

Best Regards,

K. Ramalingam, MBA, CFP,

Chief Financial Planner,

www.holisticinvestment.in

..Read more

Latest Questions
Milind

Milind Vadjikar  |541 Answers  |Ask -

Insurance, Stocks, MF, PF Expert - Answered on Oct 31, 2024

Listen
Money
Sir My Age is 38 Now. Running Business In Pune city. Below are the My Assets & Liabilities. Current Values - Assets. Own Industrial Plot - Rs. 2.0 Cr Business Income Yearly Rs. 24.00 Lack Own Company Investment ( Machinery, Debtors Etc ) - Rs 2.40 Cr Mutual Fund & Share Market Investment Rs. 2.10 Cr Bank FD - Rs. 50.00 Lack Own 3 Flats in Pune - Rs. 75 lack, 50 Lack & 35 Lack ( Current Values ) Golds - Rs. 25.00 Lack Land - Agriculture - Rs. 50.00 Lack Term Insurances - Rs. 20.00 Lack ( Till Date Premium Paid ) Labilities. House Loan - Rs. 30.00 Lack ( EMI 26500.00 PM ) Loan will close after 17 years. Car Loan - Rs. 6.35 lack ( EMI 12500.00 PM ) Loan will close after 5 years. This Assets & investment sufficient for maintain 7 family members Expenses after retirement ? ( 4 Adult + 3 Children (Below 5 Years) ). I will retire at the age of 45.
Ans: Hello;

What is the expected monthly rental from industrial plot and machinery?

Are you currently occupying one of the flats mentioned here or are all of them given on rent?

Also your term life insurance is very low. You should have minimum term insurance cover of 2.4 Cr.

You have good assets in agri land, industrial land, gold, real estate but they are relatively illiquid when need arises hence term insurance cover with riders for critical care and accident benefit are an absolute must!

Considering the home loan tenure of 17 years and 3 small kids in the family to be supported for education and decent lifestyle, I am not sure if you can retire in 7 years timeframe from now.

However I would appreciate your reply to my queries above, before I give my firm view about your retirement in 7 years timeframe.

Best wishes;

...Read more

Radheshyam

Radheshyam Zanwar  |1013 Answers  |Ask -

MHT-CET, IIT-JEE, NEET-UG Expert - Answered on Oct 31, 2024

Milind

Milind Vadjikar  |541 Answers  |Ask -

Insurance, Stocks, MF, PF Expert - Answered on Oct 31, 2024

Asked by Anonymous - Oct 30, 2024Hindi
Listen
Money
I have around 1 crore to invest. I am 61 years old retired defence officer and pension amounting to around ?1,50,000/- per month and medically covered. Need some sound investment plan for 1 crore. Don't have any liabilities?
Ans: Hello;

You may invest your corpus into following two funds in proportion of 50:50,

1. Kotak Arbitrage fund (low risk)
You may consider modest return of 6% from this scheme.

2. ICICI Pru equity savings fund (low to moderate risk). You may consider modest return of 8% from this scheme.

Theses investments will retain purchasing power of your corpus aginst inflation and deliver some real returns too with low to moderate risk.

This is in accordance with your age and commensurate risk appetite.

Happy Investing;

*Investments in mutual funds are subject to market risks. Please read all scheme related documents carefully before investing.

...Read more

Milind

Milind Vadjikar  |541 Answers  |Ask -

Insurance, Stocks, MF, PF Expert - Answered on Oct 30, 2024

Asked by Anonymous - Oct 30, 2024Hindi
Listen
Money
Hello Sir, I am 53 years, planned for retirement in 3 years. Have MF investment about 80 lacs, FDs about 20 Lacs, will invest 50 lacs in the coming three years through investment in MF. I don’t have any loan, living in my own home. My current monthly expenditure is Rs 65,000. How can I plan with the above corpus for my retirement so as get monthly payout? Whether to go for SWP - Balanced advantage funds or SWP- Debt funds for my monthly income? Is this correct plan? I will be needing 75,000 per month after my retirement. How much LTCG will I have to pay on 75,000 per month? Will there be any exit load while changing to SWP? What should be my investment strategy? Can you suggest some SWP funds?
Ans: Hello;

If you put your current corpus (1 Cr) in a equity savings type mutual fund with moderate risk(for eg Kotak equity savings fund)then it may grow to 1.3 Cr in 3 years.

Your 50 L additional investments staggered over 3 years in the same fund may yield you a corpus of around 60 L. (Modest return of 9% considered).

If you do SWP at 3% you may expect post tax income of 41.5 K.

Alternately if you buy an annuity from a life insurance company for your corpus then considering 6.5 % annuity rate you may expect post tax income of 77 K.

You can do SWP also at 6.5% rate but you run the risk of eating into your corpus heavily during prolonged drawdowns or sideways movements of the market.

SWP from equity oriented(hybrid) schemes is tax efficient solution for monthly income but it has its own set of risks and other negative aspects.

Ranking preference for retirement income should be as follows:
1. Statutory pension
2. POMIS
3. SCSS (Quarterly income)
4. FDs with big Govt banks
5. Rental income
6. Annuity
7. SWP

SWP is recommended for those who retire early, say in 40s, and also have a big corpus so that minimum SWP rate can meet monthly requirements and corpus can grow atleast to beat inflation for the longer retirement period.

Happy Investing;

...Read more

DISCLAIMER: The content of this post by the expert is the personal view of the rediffGURU. Investment in securities market are subject to market risks. Read all the related document carefully before investing. The securities quoted are for illustration only and are not recommendatory. Users are advised to pursue the information provided by the rediffGURU only as a source of information and as a point of reference and to rely on their own judgement when making a decision. RediffGURUS is an intermediary as per India's Information Technology Act.

Close  

You haven't logged in yet. To ask a question, Please Log in below
Login

A verification OTP will be sent to this
Mobile Number / Email

Enter OTP
A 6 digit code has been sent to

Resend OTP in120seconds

Dear User, You have not registered yet. Please register by filling the fields below to get expert answers from our Gurus
Sign up

By signing up, you agree to our
Terms & Conditions and Privacy Policy

Already have an account?

Enter OTP
A 6 digit code has been sent to Mobile

Resend OTP in120seconds

x