Depreciation Schedule Calculator Excel Download

A type of expense that is actually can not ignore, and this is none other than depreciation. Depreciation Schedule Calculator Excel is now available which can download in a single click.

Specifically, there are various methods available to calculate depreciation and templates are now available to give the choice to you which one you want to pick for your company assets!

Depreciation Schedule Calculator Excel

“Depreciation is something that you can get a deduction for in the current year even though you might not have spent money to buy it in that year. For instance, you bought a computer system in 2017 for $5,000. “(according to Jean Murray in his blog, how depreciation benefits your business published on”.

In all honesty, some of the best methods adopted by companies to avoid the entire tax amount faced by them using depreciation. As explained above it is actually a method of substituting the total cost of the asset over its useful life.

Components of Depreciation Schedule Template

If you are able to learn the format of the template, you are able to use it smartly. Go through the components of the template before downloading it:

Depreciation schedule

This part of the template is further separated into various sections:

Date acquired

Enter the date when the asset actually becomes part of your company. enter the date.

Item/ description

Enter the name of the asset or list its description here. You need to enter the item along with the acquired data. This may include, computers, furniture, telephone system, machinery, or others. You can enter yours!

Enter the cost of an item

Start entering the cost of the item or asset which is listed in the previous column. Go through it twice as depreciation expense is actually dependent on this cost.

Depreciation years

Enter the number of years which are actually the useful life of the asset. Enter the number here. It is dependent on the asset.

Per year

Start adding the cost of depreciation per year for the specific asset here. You need to use the formula of the total cost of the asset divided by its useful life. It is also the depreciation method that may change costs here.

Per month

Divide the depreciation cost per year with the 12 and you will be able to get the depreciation expense amount per month.


The total cost for each of the columns is calculated and shows at the end. Don’t forget to go through the formulas once before you are using them on a calculation basis. This expense amount can then be taken further!

Straight Line Depreciation Excel Example

  1. Purchase cost of $60,000 – estimated salvage value of $10,000 = Depreciable asset cost of $50,000
  2. 1 / 5-year useful life = 20% depreciation rate per year
  3. 20% depreciation rate x $50,000 depreciable asset cost = $10,000 annual depreciation

David Halls

David Halls is a professional Digital Marketing Strategist, Blogger, and SEO Specialist. I love to Write about Excel Spreadsheet Templates.

One thought on “Depreciation Schedule Calculator Excel Download

Leave a Reply

Your email address will not be published.