Depreciation

Depreciation is a bookkeeping entry in a company's accounts that expenses the write down of the value of the asset over its useful life.

Excel contains several functions for calculating depreciation.

SLN Straight line accounting.
SYD Sum of digits.
DB Declining Balance.
DDB Double declining balance
VDB Declining balance allowing a switch to straight line at an optimum point.

Use Asset Register PRO for maintaining a monthly and annual register of assets, their depreciation and book values to any month end.

In Asset Register PRO, the month end is adjustable backwards and forwards for forecasting and checking prior values.