Manuals/calci/DDB - Revision history

Devika: /* Related Videos */

2018-11-15T20:48:30Z

Devika at 22:06, 22 August 2018

2018-08-22T22:06:06Z

Devika at 21:41, 23 July 2018

2018-07-23T21:41:57Z

Devika at 21:41, 23 July 2018

2018-07-23T21:41:28Z

Jayaram at 10:47, 14 March 2017

2017-03-14T10:47:34Z

Swapna: /* See Also */

2015-05-13T18:27:04Z

Swapna at 18:25, 13 May 2015

2015-05-13T18:25:48Z

Swapna: /* Examples */

2014-07-30T20:43:15Z

Examples

Swapna: /* See Also */

2014-02-25T22:22:29Z

Swapna at 22:21, 25 February 2014

2014-02-25T22:21:22Z

Show changes

@@ Line 60: / Line 60: @@
 ==Related Videos==
-{{#ev:youtube|BDMdn7VPYEY|280|center|Double Declining Balance Method}}
+{{#ev:youtube|v=jXqU8EZjdS8|280|center|Double Declining Balance Method}}
 == See Also ==

@@ Line 7: / Line 7: @@
 *<math>Period</math> is the period for which depreciation is to be calculated, and
 *<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.
 == Description ==

← Older revision		Revision as of 21:41, 23 July 2018
Line 1:		Line 1:
−	~~=DDB(C, Salvage, L, P, F)=~~
	<div style="font-size:30px">'''DDB (Cost,Salvage,Life,Period,Factor)'''</div><br/>		<div style="font-size:30px">'''DDB (Cost,Salvage,Life,Period,Factor)'''</div><br/>

@@ Line 1: / Line 1: @@
 =DDB(C, Salvage, L, P, F)=
 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>F</math> is the rate factor at which the balance declines.
+*<math>Factor</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.
+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(C, Salvage, L, P, F)
+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 <math>Salvage</math> &lt;0, Calci displays #N/A error message.
-*If <math>C</math> ,<math>L</math>, <math>P</math>, <math>F</math> &lt;=0, Calci displays #N/A error message.
+*If <math>Cost</math> ,<math>Life</math>, <math>Period</math>, <math>Factor</math> &lt;=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).
+*Argument <math>Factor</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).
+*If <math>Period</math> is not an integer, Calci rounds up the value (e.g. 4.2 is rounded up to 5).
 == Examples ==

← Older revision		Revision as of 10:47, 14 March 2017
Line 71:		Line 71:
	*[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 ]]

@@ Line 65: / Line 65: @@
 == See Also ==
-*[[Manuals/calci/db | db]]
+*[[Manuals/calci/db | DB]]
 == References ==

@@ Line 58: / Line 58: @@
   =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 '''1338.5030444492834''' as a result.
 == See Also ==