Manuals/calci/AMORDEGRC

AMORDEGRC (Cost,PurchaseDate,FirstPeriod,SalvageValue,Period,Rate,Basis)

• where, $Cost$ is cost of the asset
• $PurchaseDate$ is the date of purchase of asset
• $FirstPeriod$ is the end of first period
• $SalvageValue$ is the salvage value at the end of life of asset
• $Period$ is the accounting period
• $Rate$ is the rate of depreciation
• $Basis$ is the year basis to be used
  • AMORDEGRC() returns the depreciation for each accounting period by using a depreciation coefficient.

Description

• The function calculates the decrease in value of asset for a mentioned period considering the depreciation coefficient depending on life of assets. This function is used in French accounting system.
• If $PurchaseDate$ > $FirstPeriod$, Calci displays #N/A error message.
• If $Rate$ is <=0, Calci displays #N/A error message.
• If $Period$ is omitted, Calci assumes it as 0.5 years(6 months).
• 'Basis' value is optional. If omitted, Calci assumes it to be 0.

Below table shows the use of 'basis' values:

Basis	Description
0	360 days (NASD)
1	Actual
3	365 days in a year
4	360 days in a year (European)

• If 'basis' value is other than 0, 1, 3 or 4, Calci displays #N/A error message.
• The Depreciation coefficients used in calculation are referred as follows:

Life of Assets	Depreciation Coefficient
Between 3 and 4 years	1.5
Between 5 and 6 years	2
More than 6 years	2.5

• If life of assets is other than above mentioned years, Calci displays an error message.

Examples

Consider the following example that shows the use of AMORDEGRC function:

2400
8/19/2010
12/31/2014
350
2
25%
1

=AMORDEGRC(A1,A2,A3,A4,A5,A6,A7) displays 564 as a result.
=AMORDEGRC(3600,DATE(2010,3,4),DATE(2012,3,4),750,1,20%,1) displays 1441 as a result.

Related Videos

AMORDEGRC

See Also

• AMORLINC
• ACCRINT

References

• Depreciation
• Day Count Basis

• List of Main Z Functions

• Z3 home