writer
6,694
edits
Changes
Manuals/calci/AMORLINC (view source)
Revision as of 20:22, 15 November 2018
, 20:22, 15 November 2018→Related Videos
=AMORLINC(cost, DP, FP, salvage, period, rate, basis)=
<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
*where, <math>Cost</math> is the cost of the asset
*<math>DP</math> is the date of purchase of asset
*<math>DatePurchased</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>Salvage</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
**AMORLINC(), returns the depreciation for each accounting period.
AMORLINC() calculates 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> > <math>FP</math>, Calci displays #N/A error message.
*If <math>DatePurchased</math> > <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 <=0, Calci displays #N/A error message.
*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).
*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"
|}
|}
*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 ==
==Related Videos==
==Related Videos==
{{#ev:youtube|1JN8jL5haZY|280|center|AMORLINC}}
{{#ev:youtube|v=DQfl_5hkeYo|280|center|AMORLINC}}
== See Also ==
== See Also ==
*[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 ]]