Manuals/calci/AMORDEGRC
AMORDEGRC(C, DP, FP, salvage, P, R, basis)
Where 'C' is the cost of the asset, 'DP' is the date of the purchase of the asset, 'FP' is the date of the end of the first period, 'Salvage' is the salvage value, 'P' is the period, 'R' is the rate of depreciation and 'basis' is the year basis to be used.
This function identifies the depreciation for each accounting period.
- This function will return the depreciation until the last period of the life of the assets or until the cumulated value of depreciation is greater than the cost of the assets minus the salvage value. The depreciation coefficients are:
|
Life of assets |
Depreciation coefficient |
|---|---|
|
Between 3 and 4 years |
1.5 |
|
Between 5 and 6 years |
2 |
|
More than 6 years |
2.5 |
AMORDEGRC
Lets see an example,
AMORDEGRC(C, DP, FP, salvage, P, R, basis)
B
2400
8/19/2010
12/31/2010
350
2
25%
1
=AMORDEGRC(B2,B3,B4,B5,B6,B7,B8) is 484.5
Syntax
Remarks
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 2400 | |||
| Row2 | 8/19/2010 | |||
| Row3 | 12/31/2010 | 484.5 | ||
| Row4 | 350 | |||
| Row5 | 2 | |||
| Row6 | 25% | |||
| Row7 | 1 |
