![]() The first four ( cost, salvage, life, and period) are required and the same as used in the DB function. The DDB function is used for calculating double- declining- balance depreciation (or some other factor of declining- balance depreciation) and contains five arguments. If it is left blank, Excel will assume there were 12 months in the first year. The optional argument, month, refers to the number of months in the first year. As with per in the SYD function, the unit used for the period must be the same as the unit used for the life e.g., years, months, etc. Period is required and represents the period to calculate the depreciation. ![]() The first four arguments are required, and the last one is optional. The DB function is used for calculating fixed declining- balance depreciation and contains five arguments: cost, salvage, life, period, and month. The unit used for the period must be the same as the unit used for the life e.g., years, months, etc. The syntax is =SYD(cost, salvage, life, per) with per defined as the period to calculate the depreciation. The SYD function calculates the sum- of- years' digits depreciation and adds a fourth required argument, per. Those three arguments are the only ones used by the SLN function, which calculates straight- line depreciation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |