The RRI function returns the interest rate needed for an investment to reach a specific value within a given number of periods.
Parts of a RRI function
RRI(number_of_periods, present_value, future_value)
||Required. The number of periods.|
||Required. The present value of the investment|
||Required. The future value of the investment.|
- All values must be positive.
present_valuemust be greater than 0.
future_valueis 0, the rate returned is -1 (-100%).
- PDURATION: The PDURATION function returns the number of periods for an investment to reach a specific value at a given rate.