| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating a dollar-weighted return
I am trying to calculate a dollar-weighted investment return for a month
period with some cash flows on some days in the month, For example: Jan 1: $100 Beginning market value Jan 5: $5 added Jan 10: $10 taken out Jan 15: $3 taken out. Jan 31: Ending market value is $110. I assume I use XIRR to get the return for the month. For some reason I am getting a nonsensical answer. Could I get some advise on how to set it up and let me know what the correct answer (return) is? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating weighted averages in a pivot table | Excel Discussion (Misc queries) | |||
| Dollar weighted rate of return with random cash flows | Excel Discussion (Misc queries) | |||
| Calculating weighted averages | Excel Discussion (Misc queries) | |||
| calculating a weighted average using formula | Excel Worksheet Functions | |||
| calculating a weighted average uisng formula | Excel Worksheet Functions | |||
Threaded Mode
