From 11339dbac0948e0c5798b50aad59dbded85e7efb Mon Sep 17 00:00:00 2001
From: Hong Xu <hong@topbug.net>
Date: Wed, 4 Mar 2020 21:22:38 -0800
Subject: [PATCH] Add a negative number to the example of NPV.

Otherwise the user may doubt whether negative numbers can be used.
---
 source/text/scalc/01/04060119.xhp | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/source/text/scalc/01/04060119.xhp b/source/text/scalc/01/04060119.xhp
index ea6686d20a1a..9805881768f1 100644
--- a/source/text/scalc/01/04060119.xhp
+++ b/source/text/scalc/01/04060119.xhp
@@ -338,9 +338,9 @@
 <paragraph role="paragraph" id="par_id3150427" xml-lang="en-US">
 <emph>Value1, Value2, ..., Value30</emph> are up to 30 values, which represent deposits or withdrawals.</paragraph>
 <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
-<paragraph role="paragraph" id="par_id3154800" xml-lang="en-US">What is the net present value of periodic payments of 10, 20 and 30 currency units with a discount rate of 8.75%. At time zero the costs were paid as -40 currency units.</paragraph>
+<paragraph role="paragraph" id="par_id3154800" xml-lang="en-US">What is the net present value of periodic payments of 10, 20, 30 and -5 currency units with a discount rate of 8.75%. At time zero the costs were paid as -40 currency units.</paragraph>
 <paragraph role="paragraph" id="par_id3143270" xml-lang="en-US">
-<item type="input">=NPV(8.75%;10;20;30)</item> = 49.43 currency units. The net present value is the returned value minus the initial costs of 40 currency units, therefore 9.43 currency units.</paragraph>
+<item type="input">=NPV(8.75%;10;20;30;-5)</item> = 45.68 currency units. The net present value is the returned value minus the initial costs of 40 currency units, therefore 5.68 currency units.</paragraph>
 </section>
 <section id="nominal">
 <bookmark xml-lang="en-US" branch="index" id="bm_id3149484"><bookmark_value>calculating;nominal interest rates</bookmark_value>
-- 
2.20.1