SegRateText

SegRateText returns all three minimum present value spot segment rates under §417(e)(3), for a given month and year, in a “/” delimited text string. This can be used as the interest rate parameter for various present value functions. These rates are published monthly at the IRS web site.

For example: for August 2017, the function returns “1.93/3.57/4.36”.

Syntax

SegRateText (Date, Month, [ForPlanYearBeg])

Parameter Name	Description
Year	Year or date (not before August 2007). Instead of a year, you may provide a date as m/d/year, in which case Month will be ignored.
Month	Month (not before August 2007). Ignored if Year is provided as a date.
ForPlanYearBeg	Needed only if year < 2013. Cannot be before 2008. Optional, not used if Year >= 2013.