deepcalc
DocsRRI

RRI

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

Returns equivalent interest rate for growth.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=RRI(96, 10000, 11000)
Result 0.0009933073762913303

Syntax

RRI(nper, pv, fv)
nper
number required
pv
number required
fv
number required
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.