AMORDEGRC function in Excel

AMORDEGRC function in Excel The Microsoft Excel AMORDEGRC function returns the linear depreciation of an asset for each accounting period, on a prorated basis. The AMORDEGRC function is a built-in function in Excel that is categorized as a Financial Function . It can be used as a worksheet function (WS) in Excel. As a worksheet function, the AMORDEGRC function can be entered as part of a formula in a cell of a worksheet. Syntax The syntax for the AMORDEGRC function in Microsoft Excel is: AMORDEGRC( cost, purchase_date, first_period, salvage, period, rate, [basis] ) Parameters or Arguments cost The cost of the asset. purchase_date The date that the asset was purchased. first_period The date of the end of the first period. salvage The salvage value after the asset has been fully depreciated. period The period in which to calculate the linear depreciation. rate The rate of depreciation. basis Optional. It is the type of year basis to use when calculating the depreciation. If th...