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...
Market Capitalization Template
Market Capitalization Template This market capitalization template helps you differentiate between market capitalization and enterprise value. This is what the market capitalization template looks like: Download the Free Template Market Capitalization (Market Cap) is the most recent market value of a company’s outstanding shares. The Market Cap is equal to the current share price multiplied by the number...
Price/Earnings to Growth Ratio Template
Price/Earnings to Growth Ratio Template This price/earnings to growth ratio template shows you the calculation of the PEG ratio given the share price, EPS, and EPS growth rate. Below is a screenshot of the PEG ratio template: Download the Free Template The PEG ratio is a company’s Price/Earnings ratio divided by its earnings growth rate...
Sharpe Ratio Table Template
Sharpe Ratio Table Template This Sharpe ratio table template demonstrates the calculation of the Sharpe ratio (using the arithmetic mean) given the expected portfolio return, risk-free rate, and standard deviation of the portfolio return. Below is a screenshot of the Sharpe ratio table template: Download the Free Template The Sharpe Ratio (or Sharpe Index) is...
