View Single Post
  #1   Report Post  
Pro - Land
 
Posts: n/a
Default Real RATE of return using =RATE illusive, inflation adjusted inflo

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