Description
The Commonwealth of Kentucky Department of Revenue is seeking an experienced actuarial consultant to update its Multiple Life Estate Calculator Excel worksheet. The contractor will incorporate the latest National Center for Health Statistics life‑expectancy tables and configure the model to handle a variety of multi‑life survivorship scenarios (two‑, three‑, and four‑life arrangements). Deliverables include a fully functional spreadsheet, documentation of methodology, and optional training or support for department staff. The contract is a personal service contract with a term from 15 Nov 2026 to 30 Jun 2028, and the award will be made after a technical, cost, and possible oral‑presentation evaluation.
• Update existing Excel calculator with 2026 NCHS life‑table data.
• Implement eight defined multi‑life estate scenarios.
• Provide technical documentation and methodology notes.
• Offer optional training or Q&A sessions for DOR staff.
• Submit separate technical, cost, and proprietary proposals via Kentucky e‑Procurement.
• Contract term ~19 months; renewal possible for up to two additional two‑year periods.