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 Download CFI’s Excel template to advance your finance knowledge and perform better financial analysis. Comparable company analysis (or “comps” for...
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...
WACC Calculator
WACC Calculator This WACC calculator helps you calculate WACC based on capital structure, cost of equity, cost of debt, and tax rate. Here is a preview of the WACC calculator: Weighted Average Cost of Capital (WACC) represents a company’s blended cost of capital across all sources, including common shares, preferred shares, and debt. The cost of...
EBITDA Multiple Template
EBITDA Multiple Template This EBITDA multiple template helps you find out the EBITDA multiple given the line items for determining the enterprise value. This is what the EBITDA multiple template looks like: Download the Free Template Download CFI’s Excel template to advance your finance knowledge and perform better financial analysis. The EBITDA multiple is a financial ratio...
