NPV Function in SoftMaker PlanMaker 2026: Discounted Cash Flows
Calculate present value of future periodic cash flows with PlanMaker NPV, including zero-cash-flow years, initial costs, worked tables, and compatibility.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in SoftMaker PlanMaker 2026. How formula examples are checked
Quick answer: =NPV(6.5%,4000,5000) gives an expected 8164.16 according to SoftMaker’s official 2026 manual. NPV discounts an ordered set of future cash flows, each occurring at the end of an equally spaced period. Cash flows may be positive or negative and can vary from period to period. Official documentation.
Validation: The 2026 and 2024 English help pages were checked on 2026-10-12. All further numeric results are independently calculated mathematical expectations, not results observed in a PlanMaker or Excel runtime. Per-edition and platform support was not tested.
Exact syntax, inputs and defaults
=NPV(Rate, Value1 [, Value2, Value3 ...])
| Argument | Required? | Type/meaning |
|---|---|---|
Rate |
Yes | Fixed discount/interest rate per period, entered as a numeric rate (for example 10% or a numeric cell). |
Value1 |
Yes | First future period’s end cash flow; a number or a cell range of period-end flows. |
Value2, Value3, … |
No | Further cash flows in order, as values or references. |
Square brackets indicate optional arguments; do not type them. There is no optional argument that switches to beginning-of-period payments. For any period without a payment or receipt, include zero so the timing of later values does not shift. If the initial investment occurs now (period 0), add it separately outside NPV; do not put it at the front of the future payment range. In SoftMaker’s manual, values must be regular, period-end, chronological cash flows. Official PlanMaker rules.
The formulas here use commas, consistent with the vendor’s English documentation. A local installation may expect different argument separators or decimal punctuation; inspect PlanMaker’s formula editor in the target locale before pasting.
Reproducible project example with a current initial cost
Enter these cells into a blank worksheet exactly as shown:
| Cell | Description | Value |
|---|---|---|
| B2 | Annual discount rate | 10% |
| B3 | Initial project cost today | -10000 |
| B4 | End-of-year 1 net cash flow | 3000 |
| B5 | End-of-year 2 net cash flow | 4200 |
| B6 | End-of-year 3 net cash flow | 6800 |
In B7, enter:
=NPV(B2,B4:B6)+B3
Expected result: 1307.29 (present value of future receipts 11307.29, less the 10000 initial outlay). This formula separates an immediate period-0 cost from the end-of-period cash flows. If you incorrectly put B3 inside the future range, you discount the initial outlay by a full period and obtain a different economic model. The value is a mathematical expectation derived from the supplied rows; check formatting to display two decimal places.
Official PlanMaker sanity check: =NPV(6.5%,4000,5000) should display approximately 8164.16, exactly the example in the PlanMaker 2026 manual. Vendor example.
Advanced examples
No cash flow in year 2: use an explicit zero
Suppose year 1 returns 3000, year 2 returns nothing and year 3 returns 5000. Enter the three amounts in C2:C4 as 3000, 0, and 5000, then use:
=NPV(10%,C2:C4)
Expected future-value present worth: 6483.85. The zero in C3 preserves the third payment’s year-3 discount factor. Omitting C3 from the listed flows would incorrectly treat the 5000 receipt as occurring in year 2. SoftMaker explicitly requires zeros for periods with no cash flow. Manual rule.
Mixed income and outflows
=NPV(8%,1000,-200,700)
Expected: 1310.14 for three period-end flows (receipt, cost, receipt). A negative future number is valid; it signifies an expense. The amounts can be individual arguments or supplied in an ordered range.
Discount rate is zero
=NPV(0,100,-50)
Independent mathematical expectation: 50.00, since future amounts have no discounting in this model. This is a calculation check only; the guide makes no untested claim about every boundary input accepted by the PlanMaker runtime.
Rates must match cash-flow intervals
For cash flows every month and a nominal annual rate of 12%, a monthly periodic model would use 12%/12 as the NPV rate and list each monthly cash flow. An annual discount rate applied directly to monthly cash flows uses the wrong period length. A genuine effective annual rate converted to an effective monthly rate requires a different conversion ((1+annual_effective_rate)^(1/12)-1); the appropriate rate definition depends on the financial agreement.
Independent verification: what NPV discounts
For period-end cash flows C1...Cn and periodic rate r, the mathematical check is:
NPV = C1/(1+r)^1 + C2/(1+r)^2 + ... + Cn/(1+r)^n
An immediate outlay C0 enters the complete project value as C0 + NPV. Our worked example uses 3000/1.1 + 4200/1.1^2 + 6800/1.1^3 ≈ 11307.29, then adds -10000 to obtain 1307.29. This arithmetic was independently calculated with Python Decimal; it was not run in a spreadsheet application.
Troubleshooting and limitations
| Situation | Check or correction |
|---|---|
| Initial cost produces the wrong present value | If the outlay happens now, put it outside the NPV function (=NPV(...)+initial_cost). |
| Result changes when removing a blank period | Insert 0 for every end-of-period with no cash flow. Do not compress the timeline. |
| Irregular receipt dates | Standard NPV assumes equally spaced periods. Examine the separate SoftMaker XNPV documentation, and verify its date handling before using it. |
| Annual rate with monthly cash flows | Convert the rate appropriately to the same cash-flow interval. |
| Formula not recognized or result looks like text | Check function spelling, numeric input, local punctuation and separators; formatting should not be confused with the underlying numeric value. |
| Unexpected error for nonnumeric cells | The 2026 NPV entry does not provide a complete list of error codes or text/blank coercion rules. Native testing is required; do not silently borrow Excel rules. |
Scope: NPV describes a fixed-period discounting model, not an annualized investment return, not an IRR solver, and not a detailed tax/inflation projection. Economic usefulness depends on plausible estimates of discount rates and future cash flows.
Excel and version compatibility
PlanMaker 2026 and Microsoft’s Excel NPV documentation use the same general argument order, period-end timing, and the requirement to place an immediate period-0 cost outside the future-flow discount series. This supports syntax-level compatibility for the shown numeric examples only. Excel explicitly documents special handling of empty cells, logical values and text and a particular maximum argument count; those Excel-specific claims are not verified PlanMaker behaviour. Excel reference.
Cross-version evidence: The PlanMaker 2024 English NPV entry documents the same syntax and official worked example. A full 2021 compatibility check and any native Windows/macOS/Linux/mobile verification were not performed. Support for every edition/platform cannot be inferred from the presence of the shared 2026 online help.
Related official documentation
- PlanMaker PV: constant-payment present-value model; allows beginning/end timing unlike NPV.
- PlanMaker IRR: discount rate that balances cash flows under its own model.
- PlanMaker XNPV: cash flows whose dates are not equally spaced, subject to separate date-input validation.
These are vendor documentation links, not claims that those URLs currently exist as internal Spreadsheet-Tutorials.com pages.
Source and review notes
- SoftMaker 2026 NPV: https://help.softmaker.com/planmaker2026/en/npv_net_present_value.html — accessed 2026-10-12; syntax, timing, zeros, variable cash flows, official 8164.16 example.
- SoftMaker 2024 NPV: https://help.softmaker.com/planmaker2024/en/npv_net_present_value.html — accessed 2026-10-12; cross-version documentation for listed rules.
- Microsoft Excel NPV: https://support.microsoft.com/en-us/excel/functions/npv-function — accessed 2026-10-12; Excel comparison only.
- Independent mathematics: cash-flow model checks are stored in the evidence and validation results. No native PlanMaker or Excel execution.