Dollar weighted rate of return with random cash flows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You want the XIRR function. It was built exactly for your situation. XIRR is
part of the Analysis Toolpak which is loaded via Tools>Addins.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cash Flow Distribution/IRR Modeling 7
IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
rate of return formula 2
Calculating a dollar-weighted return 6
How do you calculate rate of return on monthly cash flows 1
Future Value function with differenct cash flows 1
IRR formula for monthly cash flows 3
Weighted averaging of dates 3

Back
Top