Asso.prof.(commerce & Management) Pg

PRIME SPONSOR - FACTOHR - Customised Payroll, GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
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.
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Hi Vjdarne,
A model working is attached. You are free to amend to suit your requirement.

Attached Files
Membership is required for download. Create An Account First
File Type: xls CTC for 5.00L Gross.xls (25.0 KB, 152 views)

PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses
Add Reply Start A New Discussion

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™