SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / AMORDEGRC
In This Topic
    AMORDEGRC
    In This Topic

    This function returns the depreciation for an accounting period, taking into consideration prorated depreciation, and applies a depreciation coefficient in the calculation based on the life of the assets.

    Syntax

    AMORDEGRC(cost,datepurchased,firstperiod,salvage,period,drate,basis)

    Arguments

    This function has these arguments:

    Argument Description
    cost Cost of the asset
    datepurchased Purchase date of the asset
    firstperiod End date of the first period
    salvage Salvage value at the end of the life of the asset
    period Accounting period
    drate Rate of depreciation
    basis [Optional] Integer representing the basis for day count (Refer to Day Count Basis)

    Remarks

    This function returns the depreciation until the last period of the asset life or until the total 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

    The depreciation rate will grow to 50 percent for the period proceeding 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.

    This function differs from AMORLINC, which does not apply a depreciation coefficient in the calculation depending on the life of the assets.

    Data Types

    Accepts numeric and DateTime object data. Returns numeric data.

    Examples

    AMORDEGRC(B1,B2,B3,B4,B5,B6,B7)

    AMORDEGRC(2800,DATE(2003,9,4),DATE(2006,12,31),200,1,0.02,1) gives the result 117