What is the WORKDAY.INTL Function? The WORKDAY.INTL Functionis categorized under Excel Date and Time functions. It is a robust modification of the WORKDAY function, as it works with customizable weekend parameters. WORKDAY.INTL will provide us with a date that is N working days in the future or in the past and allows us to determine…
What is the VARA Function? The VARA Function is categorized under Excel Statistical functions. VARA is very similar to the VAR function. It will calculate the sample variance of a given set of values. Variance is a statistical measure used across a set of values to identify the amount that the values vary from the…
What is the FORECAST.LINEAR Function? The FORECAST.LINEAR Function is categorized under Excel Statistical functions. It will calculate or predict a future value using linear regression. In financial modeling, the FORECAST.LINEAR function can be useful in calculating the statistical value of a forecast made. For example, if we know the past earnings and expenses that are…
What is the FORECAST Function? The FORECAST Function is categorized under Excel Statistical functions. It will calculate or predict a future value using existing values. In financial modeling, the FORECAST function can be useful in calculating the statistical value of a forecast made. For example, if we know the past earnings and expenses, we can…
What is the PERCENTRANK Function? The PERCENTRANK Function is categorized under Excel Statistical functions. This function will return the rank of a value in a data set as a percentage. It can be used to evaluate the relative standing of a value within a data set. In corporate finance, we can use PERCENTRANK to evaluate…
What is the PERCENTILE Function? The PERCENTILE Function is categorized under Excel Statistical functions. PERCENTILE will return the k-th percentile of the values in a particular range. In corporate finance, we can use the function to analyze, for example, the number of employees who scored above a certain percentile on a test. In MS Excel…
What are Closed-end Mutual Funds? Closed-end mutual funds are mutual funds that raise a fixed amount of capital from investors through an initial public offering (IPO) and lists its shares on a stock exchange. A closed-end mutual fund is overseen by a fund manager, trades similarly to securities, and is considered a publicly traded investment…
What are Open-end Mutual Funds? Open-end mutual funds refer to mutual funds that issue shares to investors based on the fund’s net asset value (NAV) per share. In an open-end mutual fund, investors purchase shares directly from the mutual fund at the net asset value (the value of the fund’s underlying securities) per share rather…
What is the UNICODE Function? The UNICODE Function is categorized under Excel Text functions. It will give the number (code point) for the first character of a supplied text string. The function was introduced in MS Excel 2013. Formula =UNICODE(text) The UNICODE Function requires the following argument: Text (required argument) – This is the…
What is the YIELD Function? The YIELD Function is categorized under Excel Financial functions. It will calculate the yield on a security that pays periodic interest. The function is generally used to calculate bond yield. As a financial analyst, we often calculate the yield on a bond to determine the income that would be generated…
