How to calculate depreciation on fixed assets in excel?

Open in App

Solution

Depreciation can be calculated on fixed assets in excel by:

For straight-line depreciation method: =SLN (cost, salvage, life).

For the sum of years digits depreciation method: =SYD(cost, salvage, life).

For declining balance depreciation method: =DB(cost, salvage, life, period[month]).

For double declining depreciation method: =DDB(cost, salvage, life, period [factor]).

For units of production depreciation method: =((cost-salvage)/useful life in units) *units produced in the year.

Also see:

Difference Between Assets and Liabilities

What Are Non Current Assets?

Suggest Corrections

Similar questions

Depreciation of fixed capital assets refers to :

Depreciation on fixed assets is _________.

A company has to disclose depreciation provided on fixed assets and amortization of intangible assets under ___

Join BYJU'S Learning Program