Straight Line Depreciation Calculator Tables
The straight line depreciation tables below act as a quick reference to help you calculate straight line depreciation for a month. The tables are based on the formula for straight line depreciation as follows:
This formula assumes that the salvage value of the asset is zero at the end of its useful life.
How to Calculate monthly straight line depreciation
As an example of calculating straight line depreciation using the tables, suppose a business purchased at asset for 25,000 with an estimated useful life of 5 years.
Using the formula shown above, we could calculate the depreciation as follows:
Cost = 25,000 Useful life = 5 years Straight line depreciation = Cost / Useful Life Straight line depreciation = 25,000 / 5 = 5,000 each year Monthly depreciation = 5,000 / 12 = 417 per month
However, to avoid having to carry out this calculation, the straight line depreciation calculator table below can be used.
If we look at the straight line depreciation tables row for the amount 25,000 and the column for years 5, then the value given by the table is 417, which is the same as in the calculation above.
Amounts can be combined to give the total amount of depreciation, for example if an asset costs 16,000 with a useful life of 4 years, the depreciation is calculated by taking the amount for 15,000 and the amount for 1,000 from the 4 years column, which is 313 + 21 = 334 per month.
Straight Line Depreciation Tables Guide and Key
- Years: Each column represents the useful life of the asset in years.
- Cost: Each row represents the cost of the fixed asset.
Our straight line depreciation schedule calculator is available to help you calculate the straight line depreciation of any asset by entering its cost, salvage value and depreciation rate.
About the Author
Chartered accountant Michael Brown is the founder and CEO of Double Entry Bookkeeping. He has worked as an accountant and consultant for more than 25 years in all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a BSc from Loughborough University.