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…
What is the DEGREES Function? The DEGREES Function is an Excel Math and Trigonometry function. It will convert angles that are expressed in radians to degrees. DEGREES was introduced in MS Excel 2000. Although the function is not frequently used by financial analysts, it is important for those who want to master the full range of…
What is a Stock Index Future? Stock index futures, also referred to as equity index futures or just index futures, are futures contracts based on a stock index. Futures contracts are an agreement to buy or sell the value of the underlying asset at a specific price on a specific date. In this case, the…
Interest Rate Parity (IRP) Excel Calculator This interest rate parity (IRP) calculator can be used to calculate any of the components in the IRP equation. IRP shows the relationship between the exchange rate and interest rates of two countries. In order for currencies to be in equilibrium, this parity should hold. Below is a quick…
Bank Mixed Statement Ratio Calculator The Bank Mixed Statement Ratio Calculator can be used to determine a bank’s profitability and financial strength using items found on an income statement and balance sheet. This template includes the following ratios: Return on Assets (ROA) Ratio Return on Equity (ROE) Ratio Provision for Credit Losses (PCL) Ratio Net…
