ZCubes Wiki

Changes

Manuals/calci/AMORDEGRC (view source)

Revision as of 02:29, 25 October 2013

5,486 bytes added ,  02:29, 25 October 2013
Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''AMORDEGRC'''</font><font size="2">(</font><font ..."
<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''AMORDEGRC'''</font><font size="2">(</font><font size="2">'''C'''</font><font size="2">, </font><font size="2">'''DP'''</font><font size="2">, </font><font size="2">'''FP'''</font><font size="2">, </font><font size="2">'''salvage'''</font><font size="2">, </font><font size="2">'''P'''</font><font size="2">, </font><font size="2">'''R'''</font><font size="2">, basis)</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">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, '</font><font size="2">Salvage' </font><font size="2">is the salvage value, 'P' is the period, 'R' is the rate of depreciation and 'basis' is the year basis to be used.</font></font></font>

</div>
----
<div id="1SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">This function identifies the depreciation for each accounting period. </font></font></font></div>
----
<div id="7SpaceContent" class="zcontent" align="left"> 

* <font color="#000000"><font face="Arial, sans-serif"><font size="2">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:</font></font></font>

{| width="100%" border="1" cellpadding="4"
|- valign="top"
! width="49%" |
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Life of assets</font></font></font>
! width="51%" |
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Depreciation coefficient</font></font></font>
|- valign="top"
| width="49%" |
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Between 3 and 4 years</font></font></font>
| width="51%" |
<font color="#000000"><font face="Arial, sans-serif"><font size="2">1.5</font></font></font>
|- valign="top"
| width="49%" |
<font color="#000000"><font face="Arial, sans-serif"><font size="2">Between 5 and 6 years</font></font></font>
| width="51%" |
<font color="#000000"><font face="Arial, sans-serif"><font size="2">2</font></font></font>
|- valign="top"
| width="49%" |
<font color="#000000"><font face="Arial, sans-serif"><font size="2">More than 6 years</font></font></font>
| width="51%" |
<font color="#000000"><font face="Arial, sans-serif"><font size="2">2.5</font></font></font>
|}

<br /><br />

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

AMORDEGRC

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

<font color="#000000"><font face="Arial, sans-serif"><font size="2">Lets see an example,</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">AMORDEGRC(C, DP, FP, salvage, P, R, basis)</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">B</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">2400</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">8/19/2010</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">12/31/2010</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">350</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">2</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">25%</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2">1</font></font></font>

<font color="#000000"><font face="Arial, sans-serif"><font size="2"><nowiki>=AMORDEGRC(B2,B3,B4,B5,B6,B7,B8) is 484.5</nowiki></font></font></font>

</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>
----
MassBot1
Bots, writer
193,448

edits

Retrieved from "http://wiki.zcubes.com/Special:MobileDiff/272"