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:

EBITDA Multiple Template Screenshot

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 that compares a company’s Enterprise Value to its annual EBITDA (which can be either a historical figure or a forecast/estimate).  This multiple is used to determine the value of a company and compare it to the value of other, similar businesses.

A company’s EBITDA multiple provides a normalized ratio for differences in capital structure, taxation, fixed assets, and for comparing disparities of operations in various companies. The ratio takes a company’s enterprise value (which represents market capitalization plus net debt) and compares it to the Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) for a given period.

The formula for calculating EBITDA multiple is:  EBITDA Multiple = Enterprise Value / EBITDA

To Determine the Enterprise Value and EBITDA:

  • Enterprise Value = (market capitalization + value of debt + minority interest + preferred shares) – (cash and cash equivalents)
  • EBITDA = Earnings Before Tax + Interest + Depreciation + Amortization

More Free Templates

For more resources, check out our business templates library to download numerous free Excel modeling, PowerPoint presentation, and Word document templates.

Excel Tutorial

To master the art of Excel, check out CFI’s Excel Crash Course, which teaches you how to become an Excel power user. Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.

Launch CFI’s Excel Crash Course now to take your career to the next level and move up the ladder!

0 search results for ‘