| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dollar weighted rate of return with random cash flows
hello,
I am having trouble coming up with a formula that will allow me to calculate the IRR with several random contributions and two random withdrawals. I have month end values for the time periods from 9-30-1997 through 12-31-05. Any help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dollar weighted rate of return with random cash flows
You want the XIRR function. It was built exactly for your situation. XIRR is
part of the Analysis Toolpak which is loaded via ToolsAddins. -- Regards, Fred "shfigato" wrote in message ... hello, I am having trouble coming up with a formula that will allow me to calculate the IRR with several random contributions and two random withdrawals. I have month end values for the time periods from 9-30-1997 through 12-31-05. Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search a random array of cells and return a value of "X" | Excel Worksheet Functions | |||
| Future Value function with differenct cash flows | Excel Discussion (Misc queries) | |||
| How do you calculate rate of return on monthly cash flows | Excel Worksheet Functions | |||
| Selecting at random with weighted probability | Excel Worksheet Functions | |||
| Rate of return required formula | Excel Worksheet Functions | |||
Linear Mode
