Thread: IRR and NPV
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tom ossieur tom ossieur is offline
external usenet poster
 
Posts: 33
Default IRR and NPV

Hi,

IRR, according to explanation in Excel, is of a similar concept with NPV.

But if my cash flow starts from say 2009 onwards (and any cash flows between
2007-2009 are 0), IRR gives me the same result whether or not I choose cells
starting from 2007 or 2009.

But with NPV function, the results are different. How can I get the right
IRRs for different periods with the IRR function?

Thanks!

tom