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…
What is the DMIN Function? The DMIN Function is categorized under Excel Database functions. The function helps find the minimum value for a specific field/column in a database for selected records based on user-specified criteria. DMIN will return a numerical value. It was introduced in MS Excel 2000. Formula =DMIN(database, field, criteria) The DMIN function…
What is the NOMINAL Function? The NOMINAL Function is categorized under Excel Financial functions. The function will return the nominal annual interest rate when the effective rate and number of compounding years are given. In financial analysis, we often evaluate more than one bond and hence are interested in knowing the net return offered by…
