View Single Post
  #10   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??


"joeu2004" wrote in message
...
On Jan 7, 1:40 pm, "Carl LaFong" wrote:
What I DO need is a method that mirrors the Vanguard example such that a
hypothetical 10k beginning balance x q1 x q2 x q3 x q4 gives the same
result
as a hypothetical 10k beginning balance x XIRR annual rate (20.11 in this
particular case).


10K(!)? Well, you do say "hypothetical" 10K. If this is for a class
or for your personal edification, fine.

Joe:

I was referring to a hypothetical 10,000 dollar investment, not to a 10k
filing with the Securities and Exchange Commission. Sorry for the confusing
shorthand.

I am digesting your earlier lengthy response, which is appreciated. I have
replicated in Excel and agree with nearly all of it and will post my
comments shortly.