For a number of tasks and uses, including financial analysis to sales forecast, Excel will continue to be a crucial tool for enterprises. For instance, you can calculate your car depreciation by using an Excel workbook. So today we will learn how to use **formula to calculate car depreciation in Excel**.

**Table of Contents**hide

## Download Practice Workbook

You can download and practice the dataset that we have used to prepare this article.

## What Is Depreciation?

**Depreciation** is an accounting method for distributing the cost over the course of an asset’s useful life. In financial accounting, the “Purchased Value” must be subtracted from the utility value that has been used.

Before diving into today’s topic, let’s look at the definition that is provided below for your better understanding.

**Cost of Asset:**Actual cost of acquiring an asset, after taking into account all direct costs.**Salvage Value:**Salvage value is the anticipated marketable value of an item at the end of its useful life, often referred to as Residual Value.**Useful Life of Asset:**the duration of time that the asset is used. When the asset’s useful life is up, all of its value is lost.

## 3 Methods to Calculate Car Depreciation in Excel

Let’s assume we have a dataset, namely **“ Car Depreciation Tally for North East Builders”. **You can use any dataset suitable for you.

Here, we have used the **Microsoft Excel 365 **version; you may use any other version according to your convenience.

### 1. Applying Straight Line Depreciation Method

In **straight line depreciation method**, the value of the asset will be reduced over the period of useful life linearly and will end up having its salvage value.

Thus the depreciation value can be formulated as follows:

**Depreciation Per year=(Cost of Asset-Salvage Value)/ Useful life of Asset**

📌

**:**

__Steps__- Type the following formula in cell
**C11**.

**
**

`=(C7-C9)/C8`

- Now see the output as given below.

**Read More: ****How to Use SLM Method of Depreciation Formula in Excel**

### 2. Employing Activity Depreciation Method

The **activity depreciation method** aka unit of activity depreciation method is a unique way to calculate the depreciated value of an asset, as it does not depend on its passage of time (such as years) rather than the asset’s usage.

📌 ** Steps**:

- To calculate the cart depreciation we have chosen the following dataset as provided below.

- Now enter the following formula in the
**C15**cell.

**
**

`=((C7-C9)/C10)*C11`

Here,** C7**, **C9**, **C10,** and **C11** refer to the **Initial Cost of the Car**, **Salvage Value**,** Predicted** **Service Value,** and **Service Value in First Year **respectively.

- Press
**ENTER**to see the output as given below.

- Again enter the following formula in the
**D15**cell.

**
**

`=((C7-C9)/C10)*C12`

Here,** C7**, **C9**, **C10,** and **C12** refer to the **Initial Cost of the Car**, **Salvage Value**,** Predicted** **Service Value,** and **Service Value in First Year **respectively.

- Then, press
**ENTER**to see the output.

**Read More: ****How to Create Vehicle Depreciation Calculator in Excel**

**Similar Readings**

**How to Create Monthly Depreciation Schedule in Excel****Calculate Sum of Years Digits Depreciation with Formula in Excel****How to Use MACRS Depreciation Formula in Excel (8 Methods)**

### 3. Utilizing Double Declining Balance Method

The** double declining depreciation balance method** works by multiplying the value of the straight line depreciation value twice. So now the question is why we need to use this type of method when a straight line depreciation method can do the job.

Well, the DDB depreciation method fits for those assets whose value depreciates rapidly during the first few years of their life span. Although it may also apply to company assets like electronic gadgets, mobile, cameras, etc. However, this is more usually the case for items like vehicles, motors, generators, etc.

📌 ** Steps**:

- To begin with this method, write the following formula in cell
**C10**.

`=1/C8`

- Hit
**ENTER**to see the output.

- Now enter the following formula in cell
**C13**.

`=2*C7*C10`

- Press on the
**ENTER**button afterward.

- Now do the same to cell no
**D13**also.

`=(C7-C13)*2*C10 `

- See the output as given below.

**Read More: ****How to Apply Declining Balance Depreciation Formula in Excel**

## How to Calculate Accumulated Depreciation in Excel

**Accumulated depreciation** describes the aggregated depreciation over a period of time. To begin with this method, first look at the dataset as we provided below.

📌 ** Steps**:

- As the depreciation in the first year is zero, therefore write
**0**in the**D10**cell.

- Now, type the following formula in cell
**D11**.

`=($E$5-$E$6)/$E$7 `

Here, **D5 **and **D6 **cells represent the** “ Initial Cost of the Asset”** and

**“**respectively.

*Salvage Value*”- Press
**ENTER**to get the output for**2017.**

It is worth mentioning that here dollar sign ($) also known as **absolute reference** is used to lock the **E5**, **E6 **and** E7 **cells as those cell values will be required to calculate the value for years ** 2018** to

**as well. If you want to make this process more shortcut, press the**

*2024***F4**key after selecting the cell.

- To get the other values, drag the
**Fill Handle**tool from**D11**to**D18**.

- Now to calculate
**Accumulated Depreciation**, first thing first, type**0**as the initiator in the**E10**cell. - Enter the following formula in cell
**E11**.

` =E10+D11`

- Then, hit the
**ENTER**button afterward.

- Now drag down the
**Fill Handle**tool to get the other value.

- The last step of this method is to calculate
**Depreciated Asset Value**. First of all, enter**$15,000**in the**F10**cell as the initial asset value is**$15,000.** - Then, simply enter the following formula in cell
**F11**.

`=$F$10-E11`

Here **F10** and **E11** cells stand for **“Depreciated Asset Value”** and **“Accumulated Depreciation”** respectively.

- Press the
**ENTER**button to see the result.

- Drag down the
**Fill Handle**tool from**F11**to**F18**to get the other output.

**Read More: ****How to Create Fixed Asset Depreciation Calculator in Excel**

## Practice Section

To practice those formula to calculate car depreciation in Excel, We have provided a** Practice** section on the right side of each sheet. Please make sure to do it yourself.

## Conclusion

In this article, we have discussed how to use **formula to calculate car depreciation in Excel.** As you have already understood, there are plenty of ways to do this task. So before going through a specific method, ensure the method you choose aligns with your work. Further, If you have any queries, feel free to comment below and we will get back to you soon. Also, you may follow our website, **ExcelDemy**, a one-stop Excel solution provider to explore more.