SegRate
returns
the minimum
present value segment rate for a given month and year. These rates are
published monthly at the IRS web site.
Syntax
SegRate (Year, Month, SegRateNum, [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 ignore.
|
|
Month
|
Month (not before August 2007).
Ignored if Year is provided as a date.
|
|
SegRateNum
|
Defines which rate to return.
|
Option
|
Description
|
|
1
|
Returns
the 1st segment rate.
|
|
2
|
Returns
the 2nd segment rate.
|
|
3
|
Returns
the 3rd 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.
|