Cost of Preferred Stock Calculator
Cost of Preferred Stock Calculator This cost of preferred stock calculator shows you how to calculate the cost of preferred stock given the dividend, stock price, and growth rate. Below is a screenshot of the cost of preferred stock calculator: Download the Free Template The cost of preferred stock to the company is effectively the...
Expected Return Template
Expected Return Template This expected return template will demonstrate the calculation of expected return for a single investment and for a portfolio. Below is a screenshot of the expected return template: Download the Free Template The expected return of an investment is the expected value of the probability distribution of possible returns it can provide...
Comparable Company Analysis Template
Comparable Company Analysis Template This comparable company analysis template demonstrates how to compute and compare the valuation ratios of industry competitors. Below is a screenshot of the comparable company analysis template: Download the Free Template Comparable company analysis (or “comps” for short) is a valuation methodology that looks at ratios of similar public companies and uses them...
Exchange Ratio Template
Exchange Ratio Template This exchange ratio template shows you how to calculate an exchange ratio using the offer price for the target’s shares and the acquirer’s share price. Here is a screenshot of the exchange ratio template: Download the Free Template In mergers and acquisitions (M&A), the share exchange ratio measures the number of shares the acquiring...
EV/EBITDA Template
EV/EBITDA Template This EV/EBITDA template guides you through the calculation of EV/EBITDA using figures from an Income Statement. Below is a preview of the EV/EBITDA template: Download the Free Template Download CFI’s Excel template to advance your finance knowledge and perform better financial analysis. EV/EBITDA is a ratio that looks at a company’s Enterprise Value (EV) and...
