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?
|