Multiples Valuation Template
(in millions) (in millions) (in millions) (in millions)
Solution Legend
Downloaded data
Formula/Calculation/Analysis required
Peer Companies: Peer 1 Peer 2 Peer 3 Your Company
Ticker
PERIOD ENDING
From Income Statement and Balance Sheet
Balance Sheet
Insert Relevant Items here
Income Statement
Insert Relevant Items here
Calculated Multiples
EV/EBITDA Multiple
P/E Multiple
Market to Book Multiple
Price/Revenue Multiple
Your Company Valuation
Your Company
Enterprise Value based on EV/EBITDA multiple
Plus: Your Company Cash $0
Less: Your Company Interest-bearing debt $0
Total Equity value based on EBITDA
Shares Outstanding (millions) –
Equity value per share
Equity value per share based on P/E multiple
Total Equity value based on P/E multiple
Plus: Your Company Interest-bearing debt $0
Less: Your Company Cash and equivalents $0
Enterprise value based on P/E multiple
Equity value per share based on MTB Ratio
Total Equity value based on MTB ratio
Plus: Your Company Interest-bearing debt1. Choose peer companies for your company (Exxon Mobil) and download their relevant financial data. You don’t have to download entire financial statements ” only the items used in multiples valuation
2. Using approach similar to the one described in this module’s Excel file, find valuation multiples (ratios) of peer companies.
3. Estimate your company’s equity value and enterprise value
I suggest starting from the “Multiples Valuation Template” in Module 4 Excel file and adjust it accordingly