Difference between revisions of "Manuals/calci/AMORLINC"

From ZCubes Wiki
Jump to navigation Jump to search
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/>
*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.
+
*where, <math>Cost</math> is the cost of the asset
 +
*<math>DatePurchased</math> is the date of purchase of asset
 +
*<math>FirstPeriod</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(), returns the depreciation for each accounting period.
  
 
== Description ==
 
== Description ==
  
 
*The function calculates the decrease in value of asset for the mentioned period.
 
*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"
 
{| 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 ==
 
== Examples ==

Revision as of 17:18, 19 July 2018

AMORLINC (Cost,DatePurchased,FirstPeriod,Salvage,Period,Rate,Basis)


  • where, is the cost of the asset
  • is the date of purchase of asset
  • is the end of first period
  • is the salvage value at the end of life of asset
  • is the accounting period
  • is the rate of depreciation
  • is the year basis to be used

AMORLINC(), returns the depreciation for each accounting period.

Description

  • The function calculates the decrease in value of asset for the mentioned period.
  • If > , Calci displays #N/A error message.
  • also called as 'residual value' is the remaining value of an asset after it has been fully depreciated.
  • If is <=0, Calci displays #N/A error message.
  • If is omitted, Calci assumes it as 0.5 years(6 months).
  • value is optional. If omitted, Calci assumes it to be 0.

Below table shows the use of values:

Basis Description
0 360 days (NASD)
1 Actual
3 365 days in a year
4 360 days in a year (European)
  • If 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 AMORLINC function:

3200
8/19/2010
12/31/2010
250
1
18%
1
=AMORLINC(A1,A2,A3,A4,A5,A6,A7) displays 576 as a result.

Related Videos

AMORLINC

See Also

References