SegRateX

SegRateX returns the minimum present value segment rate for a month and year based on given payment date, and also based on a pension plan’s stability period and lookback months. These rates are published monthly at the IRS web site.

Syntax

SegRateX (PaymentDate, StabilityPeriod, Lookback, PlanYearStart, SegRateNum)

Parameter Name

Description

PaymentDate

Benefit payment date.

StabilityPeriod

The plan’s defined “stability period”: "year", "quarter", "month".

Lookback

The plan’s defined “lookback months”: from 1 to 5 months.

PlanYearStart

Month of first day of plan year (text or month number). Enter the month as:

· number (1 to 12), or

· text (“January”, “February, …, “December”), or

· text (“Jan”, “Feb, …, “Dec”).

SegRateNum

Option	Description
1	Returns the 1^st segment rate.
2	Returns the 2^nd segment rate.
3	Returns the 3^rd segment rate.
“all”	Returns all three rates in a “/” delimited text string for the given month/year. This can be used as the interest rate parameter for various present value functions. For example: for August/2017, the function returns “1.93/3.57/4.36”. This is the same as the SegRateText function.
“long”	Returns a text string description of the segment rates for the given month/year. For example: for August/2017, the function returns “Minimum present value segment rates for August 2017: 1.93%, 3.57%, 4.36%”. This is the same as the SegRateTextLong function.

ForPlanYearBeg

Needed only if year < 2013.
Cannot be before 2008.
Optional, not used if Year >= 2013.