How to use Excel COUPPCD Function

Introduction:- COUPPCD function in excel is a financial function. It is used to retrieve the previous coupon date before the settlement date of a security. It is a worksheet function and can be entered into the cell in which value is required. Syntax:-                             =COUPPCD(Settlement, Maturity, Frequency, basis) Arguments:- Settlement:  It is the settlement date of the security. Maturity:  It is the maturity date of the security. Frequency: Number of coupon payments per year. Basis: It is the day count basis…

Continue Reading

How to use Excel COUPNUM Function

Introduction:- COUPNUM function in excel is a financial function. It is used to retrieve number of  coupon payable from the settlement date to the maturity date. It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =COUPNUM(Settlement, Maturity, Frequency, basis) Arguments:- Settlement:  It is the settlement date of the security. Maturity:  It is the maturity date of the security. Frequency: Number of coupon payments per year. Basis: It is the day count…

Continue Reading

How to use Excel COUPNCD Function

Introduction:-     COUPNCD function in excel is a financial function. It is used to retrieve the next coupon date after the settlement date. It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =COUPNCD(Settlement, Maturity, Frequency, basis) Arguments:- Settlement:  It is the settlement date of the security. Maturity:  It is the maturity date of the security. Frequency: Number of coupon payments per year. Basis: It is the day count basis to be used.…

Continue Reading

How to use Excel COUPDAYBS Function

Introduction:- COUPDAYBS function in excel is a financial function. It is used to retrieve number of days from the start of coupon period to the settlement date. It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =COUPDAYBS(Settlement, Maturity, Frequency, basis) Arguments:- Settlement:  It is the settlement date of the security. Maturity:  It is the maturity date of the security. Frequency: Number of coupon payments per year. Basis: It is the day…

Continue Reading

How to use Excel COUPDAYSNC Function

Introduction:- COUPDAYSNC function in excel is a financial function. It is used to retrieve number of days from the settlement date to the next coupon period. It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =COUPDAYSNC(Settlement, Maturity, Frequency, basis) Arguments:- Settlement:  It is the settlement date of the security. Maturity:  It is the maturity date of the security. Frequency: Number of coupon payments per year. Basis: It is the day count…

Continue Reading

How to use Excel COUPDAYS Function

Introduction:- COUPDAYS function in excel is a financial function. It is used to retrieve number of days in the coupon period including the settlement date. It is a worksheet function and can be entered into the cell in which value is required. Syntax:- =COUPDAYS(Settlement, Maturity, Frequency, basis) Arguments:- Settlement:  It is the settlement date of the security. Maturity:  It is the maturity date of the security. Frequency: Number of coupon payments per year. Basis: It is the day count basis…

Continue Reading

How to use Excel AMORLINC Function

Introduction:- AMORLINC function in excel is a financial function. It is used to retrieve the depreciation value for every accounting period. It is mainly useful in prorated depreciation calculation. It is different from AMORDEGRC function in a way that in AMORDGERC function, depreciation coefficient is used depending on life of assets. Syntax:- =AMORLINC(cost, date_purchased, first_period, salvage period, rate, basis) Arguments:- Cost: It is cost of the assets. Date_Purchased: It is the date on which assets is purchased. First_Period:  It is…

Continue Reading

How to use Excel ACCRINTM Function

Introduction:- ACCRINTM function in excel is a financial function. It is used to find accrued interest for a security that pays interest at maturity. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =ACCRINTM(issue_date, maturity_date, rate, par, basis) Arguments:- Issue_Date: It is the date on which security is used. Maturity_Date: It is the date on which security will be matured. Rate: Annual coupon rate of the security. Par: It is the…

Continue Reading

How to use Excel AMORDEGRC Function

Introduction:- AMORDEGRC function in excel is a financial function. It is used to retrieve the depreciation value for every accounting period. It is mainly useful in prorated depreciation calculation. It is different from AMORLINC in a way that here depreciation coefficient is used depending on life of assets. Syntax:- =AMORDEGRC(cost, date_purchased, first_period, salvage period, rate, basis) Arguments:- Cost: It is cost of the assets. Date_Purchased: It is the date on which assets is purchased. First_Period:  It is the date on…

Continue Reading

How to use ACCRINT function in excel

Excel version in which ACCRINT function can work: ACCRINT function works in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010. About ACCRINT function in excel: The Microsoft Excel ACCRINT is a financial function, which returns the accrued interest for a security…

Continue Reading
Close Menu
×

Cart