Manuals/calci/DB - Revision history

Devika at 22:04, 22 August 2018

2018-08-22T22:04:55Z

Devika at 20:36, 23 July 2018

2018-07-23T20:36:34Z

Devika at 20:35, 23 July 2018

2018-07-23T20:35:54Z

Swapna at 10:57, 17 March 2017

2017-03-17T10:57:04Z

Swapna at 10:56, 15 March 2017

2017-03-15T10:56:36Z

Swapna: Created page with "=DB(C, Salvage, L, P, NoMonths)= Where * $C$ is the initial cost of an asset, * $Salvage$ is the value at the end of depreciation, * $L$ is lif..."

2017-03-15T10:50:53Z

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..."

New page

=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 ]]

@@ Line 6: / Line 6: @@
 *<math>Period</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(), returns the depreciation of an asset for a specified period by using the fixed-declining balance method.
 == Description ==

← Older revision		Revision as of 20:36, 23 July 2018
Line 1:		Line 1:
−	~~=DB(C, Salvage, L, P, NoMonths)=~~
	<div style="font-size:30px">'''DB (Cost,Salvage,Life,Period,NoMonths)'''</div><br/>		<div style="font-size:30px">'''DB (Cost,Salvage,Life,Period,NoMonths)'''</div><br/>
	Where		Where

@@ Line 1: / Line 1: @@
 =DB(C, Salvage, L, P, NoMonths)=
+<div style="font-size:30px">'''DB (Cost,Salvage,Life,Period,NoMonths)'''</div><br/>
 Where
-*<math>C</math> is the initial cost of an asset,
+*<math>Cost</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>Life</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>Period</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.
+DB(), returns the depreciation of an asset for a specified period by using the fixed-declining balance method.
 == Description ==
-DB(C, Salvage, L, P, NoMonths)
+DB (Cost,Salvage,Life,Period,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> &lt;0, Calci displays #N/A error message.
-*If <math>C</math> ,<math>L</math>, <math>P</math>, <math>NoMonths</math> &lt;=0, Calci displays #N/A error message.
+*If <math>Cost</math> ,<math>L</math>, <math>P</math>, <math>NoMonths</math> &lt;=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).
+*If <math>Period</math> is not an integer, Calci rounds up the value (e.g. 4.2 is rounded up to 5).
 == Examples ==

@@ Line 29: / Line 29: @@
 ==Related Videos==
-{{#ev:youtube|BDMdn7VPYEY|280|center|Double Declining Balance Method}}
+{{#ev:youtube|szRp_ErgmR8|280|center|Fixed Declining Balance Method}}
 == See Also ==
-*[[Manuals/calci/db | DB]]
+*[[Manuals/calci/DDB | DDB]]
 == References ==