Difference between revisions of "Manuals/calci/db"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''DB'''(C, Salvage, L, P, M) where, '''C''' - the initial cost of the asset. '''Salvage''' - the value at t...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | =DB(C, Salvage, L, P, M)= | |
| − | + | 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>M</math> is the number of months in the first year. | ||
| − | + | DB() calculates the depreciation of an asset for a specified period. | |
| − | + | == Description == | |
| − | + | DB(C, Salvage, L, P, M) | |
| − | + | *Depreciation is the decrease in value of assets. | |
| + | *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>M</math> <=0, Calci displays #N/A error message. | ||
| + | *Argument <math>M</math> is optional. If omitted, Calci assumes it to be 12. | ||
| − | + | == Examples == | |
| − | + | Consider the following example that shows the use of DB 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=" | + | | class=" " | 200,000 |
| − | + | | class=" " | 1,000,000 | |
| − | + | | class=" " | | |
| − | | class=" | + | |
| − | | class=" | ||
| − | |||
|- class="odd" | |- class="odd" | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| class=" " | 1000 | | class=" " | 1000 | ||
| class=" " | 10000 | | class=" " | 10000 | ||
| − | | class=" | + | | class=" " | |
| − | + | ||
| − | |- class=" | + | |- class="even" |
| − | |||
| class=" " | 5 | | class=" " | 5 | ||
| class=" " | 2 | | class=" " | 2 | ||
| − | | class=" | + | | class=" " | |
| − | + | ||
| − | |- class=" | + | |- class="odd" |
| − | + | | class=" " | 1 | |
| − | | class=" | ||
| class=" " | 1 | | class=" " | 1 | ||
| − | | class=" | + | | class=" " | |
| − | + | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|- class="even" | |- class="even" | ||
| − | + | | class=" " | 6 | |
| − | + | | class=" " | 7 | |
| − | | class=" | + | | class=" " | |
| − | | class=" | ||
| − | | class=" | ||
|} | |} | ||
| − | + | =DB(A1,A2,A3,A4,A5) : Calculates the depreciation for the values in the range A1 to A5. Displays '''65300''' as a result. | |
| − | + | =DB(A1,A2,A3,A4) : Calculates the depreciation for the values in the range A1 to A4. <br />M is assumed to be 12.Displays '''130600''' as a result. | |
| + | =DB(B1,B2,B3,B4,B5) : Calculates the depreciation for the values in the range B1 to B5. <br />Displays '''525000''' as a result. | ||
| + | =DB(20000,2000,5,4.5,6) : Displays '''2396.28818079''' as a result. | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/DDB | DDB]] | ||
| + | |||
| + | == References == | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Depreciation Depreciation] | ||
Latest revision as of 15:02, 30 July 2014
DB(C, Salvage, L, P, M)
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 number of months in the first year.
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 number of months in the first year.DB() calculates the depreciation of an asset for a specified period.
Description
DB(C, Salvage, L, P, M)
- Depreciation is the decrease in value of assets.
- DB() calculates the depreciation using the fixed-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 12.
Examples
Consider the following example that shows the use of DB function:
| 200,000 | 1,000,000 | |
| 1000 | 10000 | |
| 5 | 2 | |
| 1 | 1 | |
| 6 | 7 |
=DB(A1,A2,A3,A4,A5) : Calculates the depreciation for the values in the range A1 to A5. Displays 65300 as a result. =DB(A1,A2,A3,A4) : Calculates the depreciation for the values in the range A1 to A4.
M is assumed to be 12.Displays 130600 as a result. =DB(B1,B2,B3,B4,B5) : Calculates the depreciation for the values in the range B1 to B5.
Displays 525000 as a result. =DB(20000,2000,5,4.5,6) : Displays 2396.28818079 as a result.