Bloomberg Functions Spreadsheet
Bloomberg Functions Spreadsheet This Bloomberg functions spreadsheet contains a list of some of the most common and important functions, keystrokes and shortcuts to know on the Bloomberg Terminal. Below is a screenshot of the Bloomberg functions spreadsheet: Download the Free Template These Bloomberg functions will help you navigate the Bloomberg Terminal more efficiently for grabbing...
Efficient Frontier and CAL Template
Efficient Frontier and CAL Template This efficient frontier and CAL template demonstrates how to construct a portfolio frontier and CAL line chart to find the optimal portfolio. Below is a screenshot of the efficient frontier and CAL template: Download the Free Template The Efficient Frontier A portfolio frontier is a graph that maps out all...
Cost of Equity Calculator
Cost of Equity Calculator This cost of equity calculator helps you calculate the cost of equity given the risk-free rate, beta, and equity risk premium. This is what the cost of equity calculator looks like: Download the Free Template Cost of Equity is the rate of return a shareholder requires for investing equity into a business. The rate...
Beta Calculator
Beta Calculator This beta calculator allows you to measure the volatility of returns of an individual stock relative to the entire market. Below is a screenshot of the beta calculator: Download the Free Beta Calculator The beta (β) of an investment security (i.e. a stock) is a measurement of its volatility of returns relative to the...
Intrinsic Value Template
Intrinsic Value Template This intrinsic value template will demonstrate the calculation of intrinsic value using the discount rate method and the certainty factor method. Below is a screenshot of the intrinsic value template: Download the Free Template Download CFI’s free Excel template now to advance your finance knowledge and perform better financial analysis. The intrinsic...
