SegRateARPA
returns
the Post-ARP/IIJA
adjusted 24-month average segment rate under § 430(h)(2), for a given month and year. These rates are
published monthly at the IRS web site.
Syntax
SegRateARPA (Year, Month, SegRateNum, [ForPlanYearBeg])
|
Parameter Name
|
Description
|
|
Year
|
Year
or date (not before September
2019). Instead of a year, you may provide a date as
m/d/year, in which case Month will be ignored.
|
|
Month
|
Month (not before September 2019).
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 November 2024, the function returns “5.03/5.28/5.59”.
This
is the same as the SegRateTextARPA
function.
|
|
“long”
|
Returns
a text string description of the segment rates for the given month/year.
For
example, for November 2024, the function returns “Post-ARP/IIJA
adjusted 24-month average segment rates, for November 2024, for plan years
beginning in 2024: 5.03%, 5.28%, 5.59%”.
This
is the same as the SegRateTextLongARPA function.
|
|
|
ForPlanYearBeg
|
Cannot be before 2020.
Optional, if omitted then the value provided for Year will be used by
default.
|