PV Function in Apple Numbers: Syntax, Examples and Troubleshooting
Learn Apple Numbers PV 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: To estimate the up-front amount needed today for a target $150,000 savings balance in 15 years, with $200 paid at the beginning of each month and a 4.5% nominal annual interest rate compounded monthly, use =PV(0.045/12,15*12,-200,150000,1). The Apple-published expected value is -50,227.88. The negative sign means an initial deposit paid out now, not a $50,227.88 profit.
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 PV reference. Documentation and independent arithmetic checks; no native Numbers test.
What PV measures and what it does not
PV answers a value-today question under the assumptions of a fixed rate, evenly timed periods, and equal payments. It relates how much capital is needed now to achieve a specified future target or how much a fixed payment stream is worth today. For comparison, FV asks how much today’s capital and contributions become later, whereas PMT solves for the payment amount. This relationship is documented by Apple.
A numerical PV answer is not a market price guarantee, an investment recommendation, a mortgage annual percentage rate, a model of taxes, a prediction of actual returns, or a calculation for irregular payment dates. It depends directly on your rate and timing assumptions.
Exact documented syntax and argument definitions
=PV(periodic-rate, num-periods, payment, future-value, when-due)
| Position | Name | Required / optional | Type, rule and sign | Default |
|---|---|---|---|---|
| 1 | periodic-rate |
Required | Number interest rate per period, e.g. 0.045/12 for monthly intervals. Negative values are permitted but may be difficult to interpret. |
None |
| 2 | num-periods |
Required | Number ≥ 0 over the same time unit as the rate. 15*12 represents 180 months. |
None |
| 3 | payment |
Normally supplied; may be omitted if future-value is supplied |
Number received each period (positive) or paid each period (negative), including 0 when there are no periodic payments. |
Not a documented general numeric default; explicitly enter 0 for zero payments. |
| 4 | future-value |
Optional when payment is supplied, required if payment is omitted |
Number representing ending money received (positive) or paid (negative). | 0 when omitted, with payment supplied |
| 5 | when-due |
Optional | Modal 0 or 1: 0 for payments at the end, 1 at the beginning of each period. |
0 |
Apple explicitly says if the payment argument is omitted the future value must be included. To avoid uncertainty about skipping a middle argument in a manually entered formula, the examples below use all five arguments and put 0 in payment for a zero-contribution scenario. This preserves the precise Apple argument ordering.
Why the sign is important
Money invested today is a negative initial cash flow; money received later is positive. In Apple’s sample, both the monthly -200 deposits and the up-front negative PV fund a positive $150,000 maturity value. Do not make every argument positive merely because it is shown as currency, and do not treat a negative output as an error without checking the cash-flow direction.
Reproducible Numbers worksheet: funding a savings goal
Create a Numbers table SavingsPlan with column A labeled Input and column B labeled Value. Set up these numeric entries and formula cells (use at least 11 rows):
| Cell | Description | Entry |
|---|---|---|
| B2 | Annual interest rate | 0.045 (optionally display as 4.5%) |
| B3 | Contributions per year | 12 |
| B4 | Years until goal | 15 |
| B5 | Monthly cash deposit (outflow) | -200 |
| B6 | Desired ending savings (inflow) | 150000 |
| B7 | Payment timing (beginning) | 1 |
| B8 | Upfront deposit, signed | =PV(B2/B3,B4*B3,B5,B6,B7) |
| B9 | How much to deposit, displayed positively | =-B8 |
| B10 | Upfront deposit if contributions at end | =PV(B2/B3,B4*B3,B5,B6,0) |
Expected: B8 is -50,227.88; B9 is +50,227.88; B10 is -50,325.92. Amounts are rounded to cents for display. The sign-reversed B9 is only a friendly display of the amount to contribute and should not replace the signed B8 in a financial model. Apple’s own example yields the B8 amount.
The starting deposit must work together with 180 monthly deposits and compound growth. The current value is not simply $150000−180×$200, because contributions and initial capital earn interest over different periods. Beginning-of-month contributions accrue interest one additional period compared with end-of-month deposits, so the PV needed at the beginning is smaller in magnitude under these assumptions.
Independent mathematical cross-check
For r periodic interest, n periods, signed payment p, ending value F, and timing flag t, the conventional PV equation is:
q = (1 + r)^n
annuity_factor = ((q - 1)/r) * (1 + r*t) when r ≠0
PV = -(F + p*annuity_factor) / q
When r = 0, the simplified expectation becomes PV = -(F + p*n) if n is a meaningful positive period count. These formulas are independent financial arithmetic and are not a claim about Apple’s implementation details.
Advanced cases worth trying
1. Discounted single redemption: =PV(0.0525/12,14*12,0,100000,0) returns an expected -48,027.48, matching Apple’s published $100,000 redemption after 14 years with a 5.25% nominal annual rate compounded monthly. With no regular deposits, when-due has no effect on this example. Apple’s output is negative because buying the investment costs money today.
2. Equal payments without a residual: =PV(0.04/12,60,-100,0,0) has independently calculated expected result +5,429.91. From the borrower perspective, the positive PV is the loan principal received today, offset by negative scheduled payments; a lender’s outgoing initial principal would have the opposite sign. State whose account you are modeling before interpreting signs.
3. Zero interest: =PV(0,24,-500,0,0) has expected result +12,000.00: 24 repayments of -$500 balance a +$12,000 amount at time zero.
4. Sensitivity to the rate: Keep the same table but increase B2 to 0.055 and recalculate: B8 becomes approximately -41,269.78. Restore B2 to 0.045 afterward to reproduce the original outputs. Larger expected returns generally reduce the required starting deposit for a positive future target with unchanged negative contributions, but the exact effect depends on signs and values. This is a scenario, not proof that the stated return will actually occur.
Errors, limitations and a practical troubleshooting table
| Issue | Check and remedy |
|---|---|
| The result is negative | Check cash flow: a deposit today is an outflow, so negative is expected. |
| Value looks impossibly small or large | Check rate-period alignment: monthly rate is annual nominal rate divided by 12 and n=years*12. |
| An expected payment argument was skipped | Apple allows its omission only when the ending FV is provided. For explicit, reproducible formulas, use payment=0 instead of relying on how a skipped middle argument parses. |
| Beginning versus end timing differs | Use when-due=1 for start-of-period deposits; default 0 for end. |
| A rate is formatted as a percentage but stored as text | Enter a numeric 0.045 or 4.5%; formatting text characters alone does not make it a number. |
| You see a parsing or reference error | Inspect argument separators, copied table references, unmatched parentheses and number-vs-text input types. |
| A calculation includes a fee, irregular deposit, or varying interest | PV’s fixed-rate equal-payment assumptions do not encompass those items. Model additional flows separately, and compare other documented function families if appropriate. |
| Zero periods | Apple’s published argument range includes num-periods>=0, but it does not document every degenerate-case output. Check your business interpretation and test native behavior instead of predicting an error message. |
Formatting caveat: A cell displayed as currency may show two decimals while holding more precision. Rounding intermediate values can change the final comparison. Region affects symbol and presentation, not the mathematical sign convention.
Table references and related reading
Numbers has tables within sheets, so SavingsPlan::B2 qualifies a reference to this named table when needed; Sheet Name::SavingsPlan::B2 qualifies a reference across sheets. Use the formula editor instead of assuming Excel’s Sheet1!B2 syntax.
- Apple PV reference (live official source; checked October 14, 2026).
- Apple financial-functions guide (official guide to PV, FV, PMT, NPER and RATE).
- ROUND function guide in Apple Numbers.
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: =PV(B2/B3;B4*B3;B5;B6;B7). Select source cells in the Numbers formula editor to insert the correct table and sheet qualifiers.
- Apple functions overview: argument notation and regional separators.
- Apple cell-reference guide: table names and cross-sheet references.
The examples illustrate a fixed-rate model. They do not include taxes, fees or a lender’s contractual rounding rules.