Manuals/calci/AMORLINC - Revision history

Devika: /* Related Videos */

2018-11-15T20:22:46Z

Devika: /* Related Videos */

2018-11-15T20:22:29Z

Devika at 21:54, 22 August 2018

2018-08-22T21:54:54Z

Devika at 22:18, 19 July 2018

2018-07-19T22:18:26Z

Devika at 22:53, 13 July 2018

2018-07-13T22:53:22Z

Jayaram at 10:45, 14 March 2017

2017-03-14T10:45:25Z

Swapna at 18:12, 28 April 2015

2015-04-28T18:12:52Z

Swapna at 22:25, 3 January 2014

2014-01-03T22:25:55Z

Swapna at 00:25, 3 January 2014

2014-01-03T00:25:47Z

Swapna at 00:19, 3 January 2014

2014-01-03T00:19:22Z

Show changes

← Older revision		Revision as of 20:22, 15 November 2018
Line 82:		Line 82:
	==Related Videos==		==Related Videos==

−	~~{{#ev:youtube\|1JN8jL5haZY\|280\|center\|AMORLINC}}~~
	{{#ev:youtube\|v=DQfl_5hkeYo\|280\|center\|AMORLINC}}		{{#ev:youtube\|v=DQfl_5hkeYo\|280\|center\|AMORLINC}}

← Older revision		Revision as of 20:22, 15 November 2018
Line 83:		Line 83:

	{{#ev:youtube\|1JN8jL5haZY\|280\|center\|AMORLINC}}		{{#ev:youtube\|1JN8jL5haZY\|280\|center\|AMORLINC}}
		+	{{#ev:youtube\|v=DQfl_5hkeYo\|280\|center\|AMORLINC}}

	== See Also ==		== See Also ==

@@ Line 8: / Line 8: @@
 *<math>Rate</math> is the rate of depreciation
 *<math>Basis</math> is the year basis to be used
+**AMORLINC(), returns the depreciation for each accounting period.
 == Description ==

@@ Line 1: / Line 1: @@
-<div style="font-size:25px">'''AMORLINC(cost, DP, FP, salvage, period, rate, basis)'''</div><br/>
+<div style="font-size:25px">'''AMORLINC (Cost,DatePurchased,FirstPeriod,Salvage,Period,Rate,Basis)'''</div><br/>
-AMORLINC() calculates the depreciation for each accounting period.
+*where, <math>Cost</math> is the cost of the asset
 == Description ==
 *The function calculates the decrease in value of asset for the mentioned period.
-*If <math>DP</math> &gt; <math>FP</math>, Calci displays #N/A error message.
+*If <math>DatePurchased</math> &gt; <math>FirstPeriod</math>, Calci displays #N/A error message.
-*<math>salvage</math> also called as 'residual value' is the remaining value of an asset after it has been fully depreciated.
+*<math>Salvage</math> also called as 'residual value' is the remaining value of an asset after it has been fully depreciated.
-*If <math>rate</math> is &lt;=0, Calci displays #N/A error message.
+*If <math>Rate</math> is &lt;=0, Calci displays #N/A error message.
-*If <math>period</math> is omitted, Calci assumes it as 0.5 years(6 months).
+*If <math>Period</math> is omitted, Calci assumes it as 0.5 years(6 months).
-*<math>basis</math> value is optional. If omitted, Calci assumes it to be 0.
+*<math>Basis</math> value is optional. If omitted, Calci assumes it to be 0.
-Below table shows the use of <math>basis</math> values:
+Below table shows the use of <math>Basis</math> values:
 {| class="wikitable"
@@ Line 33: / Line 34: @@
 |}
-*If <math>basis</math> value is other than 0, 1, 3 or 4, Calci displays #N/A error message.
+*If <math>Basis</math> value is other than 0, 1, 3 or 4, Calci displays #N/A error message.
 == Examples ==

@@ Line 1: / Line 1: @@
-=AMORLINC(cost, DP, FP, salvage, period, rate, basis)=
+<div style="font-size:25px">'''AMORLINC(cost, DP, FP, salvage, period, rate, basis)'''</div><br/>
 *where, <math>cost</math> is the cost of the asset
 *<math>DP</math> is the date of purchase of asset

← Older revision		Revision as of 10:45, 14 March 2017
Line 94:		Line 94:
	*[http://en.wikipedia.org/wiki/Depreciation Depreciation]		*[http://en.wikipedia.org/wiki/Depreciation Depreciation]
	*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis]		*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

← Older revision		Revision as of 18:12, 28 April 2015
Line 80:		Line 80:

	=AMORLINC(A1,A2,A3,A4,A5,A6,A7) ''displays 576'' as a result.		=AMORLINC(A1,A2,A3,A4,A5,A6,A7) ''displays 576'' as a result.
		+
		+	==Related Videos==
		+
		+	{{#ev:youtube\|1JN8jL5haZY\|280\|center\|AMORLINC}}

	== See Also ==		== See Also ==

@@ Line 38: / Line 38: @@
 == Examples ==
-Consider the following example that shows the use of DURATION function:
+Consider the following example that shows the use of AMORLINC function:
 <div id="2SpaceContent" class="zcontent" align="left">