source/text/scalc/01/04060119.xhp | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)
New commits: commit 8b4da8e88b89d877bf4a0c6c2d047c992fc26476 Author: Pierre F <f...@bger.ch> AuthorDate: Thu Aug 1 09:46:47 2024 +0200 Commit: Olivier Hallot <olivier.hal...@libreoffice.org> CommitDate: Thu Aug 1 23:00:06 2024 +0200 NPV() example. tdf#131140 Change-Id: I551522d382b9239ac4f566c7109ac032eb7e9a04 Reviewed-on: https://gerrit.libreoffice.org/c/help/+/171348 Tested-by: Jenkins Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org> diff --git a/source/text/scalc/01/04060119.xhp b/source/text/scalc/01/04060119.xhp index 23a10ae66a..05adc68a1e 100644 --- a/source/text/scalc/01/04060119.xhp +++ b/source/text/scalc/01/04060119.xhp @@ -339,9 +339,9 @@ <embed href="text/scalc/01/common_func.xhp#datenumbersequencenote"/> <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.86 currency units. The net present value is the returned value minus the initial costs of 40 currency units, therefore 5.86 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>