Contact
12 programs
Explore the site

RATE Function in Apple Numbers: Syntax, Examples and Troubleshooting

Financial Intermediate Apple Numbers

Apple Numbers RATE: calculate periodic interest from loan payments and savings targets, including estimate, signs and timing.

Verification status: See the evidence and test scope described in this guide. How formula examples are checked

Quick answer: To estimate the monthly rate needed to grow a $50,000 initial savings deposit plus $200 paid at the beginning of each month to $150,000 over 15 years, enter:

=RATE(15*12,-200,-50000,150000,1,0.1/12)

Apple’s published expected result is approximately 0.376962210924744% per month (underlying decimal 0.00376962210924744). Multiplied by twelve it is approximately 4.52354653109693% nominal annual, not necessarily the effective annual return. Apple rounds the annual description to about 4.52%.

Availability and version history

  • Introduced: Documented in Apple’s Formulas and Functions Help 15.4; the original introduction release is not established.
  • Availability: Currently documented for Numbers in that help version; it is not a final supported-version endpoint.
  • Scope: Shared iWork function help; individual-client and older-release availability are not established by this check.
  • Checked: October 14, 2026, against the official RATE reference. Documentation and independent arithmetic checks; no native Numbers test.

Use the correct financial question

RATE solves for a single periodic rate that makes a series of equal payments at equally spaced intervals reconcile with an initial and final value. It is the missing-rate counterpart of PMT (payment), NPER (number of periods), PV (starting value) and FV (ending value). Use it for a fixed-payment loan or regular savings annuity. Do not present it as a direct APR disclosure calculator for loans with fees, irregular cash flows, variable interest or tax effects.

Exact Apple syntax, argument types and defaults

=RATE(num-periods, payment, present-value, future-value, when-due, estimate)
Position Apple’s argument Required? Exact interpretation / type Default
1 num-periods Yes Number of equal periods, documented as ≥ 0. A meaningful amortising-payment problem ordinarily has > 0 periods. None
2 payment Yes Number: fixed cash flow each period; repayments/deposits are usually negative to the payer. None
3 present-value Yes Number: starting cash value; loan proceeds received are positive, initial savings invested are negative. None
4 future-value No Number: signed remaining value at the final period; a loan balloon still owed is usually negative from the borrower perspective. 0
5 when-due No Modal value 0 for end of period, 1 for beginning of period. 0
6 estimate No Number used as the initial guess for the rate. Apple specifies 10% when omitted; minimum allowed guess is -1. Enter 0.08 for 8%. 0.1

The last argument is a solver starting estimate, not an added fee or the rate you want the answer to equal. Apple recommends trying a larger positive estimate, then a small negative estimate when the default does not find a solution; differing estimates can matter for numerical convergence. It does not document a universal convergence guarantee.

Reproducible Numbers worksheet: recover a loan interest rate

Create a table named RatePlan (one header row and at least twelve rows) with labels in A and inputs in B. Type plain numeric values, then set percent/currency cell formats if desired. The example has 10 years of monthly payments, a $200,000 initial loan, $2,220.410038833 paid monthly, and no balloon. The monthly payment is independently consistent with Apple’s PMT formula for a 6% nominal annual rate.

Cell A-column label B-column value/formula
B2 Loan amount received 200000
B3 Loan years 10
B4 Monthly payment amount (signed) -2220.410038833
B5 Payments per year 12
B6 Final balance 0
B7 Payment timing (month-end) 0
B8 Initial monthly rate estimate 0.01
B9 Solved periodic monthly interest rate =RATE(B3*B5,B4,B2,B6,B7,B8)
B10 Nominal annual rate (not EAR) =B9*B5
B11 Effective annual rate implied by monthly compounding =(1+B9)^B5-1
B12 Cross-check payment using solved rate =PMT(B9,B3*B5,B2,B6,B7)

Expected independent numerical checks: B9 ≈ 0.005 (0.5% per month), B10 ≈ 0.06 (6.0% nominal annual), B11 ≈ 0.0616778118645 (about 6.1678% effective annual), and B12 ≈ -2220.410038833. Minor last-digit differences can occur when a solver converges and when a payment is truncated for display; these expectations do not imply identical solver tolerances.

For a separate worksheet, replace same-table B2 with RatePlan::B2 if required, or use Finance::RatePlan::B2 from a sheet called Finance. Apple’s documented cross-table syntax uses ::; it is not an Excel Finance!B2 reference.

Apple’s published savings example explained

Apple gives an initial outflow of $50,000, a further outflow of $200 at the beginning of each month, a positive final $150,000, and 15 × 12 = 180 periods:

=RATE(180,-200,-50000,150000,1,0.1/12)

The published result is 0.376962210924744% per month, or approximately 0.00376962210924744 as a decimal. If the positive answer is formatted as a Percentage in Numbers, the visible number is multiplied by 100 for display; entering the percentage-form result as 0.376962 would make it approximately 100 times too large in subsequent calculations. The nominal and effective annualisations are different:

=RATE(180,-200,-50000,150000,1,0.1/12)*12

Expected 0.0452354653109693 (about 4.5235% nominal annual). For effective annual yield under twelve compounding periods:

=(1+RATE(180,-200,-50000,150000,1,0.1/12))^12-1

Expected approximately 4.6185% after independent calculation (retain full rate precision). Do not simply call rate*12 the effective annual return. Both scenarios assume monthly compounding and no additional fees.

Advanced: the estimate parameter and tricky cases

An interest rate is found by solving a cash-flow equation

The conventional financial identity for rate r, periodic payment p, present value PV, future value FV, period count n and timing flag t is:

0 = PV*(1+r)^n + p*(1+r*t)*((1+r)^n-1)/r + FV       (r != 0)

At r = 0, this reduces to PV + p*n + FV = 0. RATE finds a value of r that makes this identity approximately zero for feasible inputs; Apple’s documentation defines the inputs and estimate but does not specify its internal algorithm.

The estimate is not the answer

The optional estimate of 0.1 is 10% per period, not 10% per year. For a typical monthly loan, a deliberately lower guess such as 0.1/12 or 0.01 may improve the chance of convergence, although no success is guaranteed. If a plausible candidate is negative, Apple’s guidance permits guesses down to -1 and suggests trying small negative starts after larger positive starts fail. Consult the error shown by your installed build when troubleshooting convergence.

Zero-interest loans

A 12-month loan of $12,000 with twelve exact month-end payments of $1,000 obeys the zero-rate cash-flow identity:

=RATE(12,-1000,12000,0,0,0.01)

The independently expected solution is approximately 0%. A tiny residual rate may reflect solver tolerance; check the cash-flow inputs before interpreting it as meaningful interest.

Balloon payments and beginning-of-period loans

The same loan can yield a different periodic rate if you change future-value from 0 to a negative remaining balloon, or when-due from 0 to 1 while holding payments fixed. Test scenarios separately and document the sign of every cash flow. A lease paid in advance is not equivalent to ordinary payments made one month later.

Troubleshooting

Symptom Action grounded in Apple’s inputs
The result seems like 60% instead of 6% RATE returns a periodic decimal rate. Format the result as Percentage; multiply by 12 only for a nominal annual rate when there are 12 monthly periods.
No numerical solution / formula error Test whether the cash-flow equation has a feasible solution. Check opposite signs for loan proceeds versus repayments, and a plausible target balance; adjust the initial estimate within the documented range.
The displayed rate changes with estimate RATE is an iterative/numerical financial calculation; different starting guesses may converge differently or fail. Check input plausibility and do not assume all parameter sets have a unique solution.
Rate looks wrong for a beginning-of-month loan Verify the optional when-due=1 for advance payments. Omitted means 0, end-of-month.
Solver finds the right rate, but PMT cross-check differs by cents Preserve full precision when passing the payment or rate; cell formatting does not round underlying value, but typing an already rounded payment does.
Annual rate accidentally entered as monthly RATE outputs rate per period, not annually by default; the number of periods and payments must use matching units.
Invalid formula / locale separator Apple uses commas in the English syntax; where the decimal separator is a comma, use semicolon argument separators, for example =RATE(120;-2220,41;200000;0;0;0,01) after matching all local numeric formatting.
A cell’s currency amount is interpreted as text Enter numeric values in cells and use Numbers cell formatting for $/currency rather than prefixing textual dollar signs. See Apple’s formula error guidance.

Questions and important limits

Is RATE an APR calculator? Not by itself. RATE returns a model’s periodic yield based on cash flows provided. Regulation-specific APR computations may require fees, conventions and timing rules not captured in a five/six-argument annuity equation.

What happens when I leave out the estimate? Apple assumes an initial guess of 10%, which is the number 0.1 in its decimal formulation. Explicitly supplying a monthly guess is often more interpretable for monthly cash flows.

Can num-periods be zero? Apple lists zero as accepted for the first argument, but when n=0 the cash-flow identity generally cannot identify a unique rate; do not promise a usable RATE output in such an underdetermined scenario.

Does a negative RATE always mean failure? No. Some cash-flow patterns can yield negative investment returns. Check the period and sign conventions before treating the outcome as an error.