Hello Friends,
Just started working on Gratuity valuation and wanted to know how to calculate Past Service liability and future service contribution for 400 employees.I have data with me like salary escalation,discount rate,age,DOJ etc.
From India, Bengaluru
1Just started working on Gratuity valuation and wanted to know how to calculate Past Service liability and future service contribution for 400 employees.I have data with me like salary escalation,discount rate,age,DOJ etc.
From India, Bengaluru
The easy way out is to go for group gratuity policy of LIC. Anyway making provision for gratuity liability is accounting function.
From India, Mumbai
From India, Mumbai
Thanks Shirkant, Basically I am looking for gratuity valuation calculation and trying to find out Past Service liability and future service contribution. If you can help me with this
From India, Bengaluru
From India, Bengaluru
In excel sheet fill data under fields: name, DOJ, Years of service, Rate of last basic+DA, Gratuity amount
Gratuity liability on date can be calculated with above. At end of every month you will able to view your liability.
From India, Mumbai
Gratuity liability on date can be calculated with above. At end of every month you will able to view your liability.
From India, Mumbai
How to Calculate the Accountability in the Past in Bonus Valuation you share is great. Very good calculation and high efficiency. Thanks for sharing this great calculation.
vex 3
vex 3
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.
Calculate Your Age.xls
EPFO Not To Claim Past PF Dues Without Known Identity.pdf