What is the MDURATION Function? The MDURATION Function is categorized under Excel Financial functions. It will calculate the duration of a security using the Modified Macauley method. In financial analysis, we often evaluate a bond and develop a strategy that will match the duration of assets and liabilities. This is done to minimize the impact…
What is the BASE Function? The BASE Function is available under Excel Mathematical and Trigonometric functions. The function returns a text representation of the calculated value and will convert a number into the supplied base (radix). BASE was introduced in Excel 2013 and is unavailable in earlier versions. Formula =BASE(number, radix, [min_length]) The BASE function…
What is the ISPMT Function? The ISPMT Function is categorized under Excel Financial functions. The function will calculate the interest paid during a specific period of Investment. ISPMT is useful to a financial analyst as it helps predict interest payments while preparing revenue forecasts, annual budgets, etc. For example, suppose a business takes out a…
What is the MOD Function? The MOD Function is categorized under Excel Math and Trigonometry functions. The function helps find a remainder after a number (dividend) is divided by another number (divisor). As a financial analyst, the function is useful when we need to process every nth value. For example, if our data comprises several…
What is the NA Function? The NA Function is categorized under Excel Information functions. It will return the #N/A error value. N/A means “no value available” or “not available.” As a financial analyst, the NA function can be used to mark empty cells and thus avoid the inclusion of empty cells in the calculation. It…
What is the MROUND Function? The MROUND Function is categorized under Excel Math and Trigonometry functions. The function will return a number rounded to a multiple given by the user. MROUND will always round up away from zero. As a financial analyst, the MROUND function helps round a number and eliminate the least significant digits,…
What is the Excel LARGE Function? The Excel LARGE Function is categorized under Excel Statistical functions. The function will return the k largest value, sorted by value in descending order. As a financial analyst, the LARGE function can be used to sort information provided and find the maximum value, such as share price or rate of…
What is the HYPERLINK Function? The HYPERLINK Function is categorized under Excel Lookup and Reference functions. The function helps link data to multiple documents. What is a hyperlink? A hyperlink is a link created from a document that opens another page or file when a user clicks it. Often, the destination is another web…
What is the DMAX Function? The DMAX Function is categorized under Excel Database functions. The function helps find the maximum value for a specific field/column in a database for selected records based on user-specified criteria. DMAX will return a numerical value. It was introduced in MS Excel 2000. Formula =DMAX(database, field, criteria) The DMAX function…
What is the EVEN Function? The EVEN Function is classified as an Excel Math and Trigonometry function. It will round a specified number away from zero to the next even number. The function will round a positive number up and a negative number down. As a financial analyst, EVEN is a very useful function, as…
