Home |
Search |
Today's Posts |
#1
|
|||
|
|||
XIRR function
If anyone is familiar with this function, can you help me with it?
I have my values in column B, and my dates in column A. If I enter the "guess" as 0.1, then my XIRR value is returned as 0.099. If I enter my guess as -0.1, then then the XIRR value returned is entirely different. I had thought that the guess only sped up the calculation, and never affected the outcome. Am I wrong? Thanks Daniel |
#2
|
|||
|
|||
Daniel Bonallack wrote...
If anyone is familiar with this function, can you help me with it? I have my values in column B, and my dates in column A. If I enter the "guess" as 0.1, then my XIRR value is returned as 0.099. If I enter my guess as -0.1, then then the XIRR value returned is entirely different. I had thought that the guess only sped up the calculation, and never affected the outcome. Am I wrong? Yes, you are wrong. If the cashflows involved, sorted by date, have multiple sign changes, there could be multiple *EQUALLY* *VALID* IRRs. When there are multiple IRRs, then your initial guess can affect which one IRR or XIRR returns. |
#3
|
|||
|
|||
Thank you very much!
"Harlan Grove" wrote: Daniel Bonallack wrote... If anyone is familiar with this function, can you help me with it? I have my values in column B, and my dates in column A. If I enter the "guess" as 0.1, then my XIRR value is returned as 0.099. If I enter my guess as -0.1, then then the XIRR value returned is entirely different. I had thought that the guess only sped up the calculation, and never affected the outcome. Am I wrong? Yes, you are wrong. If the cashflows involved, sorted by date, have multiple sign changes, there could be multiple *EQUALLY* *VALID* IRRs. When there are multiple IRRs, then your initial guess can affect which one IRR or XIRR returns. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Problem with XIRR function returning #NUM! | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |