- Added mortality improvement scale MP-2021 announced by Society of Actuaries.
- Updated mortality table "LS2023" to use MP-2021. Note that IRS mortality tables for years 2023 and later are not available yet. The results produced using "LS2023" are based on the methodology in effect for 2022, (using mortality improvement MP-2021 announced by the SOA on 10/20/2021) per IRS Notice 2020-85 on December 14, 2020. Another update will be issued when the IRS announces the 2023 static mortality tables.
- Added new shortcut functions: PVSL12, PVJL12, EIRSL12. These are the same as the regular functions PVSL, PVJL, EIRSL with the following simplifying parameters:
* Frequency = 12 (monthly)
* COLA = 0 (no COLA)
* CalculationMethod = 1 (exact method)
* NoPreRetMort = 0 (use pre-retirement mortality)
* AnnTiming = 0 (beginning of month) - Fixed an issue with the right-click pop-up menu.
- Added "Audit" to the right-click pop-up menu.
- In the PVJL function, when using "years certain option" = 1, and "years certain" > 0, and calculation method = 0, 8, 9; fixed a bug where the function returned only the present value of the certain period, and not the deferred portion of the annuity.
- Minor fix for a strange Windows/Excel issue that was reported by a new user, causing Excel to fail to open.
0 Comments
Your comment will be posted after it is approved.
Leave a Reply. |
Archives
April 2025
|