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 ...") |
|||
Line 1: | Line 1: | ||
− | + | =AMORDEGRC(cost, DP, FP, salvage, period, rate, basis)= | |
− | < | + | *where, <math>cost</math> is the cost of the asset |
+ | *<math>DP</math> is the date of purchase of asset | ||
+ | *<math>FP</math> is the end of first period | ||
+ | <math>salvage</math> is the salvage value at the end of life of asset | ||
+ | <math>period</math> is the accounting period | ||
+ | *<math>rate</math> is the rate of depreciation | ||
+ | *<math>basis</math> is the year basis to be used | ||
− | + | AMORLINC() calculates the depreciation for each accounting period by applying depreciation coefficient. | |
− | |||
− | |||
− | |||
− | |||
− | + | == Description == | |
− | + | *The function calculates the decrease in value of asset for the mentioned period considering the depreciation coefficient depending on life of assets. This function is used in French accounting system. | |
− | + | *If <math>DP</math> > <math>FP</math>, Calci displays #N/A error message. | |
− | + | *If <math>rate</math> is <=0, Calci displays #N/A error message. | |
− | < | + | *If <math>period</math> 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: | |
− | + | ||
− | + | {| class="wikitable" | |
− | + | |- | |
− | | | + | ! 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: | ||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | !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: | |
− | |||
− | |||
− | < | + | <div id="2SpaceContent" class="zcontent" align="left"> |
− | + | {| id="TABLE3" class="SpreadSheet blue" | |
+ | |- class="even" | ||
+ | | class="sshl_f" | 2400 | ||
+ | | class=" " | | ||
+ | | class=" " | | ||
− | + | |- class="odd" | |
+ | | class="sshl_f" | 8/19/2010 | ||
+ | | class=" " | | ||
+ | | class=" " | | ||
− | + | |- class="even" | |
+ | | class="sshl_f" | 12/31/2014 | ||
+ | | class=" " | | ||
+ | | class=" " | | ||
− | + | |- class="odd" | |
+ | | class="sshl_f" | 350 | ||
+ | | class=" " | | ||
+ | | class=" " | | ||
− | + | |- class="even" | |
+ | | class="sshl_f" | 2 | ||
+ | | class=" " | | ||
+ | | class=" " | | ||
− | + | |- class="odd" | |
+ | | class="sshl_f" | 25% | ||
+ | | class=" " | | ||
+ | | class=" " | | ||
− | + | |- class="even" | |
− | + | | class="sshl_f" | 1 | |
− | + | | class=" " | | |
+ | | class=" " | | ||
+ | |} | ||
− | + | =AMORDEGRC(A1,A2,A3,A4,A5,A6,A7) ''displays 564'' as a result. | |
− | + | == See Also == | |
− | + | *[[Manuals/calci/AMORLINC | AMORLINC]] | |
− | + | *[[Manuals/calci/ACCRINT | ACCRINT]] | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | == References == | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | + | *[http://en.wikipedia.org/wiki/Depreciation Depreciation] | |
− | + | *[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis] |
Revision as of 07:19, 17 January 2014
AMORDEGRC(cost, DP, FP, salvage, period, rate, basis)
- where, is the cost of the asset
- is the date of purchase of asset
- is the end of first period
is the salvage value at the end of life of asset is the accounting period
- is the rate of depreciation
- is the year basis to be used
AMORLINC() calculates the depreciation for each accounting period by applying depreciation coefficient.
Description
- The function calculates the decrease in value of asset for the mentioned period considering the depreciation coefficient depending on life of assets. This function is used in French accounting system.
- If > , Calci displays #N/A error message.
- If is <=0, Calci displays #N/A error message.
- If 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.