Download Depreciation Calculator template Excel Template

Contents

Popular Categories in Excel Template
Trednding in Excel Template

Price Quotation Format

A Price Quote, Sales Quote, or Service Quote can be legally binding agreement between a vendor and a …

Read More

Credit card payment calculator

Our new Credit Card Payment Calculator will help you calculate your minimum payment and estimate how long …

Read More

GST Invoice

With the implementation of Goods and Services Tax from 1st July 2017, as every register …

Read More

2021 Monthly Calendar Landscape

We all have different strengths, and while some of us flow through computer task with …

Read More
Search
Generic filters

Depreciation Calculator is an 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 Diminishing Balance method.

Straight Line Depreciation means:

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

Diminishing Balance Depreciation means:

Similarly “The declining balance method reduces an asset’s value by the amount it is depreciated in the previous years. It calculates the new depreciation base on that lower value. Hence, it is named as 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 for both the methods.

Contents of Depreciation Calculator Excel Template

Above all this template consists of 2 method: Straight-Line Depreciation Calculation and Diminishing Balance Depreciation Calculation.

Straight-Line Depreciation formula

In addition, the template calculates the straight-line depreciation. It’s calculation is based on Asset value, scrap value and life of an asset.

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

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

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

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

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

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

Diminishing Balance Depreciation formula

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 asset. In Diminishing Method, the scrap value will never 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. However it uses the rate of depreciation on closing asset value of the asset.

Book Value of Each Year X Depreciation Rate

It calculates the depreciation until the scrap value amount.

Download Depreciation Calculator template Excel Template

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download Depreciation Calculator template Excel Template

Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: