How to use Excel CUMPRINC Function

Introduction:- CUMPRINC function in excel is a financial function. It is used to find cumulative principal of a loan between the start and end period. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =CUMPRINC(rate, nper, pv, start_period, end_period, type) Arguments:- Rate: It is the rate of the required loan.NPER: It is the number of payment periods.PV: It is the present value.Start_Period: First period to be used in the calculation.End_Period: Last…

Continue Reading

How to use Excel CUMIPMT Function

Introduction:- CUMIPMT function in excel is a financial function. It is used to find cumulative interest of a loan between the start and end period. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =CUMIPMT(rate, nper, pv, start_period, end_period, type) Arguments:- Rate: It is the rate of the required loan. NPER: It is the number of payment periods. PV: It is the present value. Start_Period: First period to be used in…

Continue Reading

How to use Excel T Function

Introduction:- T function are text/string function in excel. It is used to retrieve text from a given text value and also retrieves blank strings for numbers, logical values, dates etc. It is a worksheet function and can be entered in the cell in which value is required. .                                                                 Syntax:- =T(Value) Arguments:- Value: Value or reference to a cell containing value whose text will be returned. Keynotes:- This function gives empty  strings for numbers, logical values, dates etc Examples In this…

Continue Reading

How to use Excel EXPON.DIST Function

Introduction:-     EXPON.DIST function in excel is a statistical function. This function is used to find the exponential distribution. It is an update over EXONDIST function and is available in Excel 2010 and newer versions. It is a worksheet function and can be entered into the cell in which value is required. Syntax:-                                     =EXPON.DIST(X, Lambda, Cumulative) Arguments:- X: It is the value of the function. Lambda:  It is the value of the parameter. Cumulative: It is a logical value which helps…

Continue Reading

How to use Excel DEVSQ Function

Introduction:- DEVSQ function in excel is a statistical function. This function is used to find the sum of the squared deviations from the mean from a sample. It is a worksheet function and can be entered into the cell in which value is required. Syntax:-                         =DEVSQ(Number1,Number2, ……) Arguments:- Number1: First value or reference to the cell containing first value. Number2: Second value or reference to a cell containing second value. Keynotes:- Arguments may be in form of numbers, names, arrays,…

Continue Reading

How to use Excel COVARIANCE.S Function

Introduction:- COVARIANCE.S function in excel is a statistical function. This function is used to find the sample co-variance of two data sets. For example it can be used to keep  check on how to assets are moving together. This is a worksheet function and can be entered into the cell in which count is required. Syntax:-                          =COVARIANCE.S(Array1, Array2) Arguments:- Array1: 1st range of cells. Array2: 2nd range of cells. Keynotes:- The arguments used should be numbers or range of cells…

Continue Reading

How to use Excel COVARIANCE.P Function

Introduction:- COVARIANCE.P function in excel is a statistical function. This function is used to find the variability of two data sets which are co-variant to each other. For example if we needs to find whether greater levels of inflation leads to greater levels of inflation, than we can use excel function. This is a worksheet function and can be entered into the cell in which count is required. Syntax:-                     =COVARIANCE.P(Array1, Array2) Arguments:- Array1: 1st range of cells. Array2: 2nd range…

Continue Reading

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
Close Menu
×

Cart