Excel Functions
Function
Name |
Category |
Description |
Interest |
Function to return any available rate |
|
Interest |
Interest rate description |
|
Interest |
Interest discount |
|
Interest |
120% Federal Mid-term Rate |
|
Interest |
Minimum present value segment rate |
|
Interest |
Minimum present value segment rates: 3
rates in a text string |
|
Interest |
Minimum present value segment rates in
a long text string |
|
Interest |
Minimum present value segment rate
(alternative function) |
|
Interest |
Spot rate from yield curve |
|
Interest |
1-Year Treasury Rate (average all
business days in month) |
|
Interest |
3-Year Treasury Rate (average all
business days in month) |
|
Interest |
5-Year Treasury Rate (average all
business days in month) |
|
Interest |
10-Year Treasury Rate (average all
business days in month) |
|
Interest |
10-Year Treasury Rate (first business
day in month) |
|
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.
Related Topics
Excel Functions in EAC Tools
Complete list of functions
Single life functions
Joint life functions
Actuarial equivalence functions
Age, date, more functions
Defined contribution plan functions
Commutation functions
Life expectancy and survival functions
Life insurance functions
More PV functions
Period certain annuity functions
Regulatory limits and other functions