# Sum of Years Depreciation Calculator

## What does it do?

This sum of years depreciation calculator can be used to provide the sum of the years digits depreciation expense for any period in the useful life of an asset up to a maximum of 600 periods.

The calculator will also produce a depreciation schedule setting out for each period, the beginning asset book value, the depreciation expense for the period, and the ending asset book value.

## Instructions

The Excel sum of years depreciation calculator, available for download below, is used to produce an asset depreciation schedule by entering details relating to the cost of the asset, the asset salvage value at the end of its useful life, and the number of periods in the useful lifetime.

The sum of years depreciation calculator is used as follows:

### Step 1

Enter the cost of the asset.

### Step 2

Enter the salvage value. This is the estimated salvage value of the asset at the end of its useful life.

### Step 3

Enter the useful life. This is the estimated number of periods in the useful life of the asset. A period can be any term (month, year etc). The depreciation expense will be calculated for this period. For example is an asset has a 4 year life and the useful life is entered as 4 then the depreciation will be for each year, if the useful life is entered as 48 months, then the depreciation expense will be calculated for each month.

### Step 4

Enter the period for which the sum of the years digits depreciation expense is required. For example, if the depreciation expense for period 11 is required enter 11.

### Step 5

The sum of years depreciation calculator works out the depreciation expense for the period entered in step 4.

In addition, the calculator provides a sum of the years digits depreciation schedule setting out for each period, the beginning asset book value, the depreciation expense for the period, and the ending asset book value.