Learn with Yuvnesh

 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 this parame

  ACCRINTM Function in MS Excel What is the ACCRINTM Function? The ACCRINTM function in Excel is used to calculate the accrued interest for a security that pays interest at maturity. This function is typically used for bonds and similar financial instruments where interest is not paid periodically but is instead accumulated and paid at the maturity of the security.   Syntax The syntax for the ACCRINTM function in Microsoft Excel is: ACCRINTM( issue_date, maturity_date, rate, par, [basis] ) Parameters or Arguments issue_date The date that the security was issued. maturity_date The maturity date of the security. rate The annual coupon rate for the security. par The par value of the security. If this parameter is omitted, the ACCRINTM function will assume that the  par  is set to $1,000. basis Optional. It is the type of day count to use when calculating interest for the security. If this parameter is omitted, it assumes that the  basis  is set to 0. It can be any of the following value