What is a Bull Put Spread? A bull put spread, which is an options strategy, is utilized by an investor when he believes the underlying stock will exhibit a moderate increase in price. A bull put spread involves purchasing an out-of-the-money (OTM) put option and selling an in-the-money (ITM) put option with a higher strike…
What is a Bull Call Spread? A bull call spread, which is an options strategy, is utilized by an investor when he believes a stock will exhibit a moderate increase in price. A bull spread involves purchasing an in-the-money (ITM) call option and selling an out-of-the-money (OTM) call option with a higher strike price but…
What is “Best Efforts”? In a securities offering, “best efforts” refers to a contractual term in which the underwriter promises to do the best it can to sell as much of a securities offering as possible. Understanding “Best Efforts” In a best efforts offering, not all securities are required to be sold. Generally, the underwriter…
The LOOKUP function in Excel retrieves a value from a one-row or one-column range. It performs a rough match lookup either vertically or horizontally. The vector form syntax is =LOOKUP(lookup_value, lookup_vector, [result_vector]), while the array form is =LOOKUP(lookup_value, array). Common applications include comparing rows or columns of data. The function handles simple lookups and returns…
What is the COUNT Function? The COUNT Function is an Excel Statistical function. This function helps count the number of cells that contain a number, as well as the number of arguments that contain numbers. It will also count numbers in any given array. It was introduced in Excel in 2000. As a financial analyst,…
What is the RANK Function? The RANK Function is categorized as an Excel Statistical function. The function returns the statistical rank of a given value within a supplied array of values. Thus, it determines the position of a specific value in an array. Formula =RANK(number,ref,[order]) The RANK function uses the following arguments: Number (required…
What is the NOT Function? The NOT Function is an Excel Logical function. The function helps check if one value is not equal to another. If we give TRUE, it will return FALSE and when given FALSE, it will return TRUE. So, basically, it will always return a reverse logical value. As a financial analyst,…
What is the ISODD Function? The ISODD Function is categorized under Excel Information functions. ISODD returns TRUE if the number is odd or FALSE if the number is even. It is a reference function that helps to indicate if a given number is odd or not. While doing financial analysis, we need to deal with…
What is the AVERAGEIF Function? The AVERAGEIF Function is an Excel Statistical function, which calculates the average of a given range of cells by a specific criterion. Basically, AVERAGEIF calculates central tendency, which is the location of the center of a group of numbers in a statistical distribution. The function was introduced in Excel 2007….
What is the TIMEVALUE Function? The TIMEVALUE Function is categorized under Excel DATE/TIME functions. TIMEVALUE helps us convert a text representation of a time to MS Excel time. In MS Excel, time is stored internally as a numerical value. It doesn’t recognize time in text form. Hence, the TIMEVALUE function allows us to convert the…
