| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What function or formula do I use to calculate ROI with this data?
I have the following data and I want to calculate my investment Rate of
Return or lack thereof. I have three pieces on data: 1. the beginning amount of money $10,000 2. the total of the equal monthly contributions $12,000 - (each month I contributed $1,000) 3. the ending value of $22,000. So the data is $10,000, $12,000, $22,000 So I want to figure out the compounded percentage rate. Does Excel have a function for that? Thanks Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula displays does not calculate | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) | |||
| Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
