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

SegRateTextARPA returns all three segment rates for the Post-ARP/IIJA adjusted 24-month average segment rate under §430(h)(2), in a “/” delimited text string, for a given month/year. This can be used as the interest rate parameter for various present value functions. These rates are published monthly at the IRS web site.

For example: for November 2024, the function returns “5.03/5.28/5.36”.

Syntax

SegRateTextARPA (Date, Month, ForPlanYearBeg)

Parameter Name

Description

Year

Year or date (not before September 2019).

Month

Month (not before September 2019)

ForPlanYearBeg

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