deepcalc
DocsMIRR

MIRR

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

Returns modified internal rate of return.

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

Examples

=MIRR(K1:K5, 0.1, 0.12)
K
1 -100000
2 30000
3 40000
4 50000
5 60000
Result 0.20139202041968263

Syntax

MIRR(values, finance_rate, reinvest_rate)
values
range required
finance_rate
number required
reinvest_rate
number required

Errors

#DIV/0!
=MIRR(A1:A3, 0.05, 0.05)
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.