microsoft+excel+training - Depreciation

Hi Doug,

Here are some different functions associated with depreciation. They return different calculations based on different inputs and different methods.

=SYD(cost,salvage,life,period) this calculates the sum of the years depreciation.

=SLN(cost,salvage,life) returns the "striaght-line" depreciation for one period

=DDB(cost,salvage,life,period,factor) returns depreciation using a double declining method.


=DB(cost,salvage,life,period,month) returns the depreciation based on a fixed-declining balance method.

If you go to the Function wizard under Insert>Function and select these functions you can get more details about them and see precisely what each argument means. If I can help you at all please let me know

Tracy