Question 1079741
you use the IRR function to find the internal rate of return.
you use the NPV function to determine if the internal rate of return was calculated correctly.
if the NPV is 0, then the internal rate of return was calculated correctly.
here's a picture of my excel spreadsheet.
<img src = "http://theo.x10hosting.com/2017/050601.jpg" alt="$$$" </>
any questions, send an email to dtheophilis@gmail.com