writer
2,661
edits
Changes
Jump to navigation
Jump to search
Created page with "=DB(C, Salvage, L, P, NoMonths)= Where *<math>C</math> is the initial cost of an asset, *<math>Salvage</math> is the value at the end of depreciation, *<math>L</math> is lif..."
=DB(C, Salvage, L, P, NoMonths)=
Where
*<math>C</math> is the initial cost of an asset,
*<math>Salvage</math> is the value at the end of depreciation,
*<math>L</math> is life of an asset that indicates the number of periods over which the asset is being depreciated,
*<math>P</math> is the period for which depreciation is to be calculated, and
*<math>NoMonths</math> specifies how many months of the year are used in the calculation of the first period of depreciation.
DB() calculates the depreciation of an asset for a specified period using the fixed-declining method.
== Description ==
DDB(C, Salvage, L, P, NoMonths)
*Depreciation is the decrease in value of assets. Depreciation of an asset is highest in the first period and decreases in successive periods.
*DB() calculates the depreciation using the fixed-declining balance method.
*If <math>Salvage</math> <0, Calci displays #N/A error message.
*If <math>C</math> ,<math>L</math>, <math>P</math>, <math>F</math> <=0, Calci displays #N/A error message.
*If <math>P</math> is not an integer, Calci rounds up the value (e.g. 4.2 is rounded up to 5).
== Examples ==
1. =DB(20000,2000,5,4.5,2) : Displays '''1338.5030444492834''' as a result.
2. =DB(10000,1000,5,1,6) : Displays '''1338.5030444492834''' as a result.
==Related Videos==
{{#ev:youtube|BDMdn7VPYEY|280|center|Double Declining Balance Method}}
== See Also ==
*[[Manuals/calci/db | DB]]
== References ==
*[http://en.wikipedia.org/wiki/Depreciation Depreciation]
*[http://en.wikipedia.org/wiki/Accelerated_depreciation Accelerated Depreciation]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]
Where
*<math>C</math> is the initial cost of an asset,
*<math>Salvage</math> is the value at the end of depreciation,
*<math>L</math> is life of an asset that indicates the number of periods over which the asset is being depreciated,
*<math>P</math> is the period for which depreciation is to be calculated, and
*<math>NoMonths</math> specifies how many months of the year are used in the calculation of the first period of depreciation.
DB() calculates the depreciation of an asset for a specified period using the fixed-declining method.
== Description ==
DDB(C, Salvage, L, P, NoMonths)
*Depreciation is the decrease in value of assets. Depreciation of an asset is highest in the first period and decreases in successive periods.
*DB() calculates the depreciation using the fixed-declining balance method.
*If <math>Salvage</math> <0, Calci displays #N/A error message.
*If <math>C</math> ,<math>L</math>, <math>P</math>, <math>F</math> <=0, Calci displays #N/A error message.
*If <math>P</math> is not an integer, Calci rounds up the value (e.g. 4.2 is rounded up to 5).
== Examples ==
1. =DB(20000,2000,5,4.5,2) : Displays '''1338.5030444492834''' as a result.
2. =DB(10000,1000,5,1,6) : Displays '''1338.5030444492834''' as a result.
==Related Videos==
{{#ev:youtube|BDMdn7VPYEY|280|center|Double Declining Balance Method}}
== See Also ==
*[[Manuals/calci/db | DB]]
== References ==
*[http://en.wikipedia.org/wiki/Depreciation Depreciation]
*[http://en.wikipedia.org/wiki/Accelerated_depreciation Accelerated Depreciation]
*[[Z_API_Functions | List of Main Z Functions]]
*[[ Z3 | Z3 home ]]