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

EAC PV Tools updated

5/20/2014

0 Comments

 
  1. SL and JL present value functions have been enhanced to allow the use of monthly mortality rates (based on UDD). This allows for a slightly more precise calculation of present values especially when using segment interest rates.

  2. User-defined mortality tables can be used. Create your own q's -- project, blend, combine, and feed into the function call.

  3. 417(e)(3) applicable mortality tables are available (1995 through 2015). For example, to use the mortality table for lump sums paid in 2014, the table name is "LS2014".

  4. SL and JL present value functions allow the user to specify the interest rate as 3 segment rates (for first 5 years, next 15 year, thereafter). For example, instead of entering interest as a single rate like ".0525" you can enter interest like ".0097/.035/.046" or ".97/3.5/4.6" or ".97%/3.5%/4.6%".

  5. SL and JL present value functions allow the user to specify the interest rate as a yield curve. For example, instead of entering interest as a single rate like ".0525" you can enter interest as a "range" containing your own spot rates. ALSO, you can enter interest like "citi 3/2014" or "irs 4/2014" to use yield curve sport rates published by Citigroup and IRS. In order to do this you need to download yield curve files Citigroup Pension Discount Curve from the Society of Actuaries and Recent Yield Curve Spot Rates from the IRS and save them in the same folder where the add-in is saved.

  6. A new function "EIRSL" (with the same calling syntax as PVSL) returns the effective interest rate. This is useful for when you are using segment rates or a full yield curve.
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