What is the QUARTILE.EXC Function? The QUARTILE.EXC Function is categorized under Excel Statistical functions. It will return the quartile of a given data set based on percentile values from 0.1, exclusive. The function bases its calculation on a percentile range of 0 to 1, exclusive. As a financial analyst, QUARTILE.EXC can be used to find…
What is the SWITCH Function? The SWITCH Function is categorized under Excel’s Logical functions. This function will evaluate a given expression (or a value) against a list of values and will return a result corresponding to the first matching value. In case there is no matching value, an optional default value will be returned. SWITCH…
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…
