deepcalc
DocsIRR

IRR

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

Calculates internal rate of return.

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

Examples

=IRR(K1:K5)
K
1 -100000
2 30000
3 40000
4 50000
5 60000
Result 0.24888335662407082
=IRR(K1:K5, 0.1)
Result, over the same cells 0.24888335662407082

Syntax

IRR(values, [guess])
values
number required
guess
number optional

Errors

#NUM!
=IRR(A1:A3)
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.