RATE
FinancialExcel 2007The interest rate per period of a loan or investment.
Syntax
RATE(nper, pmt, pv, [fv], [type], [guess])
Examples
=RATE(240, -25093, 3000000)*12
→ ≈ 8% — the implied annual rate
Good to know
- Iterative — add a guess (e.g. 0.1) if it returns #NUM!.
Related functions
More Financial functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.