AMORDEGRC function - The function returns the depreciation for each accounting period in Excel
Excel is a powerful tool in financial accounting. In each accounting period depreciation values are always mentioned. The following article details the AMORDEGRC function, the function returns the depreciation for each accounting period.
Description: The function calculates the depreciation of assets in each accounting period, the preferred function is to look at the French accounting system.
Syntax: AMORDEGRC (cost, date_purchased, first_period, salvage, period, rate, basis) .
Inside:
- cost: The value of the property when purchased, is a required parameter.
- date_purchased: The date the asset was purchased, a required parameter.
- first_period: The last day of the first accounting period, is a required parameter.
- salvage: The recovered value of the real ship at the end of the service life, which is a mandatory parameter.
- period: The number of periods for which depreciation is to be calculated and required.
- rate: Depreciation rate.
- basis: The basis for determining the number of days, is an optional parameter if ignoring the default value is 0. Basis has the following values:
+ Basis = 0: The number of days per month is 30, the number of days per year is 360 according to US standards.
+ Basis = 1: The number of days per month is equal to the actual number of days per month, the number of days in a year is the actual number of days per year.
+ Basis = 2: The actual number of days in a month / 360 days a year.
+ Basis = 3: The actual number of days in a month / 365 days a year.
+ Basis = 4: The number of days per month is 30 / A year has 360 days according to European standards.
Attention:
- Enter the date using the DATE function (year, moth, day) .
- The function calculates depreciation to the end of the term or depreciation until the accumulated depreciation value is greater than the capital spent minus the residual value of the asset when it expires.
- The depreciation value reaches 50% in the period before the last period and increases by 100% in the last period.
- If the asset's life cycle is from 0 to 1, 1 to 2, 2 to 3, 3 to 4 => the #NUM!
For example:
The depreciation in the first period of an asset is calculated as follows:
In the cell that you want to enter the formula: = AMORDEGRC (D6, D7, D8, D9, D10, D11, D12) .
Pressing Enter will calculate the depreciation value in the first period of the 68 million property value:
Thus, the depreciation value of the asset is 68 million VND in the first period, the depreciation value is 10 million.
Above is a guide to using AMORDEGRC function, hoping to help you in your work.
Good luck!
You should read it
- SYD function - Calculate depreciation for an asset by remaining value in Excel
- Basic Excel functions that anyone must know
- DB function - The function calculates the depreciation of assets with specific maturity in Excel
- VDB function - Calculate asset depreciation by the declining balance method in Excel
- How to use the IF function in Excel
- How to use the IFS function in Excel 2016
- DAYS360 function - The function returns the number of days between 2 dates, based on 360 days in Excel
- CHISQ.TEST function - The function returns the independence test in Excel
May be interested
- How to use the IF function in Excelthe if function in excel checks for a true or false condition. if the condition is true, the function returns a value, if the condition fails the function returns another value
- F.TEST function - The function returns the result of the F - test in Excelf.test: the function returns the result of the f - test, the probability of two ends where the variance of 2 arrays is not significant. support functions from excel 2010 version. syntax: f.test (array1, array2)
- GAMMA function - The function returns the gamma function value in Excelgamma: the function returns the gamma function. support functions from excel 2013 onwards. syntax: gamma (number)
- POISSON.DIST function - The function returns the Poisson distribution in Excelpoisson.dist function: the function returns the poisson distribution, the application function to predict the number of events in a specific time. support functions from excel 2013 onwards. syntax: poisson.dist (x, mean, cumulative)
- WEIBULL function - The function returns the Weibull distribution in Excelthe function performs the calculation and returns the weibull distribution. based on this distribution to analyze reliability in theory such as calculating the average life of the device or used in the field of meteorology, hydrology and weather forecast.
- QUARTILE.EXC function - The function returns the quartile of a dataset without values 0 and 1 in Excelquartile.exc function: the function returns the quartile of the data set, with percentile values from 0 to 1 excluding 0 and 1. the support function is from excel 2010 onwards. syntax: quartile.exc (array, quart)
- PHI function - The function returns the value of the density function for a normal distribution in Excelphi function: the function returns the value of the density function for a standard normal distribution. support functions from excel 2013 onwards. syntax: phi (x)
- FORECAST function - The function returns a value along a linear trend in Excelforecast function: the function performs the calculation or prediction of a future value by using current values using linear regression. in excel 2016 this function is replaced by forecast.linear function. syntax: forecast (x, known_ys, known_xs)
- BETA.DIST function - The function returns the Beta distribution in Excelbeta.dist function: the function returns the beta distribution to study the variability of a number of things through a sample. support functions from excel 2010 onwards. syntax: beta.dist (x, alpha, beta, cumulative, [a], [b])
- How to use the IFS function in Excel 2016the ifs function in excel is a logical function introduced in excel 2016. this function is a function that replaces the nested if function and is much easier to use. the ifs function checks one or more conditions and returns a value that meets the first true condition.