Asso.prof.(commerce & Management)

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Hi All, According to my company standards, the CTC breakup is as below:
i)Basic - 40% of ctc
ii)HRA - 50% of basic
iii)LTA - 1 month basic in a year
iv)Other allowance - "x" value
We also include employers PF in CTC which is capped to maximum 1800 pm and is calculated on basic and Other allowance. So here i have 2 values that are unknown ie PF calculation and OA. Please help me out with an excel formula to work out the same.

From India, Mumbai
Hi Vjdarne, A model working is attached. You are free to amend to suit your requirement.
From India, Bangalore

Attached Files
File Type: xls CTC for 5.00L Gross.xls (25.0 KB, 303 views)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™