View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl LaFong Carl LaFong is offline
external usenet poster
 
Posts: 19
Default Calculating quarterly investment returns---XIRR or another function??

Let me make a minor correction to my own post:



Joe said:



Huh!? Values and dates of what?


I said:

The dates are the dates of each interim addition to the account during
that particular quarter. The values are the account values on those dates,
as reported by my broker. For instance, on Feb 24, I might have added $400
to the account and the broker reports an account value on that date of
$11.099.87. (those are just examples, not the actual figures)


The dates are the ending date of the prior quarter quarter, the dates of the
interim additions of new money, and the last date of the current quarter.

The values are the ending balance for the prior quarter as reported by my
broker, the amounts of the interim additions, and the closing balance for
the current quarter as reported by my broker. Column A has dates. Column B
has dollar amounts. Each quarter has several additions to the account.