INTRATE
Returns the interest rate for a fully invested security
Syntax
INTRATE(settlement, maturity, investment, redemption, [basis])
Parameters
- settlement: Required. The security's settlement date
- maturity: Required. The security's maturity date
- investment: Required. The amount invested in the security
- redemption: Required. The amount to be received at maturity
- basis: Optional. The type of day count basis
Example
=INTRATE("02/15/2024", "05/15/2024", 1000000, 1014420, 2)