Difference between revisions of "Documentation/How Tos/Calc: AMORDEGRC function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
(17 intermediate revisions by 6 users not shown) | |||
Line 1: | Line 1: | ||
− | __NOTOC__ | + | {{DISPLAYTITLE: AMORDEGRC function}} |
+ | {{Documentation/CalcFunc FinancialTOC | ||
+ | |ShowPrevNext=block | ||
+ | |PrevPage=Documentation/How_Tos/Calc:_Financial_functions | ||
+ | |NextPage=Documentation/How_Tos/Calc:_AMORLINC_function | ||
+ | }}__NOTOC__ | ||
== AMORDEGRC == | == AMORDEGRC == | ||
− | Returns depreciation for a | + | Returns depreciation for a period using degressive depreciation (French system). |
+ | |||
+ | This function is only available if the '''Analysis AddIn''' is installed. | ||
=== Syntax: === | === Syntax: === | ||
− | <tt>'''AMORDEGRC(cost; | + | <tt>'''AMORDEGRC(cost; purchase_date; first_period_end; salvage; period; rate; basis)'''</tt> |
− | + | : <tt>'''cost'''</tt>: the acquisition cost. | |
− | + | : <tt>'''purchase_date'''</tt>: the date of acquisition. | |
− | : <tt>'''cost'''</tt>: the acquisition | + | : <tt>'''first_period_end'''</tt>: the end date of the first depreciation period. |
− | : <tt>''' | + | : <tt>'''salvage'''</tt>: the salvage value at the end of life. |
− | : <tt>''' | + | : <tt>'''period'''</tt>: the period for which to calculate depreciation. 0 is the initial period (from <tt>'''purchase_date'''</tt> to <tt>'''first_period_end'''</tt>. |
− | : <tt>'''salvage'''</tt>: the salvage value | + | |
− | : <tt>'''period'''</tt>: the | + | |
: <tt>'''rate'''</tt>: the rate of depreciation. | : <tt>'''rate'''</tt>: the rate of depreciation. | ||
: <tt>'''basis'''</tt>: is chosen from a list of options and indicates how the year is to be calculated. Defaults to <tt>'''0'''</tt> if omitted. | : <tt>'''basis'''</tt>: is chosen from a list of options and indicates how the year is to be calculated. Defaults to <tt>'''0'''</tt> if omitted. | ||
Line 21: | Line 26: | ||
:: 3 - Exact number of days in month, year has 365 days | :: 3 - Exact number of days in month, year has 365 days | ||
:: 4 - European method, 12 months of 30 days each | :: 4 - European method, 12 months of 30 days each | ||
+ | |||
+ | |||
+ | : Calculates the amount of depreciation for a period as degressive amortization, as used in French accounting systems. | ||
+ | |||
+ | : The life time ''t'' of the asset is 1/<tt>'''rate'''</tt>. A depreciation factor ''f'' is given by: | ||
+ | :: 0 < = ''t'' < 3 : ''f''=1.0 | ||
+ | :: 3 <= ''t'' < 5 : ''f''=1.5 | ||
+ | :: 5 <= ''t'' < 6 : ''f''=2.0 | ||
+ | :: ''t'' >= 6 : ''f''=2.5 | ||
+ | |||
+ | : Depreciation for a period is calculated as: | ||
+ | :: period 0: <tt>'''cost'''</tt>*<tt>'''rate'''</tt>*<tt>'''YEARFRAC(purchase_date;first_period_end;basis)'''</tt> | ||
+ | :: period 1 to t-3 : <tt>'''rate'''</tt> * ''f'' * previous_period_depreciation | ||
+ | :: period t-2 : 0.5 * previous_period_depreciation | ||
+ | :: period t-1 : depreciation_in_period_t-2 | ||
+ | :: period >= t : 0 | ||
=== Example: === | === Example: === | ||
Line 26: | Line 47: | ||
: returns <tt>'''228'''</tt>. | : returns <tt>'''228'''</tt>. | ||
− | + | {{SeeAlso|EN| | |
− | [[Documentation/How_Tos/Calc: AMORLINC function| | + | * [[Documentation/How_Tos/Calc: AMORLINC function|AMORLINC]] |
+ | |||
+ | * [[Documentation/How_Tos/Calc: DB function|DB]] | ||
+ | * [[Documentation/How_Tos/Calc: DDB function|DDB]] | ||
+ | * [[Documentation/How_Tos/Calc: SLN function|SLN]] | ||
+ | * [[Documentation/How_Tos/Calc: SYD function|SYD]] | ||
+ | * [[Documentation/How_Tos/Calc: VDB function|VDB]] | ||
+ | |||
+ | * [[Documentation/How_Tos/Calc: YEARFRAC function|YEARFRAC]] | ||
+ | |||
+ | * [[Documentation/How_Tos/Calc: Date & Time functions#Financial date systems|Financial date systems]] | ||
+ | |||
+ | * [[Documentation/How_Tos/Calc: Financial functions|Financial functions]] | ||
− | [[Documentation/How_Tos/Calc: | + | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] |
+ | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | ||
+ | [[Category: Documentation/Reference/Calc/Financial functions]] |
Latest revision as of 15:03, 30 January 2024
- Financial FunctionsDepreciation
- AMORDEGRCAMORLINCDBDDBSLNSYDVDBPayment Streams, Annuities, Loans
- CUMIPMTCUMIPMT_ADDCUMPRINCCUMPRINC ADDFVFVSCHEDULEIPMTIRRISPMTMIRRNPERNPVPMTPPMTPVRATERRIXIRRXNPVSecurities
-