Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Better Understanding of XIRR
I occasionally see an analysis of returns where someone will take the
present value of the future cash flows, and then apply XIRR to those present values. Since the present value already discounts the cash flow according to the discount rate, would XIRR in this case simply be a measurement of the rate of return on money that is already growing at the discount rate? Using a real example, if XIRR measures 15% IRR after three years on a cash flow of present values that were each calculated using a 12% discount, then is XIRR calculating 15% additional growth applied to 12% growth? -- W |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
understanding | Excel Programming | |||
Better Understanding | Excel Programming | |||
Understanding formula | Excel Worksheet Functions | |||
Not understanding with/end with | Excel Programming | |||
Not understanding If Not..Then nothing | Excel Programming |