What is the NUMBERVALUE Function? The NUMBERVALUE Function is categorized under Excel TEXT functions. It will convert a text string into a number in a locale-independent manner. The function was added in MS Excel 2013 and not available in earlier versions. Formula =NUMBERVALUE(Text,[decimal_separator],[group_separator]) The NUMBERVALUE function uses the following arguments: Text (required argument) – This…
What is the EFFECT Function? The EFFECT Function is categorized under Excel Financial functions. It will calculate the annual interest rate with the number of compounding periods per year. The effective annual interest rate is often used to compare financial loans with different compounding terms. As a financial analyst, we often need to make decisions…
What is the T.INV.2T Function? The T.INV.2T Function is categorized under Excel Statistical functions. It will calculate the two-tailed Student’s T-Distribution. The Student’s T-Distribution is a continuous probability distribution that is frequently used for testing hypotheses on small sample data sets. In financial analysis, T.INV.2T is often used in examining the risk-return relationship of a portfolio. The…
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…
