• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

Download Depreciation Calculator Excel Template

Download Depreciation Calculator Excel Template

Depreciation Calculator is a ready-to-use excel template to calculate Straight-Line as well as Diminishing Balance Depreciation on Tangible/Fixed Assets.

The template displays the depreciation rate for the straight-line method based on scrap value. Moreover, it displays the year on year amount of depreciation for as per the Diminishing Balance method.

Straight Line Depreciation means:

“Straight Line method depreciates an asset uniformly over the period of its usability. The Straight-line method of depreciation applies even cost throughout the life of the fixed asset.”

Diminishing Balance Depreciation means:

“The declining balance method reduces an asset’s value by the amount it depreciated in the previous years. It calculates the new depreciation based on that lower value. Hence, it is given the name as the diminishing balance method.”

Depreciation Calculator Excel Template

We have created a simple and easy Depreciation Calculator with predefined formulas. Just enter a few values and it will automatically calculate depreciation by both the methods.

Click here to download the Depreciation Calculator Excel Template.

Click here to Download All Accounting Excel Templates for ₹299.

You can also download other templates like Cash Flow Statement, Trial Balance and Profit and Loss Account.

Let us understand the contents of this template and how to use it.

Contents of Depreciation Calculator Excel Template

This template consists of 2 sections: Straight-Line Depreciation Calculation and Diminishing Balance Depreciation Calculation.

Straight-Line Depreciation Calculation

In this section, the template calculates the straight-line depreciation. It is calculated based on Asset value, scrap value and life of an asset.

Here, asset value is the asset price in addition to the additional costs associated with an asset. These costs include fixtures, transportation, insurance, etc.

Insert the Asset Cost and Additional Asset Cost in the given cells and it will automatically calculate the total Asset Price for you.

Enter the Scrap Value and Life Span for the asset and 0 if an asset is completely written off. When asset scrap value is 0 the template will calculate the depreciation on complete asset value.

Entering the above-mentioned details will give you the following results:

Depreciation/Year
Depreciation Percentage
Total Depreciation for the life span of the asset
Book Value after the life span of the asset

Depreciation Calculator

The balance amount is just for accuracy check. It should always be 0. It is the Scrap Value minus Book Value at the end of the life span.

Diminishing Balance Depreciation Calculation

Diminishing Balance Depreciation

Similar to the above section, enter Asset Cost and Additional Asset Cost to obtain total Asset Price. 

Enter the Scrap Value and Life Span of the asset. In Diminishing Method, the scrap value cannot be 0.

The template calculates the Rate of Depreciation applying the following formula:

1 – (Scrap Value/Asset Value) ^ (1/Life Span)

In the end, the template displays the depreciation schedule for the diminishing balance method. It uses the rate of depreciation on the closing asset value of the asset.

Diminishing Balance Depreciation

It calculates the depreciation using the below formula:

Book Value of Each Year X Depreciation Rate

It calculates the depreciation until the scrap value amount.

This template can be useful to the account professionals, assistants, and SME owners. ]

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. We will be more than happy to assist you.

« Download Asset Inventory Tracker Excel Template

Filed Under: Accounting Templates

You are Here: Home / Excel Templates / Accounting Templates / Download Depreciation Calculator Excel Template

About Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Accounting Templates

  • Accounts Payable Excel Template
  • Accounts Receivable Excel Template
  • Cash Book Excel Template
  • Invoice Excel Templates
  • Expense Report Excel Template
  • Petty Cash Book Excel Template
  • Inventory Management Excel Template
  • Billing Statement Excel Template
  • Purchase Return Book Excel Template
  • Accounts Payable With Aging Excel Template
  • Accounts Receivable With Aging Excel Template
  • Budget With Charts Excel Template
  • Checkbook Register Excel Template
  • Purchase Order Excel Template
  • Purchase Return Book With Tax Excel Template
  • Marketing Budget Excel Template
  • Asset Inventory Tracker Excel Template
  • Depreciation Calculator Excel Template

ExcelDataPro

Free Excel Pro Templates

  • Glossary
    • Accounting Glossary
    • HR & Payroll Glossary
    • Tax Glossary
  • Templates
    • Accounting
      • Financial Analysis
      • Financial Statement
    • Educational
    • Taxation
      • Federal Income Tax
      • GST
      • UAE VAT
      • UK VAT
    • Human Resources
      • HR & Payroll
      • HR Metrics
    • School Management
    • Social Media
    • Sales-Marketing
    • Personal Finance
    • Other
      • Health & Fitness
  • Functions
  • FAQ’s
  • Blog
  • Home
  • Contact
  • Privacy
  • Terms

© ExcelDataPro 2023. Content Licensed Under Creative Commons with Attribution Required

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT