writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <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>+ − + + + + + + + − </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="5SpaceContent" class="zcontent" align="left"> − + + + + + + + + + + + + + + + + + + + + + + + − + − | class=" " | Column2+ − | Column3 − | class="sshl_f" | Column4 − | class=" " | Row1+ − + − + − + − | − + − + − + − |+ − | − | Row3+ − + − + − + − | − | Row4+ − + − + − + − | − + + + + + − + − |+ − | − |- class="even" − | class="sshl_f" | Row6 − − | 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>+ − ----+
no edit summary
=AMORLINC(cost, DP, FP, salvage, period, rate, basis)=
<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>
*where, <math>cost</math> is the cost of the asset
*<math>DP</math> is the date of purchase of asset
*<math>FP</math> is the end of first period
*<math>salvage</math> is the salvage value at the end of life of asset
*<math>period</math> is the accounting period
*<math>rate</math> is the rate of depreciation
*<math>basis</math> is the year basis to be used
AMORLINC() calculates the depreciation for each accounting period.
== Description ==
*The function calculates the decrease in value of asset for the mentioned period.
*If <math>DP</math> > <math>FP</math>, Calci displays #N/A error message.
<div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
*If <math>rate</math> is <=0, Calci displays #N/A error message.
*If <math>period</math> is omitted, Calci assumes it as 0.5 years(6 months).
<div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
*'basis' value is optional. If omitted, Calci assumes it to be 0.
Below table shows the use of 'basis' values:
<div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
{| id="TABLE1" class="SpreadSheet blue"
{| class="wikitable"
|-
! Basis !! Description
|-
| 0 || 360 days (NASD)
|-
| 1 || Actual
|-
| 3 || 365 days in a year
|-
| 4 || 360 days in a year (European)
|}
*If 'basis' value is other than 0, 1, 3 or 4, Calci displays #N/A error message.
== Examples ==
Consider the following example that shows the use of DURATION function:
<div id="2SpaceContent" class="zcontent" align="left">
{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
|- class="even"
| class="sshl_f" | 3200
| class=" " |
| class=" " |
| class=" " | Column1
| class=" " |
|- class="odd"
|- class="odd"
| class="sshl_f" | 8/19/2010
| class="sshl_f" | 3200
| class=" " |
| class="sshl_f" |
| class=" " |
| class=" sshl_f " |
|- class="even"
|- class="even"
| class=" " | Row2
| class="sshl_f" | 12/31/2010
| class="sshl_f" | 8/19/2010
| class=" " |
| class="sshl_f" |
| class=" " |
|- class="odd"
|- class="odd"
| class="sshl_f" | 250
| class="sshl_f " | 12/31/2010
| class=" " |
| class="sshl_f" | 576
| class=" " |
|
|- class="even"
|- class="even"
| class="sshl_f" | 1
| class="sshl_f" | 250
| class=" " |
| class="SelectTd " |
| class=" " |
|
|- class="odd"
|- class="odd"
| class=" " | Row5
| class="sshl_f" | 18%
| class=" " |
| class=" " |
|- class="even"
| class="sshl_f" | 1
| class="sshl_f" | 1
| class=" sshl_t ChangeBGColor" |
| class=" " |
| class=" " |
| class="sshl_f" | 18%
|
|}
|}
=AMORLINC(A1,A2,A3,A4,A5,A6,A7) ''displays 576'' as a result.
== See Also ==
*[[Manuals/calci/DURATION | DURATION]]
*[[Manuals/calci/ACCRINT | ACCRINT]]
== References ==
*[http://en.wikipedia.org/wiki/Depreciation Depreciation]
*[http://en.wikipedia.org/wiki/Day_count_convention Day Count Basis]