Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rate of return -excel
How do I compute the rate of return on a stream of payments that are not
equal other than by trial and error? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
rate of return -excel
You can't. You can get an average rate of return as a goal. You then know
if you have some payments less than the average you are going to have some that are greater than the average. You can create a complete payment schedule on the worksheet using the amount returned from PMT. Then if you have some payments that are less you can compensate by making some payment higher. With PTM you canspecify a final amount that is not zero. So if you have a 10 year loan you can specify what the amount of the load will be after 5 year and get a payment for the 1st 5 years. Then comput PMT for the final 5 years. "Totonno" wrote: How do I compute the rate of return on a stream of payments that are not equal other than by trial and error? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
rate of return -excel
On Sat, 6 Jun 2009 11:16:01 -0700, Totonno
wrote: How do I compute the rate of return on a stream of payments that are not equal other than by trial and error? Use the IRR function. "Returns the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. The internal rate of return is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods." --ron |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
rate of return -excel
"Ron Rosenfeld" wrote: On Sat, 6 Jun 2009 11:16:01 -0700, Totonno wrote: How do I compute the rate of return on a stream of payments that are not equal other than by trial and error? Use the IRR function. "Returns the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. The internal rate of return is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods." --ron 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
rate of return -excel
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
rate of return -excel
"Totonno" wrote:
My cash payments are not regular and are not equal. If they are irregular in frequency, use XIRR instead of IRR. But beware that XIRR always returns an annualized rate, whereas IRR returns a period rate. If you want an annual rate, that is not an issue. But if you want a non-annual periodic rate like IRR, you will need to convert it. ----- original message ----- "Totonno" wrote in message ... "Ron Rosenfeld" wrote: On Sat, 6 Jun 2009 11:16:01 -0700, Totonno wrote: How do I compute the rate of return on a stream of payments that are not equal other than by trial and error? Use the IRR function. "Returns the internal rate of return for a series of cash flows represented by the numbers in values. These cash flows do not have to be even, as they would be for an annuity. However, the cash flows must occur at regular intervals, such as monthly or annually. The internal rate of return is the interest rate received for an investment consisting of payments (negative values) and income (positive values) that occur at regular periods." --ron 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 |
#7
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 |