Excel Functions in EAC ToolsExcel Functions in EAC Tools\Interest rate functions

Interest rate functions

Excel Functions

Function Name

Category

Description

AnyRate

Interest

Function to return any available rate

IntDesc

Interest

Interest rate description

IntDisc

Interest

Interest discount

Rate120

Interest

120% Federal Mid-term Rate

SegRate

Interest

Minimum present value segment rate

SegRateText

Interest

Minimum present value segment rates: 3 rates in a text string

SegRateTextLong

Interest

Minimum present value segment rates in a long text string

SegRateX

Interest

Minimum present value segment rate (alternative function)

SpotRate

Interest

Spot rate from yield curve

TRate1

Interest

1-Year Treasury Rate (average all business days in month)

Trate3

Interest

3-Year Treasury Rate (average all business days in month)

TRate5

Interest

5-Year Treasury Rate (average all business days in month)

TRate10

Interest

10-Year Treasury Rate (average all business days in month)

TRate101

Interest

10-Year Treasury Rate (first business day in month)

TRate30

Interest

30-Year Treasury Rate (average all business days in month)

TRate30IRS

Interest

30-Year Treasury Rate (IRS 30-yr TSR) (average all business days in month)

 

These interest rate functions return various type of interest rates that are available in the add-in.