Financial

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 …

How to use Excel COUPPCD Function Read More »

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 …

How to use Excel COUPNUM Function Read More »

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:  …

How to use Excel COUPNCD Function Read More »

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 …

How to use Excel COUPDAYBS Function Read More »

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 …

How to use Excel COUPDAYSNC Function Read More »

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 …

How to use Excel COUPDAYS Function Read More »

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, …

How to use Excel AMORLINC Function Read More »

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 …

How to use Excel ACCRINTM Function Read More »

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, …

How to use Excel AMORDEGRC Function Read More »