What is the Excel CEILING Function? The Excel CEILING function is categorized under Math and Trigonometry functions. The function will return a number that is rounded up to a supplied number that is away from zero to the nearest multiple of a given number. MS Excel 2016 handles both positive and negative arguments. The function…
What are Interest Rate Futures? Interest rate futures are futures contracts based on interest-bearing financial instruments. This futures contract can be cash-settled or it can involve the delivery of the underlying security. Like other futures, this is an agreement for the long position to receive the interest earned on a notional amount and the short…
What is the FVSCHEDULE Function? The FVSCHEDULE Function is categorized under Excel Financial functions. It will calculate the future value of an investment with a variable interest rate. In financial analysis, we often need to make a decision on investments made by a company. Sometimes, we make investments that will guarantee a certain percentage for…
What is the NORMINV Function? The NORMINV Function is categorized under Excel Statistical functions. It will calculate the inverse of the normal cumulative distribution for the specified mean and standard deviation. Suppose we are given a normally distributed random variable that is denoted by x. For the value of x, if we wish to get…
What is the TBILLEQ Function? The TBILLEQ Function is categorized under Excel Financial functions. The function helps calculate the bond-equivalent yield of a T-bill. In financial analysis, if we wish to compare T-bills yields with bond yields, we can use TBILLEQ. Formula =TBILLEQ(settlement, maturity, discount) The TBILLEQ function uses the following arguments: Settlement (required argument) –…
What is a Collar Option Strategy? A collar option strategy, also referred to as a hedge wrapper or simply collar, is an options strategy employed to reduce both positive and negative returns of an underlying asset. It limits the return of the portfolio to a specified range and can hedge a position against potential volatility…
What is the Excel CONVERT units Function? The Excel CONVERT Function is an Excel Engineering Function. The function is useful for conversion of units from one measurement system to another measurement system. For example, CONVERT will help us to convert pounds to kilograms, feet to centimeters, or Fahrenheit to Celsius. Learn Excel unit conversion in…
What is the ISNONTEXT Function? The ISNONTEXT Function is categorized under Excel Information functions. The function helps to check if a cell contains text or not (is anything typed into a cell?). It will return TRUE if the value is text and if not, FALSE. For example, if the given value is a number, date,…
What is the ISNA Excel Function? The ISNA Excel Function is categorized under Information functions. This function helps in checking if a cell contains the #N/A! error. It will return a FALSE value for other types of errors. As a financial analyst, we deal with data and perform analysis on it. The ISNA function helps…
