Difference between revisions of "Manuals/calci/DDB"
Jump to navigation
Jump to search
(4 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | =DDB( | + | <div style="font-size:30px">'''DDB (Cost,Salvage,Life,Period,Factor)'''</div><br/> |
Where | Where | ||
− | *<math> | + | *<math>Cost</math> is the initial cost of an asset, |
*<math>Salvage</math> is the value at the end of depreciation, | *<math>Salvage</math> is the value at the end of depreciation, | ||
− | *<math> | + | *<math>Life</math> is life of an asset that indicates the number of periods over which the asset is being depreciated, |
− | *<math> | + | *<math>Period</math> is the period for which depreciation is to be calculated, and |
− | *<math> | + | *<math>Factor</math> is the rate factor at which the balance declines. |
− | + | **DDB(), returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify. | |
− | DDB() | ||
== Description == | == Description == | ||
− | DDB( | + | DDB (Cost,Salvage,Life,Period,Factor) |
*Depreciation is the decrease in value of assets. Depreciation of an asset is highest in the first period and decreases in successive periods. | *Depreciation is the decrease in value of assets. Depreciation of an asset is highest in the first period and decreases in successive periods. | ||
*DDB() calculates the depreciation using the double-declining balance method. | *DDB() calculates the depreciation using the double-declining balance method. | ||
*If <math>Salvage</math> <0, Calci displays #N/A error message. | *If <math>Salvage</math> <0, Calci displays #N/A error message. | ||
− | *If <math> | + | *If <math>Cost</math> ,<math>Life</math>, <math>Period</math>, <math>Factor</math> <=0, Calci displays #N/A error message. |
− | *Argument <math> | + | *Argument <math>Factor</math> is optional. If omitted, Calci assumes it to be 2 (double-declining balance method). |
− | *If <math> | + | *If <math>Period</math> is not an integer, Calci rounds up the value (e.g. 4.2 is rounded up to 5). |
== Examples == | == Examples == | ||
Line 61: | Line 60: | ||
==Related Videos== | ==Related Videos== | ||
− | {{#ev:youtube| | + | {{#ev:youtube|v=jXqU8EZjdS8|280|center|Double Declining Balance Method}} |
== See Also == | == See Also == | ||
Line 71: | Line 70: | ||
*[http://en.wikipedia.org/wiki/Depreciation Depreciation] | *[http://en.wikipedia.org/wiki/Depreciation Depreciation] | ||
*[http://en.wikipedia.org/wiki/Accelerated_depreciation Accelerated Depreciation] | *[http://en.wikipedia.org/wiki/Accelerated_depreciation Accelerated Depreciation] | ||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | *[[ Z3 | Z3 home ]] |
Latest revision as of 15:48, 15 November 2018
DDB (Cost,Salvage,Life,Period,Factor)
Where
- is the initial cost of an asset,
- is the value at the end of depreciation,
- is life of an asset that indicates the number of periods over which the asset is being depreciated,
- is the period for which depreciation is to be calculated, and
- is the rate factor at which the balance declines.
- DDB(), returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify.
Description
DDB (Cost,Salvage,Life,Period,Factor)
- Depreciation is the decrease in value of assets. Depreciation of an asset is highest in the first period and decreases in successive periods.
- DDB() calculates the depreciation using the double-declining balance method.
- If <0, Calci displays #N/A error message.
- If ,, , <=0, Calci displays #N/A error message.
- Argument is optional. If omitted, Calci assumes it to be 2 (double-declining balance method).
- If is not an integer, Calci rounds up the value (e.g. 4.2 is rounded up to 5).
Examples
Consider the following example that shows the use of DDB function:
200,000 | 10,000 | |
1000 | 100 | |
5 | 10 | |
1 | 1 | |
1.5 |
=DDB(A1,A2,A3,A4) : Calculates the depreciation for the values in the range A1 to A4.
'F' is assumed to be 2.
Displays 80000 as a result. =DDB(A1,A2,A3,A4,A5) : Calculates the depreciation for the values in the range A1 to A5.
Displays 60000 as a result. =DDB(B1,B2,B3,B4) : Calculates the depreciation for the values in the range B1 to B4.
'F' is assumed to be 2. Displays 2000 as a result. =DDB(20000,2000,5,4.5,2) : Displays 1338.5030444492834 as a result.
Related Videos
See Also
References