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

From Apache OpenOffice Wiki
Jump to: navigation, search
m
m
 
(16 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 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.  
 
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 cost.
−
 
+
: <tt>'''purchase_date'''</tt>: the date of acquisition.
−
: <tt>'''cost'''</tt>: the acquisition costs.
+
: <tt>'''first_period_end'''</tt>: the end date of the first depreciation period.
−
: <tt>'''date_purchased'''</tt>: the date of acquisition.
+
: <tt>'''salvage'''</tt>: the salvage value at the end of life.
−
: <tt>'''first_period'''</tt>: the end date of the first settlement period.
+
: <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 of the capital asset at the end of the depreciable life.
+
−
: <tt>'''period'''</tt>: the settlement period to be considered.
+
 
: <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 23: 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&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 28: Line 47:
 
:  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 15:03, 30 January 2024

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=259720"
Views
Personal tools
Navigation
Tools
In other languages