Easy Explanation Notes with Examples

XIRR Function in Excel

What is IRR The abbreviation ‘IRR’ stands for internal rate of return, it is the interest rate at which net present value of an investment with both negative and positive cash flows equals to zero. Use of the XIRR function The XIRR function calculates the internal rate of return for an investment having cash flows occurring […]

XNPV function in Excel

Use If you made an investment that pays serious of cash flows, particularly not periodic, by using the XNPV function, you can calculate the net present value for the investment. To calculate the NPV for serious of periodic regular payment, use the NPV function. Syntax XNPV(rate, values, dates) The XNPV function has the following arguments: […]

YIELD function in Excel

Use The YIELD function calculates a security’s yield that pays interest periodically, such as a bond. The function is one of the financial functions and was first introduced in the Excel 2007 version. Syntax YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis]) The function has the following arguments: settlement – Required. After the issuance date, it […]

YIELDDISC Function in Excel

Use The YIELDDISC Function one of the Financial function returns the annual yield for a discounted security, such as a treasury bill. Syntax YIELDDISC(settlement, maturity, pr, redemption, [basis]) The YIELDDISC function has the followings arguments: settlement – Required. After the issue date, it is the date when the security is traded to the buyer. maturity – Required. The […]

YIELDMAT function

Use If a bond pays interest at maturity, the YIELDMAT function calculates the annual yield of the bond. It is the Financial function and first introduced in the Excel 2007 version. Syntax YIELDMAT(settlement, maturity, issue, rate, pr, [basis]) settlement – Required. The date on which the bond is traded to the buyer. The bond’s settlement date. […]

NPER function in Excel

Use If you took a loan with constant payments and a constant interest rate, the NPER function returns the number of periods required to pay off the loan. The function is one of the Financial function and was introduced in the Excel 2007 version. Syntax NPER(rate,pmt,pv,[fv],[type]) The NPER function has the following arguments: rate – Required. The […]

NOMINAL function in Excel

Use The NOMINAL function is one of the Financial functions, it calculates the nominal interest rate of a bond having an effective interest rate and compounding periods per year. Syntax NOMINAL(effect_rate, npery) The NOMINAL function has the following arguments: effect_rate – Required. The effective interest rate. npery – Required. The number of compounding periods per year. […]

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved