RATE
Returns the interest rate per period of an annuity.
FinancialFinance & Accounting
What it does
Calculates interest rate given nper, pmt, pv.
Syntax
RATE(nper, pmt, pv, [fv], [type], [guess])
Arguments
nper(number) — Periods.pmt(number) — Payment.pv(number) — Present value.
Examples
Calc Interest Rate
Monthly rate for 5yr loan.
FORMULA
=RATE(60, -200, 10000)
RESULT
0.006
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Years | Pmt | Loan |
| 2 | 5 | -200 | 10000 |