Zoho Sheet NPV: Discounted Cash Flows and Initial-Cost Timing

• Introduced: The original introduction release and date are not established by the checked sources.
• Availability: Currently documented in Zoho Sheet’s rolling web-service help; no numbered release or retirement endpoint is established.
• Scope: English-language web-service documentation. Exact mobile and offline-client parity is not established here.
• Checked: October 14, 2026, against the official NPV reference. Documentation and independent financial models; no native Zoho Sheet test.

=NPV(discount_rate; payment; [payment1]; ...)

The discount rate is required and applies to one payment period. Payments can be individual values or ranges; additional payment arguments are optional. Zoho explicitly describes payments as occurring at the end of each period.

For the standard periodic model, the first listed amount is discounted for one period, the second for two, and so on. An initial amount paid today belongs outside that future-payment series. A negative outflow and positive receipt should be recorded consistently from the same viewpoint.

The independent calculation is a sum of cash flow/(1+rate)^period, beginning with period 1. Its result has the same currency unit as the amounts. NPV returns a discounted value, not an interest rate or an undiscounted total.

The examples use Zoho’s documented semicolon syntax. Enter 8% as 8% or 0.08, not the ordinary number 8.

Create a blank sheet named ProjectValue. Put Period, End-of-period receipt and Discounted receipt in A1:C1. Enter A2:B4 below:

Put Rate in E1 and 8% in E2. Enter Initial outlay today in E3 and -5000 in E4. Put =NPV(E2;B2:B4) in E6; expect approximately 6376.695625667.

Enter =B2/(1+$E$2)^A2 in C2 and fill to C4. Put =SUM(C2:C4) in E7. It should match E6 mathematically. In E8 enter =E4+E6; expect approximately 1376.695625667, or 1376.70 when displayed to two decimals.

The initial outlay is at period zero and is not divided by 1.08. The three receipts are discounted back to that same starting point. Keep stored precision in the helper cells rather than replacing them with the rounded table values.

Keep ProjectValue unchanged. On a separate sheet named TimingCheck, put Period and Cash flow in A1:B1. Enter 0, 1, 2, 3 in A2:A5 and -5000, 2000, 2500, 3000 in B2:B5. Put 8% in D2.

Use these formulas in D4:D6:

D5 shifts the entire sequence one period later by discounting the initial outlay as if it occurred at period 1. D6 exposes that one-period shift. It is a different timing model, not a small rounding discrepancy.

The sign of a project NPV depends on the chosen discount rate and entered cash flows. A positive value under this model does not guarantee that forecasts will occur or select an appropriate rate for a real investment.

Create another sheet named RateCheck. Put Rate and Project NPV in A1:B1. Enter 0%, 5%, 8%, 10%, 20% in A2:A6. In B2 enter =-5000+NPV(A2;2000;2500;3000) and fill to B6.

The zero-rate target is the undiscounted sum minus cost under the mathematical model; Zoho’s short entry does not separately discuss every rate boundary. Higher positive rates reduce the present value of these positive future receipts.

On another blank sheet, put 110, 0, 133.1 in A2:A4. Enter =NPV(10%;A2:A4) in C2; the independent expected value is 200, from 100+0+100.

Put =NPV(10%;110;133.1) in C3; expect 210. Deleting the zero-payment period makes the last receipt arrive one period earlier. Use an explicit numeric zero for a known zero flow; do not use a blank or text value to represent timing whose native inclusion behavior has not been established.

Keep the rate unit aligned with the payment interval. A monthly series needs a monthly rate appropriate to the model; dates are not inferred from row positions. Zoho directs irregular-date cash flows to its XNPV reference.

The generic error table does not establish every NPV-specific rate domain, blank/text coercion or extreme-precision limit. Inspect source references and input types rather than assigning undocumented error tokens.

IRR solves for a periodic rate instead of accepting one. MIRR uses explicit financing and reinvestment assumptions, while PV models an annuity with constant payments. Their timing and argument meanings must be checked separately.