Depreciation Formulas

Depreciation Formulas:

Depreciation functions in Excel

Excel provides the following depreciation formulas. They are also listed under Financial Functions :

SLN - Straight Line

DB - Fixed Declining Balance

DDB - Double Declining Balance

SYD - Sum of Years' Digits

VDB - Double Declining Balance for Partial Periods

AMORLINC - Deprecitation Method for the French Accounting System

AMORDEGRC - Deprecitation Method for the French Accounting System Using a Coeffecient

Summary

Excel provides functions for calculation some of the basic depreciation formulas used in accounting.