View Single Post
  #1  
Old May 16th, 2009, 06:31 PM posted to microsoft.public.excel.worksheet.functions
Petrak
external usenet poster
 
Posts: 2
Default 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?