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

    This function calculates the depreciation for an accounting period, taking into account prorated depreciation.

    Syntax

    AMORLINC(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 differs from AMORDEGRC, which applies 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

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