Excel Functions

Excel INTRATE Function

Pinterest LinkedIn Tumblr

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.


=INTRATE (settlement, maturity, investment, redemption, [basis])


settlementThe 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
investmentThe total amount invested in the security. Mandatory
redemptionThe 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.
0 or omittedUS (NASD) 30/360
1 Actual/actual
4European 30/360


Since 2007 for Windows.
Since 2011 for Mac.

Related Posts

Write A Comment