Use the DDB function to calculate double-declining balance method
The DDB function returns the depreciation of an asset for a specified period, using the double-declining balance method or some other method that can be specified.
DDB(cost, salvage, life, period, factor)
cost: The asset’s initial cost.
salvage: The value of the asset at the end of the depreciation.
life: The number of periods over which the asset is being [...]
How to Use the SYD function to calculate depreciation in Excel
In this tip, we calculate the depreciation of an investment. To do so, use the SYD function, which returns the sum-of-years’ digits depreciation of an asset for a specified period. Here is the syntax that is used:
SYD(cost, salvage, life, per)
cost: The asset’s initial cost.
salvage: The value of the asset at the end of the deprecation.
life: [...]
