Toggle navigation
Contact Us
Home
For Accountants
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.