Apple Numbers NPV: Discount Cash Flows and Handle Initial Cost

• Introduced: The first supported release and introduction date are not established by the checked sources.
• Availability: Currently documented in Apple’s Formulas and Functions Help 15.4 documentation edition; no final support endpoint is established.
• Scope: Shared iWork function reference. This edition number does not establish a Numbers app version or identical behavior across older Mac, iPad, iPhone and iCloud clients.
• Checked: October 14, 2026, against the official NPV reference. Documentation and independent numerical models; no native Numbers test.

=NPV(periodic-discount-rate, cash-flow, cash-flow…)

The rate and first cash flow are required; further cash-flow arguments are optional. Apple requires the periodic rate to be at least zero. Enter percentages as 10% or 0.10, not 10 when you mean ten percent. Positive cash flows are receipts; negative amounts are payments.

Amounts may vary, but their time intervals must be equal. Apple’s example places the first listed amount at the end of year 1. For a rate r and later amounts C1, C2 and C3, the mathematical check is:

C1/(1+r) + C2/(1+r)^2 + C3/(1+r)^3

The function has no argument that changes the first cash flow to time zero. It returns a discounted amount, not an internal rate of return. The IRR function solves a different question.

Create a table named CashFlows, with at least seven columns A:G and eight rows. Set A1:C1 to Year, Cash flow and Discounted amount. Enter these values in A2:B7:

Put Rate in E1 and 10% in E2. In C2 enter =B2/(1+$E$2)^A2 and fill through C7. The fixed reference keeps every row tied to the same rate.

In G2 enter =NPV(E2,B2,B3,B4,B5,B6,B7). The expected result is 50913.431713613, normally displayed as 50,913.43. These are the amounts in Apple’s worked partnership example, whose published result is 50,913.43.

For a direct arithmetic check, put =C2+C3+C4+C5+C6+C7 in G3. It should agree with G2 to calculation precision. Keep full numeric values in the cells; rounding the six row results before adding them can introduce a small display-level difference.

Put Initial cost in E4 and 45000 in E5 as a positive cost amount. In G5 enter =G2-E5. The expected project NPV is 5913.431713613, displayed as 5,913.43.

This comparison values the future receipts and additional payments at the chosen rate, then subtracts today’s price. Do not put the initial cost first inside NPV as well as subtracting it outside; that would count it twice and assign the inside copy the wrong timing.

If your source records the initial cost as -45000, add that signed value instead. Consistent sign conventions are more important than the wording of the input label. A positive modeled NPV is not a guarantee that forecast cash flows, taxes, fees or risk assumptions are correct.

In G7 enter =NPV(10%,0,1210). It returns 1000, because 1210 arrives after two periods. In G8 enter =NPV(10%,1210). It returns 1100, because the same receipt is now one period away.

Deleting a zero amount changes the timeline. Use explicit numeric zero for a period with no cash movement rather than relying on undocumented blank-cell handling. This is especially important when preparing inputs from a filtered or incomplete transaction list.

Create a separate table named Scenarios, with four columns A:D and five rows. Use headers Rate, Future cash-flow PV, Initial cost and Project NPV. Enter 0%, 5%, 10%, 15% in A2:A5 and 45000 in C2:C5.

In B2 enter =NPV(A2,-25000,-10000,0,10000,30000,100000) and fill to B5. In D2 enter =B2-C2 and fill to D5.

At zero discount, the future amounts simply sum to 105000. For this particular timeline, increasing the discount rate reduces its present value. That is an observation about these inputs, not a universal monotonicity rule for every mixture of positive and negative flows.

A monthly series needs a monthly rate. If a model explicitly specifies a 12% nominal annual rate divided across twelve months, use 12%/12. For an effective annual rate, the equivalent monthly compound rate is (1+annual_rate)^(1/12)-1; those conventions differ. Document which one your model uses.

For a six-month example, =NPV(12%/12,400,400,400,400,400,400)-2000 gives approximately 318.19. It assumes six month-end receipts and a 2000 payment today.

Check numeric inputs, rate units and equal intervals before diagnosing a result. Apple does not enumerate every blank, text-coercion or invalid-rate error code on this page. Currency display follows Language & Region settings; formatting is not currency conversion. Use XNPV for explicitly dated, uneven intervals and PV for a constant-payment annuity model.