Manuals/calci/AMORDEGRC - Revision history

Devika at 22:27, 22 August 2018

2018-08-22T22:27:12Z

Devika at 23:04, 27 July 2018

2018-07-27T23:04:56Z

Devika at 23:04, 27 July 2018

2018-07-27T23:04:30Z

Jayaram at 11:05, 14 March 2017

2017-03-14T11:05:41Z

Swapna at 20:48, 9 May 2015

2015-05-09T20:48:27Z

Swapna at 20:42, 5 May 2015

2015-05-05T20:42:23Z

Swapna at 12:28, 17 January 2014

2014-01-17T12:28:21Z

Swapna at 12:26, 17 January 2014

2014-01-17T12:26:31Z

Swapna at 12:19, 17 January 2014

2014-01-17T12:19:04Z

Show changes

MassBot1: Created page with "
'''AMORDEGRC'''(
2013-10-25T02:29:26Z

Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''AMORDEGRC'''( '''AMORDEGRC'''('''C''', '''DP''', '''FP''', '''salvage''', '''P''', '''R''', basis)

Where 'C' is the cost of the asset, 'DP' is the date of the purchase of the asset, 'FP' is the date of the end of the first period, 'Salvage' is the salvage value, 'P' is the period, 'R' is the rate of depreciation and 'basis' is the year basis to be used.

</div>
----
<div id="1SpaceContent" class="zcontent" align="left"> This function identifies the depreciation for each accounting period. </div>
----
<div id="7SpaceContent" class="zcontent" align="left">

* This function will return the depreciation until the last period of the life of the assets or until the cumulated value of depreciation is greater than the cost of the assets minus the salvage value. The depreciation coefficients are:

{| width="100%" border="1" cellpadding="4"
|- valign="top"
! width="49%" |
Life of assets
! width="51%" |
Depreciation coefficient
|- valign="top"
| width="49%" |
Between 3 and 4 years
| width="51%" |
1.5
|- valign="top"
| width="49%" |
Between 5 and 6 years
| width="51%" |
2
|- valign="top"
| width="49%" |
More than 6 years
| width="51%" |
2.5
|}

 

</div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">

AMORDEGRC

</div></div>
----
<div id="8SpaceContent" class="zcontent" align="left">

Lets see an example,

AMORDEGRC(C, DP, FP, salvage, P, R, basis)

B

2400

8/19/2010

12/31/2010

350

2

25%

1

<nowiki>=AMORDEGRC(B2,B3,B4,B5,B6,B7,B8) is 484.5</nowiki>

</div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
----
<div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
----
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
----
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
----
<div id="5SpaceContent" class="zcontent" align="left">

{| id="TABLE1" class="SpreadSheet blue"
|- class="even"
| class=" " |
| class=" " | Column1
| class=" " | Column2
| Column3
| class="sshl_f" | Column4
|- class="odd"
| class=" " | Row1
| class="sshl_f" | 2400
| class="sshl_f" |
| class=" sshl_f " |
|
|- class="even"
| class=" " | Row2
| class="sshl_f" | 8/19/2010
| class="sshl_f" |
|
|
|- class="odd"
| Row3
| class="sshl_f" | 12/31/2010
| class="sshl_f " | 484.5
|
|
|- class="even"
| Row4
| class="sshl_f" | 350
| class="SelectTd" |
|
|
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 2
| class=" sshl_t ChangeBGColor" |
|
|
|- class="even"
| class="sshl_f" | Row6
| class="sshl_f" | 25%
| class="sshl_t" |
|
|
|- class="odd"
| class="sshl_f" | Row7
| class="sshl_f" | 1
| class="sshl_t" |
|
|
|}

<div align="left">[[Image:calci1.gif]]</div></div>
----

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

@@ Line 9: / Line 9: @@
 *<math>Basis</math> is the year basis to be used
-AMORDEGRC() Returns the depreciation for each accounting period by using a depreciation coefficient.
+AMORDEGRC() returns the depreciation for each accounting period by using a depreciation coefficient.
 == Description ==

@@ Line 1: / Line 1: @@
-=AMORDEGRC(cost, DP, FP, salvage, period, rate, basis)=
+<div style="font-size:30px">'''AMORDEGRC (Cost,PurchaseDate,FirstPeriod,SalvageValue,Period,Rate,Basis)'''</div><br/>
-*where, <math>cost</math> is cost of the asset
+*where, <math>Cost</math> is cost of the asset
-*<math>DP</math> is the date of purchase of asset
+*<math>PurchaseDate</math> is the date of purchase of asset
-*<math>FP</math> is the end of first period
+*<math>FirstPeriod</math> is the end of first period
-*<math>salvage</math> is the salvage value at the end of life of asset
+*<math>SalvageValue</math> is the salvage value at the end of life of asset
-*<math>period</math> is the accounting period
+*<math>Period</math> is the accounting period
-*<math>rate</math> is the rate of depreciation
+*<math>Rate</math> is the rate of depreciation
-*<math>basis</math> is the year basis to be used
+*<math>Basis</math> is the year basis to be used
-AMORDEGRC() calculates the depreciation for each accounting period by applying depreciation coefficient.
+AMORDEGRC() Returns the depreciation for each accounting period by using a depreciation coefficient.
 == Description ==
 *The function calculates the decrease in value of asset for a mentioned period considering the depreciation coefficient depending on life of assets. This function is used in French accounting system.
-*If <math>DP</math> &gt; <math>FP</math>, Calci displays #N/A error message.
+*If <math>PurchaseDate</math> &gt; <math>FirstPeriod</math>, Calci displays #N/A error message.
-*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).
-*'basis' value is optional. If omitted, Calci assumes it to be 0.
+*'Basis' value is optional. If omitted, Calci assumes it to be 0.
 Below table shows the use of 'basis' values:

← Older revision		Revision as of 11:05, 14 March 2017
Line 107:		Line 107:
	*[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 ]]

@@ Line 93: / Line 93: @@
   =AMORDEGRC(A1,A2,A3,A4,A5,A6,A7) ''displays 564'' as a result.
   =AMORDEGRC(3600,DATE(2010,3,4),DATE(2012,3,4),750,1,20%,1) ''displays 1441'' as a result.
 == See Also ==