## Straight Line Depreciation Schedule Calculator

The straight line method is one method of calculating the depreciation expense for an asset. This Excel calculator produces a straight line depreciation schedule setting out the beginning net book value, the depreciation expense, and the ending net book value of the asset based on a straight line depreciation rate.

## Declining Balance Depreciation Schedule Calculator

The declining balance method is one method of calculating the depreciation expense for an asset. This calculator produces as asset depreciation schedule setting out the beginning net book value, the depreciation expense, and the ending net book value of the asset based on a declining balance depreciation rate.

## Quiz 61: Declining Balance Method of Depreciation

Test your knowledge of bookkeeping and the use of the declining balance method for calculating depreciation with our online quiz.

## Quiz 60: Straight Line Method of Depreciation

Test your knowledge of bookkeeping and the use of the straight line method formula for calculating depreciation with our online quiz.

## Excel DB Function

The Excel DB function is one of many Excel financial functions, and can be used to calculate the declining balance depreciation of a long term asset. It has the syntax DB (cost, salvage, life, period, month).

## Excel DDB Function

The Excel DDB function is one of many Excel financial functions, and can be used to calculate the declining balance depreciation of a long term asset. It has the syntax DDB (cost, salvage, life, period, factor).

By setting the factor parameter to either one or two, the function can be used to calculate either the declining balance depreciation or the double declining balance depreciation.

## Half Year Convention Depreciation

The main purpose of the half year convention is to avoid having to track the dates of acquisition and disposal of an asset.

## Reducing Balance Depreciation Calculator

The reducing balance depreciation calculator is used to calculate the net book value and accumulated depreciation for an asset using the future value of a lump sum formula.

## Sum of Years Depreciation Calculator

This free sum of years depreciation calculator with depreciation schedule can be used for any asset with a maximum useful life of 600 periods. The calculator will wok our the depreciation for any period, and produce an asset depreciation schedule over the useful life.

## Excel SYD Function

The Excel SYD function is used to calculate the sum of the years digits depreciation for a given accounting period. It is based on an assets cost. salvage value, and useful life.

## Sum of the Years Digits Depreciation

The sum of the years digits depreciation method sometimes referred to as the SYD depreciation is an accelerated depreciation method used to produce a depreciation expense which is higher in the earlier years.