SegRatePPAMax
returns all
three segment rates for the 24-month average segment rate under §430(h)(2), in a “/”
delimited text string for a given month/year. These rates are
published monthly at the IRS web site.
Syntax
SegRatePPAMax (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.36”.
This
is the same as the SegRateTextPPAMax function.
|
|
“long”
|
Returns
a text string description of the segment rates for the given month/year.
For
example, for November 2024, the function returns “24-month
average segment rates, not adjusted for 25-year averages, for November
2024, for plan years beginning in 2024: 5.03%, 5.28%, 5.36%
This
is the same as the SegRateTextLongPPAMax function.
|
|
|
ForPlanYearBeg
|
Cannot be before 2020.
Optional, if omitted then the value provided for Year will be used by
default.
|