diff options
| author | Rüdiger Timm <rt@openoffice.org> | 2005-10-19 08:37:58 +0000 |
|---|---|---|
| committer | Rüdiger Timm <rt@openoffice.org> | 2005-10-19 08:37:58 +0000 |
| commit | b506ac4aad8ae17f0515f539e912f3b2aa41c5df (patch) | |
| tree | dd6178e82b1ffae8839f66719688dd25ecada090 | |
| parent | 0ba656e1491beeb3d1edce989eff641f0bb7b5ce (diff) | |
INTEGRATION: CWS hc680qq1 (1.3.54); FILE MERGED
2005/09/20 16:15:02 ufi 1.3.54.3: RESYNC: (1.3-1.4); FILE MERGED
2005/09/13 13:14:31 ufi 1.3.54.2: firsttry
2005/08/24 12:11:30 ufi 1.3.54.1: Synched with hc680pp1
| -rw-r--r-- | helpcontent2/source/text/scalc/01/04060119.xhp | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/helpcontent2/source/text/scalc/01/04060119.xhp b/helpcontent2/source/text/scalc/01/04060119.xhp index 0bcc68ca56..2a870e5e2b 100644 --- a/helpcontent2/source/text/scalc/01/04060119.xhp +++ b/helpcontent2/source/text/scalc/01/04060119.xhp @@ -5,9 +5,9 @@ * * $RCSfile: 04060119.xhp,v $ * - * $Revision: 1.5 $ + * $Revision: 1.6 $ * - * last change: $Author: kz $ $Date: 2005-10-05 11:58:59 $ + * last change: $Author: rt $ $Date: 2005-10-19 09:37:58 $ * * The Contents of this file are made available subject to * the terms of GNU Lesser General Public License Version 2.1. @@ -42,7 +42,7 @@ </topic> <history> <created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> -<lastedited date="2005-05-11T08:59:59">FPE: Fixed missing headings, inserted sections, added sort element</lastedited> +<lastedited date="2005-09-13T14:09:59">FPE: Fixed missing headings, inserted sections, added sort element</lastedited> </history> </meta> <body> @@ -278,14 +278,14 @@ </bookmark> <bookmark xml-lang="en-US" branch="hid/HID_FUNC_NBW" id="bm_id3148417" localize="false"/> <paragraph role="heading" id="hd_id3149242" xml-lang="en-US" level="2" l10n="U" oldref="301">NPV</paragraph> -<paragraph role="paragraph" id="par_id3145308" xml-lang="en-US" l10n="U" oldref="302"><ahelp hid="HID_FUNC_NBW">Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.</ahelp></paragraph> +<paragraph role="paragraph" id="par_id3145308" xml-lang="en-US" l10n="CHG" oldref="302"><ahelp hid="HID_FUNC_NBW">Returns the present value of an investment based on a series of periodic cash flows and a discount rate. To get the net present value, subtract the cost of the project (the initial cash flow at time zero) from the returned value.</ahelp></paragraph> <paragraph role="heading" id="hd_id3149937" xml-lang="en-US" level="3" l10n="U" oldref="303">Syntax</paragraph> <paragraph role="code" id="par_id3153321" xml-lang="en-US" l10n="U" oldref="304">NPV(RATE;Value 1;Value 2;...)</paragraph> <paragraph role="paragraph" id="par_id3150630" xml-lang="en-US" l10n="U" oldref="305">RATE: the discount rate for a period.</paragraph> <paragraph role="paragraph" id="par_id3150427" xml-lang="en-US" l10n="U" oldref="306">Value1;... are up to 30 values, which represent deposits or withdrawals.</paragraph> <paragraph role="heading" id="hd_id3153538" xml-lang="en-US" level="3" l10n="U" oldref="307">Example</paragraph> -<paragraph role="paragraph" id="par_id3154800" xml-lang="en-US" l10n="U" oldref="308">What is the net present value of periodic payments in hundreds of 345, 276 and -145 currency units with a discount rate of 8.75%.</paragraph> -<paragraph role="paragraph" id="par_id3143270" xml-lang="en-US" l10n="U" oldref="309">NPV(8.75%;345;276;-145) = 437.87 currency units. The net present value is therefore 437.87 currency units.</paragraph> +<paragraph role="paragraph" id="par_id3154800" xml-lang="en-US" l10n="CHG" oldref="308">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 payed as -40 currency units.</paragraph> +<paragraph role="paragraph" id="par_id3143270" xml-lang="en-US" l10n="CHG" oldref="309">NPV(8.75%;10;20;30) = 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> </section> <section id="nominal"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149484"><bookmark_value>calculating;nominal interest rates</bookmark_value> |