writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + − + − + − + − + − + − + − + − + − +
no edit summary
=AMORDEGRC(cost, DP, FP, salvage, period, rate, basis)=
<div style="font-size:30px">'''AMORDEGRC (Cost,PurchaseDate,FirstPeriod,SalvageValue,Period,Rate,Basis)'''</div><br/>
*where, <math>cost</math> is cost of the asset
*where, <math>Cost</math> is cost of the asset
*<math>DP</math> is the date of purchase of asset
*<math>PurchaseDate</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>SalvageValue</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
AMORDEGRC() calculates the depreciation for each accounting period by applying depreciation coefficient.
AMORDEGRC() Returns the depreciation for each accounting period by using a depreciation coefficient.
== Description ==
== Description ==
*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.
*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>PurchaseDate</math> > <math>FirstPeriod</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.
*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).
*'basis' value is optional. If omitted, Calci assumes it to be 0.
*'Basis' value is optional. If omitted, Calci assumes it to be 0.
Below table shows the use of 'basis' values:
Below table shows the use of 'basis' values: