This function returns calculated interest rate for growth of investment.
RRI(nper,pv,fv)
This function has these arguments:
Argument | Description |
---|---|
nper | Number of periods for the investment |
pv | Present value of the investment |
fv | Future value of the investment |
All the arguments of this function has positive values.
If the passed arguments are invalid, this function returns an error value.
Accepts numeric data. Returns numeric data.
RRI(96,10000,11000) gives the result 0.0009933