Difference between revisions of "Manuals/calci/DDB"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif">'''<font size="2">DDB(C ,salvage, L, P, F)</font>'''</font></font>...") |
|||
| Line 1: | Line 1: | ||
| − | + | =DDB(C, Salvage, L, P, F)= | |
| − | < | + | 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>F</math> is the rate factor at which the balance declines. | ||
| − | + | DDB() calculates the depreciation of an asset for a specified period using the double-declining method or any other specified method. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | == Description == | |
| − | + | DDB(C, Salvage, L, P, F) | |
| − | </ | + | *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 <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. | ||
| + | *Argument <math>F</math> is optional. If omitted, Calci assumes it to be 2 (double-declining balance method). | ||
| + | *If <math>P</math> 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: | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| + | | class=" " | 200,000 | ||
| + | | class=" " | 10,000 | ||
| class=" " | | | class=" " | | ||
| − | + | ||
| − | |||
| − | |||
| − | |||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | | class=" | + | | class="sshl_f" | 1000 |
| − | + | | class=" " | 100 | |
| − | |||
| − | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | + | | class=" " | 5 | |
| − | + | | class=" " | 10 | |
| − | | class=" " | | ||
| − | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="odd" | |- class="odd" | ||
| − | + | | class=" " | 1 | |
| − | + | | class=" " | 1 | |
| − | | class=" " | | ||
| − | | class=" " | | ||
| class=" " | | | class=" " | | ||
| + | |||
|- class="even" | |- class="even" | ||
| − | + | | class=" " | 1.5 | |
| − | | class=" | + | | class=" " | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class=" " | | ||
| class=" " | | | class=" " | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
| − | < | + | =DDB(A1,A2,A3,A4) : Calculates the depreciation for the values in the range A1 to A4. <br />'F' is assumed to be 2. <br />Displays '''80000''' as a result. |
| − | + | =DDB(A1,A2,A3,A4,A5) : Calculates the depreciation for the values in the range A1 to A5. <br />Displays '''60000''' as a result. | |
| + | =DDB(B1,B2,B3,B4) : Calculates the depreciation for the values in the range B1 to B4. <br />'F' is assumed to be 2. Displays '''2000''' as a result. | ||
| + | =DDB(20000,2000,5,4.5,2) : Displays '''592''' as a result. | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/DB | DB]] | ||
| + | |||
| + | == References == | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Depreciation Depreciation] | ||
| + | *[http://en.wikipedia.org/wiki/Accelerated_depreciation Accelerated Depreciation] | ||
Revision as of 17:21, 25 February 2014
DDB(C, Salvage, L, P, F)
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.
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() calculates the depreciation of an asset for a specified period using the double-declining method or any other specified method.
Description
DDB(C, Salvage, L, P, F)
- 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 592 as a result.