| 04060118.xhp (82a98929) | 04060118.xhp (f773ab65) |
|---|---|
| 1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file --- 154 unchanged lines hidden (view full) --- 163<emph>Life</emph> is the depreciation duration of the asset.</paragraph> 164<paragraph role="paragraph" id="par_id3152817" xml-lang="en-US" l10n="U" oldref="229"> 165<emph>S</emph> is the start of the depreciation. A must be entered in the same date unit as the duration.</paragraph> 166<paragraph role="paragraph" id="par_id3153221" xml-lang="en-US" l10n="U" oldref="230"> 167<emph>End</emph> is the end of the depreciation.</paragraph> 168<paragraph role="paragraph" id="par_id3147536" xml-lang="en-US" l10n="CHG" oldref="231"> 169<emph>Factor</emph> (optional) is the depreciation factor. Factor = 2 is double rate depreciation.</paragraph> 170<paragraph role="paragraph" id="par_id3154865" xml-lang="en-US" l10n="CHG" oldref="232"> | 1<?xml version="1.0" encoding="UTF-8"?> 2 3<!--*********************************************************** 4 * 5 * Licensed to the Apache Software Foundation (ASF) under one 6 * or more contributor license agreements. See the NOTICE file 7 * distributed with this work for additional information 8 * regarding copyright ownership. The ASF licenses this file --- 154 unchanged lines hidden (view full) --- 163<emph>Life</emph> is the depreciation duration of the asset.</paragraph> 164<paragraph role="paragraph" id="par_id3152817" xml-lang="en-US" l10n="U" oldref="229"> 165<emph>S</emph> is the start of the depreciation. A must be entered in the same date unit as the duration.</paragraph> 166<paragraph role="paragraph" id="par_id3153221" xml-lang="en-US" l10n="U" oldref="230"> 167<emph>End</emph> is the end of the depreciation.</paragraph> 168<paragraph role="paragraph" id="par_id3147536" xml-lang="en-US" l10n="CHG" oldref="231"> 169<emph>Factor</emph> (optional) is the depreciation factor. Factor = 2 is double rate depreciation.</paragraph> 170<paragraph role="paragraph" id="par_id3154865" xml-lang="en-US" l10n="CHG" oldref="232"> |
| 171<emph>Type </emph>is an optional parameter. Type = 1 means a switch to linear depreciation. In Type = 0 no switch is made.</paragraph> | 171<emph>Type</emph> is an optional parameter. Type = 1 means a switch to linear depreciation. In Type = 0 no switch is made.</paragraph> |
| 172<paragraph role="paragraph" id="par_idN10A0D" xml-lang="en-US" l10n="NEW"> 173<embedvar href="text/scalc/00/00000004.xhp#optional"/> 174</paragraph> 175<paragraph role="heading" id="hd_id3148429" xml-lang="en-US" level="3" l10n="U" oldref="233">Example</paragraph> 176<paragraph role="paragraph" id="par_id3153927" xml-lang="en-US" l10n="U" oldref="234">What is the declining-balance double-rate depreciation for a period if the initial cost is 35,000 currency units and the value at the end of the depreciation is 7,500 currency units. The depreciation period is 3 years. The depreciation from the 10th to the 20th period is calculated.</paragraph> 177<paragraph role="paragraph" id="par_id3155991" xml-lang="en-US" l10n="U" oldref="235"> 178<item type="input">=VDB(35000;7500;36;10;20;2)</item> = 8603.80 currency units. The depreciation during the period between the 10th and the 20th period is 8,603.80 currency units.</paragraph> 179</section> --- 249 unchanged lines hidden (view full) --- 429<paragraph role="paragraph" id="par_id3147100" xml-lang="en-US" l10n="U" oldref="154"><ahelp hid="HID_AAI_FUNC_COUPDAYSNC">Returns the number of days from the settlement date until the next interest date.</ahelp></paragraph> 430<paragraph role="heading" id="hd_id3151312" xml-lang="en-US" level="3" l10n="U" oldref="155">Syntax</paragraph> 431<paragraph role="code" id="par_id3155121" xml-lang="en-US" l10n="U" oldref="156">COUPDAYSNC(Settlement; Maturity; Frequency; Basis)</paragraph> 432<paragraph role="paragraph" id="par_id3158440" xml-lang="en-US" l10n="U" oldref="157"> 433<emph>Settlement</emph> is the date of purchase of the security.</paragraph> 434<paragraph role="paragraph" id="par_id3146075" xml-lang="en-US" l10n="U" oldref="158"> 435<emph>Maturity</emph> is the date on which the security matures (expires).</paragraph> 436<paragraph role="paragraph" id="par_id3154620" xml-lang="en-US" l10n="U" oldref="159"> | 172<paragraph role="paragraph" id="par_idN10A0D" xml-lang="en-US" l10n="NEW"> 173<embedvar href="text/scalc/00/00000004.xhp#optional"/> 174</paragraph> 175<paragraph role="heading" id="hd_id3148429" xml-lang="en-US" level="3" l10n="U" oldref="233">Example</paragraph> 176<paragraph role="paragraph" id="par_id3153927" xml-lang="en-US" l10n="U" oldref="234">What is the declining-balance double-rate depreciation for a period if the initial cost is 35,000 currency units and the value at the end of the depreciation is 7,500 currency units. The depreciation period is 3 years. The depreciation from the 10th to the 20th period is calculated.</paragraph> 177<paragraph role="paragraph" id="par_id3155991" xml-lang="en-US" l10n="U" oldref="235"> 178<item type="input">=VDB(35000;7500;36;10;20;2)</item> = 8603.80 currency units. The depreciation during the period between the 10th and the 20th period is 8,603.80 currency units.</paragraph> 179</section> --- 249 unchanged lines hidden (view full) --- 429<paragraph role="paragraph" id="par_id3147100" xml-lang="en-US" l10n="U" oldref="154"><ahelp hid="HID_AAI_FUNC_COUPDAYSNC">Returns the number of days from the settlement date until the next interest date.</ahelp></paragraph> 430<paragraph role="heading" id="hd_id3151312" xml-lang="en-US" level="3" l10n="U" oldref="155">Syntax</paragraph> 431<paragraph role="code" id="par_id3155121" xml-lang="en-US" l10n="U" oldref="156">COUPDAYSNC(Settlement; Maturity; Frequency; Basis)</paragraph> 432<paragraph role="paragraph" id="par_id3158440" xml-lang="en-US" l10n="U" oldref="157"> 433<emph>Settlement</emph> is the date of purchase of the security.</paragraph> 434<paragraph role="paragraph" id="par_id3146075" xml-lang="en-US" l10n="U" oldref="158"> 435<emph>Maturity</emph> is the date on which the security matures (expires).</paragraph> 436<paragraph role="paragraph" id="par_id3154620" xml-lang="en-US" l10n="U" oldref="159"> |
| 437<emph>Frequency </emph>is number of interest payments per year (1, 2 or 4).</paragraph> | 437<emph>Frequency</emph> is number of interest payments per year (1, 2 or 4).</paragraph> |
| 438<embed href="text/scalc/01/func_yearfrac.xhp#basis"/> 439<paragraph role="heading" id="hd_id3155604" xml-lang="en-US" level="3" l10n="U" oldref="160">Example</paragraph> 440<paragraph role="paragraph" id="par_id3148671" xml-lang="en-US" l10n="CHG" oldref="161">A security is purchased on 2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many days are there until the next interest payment?</paragraph> 441<paragraph role="paragraph" id="par_id3156158" xml-lang="en-US" l10n="CHG" oldref="162">=COUPDAYSNC("2001-01-25"; "2001-11-15"; 2; 3) returns 110.</paragraph> 442</section> 443<section id="coupdaybs"> 444<bookmark xml-lang="en-US" branch="index" id="bm_id3150408"> 445<bookmark_value>COUPDAYBS function</bookmark_value> --- 172 unchanged lines hidden --- | 438<embed href="text/scalc/01/func_yearfrac.xhp#basis"/> 439<paragraph role="heading" id="hd_id3155604" xml-lang="en-US" level="3" l10n="U" oldref="160">Example</paragraph> 440<paragraph role="paragraph" id="par_id3148671" xml-lang="en-US" l10n="CHG" oldref="161">A security is purchased on 2001-01-25; the date of maturity is 2001-11-15. Interest is paid half-yearly (frequency is 2). Using daily balance interest calculation (basis 3) how many days are there until the next interest payment?</paragraph> 441<paragraph role="paragraph" id="par_id3156158" xml-lang="en-US" l10n="CHG" oldref="162">=COUPDAYSNC("2001-01-25"; "2001-11-15"; 2; 3) returns 110.</paragraph> 442</section> 443<section id="coupdaybs"> 444<bookmark xml-lang="en-US" branch="index" id="bm_id3150408"> 445<bookmark_value>COUPDAYBS function</bookmark_value> --- 172 unchanged lines hidden --- |