Depreciation Calculator

Video Tutorial How to Fill Out Depreciation Calculator

Thousands of positive reviews can’t be wrong

Read more or give pdfFiller a try to experience the benefits for yourself
4.0
I think it is great but I feel the UI needs to improve and that file selection s...
I think it is great but I feel the UI needs to improve and that file selection should be easier and quicker
Pieter van Z
5.0
A little difficult navigating initially.
A little difficult navigating initially. Unable to correct or remove check marks for some questions.
Joe B S
5.0
I can literally do everything!
I can literally do everything! This app has it all to be productive, I love it. I cannot live without it! Worth every penny.
Brandy R

Questions & answers

To calculate depreciation using a straight line basis, simply divide net price (purchase price less the salvage price) by the number of useful years of life the asset has.
The units-of-production method of depreciation does not have a built-in Excel function but is included here because it is a widely used method of depreciation and can be calculated using Excel. The formula is =((cost − salvage) / useful life in units) * units produced in period.
The four depreciation methods include straight-line, declining balance, sum-of-the-years' digits, and units of production.
You'll need three columns: The first column registers the depreciation deduction (aka depreciation expense) you plan to take each year. The second column shows the depreciation that has accumulated at the end of each year. The third column logs the book value of the asset at the end of each year.
Formula: Yearly Depreciation Value = (remaining lifespan / SYD) x (asset cost – salvage value).
Manually Calculating Depreciation Start by subtracting the asset's salvage value from its cost. Then, divide the remaining amount by the asset's useful life. This gives you the amount of depreciation to recognize for each period.