The Excel INTRATE stands for interest rate, INTRATE is categorized under financial functions. INTRATE helps calculate the interest rate for a fully invested security.
Purpose of Excel INTRATE Function
To get interest rate for fully invested security.
Return value
INTRATE function returns interest rate as percentage.
Syntax
=INTRATE (settlement, maturity, investment, redemption, [basis])
Arguments
| Arguments | Description | Remarks |
| settlement | The security’s settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer. | Mandatory |
| maturity | The security’s maturity date. The maturity date is the date when the security expires. | Mandatory |
| investment | The total amount invested in the security. | Mandatory |
| redemption | The total amount to be received at maturity. | Mandatory |
| [basis] | The type of day count basis to use. | Optional |
Usage note
- Settlement, maturity, and basis are truncated to integers.
- If settlement or maturity is not a valid date, INTRATE returns the #VALUE! error value.
- If investment ≤ 0 or if redemption ≤ 0, INTRATE returns the #NUM! error value.
- If basis < 0 or if basis > 4, INTRATE returns the #NUM! error value.
- If settlement ≥ maturity, INTRATE returns the #NUM! error value.
| BASIS | DAY COUNT BASIS |
| 0 or omitted | US (NASD) 30/360 |
| 1 | Actual/actual |
| 2 | Actual/360 |
| 3 | Actual/365 |
| 4 | European 30/360 |
Availability
Since 2007 for Windows.
Since 2011 for Mac.