xnpv

  1. N

    XNPV Result is not 0 when I use the XIRR result as the rate

    I have a stream of cash flows for a financial model that I am building (pasted below). I am trying to calculate the IRR of the Gross and Net lines. For the Gross line, I entered the following formula =XIRR(G19:AD19,G17:AD17,0.5) and I get the result of 47.16%. I then try to verify that XIRR...
  2. E

    XNPV with negative rate

    Is it possible to have a negative rate with the XNPV function? My accountancy knowledge is not much above zero, but I am trying to help a friend, who's Excel skills are almost zero, so any help gratefully received. Steve

Some videos you may like

This Week's Hot Topics

Top