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 on fixed assets is _________.

tangible asset

2011-12 9,00,000

2010-11 8,00,000

adjustment :

depreciation charged on tangible asset during the year amounted to Rs 3,00,000

how to calculate this ?? is there a need to prepare fixed asset a/c ?? if no then how to do this without fxed asset a/c ?

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

Join BYJU'S Learning Program