Attachment 158399 Details for Bug 131140 – patch

[patch] patch

0001-Add-a-negative-number-to-the-example-of-NPV.patch (text/plain), 1.94 KB, created by Hong Xu on 2020-03-05 05:24:43 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Hong Xu

Created: 2020-03-05 05:24:43 UTC

Size: 1.94 KB

patch

obsolete

>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
>

Actions: View

Attachments on bug 131140: 158399