INT_RATE_SEC Function
Evaluates the interest rate of a fully invested security.
Usage
result = INT_RATE_SEC(settlement, maturity, investment, redemption, basis)
Input Parameters
settlementThe date on which payment is made to settle a trade. For a more detailed discussion on dates see Chapter 8, Working with Date/Time Data in the .
maturityThe date on which the bond comes due, and principal and accrued interest are paid. For a more detailed discussion on dates see Chapter 8, Working with Date/Time Data in the .
investmentThe total amount one has invested in the security.
redemptionAmount to be received at maturity.
basisThe method for computing the number of days between two dates. It should be 0, 1, 2, 3, or 4.
*0Actual/Actual
*1US (NASD) 30/360
*2Actual/360
*3Actual/365
*4European 30/360
Returned Value
resultThe interest rate for a fully invested security. If no result can be computed, NaN is returned.
Input Keywords
DoubleIf present and nonzero, double precision is used.
Discussion
Function INT_RATE_SEC computes the interest rate for a fully invested security.
It is computed using the following:
In the equation above, B represents the number of days in a year based on the annual basis, and DSM represents the number of days in the period starting with the settlement date and ending with the maturity date.
Example
In this example, INT_RATE_SEC computes the interest rate of a $7,000 investment with the settlement date of July 1, 1995, and maturity date of July 1, 2005, using the Actual/365 day count method. The total amount received at the end of the investment is $10,000.
settlement = VAR_TO_DT(1995, 7, 1)
maturity = VAR_TO_DT(2005, 7, 1)
investment = 7000.
redemption = 10000.
basis = 3
PRINT, INT_RATE_SEC(settlement, maturity, investment, $
   redemption, basis)
; PV-WAVE prints: 0.0428219