Difference between revisions of "Manuals/calci/AMORDEGRC"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''AMORDEGRC'''</font><font size="2">(</font><font ...") |
(No difference)
|
Revision as of 21:29, 24 October 2013
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 |