Multiples Analysis - Excel Model Template
Originally published: 25/06/2019 13:33
Last version published: 04/02/2020 15:00
Publication number: ELQ-29008-2
View all versions & Certificate

Multiples Analysis - Excel Model Template

This is WSO's free Excel model for Multiples Analysis and valuation

This Excel model is Wall Street Oasis’ free Multiples Analysis template. The template is made for the purpose of allowing you to create your own multiples analysis by comparing data against other companies' financial numbers. The plug-and-play template lets you put in your own data & formulae to auto-populate output numbers. The template also includes tabs for other elements of a financial model.

A transaction multiple is a financial metric used for company valuation in a buyout scenario. It is used as part of comparable company analysis (CCA) to evaluate the value of a business using the ratios of other, similar-sized businesses in the same industry. Multiples analysis, then, is an old valuation technique that determines the different market values of these comparable companies.

There are two main types of valuation multiples:
> Equity Multiples
> Enterprise Value Multiples

In this model, enter your data for price-to-revenue ratio, price-to-book value, price-to-earnings ratio, forward price-to-earnings, forward price-to-revenue etc. to achieve a final intrinsic value of the company you wish to value.

If you have any questions about this model, feel free to start a discussion below or send a private message via the Wall Street Oasis Eloquens channel.

If you have found it useful you are welcome to leave us a comment or a review!

This Best Practice includes
1 Multiples Analysis Excel model

Wall Street Oasis offers you this Best Practice for free!

download for free

Add to bookmarks


4.8 / 5 (14 votes)

please wait...