| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
XIRR over several years
I have a series of monthly transactions over several years. I have used the
XIRR function to find the ROR for each month, each quarter, and each calendar year. The client now wants a rate from inception. My expectation was I would get an annual rate for the entire period. However I feel that a -400% ROR is not accurate. Is there anything different I need to do when the period is greater than one year? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change a list of 2 digit years to 4 digit years? | Excel Worksheet Functions | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| Convert years to years and days | Excel Discussion (Misc queries) | |||
| Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel | |||
| Change Xcel Amortization from 30 years to 40 years? | Excel Discussion (Misc queries) | |||
![Don Kline[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
