| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rate of return -excel
"Ron Rosenfeld" wrote: On Sat, 6 Jun 2009 19:19:01 -0700, Totonno wrote: My cash payments are not regular and are not equal. I prepared an excel spreadsheet applying an interest rate on a trial and error basis to come to a predetermined future value. It's very tedious and I thought there may be a quicker way. Totonno OK. You first wrote only that your cash payments are not equal, in which case the IRR function would be appropriate. If they are also not regular, you can use the XIRR function. --ron Thanks, I will try that. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I compute annual rate of return in Excel? | Excel Worksheet Functions | |||
| Rate of Return | Excel Discussion (Misc queries) | |||
| rate of return formula | Excel Discussion (Misc queries) | |||
| rate of return | Excel Worksheet Functions | |||
| Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
Hybrid Mode
