Hi,
I'm sharing the excel sheet with you. However, we modify the formula in excel sheet whenever we require. I need this because we, at many times, first decide the gross or CTC, then break the salary components as some times candidate asks for specific salary figure in terms of take home or gross. We've to optimize the structure so that his take home is maximum and legal liabilities and IT are minimum. I've seen this flexibility in some companies where negotiation goes for salary.
Attachments:
