Group Gratuity, Leave Encashment & Retirement Corpus Calculator
Actuarial mathematical cashflow model for accrued liability, lifecycle retirement payouts, Group Insurance cover, and planned annual funding.
📋 How to Enter Employee Cohort Data:
Monthly Basic: Current basic salary + DA per employee.
Service (Completed Yrs): Total continuous years served till date.
Annual Hike (%): Expected compounded annual salary increment rate.
Years to Retire: Balance working years remaining before retirement.
No. of Employees: Total headcount in this category.
1. Employee Cohorts / Categories
| Category / Grade | Monthly Basic (₹) | Completed Service (Yrs) | Annual Hike (%) | Years to Retire | No. of Employees |
|---|
2. Gratuity Funding & Investment Strategy
3. Liability & Insurance Valuation Summary
Accrued Liability (Till Date)
₹0
Total Lifetime Settlement Outflow
₹0
Ideal Annual Sinking Contribution
₹0
Group Insurance Cover (Sum Assured)
₹0
4. Year-Wise Gratuity Outflow & Fund Solvency (Till Last Employee Retires)
| Timeline | Retiring Headcount | Opening Fund (₹) | Planned Contribution (₹) | Interest Earned (₹) | Gratuity Payable (₹) | Closing Fund Balance (₹) |
|---|