source/text/scalc/01/04060103.xhp | 8 ++++++++
1 file changed, 8 insertions(+)
New commits:
commit 13b1e7bca5e5860dbf4550949f514749a64e2d54
Author: Steve Fanning <stevemfann...@yahoo.co.uk>
AuthorDate: Tue Feb 2 21:45:25 2021 +0100
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Wed Feb 3 02:58:06 2021 +0100
Provide examples in the Help descriptions of Calc’s AMORDEGRC and AMORLINC
functions.
Relevant examples might be:
=AMORDEGRC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1; 0) returns a
depreciation amount of 163 currency units.
=AMORLINC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1; 0) returns a
depreciation amount of 200 currency units.
File 04060103.xhp affected.
Change-Id: I9161d974c00cfc30515fb1fcbe44aff09242f422
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/110300
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/scalc/01/04060103.xhp
b/source/text/scalc/01/04060103.xhp
index 7145fc474..75bfec5ba 100644
--- a/source/text/scalc/01/04060103.xhp
+++ b/source/text/scalc/01/04060103.xhp
@@ -58,6 +58,10 @@
<paragraph xml-lang="en-US" id="par_id3155064" role="paragraph">
<emph>Rate</emph> is the rate of depreciation.</paragraph>
<embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+ <paragraph xml-lang="en-US" id="par_id421612299085248"
role="paragraph">An asset was acquired on 2020-02-01 at a cost of 2000 currency
units. The end date of the first settlement period was 2020-12-31. The salvage
value of the asset at the end of its depreciable life will be 10 currency
units. The rate of depreciation is 0.1 (10%) and the year is calculated using
the US method (Basis 0). Assuming degressive depreciation, what is the amount
of depreciation in the fourth depreciation period?</paragraph>
+ <paragraph xml-lang="en-US" id="par_id901612299089478"
role="paragraph">
+ <input>=AMORDEGRC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1;
0)</input> returns a depreciation amount of 163 currency units.</paragraph>
</section>
<section id="amorlinc">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3153765"><bookmark_value>AMORLINC function</bookmark_value>
@@ -81,6 +85,10 @@
<paragraph xml-lang="en-US" id="par_id3150982" role="paragraph">
<emph>Rate</emph> is the rate of depreciation.</paragraph>
<embed href="text/scalc/01/func_yearfrac.xhp#basis"/>
+ <embed href="text/scalc/01/common_func.xhp#sectionexample"/>
+ <paragraph xml-lang="en-US" id="par_id641612299092454"
role="paragraph">An asset was acquired on 2020-02-01 at a cost of 2000 currency
units. The end date of the first settlement period was 2020-12-31. The salvage
value of the asset at the end of its depreciable life will be 10 currency
units. The rate of depreciation is 0.1 (10%) and the year is calculated using
the US method (Basis 0). Assuming linear depreciation, what is the amount of
depreciation in the fourth depreciation period?</paragraph>
+ <paragraph xml-lang="en-US" id="par_id391612299096511"
role="paragraph">
+ <input>=AMORLINC(2000; "2020-02-01"; "2020-12-31"; 10; 4; 0.1;
0)</input> returns a depreciation amount of 200 currency units.</paragraph>
</section>
<section id="accrint">
<bookmark xml-lang="en-US" branch="index"
id="bm_id3145257"><bookmark_value>ACCRINT function</bookmark_value>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
