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

Chapter 20. Building Discount Formulas > Using the IRR() Function

Using the IRR() Function

You could figure this out by adjusting the discount rate up (in this case) until the NPV() calculation returns 0. However, Excel offers an easier method in the form of the IRR() function:

IRR(values, [guess])


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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