| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert Effective Annual ROR into quarterly ROR
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting annual rate of return to quarterly equivalent? | Excel Worksheet Functions | |||
| Effective Annual Interest Rate | Excel Worksheet Functions | |||
| Convert monthly data into quarterly data? | Excel Discussion (Misc queries) | |||
| Annual vs Quarterly Rates | Excel Discussion (Misc queries) | |||
| How do I convert monthly data to quarterly data? | Excel Discussion (Misc queries) | |||
Threaded Mode
