Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IRR (or MIRR?)
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? A B C D E F year 2007 2008 2009 2009 2010 - - 0 -580,864 -85,079 Equity IRR 9.60% 9.60% 9.60% (actually the table goes to 2029) Shouldn't IRR starting from 2007, 2008 or 2009 and all ending in 2029-, give different results or the same? Thanks! tom |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IRR (or MIRR?)
Please do not start multiple threads with essentially the same subject
in the same newsgroup. It makes it difficult to know which to respond to. See my response to the thread you started with the subject "IRR and NPV". ----- tom ossieur wrote: 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? A B C D E F year 2007 2008 2009 2009 2010 - - 0 -580,864 -85,079 Equity IRR 9.60% 9.60% 9.60% (actually the table goes to 2029) Shouldn't IRR starting from 2007, 2008 or 2009 and all ending in 2029-, give different results or the same? Thanks! tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NPV IRR MIRR | Excel Worksheet Functions | |||
How wrong can you be with your NPV and MIRR functions in EXCel | Excel Worksheet Functions | |||
MIRR Function sensitivity to Finance Rate | Excel Worksheet Functions | |||
Why doesn't the finance rate in MIRR impact the formula result? | Excel Worksheet Functions | |||
Using MIRR, if cash flows are monthly, should rate be / 12? | Excel Worksheet Functions |