Financial

How to use Excel EFFECT Function

Introduction:- EFFECT function in excel is a financial function. It is used to find effective annual interest rate. It is defined as the actual interest rate earned annually due to compounding. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =EFFECT(nominal_rate, npery) Arguments:- Nominal_Rate: It is …

How to use Excel DURATION Function

Introduction:- DURATION function in excel is a financial function. It is used to find duration of a security in Macaulay form using Macaulay duration formula. Duration is expressed as weighted average of cash flows at present. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =DURATION …

How to use Excel FV Function

Introduction:-     FV function in excel is a financial function. It is used to find the future value of an investment. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =FV (rate, nper, pmt, [pv], [type]) Arguments:- rate – It is the interest rate per period. nper – It …

How to use Excel DISC Function

Introduction:- DISC function in excel is a financial function. It is used to find discount rate of a security. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =DISC(settlement, maturity, pr, redemption, basis) Arguments:- Settlement: It is the date on which security is settled. It comes …

How to use Excel FVSHEDULE Function

Introduction:- FVSCHEDULE function in excel is a financial function. It is used to find the future value of an initial principal after a number of compound interest rates. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =FVSCHEDULE (Principal, Schedule) Arguments:- Principal: It is the present …

How to use Excel DDB Function

Introduction:- DDB function in excel is a financial function. It is used to return the depreciation value of an asset during a mentioned period by using double declining balance method or other methods mentioned in Factor argument. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- …

How to use Excel INTRATE Function

Introduction:- INTRATE function in excel is a financial function. It is used to find interest rate of a fully invested security. It is a worksheet function and can be entered in the cell in which value is required. .                           Syntax:- =INTRATE(settlement, maturity, investment, redemption, basis) Arguments:- Settlement: It is the date on which security is …

How to use Excel DB Function

Introduction:- DB function in excel is a financial function. It is used to return the depreciation value of an asset during a mentioned period by using fixed declining balance method. It is a worksheet function and can be entered in the cell in which value is required. Syntax:- =DB (cost, salvage, life, period, [month]) Arguments:- …

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 …

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 …