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?