deepcalc
DocsINTRATE

INTRATE

View as markdown/docs/functions/intrate.md Ask Claude about this pageOpens Claude with this page's address

Interest rate of a fully invested security.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=INTRATE(DATE(2026,1,15), DATE(2026,12,15), 1000, 1050)
Result 0.0545454545454546

Syntax

INTRATE(settlement, maturity, investment, redemption, [basis])
settlement
number required
maturity
number required
investment
number required
redemption
number required
basis
number optional

Errors

#NUM!
=INTRATE(2, 2, 2, 4)
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.