writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + Line 13:
Line 13: − +
Manuals/calci/AMORDEGRC (view source)
Revision as of 12:28, 17 January 2014
, 12:28, 17 January 2014no edit summary
=AMORDEGRC(cost, DP, FP, salvage, period, rate, basis)=
=AMORDEGRC(cost, DP, FP, salvage, period, rate, basis)=
*where, <math>cost</math> is the cost of the asset
*where, <math>cost</math> is cost of the asset
*<math>DP</math> is the date of purchase of asset
*<math>DP</math> is the date of purchase of asset
*<math>FP</math> is the end of first period
*<math>FP</math> is the end of first period
== Description ==
== Description ==
*The function calculates the decrease in value of asset for the mentioned period considering the depreciation coefficient depending on life of assets. This function is used in French accounting system.
*The function calculates the decrease in value of asset for a mentioned period considering the depreciation coefficient depending on life of assets. This function is used in French accounting system.
*If <math>DP</math> > <math>FP</math>, Calci displays #N/A error message.
*If <math>DP</math> > <math>FP</math>, Calci displays #N/A error message.
*If <math>rate</math> is <=0, Calci displays #N/A error message.
*If <math>rate</math> is <=0, Calci displays #N/A error message.