Contact
12 programs
Explore the site

FV Function in Apple Numbers: Syntax, Examples and Troubleshooting

Financial Intermediate Apple Numbers

Learn Apple Numbers FV with official syntax, reproducible cell examples, cash-flow signs and error fixes.

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

Quick answer: With $50,000 deposited today, $200 added at the start of each month, and 4.5% nominal annual interest compounded monthly for 15 years, Apple’s documented formula =FV(0.045/12,15*12,-200,-50000,1) returns approximately +149,553.00. The starting deposit and monthly contributions are negative because they are money put into the account; the account value later is positive.

Availability and version history

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

What FV answers

FV computes the eventual value of one starting amount plus optional regular equal payments, given a fixed periodic rate, a fixed number of equally spaced periods and whether payments happen at the beginning or end. It is suited to savings plans and simplified fixed-rate comparisons. For the reverse question—how much must you invest today to reach a desired amount—use PV. For a fixed amount borrowed and a repayment term, PMT solves for a constant payment. Apple’s financial help confirms this family of related tools.

A forecast is not a promise: actual returns, varying rates, fees, taxes, insurance, inflation, missed deposits and irregular dates can make actual results differ substantially. FV also reports nominal money unless you separately account for inflation; it does not automatically estimate purchasing power.

Exact Apple syntax, arguments and defaults

=FV(periodic-rate, num-periods, payment, present-value, when-due)
Position Argument Required? Type, meaning and caveat Default
1 periodic-rate Yes Numeric periodic interest rate. Monthly contributions with 4.5% nominal annual rate use 0.045/12. Apple allows negative rates but notes potential interpretation problems. None
2 num-periods Yes Number ≥ 0 of periods, expressed on the same time scale as the periodic rate (15*12 months). None
3 payment Yes in Apple’s documented signature Number transferred at each period. Money you contribute to an investment is typically a negative cash flow. Use explicit 0 when no recurring contributions exist. None
4 present-value Optional if there is no initial investment and a payment is specified Number given today. An initial savings deposit is negative. If not needed, it may be omitted; for reproducible examples specify 0 rather than assuming an undocumented numeric default.
5 when-due Optional Modal value 0 (end of period) or 1 (beginning of period). 0 (end)

This ordering differs from PV: FV takes present-value fourth; PV takes future-value fourth. Both share sign and timing conventions, but they are not interchangeable aliases. The official English notation uses commas between arguments; a decimal-comma locale requires semicolons for manually typed formulas.

A reproducible Numbers savings-plan table

Create a single table named FutureSavings with a header row and labels in column A, numeric inputs/formulas in column B. Enter the following and give the table at least twelve rows.

Cell A: Meaning B: Entry
B2 Annual nominal interest rate 0.045
B3 Deposits per year 12
B4 Years 15
B5 Each monthly deposit (signed) -200
B6 Starting deposit (signed) -50000
B7 Beginning-of-period deposits 1
B8 Projected ending balance =FV(B2/B3,B4*B3,B5,B6,B7)
B9 End-of-period alternative =FV(B2/B3,B4*B3,B5,B6,0)
B10 Amount deposited before growth =-(B6+B5*B4*B3)

Expected: B8 +149,553.00 (Apple’s published example), B9 +149,360.68, and B10 +86,000.00. All monetary expectations are rounded to cents for display. The user has deposited $50,000 + 180×$200 = $86,000 before compound returns. The difference between B8 and B10 is model-implied growth, not guaranteed income or an interest statement from a bank. A beginning-of-month contribution earns one extra month of interest compared with an end-of-month contribution.

Check the time-value equation independently

Let r denote the rate per period, n periods, p signed periodic payment, PV signed initial money and t timing (0 at period end, 1 at start). Then the conventional fixed-rate model is:

q = (1 + r)^n
annuity_factor = ((q - 1)/r) * (1 + r*t)      if r ≠ 0
FV = -(PV*q + p*annuity_factor)

If r=0, the expected value simplifies to FV=-(PV + p*n). This independent expression supports the worked outputs; it does not describe an Apple software implementation or certify the behavior for every mathematical edge case.

Advanced worked comparisons

1. Compound growth without contributions. In the annual-rate scenario =FV(0.0525,14,0,-50000,0), the independently verified expected result is +102,348.03. Apple publishes this example when comparing a 14-year account return to a $100,000 redemption on a hypothetical security. Do not divide by 12 in this case: the provided rate and 14 periods are both annual.

2. Compare monthly contribution timing. With the same starting deposit and monthly contribution amount, =FV(0.04/12,60,-150,-10000,0) yields expected +22,154.81, whereas =FV(0.04/12,60,-150,-10000,1) yields expected +22,187.96. Paying at the start of a period increases accrued interest in this example.

3. Zero-interest budget. =FV(0,12,-200,-1000,0) gives expected +3,400.00: $1,000 already set aside plus $200 across twelve deposits, with no growth. This makes an easy diagnostic for cash-flow sign errors.

4. Target-versus-projection comparison. To compare B8 to a desired target of 150000, enter the numeric target in B11, then =B8-B11 in B12. The expected B12 result is -447.00: the projected plan falls short of the target by that magnitude. Don’t claim FV finds the payment required: for that problem use a separately verified PMT model or solve the contribution requirement using the financial equations.

Error cases and troubleshooting

Problem Practical remedy / qualification
Future value unexpectedly negative Check the signs. Deposits from the investor’s perspective are negative; a future amount received is positive. If both PV and payment are positive, the computed future value may be negative.
A 4.5% rate was used directly with 180 monthly periods Use 0.045/12 for a nominal annual 4.5% rate compounded monthly, not 0.045 as a monthly rate.
Difference from a bank forecast Compare fees, compounding frequency, timing, skipped contributions, rate changes and contractual conventions. FV assumes fixed-rate periodic cash flows.
No initial deposit but formula won’t parse Use present-value=0 explicitly; Apple allows omitting it under the documented condition, but manually skipping a middle argument can be error-prone.
Wrong result from when-due 0 is end-of-period/default; 1 means deposits at beginning, changing their interest exposure.
Formula displays errors or literal text Inspect number-typed cells, the leading =, parentheses, decimal/argument separators, and reference syntax.
Very long projections and round-off Display precision and underlying precision can differ. Do not round each intermediate step unless your business rules require it.
Zero periods or negative rates Apple documents n>=0 and allows negative rates; not every degenerate numerical case is described in the help. Do not invent exact error behavior; test in the target version.

Table names, regions and devices

From within the same table, the formula uses B2 references. Another Numbers table may require FutureSavings::B2, and another sheet can use Sheet Name::FutureSavings::B2 when qualification is necessary. Apple documents these formats and the localized argument separator rule.

Formula entry and source notes

Use commas between arguments in English-locale formulas. If your decimal separator is a comma, use semicolons between arguments. A cell-reference formula avoids decimal-literal ambiguity: =FV(B2/B3;B4*B3;B5;B6;B7). Select source cells in the Numbers formula editor to insert the correct table and sheet qualifiers.

The examples illustrate a fixed-rate model. They do not include taxes, fees or a lender’s contractual rounding rules.