How to calculate depreciation on fixed assets in excel? (2024)

Analysing Comparative Statement of Profit and Loss

How to calcul...

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?

See Also

A Guide to Property Depreciation and How Much You Can Save What Is Depreciation, and How Does it Work? - businessnewsdaily.com What is the accounting treatment for an asset that is fully depreciated, but continues to be used in a business? | AccountingCoach What is Depreciation?

Suggest Corrections

0

Similar questions

Q. The need for providing depreciation on fixed assets are ________.

Q. How change in market situations leads to depreciation in a fixed asset?

See Also

The causes of depreciation — AccountingTools

Q.

Depreciation on fixed assets is _________.

Q.

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 ?

Q.

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

View More

Join BYJU'S Learning Program

Related Videos

Comparative Financial Statement

ACCOUNTANCY

Watch in App

Explore more

Analysing Comparative Statement of Profit and Loss

Standard XII Accountancy

How to calculate depreciation on fixed assets in excel? (2024)

Top Articles

Profit-Taking: Definition, How It Works, Types, and Triggers

Making Your Mark on Aeternum: Player Housing

The Ultimate Guide to Skip the Games - Gamerant

Towerborne’s Belfry Aims to Be So Much More Than a Main Menu - Xbox Wire

Craigslist Farm And Garden Boone Nc

Spenga Charlottesville

Harley Davidson and the Marlboro Man im TV - Sendung - TV SPIELFILM

Harley-Davidson Unveils New Davidson Park In Milwaukee

9Xmovies Bigg Boss

Knoxville Daily Tribune from Knoxville, Tennessee

Die Filmstarts-Kritik zu 2 Fast 2 Furious

Aig Cyberedge Policy Wording

Latest Posts

European Commission - Employment, Social Affairs & Inclusion: Non-EU nationals

Can I drink tap water in Portugal? - EN

Article information

Author: Manual Maggio

Last Updated: 2024-07-04T10:47:35+07:00

Views: 6446

Rating: 4.9 / 5 (49 voted)

Reviews: 80% of readers found this page helpful

Author information

Name: Manual Maggio

Birthday: 1998-01-20

Address: 359 Kelvin Stream, Lake Eldonview, MT 33517-1242

Phone: +577037762465

Job: Product Hospitality Supervisor

Hobby: Gardening, Web surfing, Video gaming, Amateur radio, Flag Football, Reading, Table tennis

Introduction: My name is Manual Maggio, I am a thankful, tender, adventurous, delightful, fantastic, proud, graceful person who loves writing and wants to share my knowledge and understanding with you.