Skip to content

How to calculate depreciation using the straight line method in Excel

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to calculate depreciation using the straight line method in Excel

130,316 views October 25, 2012 6:29

Watch on YouTube

ChannelDinesh Kumar Takyar

Description from the creator

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday.
For details you can visit our website:
familycomputerclub.com
Depreciation is an important aspect in any business. Businesses calculate the depreciation of their assets, deduct the depreciation amount from their net incmome and then pay taxes on the final income after depreciation. We describe here the straight line method of depreciation calculation in Microsoft Excel.

About this tutorial

Dinesh Kumar Takyar published this 6:29 video tutorial on October 25, 2012. It has been watched 130,316 times on YouTube.

Channel: Dinesh Kumar Takyar
Category: Education
Duration: 6:29
Published: October 25, 2012
Views: 130,316
Likes: 573

Tags

depreciation calculation

Share

Further reading

SLN Function - Excel Formula for Straight Line Depreciation ... corporatefinanceinstitute.com
Example – Straight-line depreciation. Suppose we are given the following data and we need to calculate the depreciation using the straight-line method: Cost of the asset: $45,000; Salvage value (if any): $7,500; Useful…
How To Easily Calculate Straight Line Depreciation in Excel ... exceldatapro.com
Excel has the SLN Function, which calculates the Straight Line Depreciation for us. To calculate the depreciation you require only 3 amounts. The initial value of the asset, the estimated life of the asset and its write…
How Do I Calculate Fixed Asset Depreciation Using Excel? investopedia.com
To calculate the depreciation value using the straight-line basis, or straight-line method (SLN), Excel uses a built-in function, SLN, which takes the arguments: cost, salvage, and life.

This tutorial in other languages

Web Analytics