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…
What is the Non-Directional Trading Strategies Template? The non-directional trading strategies template allows users to determine the profit when buying options. This template focuses on non-directional strategies that bet on the volatility of the market to create profit. These strategies usually include a combination of call and put options. The profit of the strategies depends…
What is the WEEKNUM Function? The WEEKNUM Function is an Excel DATE and TIME Function. It is often overlooked but can quite useful when utilized properly. Basically, the WEEKNUM function will return the week number of a specific date as per the calendar year. The function will return an integer that represents a week number…
What is the COVARIANCE.S Function? The COVARIANCE.S Function is categorized under Excel Statistical functions. It will calculate the sample covariance for two sets of values provided by a user. As a financial modeling analyst, the COVARIANCE.S function is very useful when we want to find the extent to which two assets move in tandem –…
