Expression Language Reference
    Preparing search index...
    • Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.

      Category: Financial

      Parameters

      • cost: any

        The initial cost of the asset.

      • salvage: any

        The value at the end of the depreciation (sometimes called the salvage value of the asset). This value can be 0.

      • life: any

        The number of periods over which the asset is being depreciated (sometimes called the useful life of the asset).

      • period: any

        The period for which you want to calculate the depreciation. Period must use the same units as life.

      • factor: any

        Optional. The rate at which the balance declines. If factor is omitted, it is assumed to be 2 (the double-declining balance method).

      Returns number | Error