NPV in WPS Spreadsheet: Discount Ordered End-of-Period Cash Flows
Calculate WPS NPV for explicit signed end-period flows, keep time-zero amounts separate and verify the result with independent discount factors.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =NPV(0.1,110,121) has expected value 200. The first flow is discounted one period and the second two periods: 110/1.1 +121/1.1² =100+100.
Syntax and timeline
=NPV(rate,value1,value2,...)
Rate is the constant discount rate per interval. The supplied cash flows are ordered, equally spaced and occur at the ends of successive periods. Positive values represent receipts and negative values represent outflows from the chosen viewpoint.
The official formula image sums each value divided by (1+rate) raised to its period index, starting at index 1. The first argument after rate is therefore not a time-zero amount. These examples use two explicit numeric flows, avoiding unresolved argument-count and mixed-type coercion details.
Complete worksheet example
Enter these numbers in a fresh worksheet:
| Cell | Meaning | Value |
|---|---|---|
| A2 | Rate per period | 0.1 |
| B2 | End-of-period 1 receipt | 110 |
| C2 | End-of-period 2 receipt | 121 |
Enter =NPV(A2,B2,C2) in D2. The independent expected result is 200.
The two discounted contributions are 100 and 100. Rate 0.1 is hypothetical and is per interval; the function does not infer whether that interval is a year, quarter or month from a heading.
For a signed-flow control, =NPV(0.1,-110,121) gives 0 because −110/1.1 +121/1.1² =−100+100. A zero result here means these two discounted flows cancel under the chosen rate and timing. It does not by itself establish a financially attractive or appropriate decision.
Advanced use: include an initial amount correctly
If the same example also has an initial outflow of 180 at time zero, keep it outside NPV’s future-flow list. The complete arithmetic is −180 + NPV(0.1,110,121) =20.
Putting −180 inside the function as the first value would discount it one period and shift both receipts later. That would represent a different timeline. The source explicitly says a beginning-of-first-period cash flow should be added separately rather than included among the future values.
The function’s name does not automatically account for an initial cost that was never supplied. Label the result precisely: the NPV of only the future receipts is 200, while the combined discounted net amount including the stated initial outflow is 20.
Order and rate controls
Swapping the receipts gives =NPV(0.1,121,110), approximately 200.9090909091. Receiving the larger amount sooner increases the discounted total in this positive-rate example. Sorting the cash-flow values without their dates would silently change the calculation.
A second rate control is =NPV(0.05,105,110.25), again 200, since each flow discounts to 100. These hand-checkable examples verify both the first-period exponent and the ordering rule.
Source limitations and interpretation
The lesson’s formal timing equation is coherent, but its walkthrough uses loose “investment” labels for positive numbers and includes a fill-reference slip. The original examples here follow explicit signed cash-flow labels and the printed equation rather than copying those labels or instructions.
The historical article states an argument limit and gives broad coercion guidance for mixed inputs. This guide does not certify those details across versions. It uses two explicit finite numeric flows and a positive rate, with no blank, text, logical or error-valued entries.
NPV differs from the fixed-payment annuity function PV: its individual future amounts may vary, while timing remains one equal interval per listed value. Irregular dates, changing rates, taxes, fees and investment suitability require separate modelling choices. The examples explain discounted arithmetic only; they are not investment advice or a forecast of actual returns.
Evidence and version scope
The official WPS Academy NPV lesson, published 2019-05-08, has the applicability scope recorded below. It was reviewed on October 18, 2026. The applicability field explicitly names WPS Office for Windows Personal. The narrative also names WPS 2019, which identifies the historical lesson context rather than a first release or exact build. The numeric build, introduction release and last supported version remain unknown. The source does not identify this function as deprecated or retired. Support in Linux, other editions and other platforms is not established by this lesson.
The worked examples are original documentation-based expectations, supported by independent reasoning and arithmetic where applicable. They were not executed in WPS. Historical vendor demonstrations are documentation, not our application tests; no screenshot or runtime precision guarantee is supplied. English names and comma separators follow the lesson. Localized entry, workbook interchange and exact output formatting require verification in the intended client.