ƒx

Excel RATE Formula

finance Difficulty:

One-Click Copy

RATE(nper, pmt, pv, [fv], [type])

Quick context

• Works in both Excel and Google Sheets.
• Use when you need consistent, auditable results.
• Copy the snippet above and adjust only the ranges.

When to use

Returns the interest rate per period of an annuity.

Find the interest rate of a loan given payments and term.

Calculate Loan Interest Rate

Find the interest rate of a loan given payments and term.

Inputs

nper Total number of payment periods.
pmt Payment made each period.
pv Present value (loan amount).

Practical Example

=RATE(48, -200, 8000)

Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.