Definition. This function calculates the depreciation amounts for an asset by using the geometric-degressive depreciation method, where part of a year (in complete months) is considered in the first depreciation period.
Purchase_Value (required) The purchase cost (net purchase price plus incidental purchase expenses minus reduction of purchase cost) of an asset. If you don’t use a value that can be evaluated as a number, the
#VALUE! error is displayed. If the entered number is negative, the
#NUMBER! error is displayed.
Salvage_Value (required) The value of
the asset at the end of the depreciation duration. If you don’t use a number, the
#VALUE! error is displayed. If the entered ...