vjdarne
1

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
loginmiraclelogistics
1064

Hi Vjdarne, A model working is attached. You are free to amend to suit your requirement.
From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls CTC for 5.00L Gross.xls (25.0 KB, 472 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.