Excel Functions in EAC ToolsExcel Functions in EAC Tools\Interest rate functionsInterest rate functions\Pension plan funding segment rates\ARPA\SegRateTextLongARPA
SegRateTextLongARPA

SegRateTextLongARPA returns a text string description of the Post-ARP/IIJA adjusted 24-month average segment rate under § 430(h)(2), for a given month/year. These rates are published monthly at the IRS web site.

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%”.

Syntax

SegRateTextLongARPA (Date, Month, [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.

ForPlanYearBeg

Cannot be before 2020.
Optional, if omitted then the value provided for Year will be used by default.