Endres Actuarial
  • Home
  • Excel Add-in
  • Versions
  • Download
  • Purchase
  • Contact
  • Terms
  • News

PV Tools Update Version 2022.4

7/7/2022

0 Comments

 
Added 417(e) table for lump sum calculations, and IRS 430(h)(3) static mortality tables for 2023 per IRS Notice 2022-22:
  • LS2023
  • IRS2023-ANN-F
  • IRS2023-ANN-M
  • IRS2023-APP
  • IRS2023-COM-F
  • IRS2023-COM-M
  • IRS2023-NON-F
  • IRS2023-NON-M
Added new 430(h)(3) Static Mortality Tables per IRS Proposed Regs April 27, 2022:
  • IRS2023-F
  • IRS2023-M
  • Added new tables 2012 Pri-2012 special base tables:
    -- IRS2012BASE-ANN-M
    -- IRS2012BASE-ANN-F
    -- IRS2012BASE-NON-M
    -- ​IRS2012BASE-NON-F

Added new sheet for "Lifetime income illustration".

Added new function TRate30IRS that returns the "IRS 30-yr TSR" which may be different from the Federal Reserve 30-year rate that is returned by the TRate30 function.

Added audit for PVSLPPA function.

Made a minor correction in the PVJL function, when using calculation method 1 or 2, and when using generational mortality improvement ("/gen" option), with a fractional age that, if rounded, would round to the next larger whole integer. Note that this does not affect calculation method 0, 8, or 9, or any other mortality table. If you find that this raises an issue for your calculations, please contact technical support.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Archives

    May 2025
    October 2024
    June 2024
    May 2024
    March 2024
    January 2024
    November 2023
    October 2023
    May 2023
    December 2022
    September 2022
    July 2022
    April 2022
    December 2021
    November 2021
    February 2021
    January 2021
    December 2020
    November 2020
    May 2020
    December 2019
    November 2019
    October 2019
    August 2019
    April 2019
    March 2019
    December 2018
    August 2018
    February 2018
    November 2017
    October 2017
    March 2017
    February 2017
    January 2017
    December 2016
    November 2016
    October 2016
    September 2016
    February 2016
    January 2016
    October 2015
    July 2015
    June 2015
    January 2015
    December 2014
    November 2014
    October 2014
    June 2014
    May 2014
    February 2014
    January 2014
    November 2013
    October 2013
    September 2013
    August 2013
    April 2013
    March 2013

    RSS Feed

Endres Actuarial Computing
Copyright © 2014-2025
Endres Actuarial Computing
All rights reserved
email: [email protected]
phone: 952-221-1000