XNPV

S

Scott

I am trying to to calculate the XNPV of a stream of cash flows. The problem
is that when I run differet scenarios through my model the cash flows are in
different years each time. Is there any way that I can get excel to
automatically calculate the XNPV of cash flows for only the years where my
cash flows are greater than zero or where my XNPV Dates are greater than
zero? Thanks in advance for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XIRR vs. IRR Function 11
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 9
XIRR Giving Negative Number on Positive Cash Flow Stream 11
Can I import text file of cash flow to excel file then use formula 1
What gets XNPV to calculate correctly if initial values are zero? 1
future value 2
IRR the same for very different cash flows 3
Too negative XIRR? 3

Top