Bots, writer
193,448
edits
Changes
Jump to navigation
Jump to search
Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">AMORLINC(C, DP, FP, salvage, P, R, basis)</font>..."
<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">AMORLINC(C, DP, FP, salvage, P, R, 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, 'salvage' is the salvage value at the end of the life of the asset, '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 calculates the depreciation for each accounting period. </font></font></font></div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
AMORLINC
</div></div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></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" | 3200
| 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" | 576
|
|
|- class="even"
| Row4
| class="sshl_f" | 250
| class="SelectTd " |
|
|
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 1
| class=" sshl_t ChangeBGColor" |
|
|
|- class="even"
| class="sshl_f" | Row6
| class="sshl_f" | 18%
| class="sshl_t" |
|
|
|- class="odd"
| class="sshl_f" | Row7
| class="sshl_f " | 1
| class="sshl_t" |
|
|
|}
<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">
<font color="#000000"><font face="Arial, sans-serif"><font size="2">AMORLINC(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">3200</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">250</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">'''18%'''</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>=AM</nowiki>'''O'''RLINC(B2,B3,B4,B5,B6,B7,B8) is 576</font></font></font>
</div>
----
<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, 'salvage' is the salvage value at the end of the life of the asset, '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 calculates the depreciation for each accounting period. </font></font></font></div>
----
<div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
AMORLINC
</div></div>
----
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></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" | 3200
| 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" | 576
|
|
|- class="even"
| Row4
| class="sshl_f" | 250
| class="SelectTd " |
|
|
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 1
| class=" sshl_t ChangeBGColor" |
|
|
|- class="even"
| class="sshl_f" | Row6
| class="sshl_f" | 18%
| class="sshl_t" |
|
|
|- class="odd"
| class="sshl_f" | Row7
| class="sshl_f " | 1
| class="sshl_t" |
|
|
|}
<div align="left">[[Image:calci1.gif]]</div></div>
----
<div id="2SpaceContent" class="zcontent" align="left">
<font color="#000000"><font face="Arial, sans-serif"><font size="2">AMORLINC(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">3200</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">250</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">'''18%'''</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>=AM</nowiki>'''O'''RLINC(B2,B3,B4,B5,B6,B7,B8) is 576</font></font></font>
</div>
----