Difference between revisions of "Documentation/How Tos/Calc: AMORDEGRC function"

From Apache OpenOffice Wiki
Jump to: navigation, search
m
 
(18 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__
 +
 
 +
'''Important:''' Because of changes to the depreciation methodology of the French accounting system, this function is deprecated and should no longer be used. It is included for compatibility of old workbooks only.
 +
 
  
 
== AMORDEGRC ==
 
== AMORDEGRC ==
−
Returns depreciation for a settlement period as degressive amortization.
+
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; date_purchased; first_period; salvage; period; rate; basis)'''</tt>
+
<tt>'''AMORDEGRC(cost; purchase_date; first_period_end; salvage; period; rate; basis)'''</tt>
−
 
 
−
: Calculates the amount of depreciation for a settlement period as degressive amortization. Unlike <tt>'''AMORLINC'''</tt>, a depreciation coefficient that is independent of the depreciable life is used here.
 
  
−
: <tt>'''cost'''</tt>: the acquisition costs.
+
: <tt>'''cost'''</tt>: the acquisition cost.
−
: <tt>'''date_purchased'''</tt>: the date of acquisition.
+
: <tt>'''purchase_date'''</tt>: the date of acquisition.
−
: <tt>'''first_period'''</tt>: the end date of the first settlement period.
+
: <tt>'''first_period_end'''</tt>: the end date of the first depreciation period.
−
: <tt>'''salvage'''</tt>: the salvage value of the capital asset at the end of the depreciable life.
+
: <tt>'''salvage'''</tt>: the salvage value at the end of life.
−
: <tt>'''period'''</tt>: the settlement period to be considered.
+
: <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>'''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 29:
 
:: 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&nbsp;&nbsp;: ''f''=1.0
 +
:: 3 <= ''t'' < 5&nbsp;&nbsp;: ''f''=1.5
 +
:: 5 <= ''t'' < 6&nbsp;&nbsp;: ''f''=2.0
 +
:: ''t'' >= 6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;: ''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 50:
 
:  returns <tt>'''228'''</tt>.  
 
:  returns <tt>'''228'''</tt>.  
  
−
=== See also: ===
+
{{SeeAlso|EN|
−
[[Documentation/How_Tos/Calc: AMORLINC function|'''AMORLINC''']]
+
* [[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: Financial functions|'''Financial functions''']]
+
* [[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 08:18, 27 January 2026

Important: Because of changes to the depreciation methodology of the French accounting system, this function is deprecated and should no longer be used. It is included for compatibility of old workbooks only.


AMORDEGRC

Returns depreciation for a period using degressive depreciation (French system).

This function is only available if the Analysis AddIn is installed.

Syntax:

AMORDEGRC(cost; purchase_date; first_period_end; salvage; period; rate; basis)

cost: the acquisition cost.
purchase_date: the date of acquisition.
first_period_end: the end date of the first depreciation period.
salvage: the salvage value at the end of life.
period: the period for which to calculate depreciation. 0 is the initial period (from purchase_date to first_period_end.
rate: the rate of depreciation.
basis: is chosen from a list of options and indicates how the year is to be calculated. Defaults to 0 if omitted.
0 - US method (NASD), 12 months of 30 days each
1 - Exact number of days in months, exact number of days in year
2 - Exact number of days in month, year has 360 days
3 - Exact number of days in month, year has 365 days
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/rate. 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: cost*rate*YEARFRAC(purchase_date;first_period_end;basis)
period 1 to t-3 : rate * f * previous_period_depreciation
period t-2 : 0.5 * previous_period_depreciation
period t-1 : depreciation_in_period_t-2
period >= t : 0

Example:

AMORDEGRC(1000; ”2006-02-01”; ”2006-12-31”; 10; 0; 0.1; 1)

returns 228.


See Also

Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_AMORDEGRC_function&oldid=263403"
Personal tools
In other languages