The straight line method of calculating depreciation assumes that the value of an asset drops linearly and is the most common method of calculating depreciation in the UK. In our example, we will assume that a company has bought a machine which cost £50,000, has a salvage value of £6,000 and an expected useful life of 10 years. The expected useful life is an estimate of the economic life of the machine while the salvage value is an estimate of the resale value of the machine at the end of its economic life. We can build a depreciation schedule to show the value of the asset over its useful life – this is reflected by the net carrying value column.
How To Calculate Depreciation Using The Reducing Balance Method In Excel:
https://youtu.be/YSppH87CGsc
How To Calculate Running Total Using Cumulative SUM In Excel:
https://youtu.be/TAS9h7iEKZM
Subscribe for weekly Excel tutorials, techniques and examples:
https://www.youtube.com/channel/UCgdRm6hepAn6Y0FqMZPLiAw?sub_confirmation1
Please share this video with others that may find it useful:
https://youtu.be/CUgH8bkr-CA
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
The Excel Hub website: https://theexcelhub.com/
Instagram: https://www.instagram.com/theexcelhub/
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]Overview: (0:00)
Build A Depreciation Table: (0:44)
Depreciation Formula: (3:32)