| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I caluclate return on investment, compounded quarterly?
We can calculate the return on investment with no problem. What we want to
do is make the rate compound quarterly, rather than annualy. Is there a way to do that? We calculate a $15,000 investment on 1/1/02 worth $25,794 on September 30, 2006, as a 14.95% rate of return. But if we use another program and compound out quarterly, the return is only about 12%. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with index to return particular cell value | Excel Discussion (Misc queries) | |||
| charts for projected costs, revenue, return on investment (resort) | Charts and Charting in Excel | |||
| Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
| WHAT IS THE RATE BY MONTHS on A return of investment | Excel Discussion (Misc queries) | |||
Threaded Mode
