Thread: Convert Effective Annual ROR into quarterly ROR
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default Convert Effective Annual ROR into quarterly ROR
Hi,

Divide by 4.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Dkline" wrote:

I have used the XIRR function which returns an Effective Annual Rate of Return.

9/30/2008 -$104,119.16
10/1/2008 $942.05
10/6/2008 -$4,924.67
11/1/2008 $944.31
11/3/2008 -$4,966.81
12/1/2008 $945.74
12/3/2008 -$5,274.03
12/31/2008 $92,520.92
-61.52%

How do I convert the -61.52% into a ROR for the quarter?
Reply With QuoteReply With Quote