IntDesc returns a text description for a given interest rate that is provided as the InterestRate parameter for any function. For example, if InterestRate = “3.01/4.11/4.41”, then IntDesc function returns “Interest: PPA segment interest rates: 3.01% for payments made in the first 5 years, 4.11% for next 15 years, 4.41% thereafter”.
Syntax
IntDesc (InterestRate)
|
Parameter Name |
Description |
|
InterestRate |
The interest rate(s) to discount future
payments to calculate the present value. May be a number, a percentage, a
text string, a named range, or reference to a range. ·
Rates
can be defined using these interest definitions. Note: A value that is greater than 25% (i.e.
0.25) will be divided by 100; e.g. if you enter 2.75 it will be treated
as .0275 or 2.75%. |
Related Topics