| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
tir... is the same as xirr??
Hello
i need to get the xirr i have this values -12120 3000 8000 11000 =xirr(all the values, ???) i dont know what to put in guess and dates, please help me |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tir... is the same as xirr??
Suppose you have values in column A and dates in Column B, then
=XIRR(A1:A10,B1:B10,0.1) 0.1 is the estimated rate. -- Best regards, --- Yongjun CHEN ================================== - - - - www.XLDataSoft.com - - - - Free Excel/VBA Tool & Training Material ================================== "Daniela Gutierrez" wrote in message ... Hello i need to get the xirr i have this values -12120 3000 8000 11000 =xirr(all the values, ???) i dont know what to put in guess and dates, please help me |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
tir... is the same as xirr??
Most people put in 0.1 (10%) for a guess. It almost always works.
However, you need the dates on which the values occurred in order to use XIRR. If you don't have dates, you can't use XIRR. If the values occurred at regular intervals (eg, monthly, quarterly, annually), you can use IRR to calculate the return. -- Regards, Fred "Daniela Gutierrez" wrote in message ... Hello i need to get the xirr i have this values -12120 3000 8000 11000 =xirr(all the values, ???) i dont know what to put in guess and dates, please help me |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XIRR non contiguous references | Excel Discussion (Misc queries) | |||
| XIRR and negative IRRs | Excel Discussion (Misc queries) | |||
| irr, xirr, npv frustrations | Excel Worksheet Functions | |||
| IRR, XIRR and NPV - a very frustrating problem | Excel Discussion (Misc queries) | |||
| XIRR and IRR | Excel Worksheet Functions | |||
Linear Mode
