Financial
RATE
Interest rate per period.
Syntax
RATE(nper, pmt, pv, [fv], [type], [guess])Example: =RATE(12,-55000,600000)*12
Available in: All versions
Try it
A tiny spreadsheet with example data. Edit the formula or any number and see the result.
Formula in D2: =RATE(24,-500,10000)*12
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Year | Cash flow | Result | |
| 2 | 0 | -10000 | 0.181570126828 | |
| 3 | 1 | 3000 | ||
| 4 | 2 | 4000 | ||
| 5 | 3 | 4500 | ||
| 6 | 4 | 2500 |
Result in D2: 0.181570126828