Excel Functions in EAC ToolsExcel Functions in EAC Tools\Interest rate functionsInterest rate functions\Treasury rates\TRate30IRS

TRate30IRS

TRate30IRS returns the 30-year Treasury Securities Rate for a given month/year (average all business days in month). These rates are published by IRS. Note that these rates are usually, but not always, the same as the 30-year Treasury rate published by the Federal Reserve that is returned by the TRate30 function.

Syntax

TRate30IRS (Year, [Month])

Parameter Name

Description

Year

Year (not before Jan 2002); 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 2002)
Optional, not used if Year is entered as a date (m/d/y), in which case Month must be blank