Now we are going to learn all about formulas and functions. This is the best way to learn them:
Returns the depreciation for each accounting period. This function is provided for the French accounting system. If an asset is purchased in the middle of the accounting period; the prorated depreciation is taken into account. The function is similar to AMORLINC; except that a depreciation coefficient is applied in the calculation depending on the life of the assets.
AMORDEGRC(cost; date_purchased; first_period; salvage; period; rate; [basis])
The AMORDEGRC function syntax has the following arguments:
- Cost Required. The cost of the asset.
- Date_purchased Required. The date of the purchase of the asset.
- First_period Required. The date of the end of the first period.
- Salvage Required. The salvage value at the end of the life of the asset.
- Period Required. The period.
- Rate Required. The rate of depreciation.
- Basis Optional. The year basis to be used.
BASIS DATE SYSTEM 0 or omitted 360 days (NASD method) 1 Actual 3 365 days in a year 4 360 days in a year (European method)
- Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default; January 1; 1900 is serial number 1; and January 1; 2008 is serial number 39448 because it is 39;448 days after January 1; 1900.
- The depreciation coefficients are:
|LIFE OF ASSETS (1/RATE)||DEPRECIATION COEFFICIENT|
|Between 3 and 4 years||1.5|
|Between 5 and 6 years||2|
|More than 6 years||2.5|
- The depreciation rate will grow to 50 percent for the period preceding the last period and will grow to 100 percent for the last period.
- If the life of assets is between 0 (zero) and 1; 1 and 2; 2 and 3; or 4 and 5; the #NUM! error value is returned.