What is the MIRR Function? The MIRR Function is categorized under Excel Financial functions. The function will provide the rate of return for an initial investment value and a series of net income values. MIRR uses a schedule of payments, including an initial investment and a series of net income payments, to calculate the compounded…
What is the COUPDAYSNC Function? The COUPDAYSNC Function is categorized under Excel Financial functions. It helps calculate the number of days from the settlement date to the next coupon rate. As we are aware, coupon bonds pay interest at regular intervals. MS Excel introduced the COUPDAYSYNC function to calculate the days before we get paid. Thus,…
What is the ODDLYIELD Function? The ODDLYIELD Function is categorized under Excel Financial functions. It helps calculate the yield of a security with an odd (short or long) last period. In financial analysis, some bonds come with irregular first or last periods. Due to the irregular first or last period, the payment sometimes doesn’t fit…
What is the ODDLPRICE Function? The ODDLPRICE Function is categorized under Excel Financial functions. It helps calculate the price per $100 face value of a security with an odd last period. In financial analysis, some bonds come with irregular first or last periods. Due to the irregular first or last period, the payment doesn’t fit in…
What is the ODDFYIELD Function? The ODDFYIELD Function is categorized under Excel Financial functions. It helps calculate the yield of a security with an odd (short or long) first period. In financial analysis, some bonds come with irregular first or last periods. Due to the irregular first or last period, the payment doesn’t fit in…
What is the ODDFPRICE Function? The ODDFPRICE Function is an Excel Financial function. It calculates the price per $100 face value of a security or bond with an odd first period. In financial analysis, some bonds come with irregular first or last periods. Due to the irregular first or last period, the payment doesn’t fit…
What Does the COUPDAYBS Function Do? The COUPDAYBS Function[1] is a financial function in Microsoft Excel that calculates the number of days from the beginning of a coupon period until its settlement date. In other words, the COUPDAYBS function helps return the number of days between the settlement date and the last time a coupon…
What is the COUPDAYS Function? The COUPDAYS Function is categorized under financial functions. It helps calculate the number of days in the coupon period that contains the settlement date. Coupon bonds are bonds that pay interest before the maturity of the bond. As a bond purchaser, we will be interested in knowing how long we…
What is the COUPPCD Function? The COUPPCD Function is a Financial function. It helps calculate the calendar date of the most recent coupon payment. The function returns the result in form of a date. Formula =COUPPNCD(settlement, maturity, frequency, [basis]) The COUPPNCD function uses the following arguments: Settlement (required argument) – This is the settlement date…
What is the COUPNUM Function? The COUPNUM Function is a financial function. It helps calculate the number of coupon payments that we will receive from the settlement date of a bond to its maturity date. Formula =COUPNUM(settlement, maturity, frequency, [basis]) The COUPNUM function uses the following arguments: Settlement (required argument) – This is the settlement…
