7 functions for this use case · out of 12 defined
Returns the sum-of-years' digits depreciation of an asset for a specified period.
Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify.
Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. VDB stands for variable declining balance.
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.
Returns the straight-line depreciation of an asset for one period.
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.