| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
To XIRR or Not To XIRR
What IRR is the investment community most familiar with? I want to
publish an effective annual rate for my investors. We give monthly distributions at the end of the month. And from what I understand I have at least two options: 1) XIRR() 2) ((1+IRR())^12)-1 Which one of these calculations (or other) is the most commonly accepted. Thank you, Jonathan |
| 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 and NPV - a very frustrating problem | Excel Discussion (Misc queries) | |||
| Problem with XIRR function returning #NUM! | Excel Worksheet Functions | |||
| XIRR and IRR | Excel Worksheet Functions | |||
Threaded Mode
