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…
Bank Income Statement Ratio Calculator The Bank Income Statement Ratio Calculator can determine a bank’s profitability, efficiency, and growth through information found on an income statement. Using inputs such as operating expenses, net interest expenses, and net income, the calculator will produce ratios that are important for the analysis of a bank’s income statement. This…
Bank Balance Sheet Ratio Calculator The Bank Balance Sheet Ratio Calculator is a tool that you can use to determine a bank’s financial stability and liquidity using items found on a balance sheet. Using the inputs, the calculator will produce ratios that are important for the analysis of a bank’s balance sheet. This template includes…
What is the Oil and Gas Industry? The oil and gas industry, also known as the energy sector, relates to the process of exploration, development, and refinement of crude oil and natural gas. It is possible to invest in this industry directly and indirectly. An investor can choose to purchase the commodity using the spot…
What is the ROUNDDOWN Function? The ROUNDDOWN Function is categorized under Excel Math and Trigonometry functions. The function will round down towards zero. Basically, it does the opposite of the ROUNDUP function. As a financial analyst, this function is useful as it helps round a number and eliminates the least significant digits, simplifying the notation…
What is the ROUND Function? The ROUND Function is categorized under Excel Math and Trigonometry functions. The function will round up a number to a specified number of digits. Unlike the ROUNDUP and ROUNDDOWN functions, the ROUND function can round either up or down. As a financial analyst, this function is useful as it helps…
Put-Call Parity Excel Calculator This put-call parity calculator shows the relationship between a European call option, put option, and their underlying asset. By inputting information, you can see what any of these variables should be if this parity relationship were to be held. Below is a quick preview of CFI’s put-call parity calculator: Download the…
What is the RANDBETWEEN Function? The RANDBETWEEN Functionis categorized under Excel Math and Trigonometry functions. The function will return a random integer number between the user-specified numbers. It will return a random integer number every time the worksheet is opened or calculated. As a financial analyst, the RANDBETWEEN function can be used to generate random…
