Yes we can provide a solution, but we need to know what the problem is.

My guess is you're looking for the XIRR function. It will handle varying cash
flows. Subtract the rate of inflation from XIRR's result to get the real return.

If your problem is to calculate the real rate of return given inflation at 3%,
you could still use Rate with a constant PMT (the first cash flow), and FV as
the final amount discounted by 3% per year.

--
Regards,
Fred


"Pro - Land" <Pro - wrote in message
...
Hi to all, The problem is I cannot get a real rate of return for my problem.
I am presented with an initial value at the beginning of year one, an annual
investment that is stepped 3% each year for inflation and the amount at the
conclusion of the final period.

The canned =RATE formula does not account for anything but a constant inflow
amount. Is there anyone who can provide a solution