Doug has attended:
Excel Intermediate course
Excel Advanced course
Depreciation
which functions calculate depreciation please
RE: 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
