INTRATE function in Excel
Returns the interest rate for a fully invested security
=INTRATE(settlement, maturity, investment, redemption, [basis])INTRATE syntax and parameters
Five arguments, four required.
- settlementnumberRequired
The security's settlement date. The security settlement date is the date after the issue date when the security is traded to the buyer.
- maturitynumberRequired
The security's maturity date. The maturity date is the date when the security expires.
- investmentnumberRequired
The amount invested in the security.
- redemptionnumberRequired
The amount to be received at maturity.
- basisnumberOptional
The type of day count basis to use.
INTRATE examples
Formulas you'll actually reuse.
The simple annual interest rate of buying at 98,862.50 and receiving 100,000, actual/360:
=INTRATE(DATE(2026, 3, 15), DATE(2026, 6, 14), 98862.5, 100000, 2)Result
0.0455The same on actual/actual (1):
=INTRATE(B2, C2, D2, E2, 1)
INTRATE in Google Sheets
Same name — your formula ports as-is.
Try INTRATE in the playground
Edit the example — nothing to install.
Preloaded with the INTRATE formula from Example 1 — change anything and watch it respond.
Related functions
More ways Excel gets this done.
- ACCRINTReturns the accrued interest for a security that pays periodic interestFinancialGoogle Sheets
- ACCRINTMReturns the accrued interest for a security that pays interest at maturityFinancialGoogle Sheets
- AMORDEGRCReturns the depreciation for each accounting period by using a depreciation coefficientFinancialNo Google Sheets equivalent
- AMORLINCReturns the depreciation for each accounting periodFinancialGoogle Sheets
- COUPDAYBSReturns the number of days from the beginning of the coupon period to the settlement dateFinancialGoogle Sheets
- COUPDAYSReturns the number of days in the coupon period that contains the settlement dateFinancialGoogle Sheets