Excel Functions in EAC ToolsExcel Functions in EAC Tools\Interest rate functionsInterest rate functions\Other interest functions\Rate120

Rate120

Rate120 returns the 120% Federal mid-term rate for a given month/year. These rates are available at the PensionSoft Corporation website. 120% Federal mid-term rates are downloaded from this URL.

Syntax

Rate120 (Year, Month)

Parameter Name

Description

Year

Year (not before Jan 1986); a 4 digit number;
or if a date (m/d/y) is entered, and the Month is missing, then the Year = y, and the Month = m

Month

Month (not before Jan 1986)
Optional, not used if Year is entered as a date (m/d/y), in which case Month must be blank