Excel Function : AMORDEGRC
Category
Financial
Description
Returns the depreciation for each accounting period by using a depreciation coefficient
Microsoft Excel Reference Page
https://support.office.com/en-us/article/AMORDEGRC-function-a14d0ca1-64a4-42eb-9b3d-b0dededf9e51
Syntax and Description of the AMORDEGRC Excel Function
The syntax for the AMORDEGRC function in Microsoft Excel is: =AMORDEGRC(cost, date_purchased, salvage, life, period, rate, [basis]) Arguments cost - The cost of the asset. date_purchased - The date the asset was purchased. salvage - The value of the asset at the end of its life. life - The number of periods over which the asset is being depreciated. period - The period for which you want to calculate the depreciation. Period must use the same units as life. rate - The rate of depreciation. basis - The type of
About AMORDEGRC Excel Function
The AMORDEGRC function returns the depreciation for an asset for each period, including partial periods, using the double-declining balance method or some other method you specify. AMORDEGRC(cost,date_purchased,first_period,salvage,period,rate,basis) cost: The initial cost of the asset. date_purchased: The date the asset was purchased. first_period: The date of the first period. salvage: The value at the end of the depreciation (sometimes called the salvage value of the asset). period: The total number of periods over which the asset is being depreciated (sometimes called the life of
