Financial functions calculate financial information and have been made available to execute a variety of financial calculations such as , payment , present value , calculation of yield , investment valuations , interest rates , internal rate of return , asset depreciation , and payment.
FINANCIAL FUNCTIONS
There are total 55 financial functions in MS Excel . These 55 Financial functions are given below :
ACCRINT : Returns the accrued interest for a security that pays periodic interest.
ACCRINTM : Returns the accrued interest for a security that pays interest at maturity.
AMORDEGRC : Returns the prorated linear depreciation of an asset for each accounting period.
AMORLINC : Returns the prorated linear depreciation of an asset for each accounting period.
COUPDAYBS : Returns the number of days from the beginning of the coupon period to the settlement date.
COUPDAYS : Returns the number of days in the coupon period that contains the settlement date.
COUPDAYSNC : Returns the number of days from the settlement date to the next coupon date.
COUPNCD : Returns the next coupon date after the settlement date.
COUPNUM : Returns the number of coupons payable between the settlement date and maturity date.
COUPPCD : Returns the previous coupon date before the settlement date.
CUMIPMT : Returns the cumulative interest paid between two periods.
CUMPRINC : Returns the cumulative principal paid on a loan between two periods.
DB : Returns the depreciation of an asset for a specified period using the fixed-declining balance method.
DDB : Returns the depreciation of an asset for specified period using the double -declining balance method or some other method you specify.
DISC : Returns the discount rate for a security.
DOLLARDE : Converts a dollar price , expressed as a fraction , into a dollar price , expressed as a decimal number.
DOLLARFR : Converts a dollar price , expressed as a decimal number , into a dollar price , expressed as a fraction.
DURATION : Returns the annual duration of a security with periodic interest payments.
EFFECT : Returns the effective annual interest rate.
FV : Returns the future value of an investment based on periodic , constant payments and a constant interest rate.
FVSCHEDULE : Returns the future value of an initial principal after applying a series of compound interest rates.
INTRATE : Returns the interest rate for a fully invested security.
IPMT : Returns the interest payment for a given period for an investment , based on periodic , constant payments and a constant interest rate.
IRR : Returns the internal rate of return for a series of cash flows.
ISPMT : Returns the interest paid during a specific period of an investment.
MDURATION : Returns the Macauley modified duration for a security with an assumed par value of $100.
MIRR : Returns the internal rate of return for a series of periodic cash flows , considering both cost of investment and interest on reinvestment of cash.
NOMINAL : Returns the annual nominal interest rate.
NPER : Returns the number of periods for an investment based on periodic , constant payments and a constant interest rate.
NPV : Returns the net present value of an investment based on a discount rate and a series of future payments ( negative values ) and income ( positive values ).
ODDFPRICE : Returns the price per $100 face value of a security with an odd first period.
ODDFYIELD : Returns the yield of a security with an odd first period.
ODDLPRICE : Returns the price per $100 face value of a security with an odd last period.
ODDLYIELD : Returns the yield of a security with an odd last period.
PDURATION : Returns the number of periods required by an investment to reach a specified value.
PMT : Calculates the payment for a loan based on constant payments and a constant interest rate.
PPMT : Returns the payment on the principal for a given investment based on periodic , constant payments and a constant interest rate.
PRICE : Returns the price per $ 100 face value of a security that pays periodic interest.
PRICEDISC : Returns the price per $ 100 face value of a discounted security.
PRICEMAT : Returns the price per $ 100 face value of a security that pays interest at maturity.
PV : Returns the present value of an investment : the total amount that a series of future payments is worth now.
RATE : Returns the interest rate per period of a loan or an investment . For example , use 6%/4 for quarterly payments at 6% APR.
RECEIVED : Returns the amount received at maturity for a fully invested security.
RRI : Returns an equivalent interest rate for the growth of an investment.
SLN : Returns the straight-line depreciation of an asset for one period.
SYD : Returns the sum-of-years digits depreciation of an asset for a specified period.
TBILLEQ : Returns the bond-equivalent yield for a treasury bill.
TBILLPRICE : Returns the price per $100 face value for a treasury bill.
TBILLYIELD : Returns the yield for a treasury bill.
VDB : Returns the depreciation of an asset for any period you specify , including partial periods , using the double-declining balance method or some other method you specify.
XIRR : Returns the internal rate of return for a schedule of cash flows.
XNPV : Returns the net present value for a schedule of cash flows.
YIELD : Returns the yield on a security that pays periodic interest.
YIELDDISC : Returns the annual yield for a discounted security. For example , a treasury bill.
YIELDMAT : Returns the annual yield of a security that pays interest at maturity.
Visit our blogs to know more about excel formulas & functions
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png)
.png&description=FINANCIAL FUNCTIONS){kind=link}
0 Comments