• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Building Discount Formulas > Calculating the Internal Rate of Retur...

Calculating the Internal Rate of Return for Nonperiodic Cash Flows

As with NPV(), the IRR() function works only with periodic cash flows. If your cash flows are nonperiodic, use the XIRR() function instead:

XIRR(values, dates, [guess])


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint