Fundamental analysisPortfolioStock ComparisonsStock investmentsStocksTechnical analysisValuation Models

Comparable Analysis Valuation Model (Equity Valuation)

Written by Meesha Ghedia
Wed May 05 2021
Comparable Analysis
See how MarketXLS helps you take advantage in the markets.
Download Option Templates →
Comparable Analysis
 

A comparable analysis valuation is a relative equity valuation technique used to compare the value of a company with metrics of other companies in the same industry. Equity valuation involves all the tools and techniques that allow investors to estimate the value of a company. It is calculated by multiplying the share price by the number of shares outstanding. The market equity value is different from the book equity value. The book value is the shareholders’ equity calculated by finding the difference between assets and liabilities. 

Equity valuation has two broad models, which include submodels within them. The two models are absolute and relative. Absolute valuation is estimated by calculating the present intrinsic value of a business by forecasting the future cash flows. The absolute valuation only calculates the values for one company; it does not compare the company with its competitors. Discounted cash flow and the discounted dividend model are examples of absolute valuation. Templates for both of these models are available through MarketXLS: 

Absolute vs Relative Valuation

Relative valuation models are the opposite of absolute valuation models because they calculate the value of a company by comparing it to other businesses. It explains that the company is a reflection of the worth of the companies it is compared to. So if the companies are worth five times their earnings, then the valued company will be worth five times too. Comparable analysis and precedent analysis valuation are examples of relative valuation models. Relative valuation is used more than absolute valuation because it is quick and easy to calculate. It also gives investors a starting point on whether they want to investigate more into the company. We will be focusing on the comparable analysis valuation model.

Comparable Analysis Valuation Model 

The first step of using a comparable analysis model is to choose one industry and then a group of companies within that industry. Creating a comparable analysis model is simple and using the MarketXLS template makes it easier. A valuation ratio is used to determine if the stock is overvalued or undervalued.

Comparable Analysis ValuationA comparable analysis allows you to use multiple metrics of your choice to make the best comparison between companies.

Metrics that the MarketXLS template uses are: 

  1. Annual Revenue: the total amount of money a company makes from all of its 12-month sales of goods or services.
  2. Enterprise Value (EV): measures the total value of a company and includes the market capitalization, the company’s cash on the balance sheet, along with the short and long-term debt. EV calculates how much a company’s takeover cost would be if an organization decided to buy every single share of the company. The calculation of EV = Market Cap +Debt +Preferred stock – Cash.
  3. Market Capitalization: refers to the total value of a company’s outstanding shares of stock. It is calculated by multiplying total outstanding shares with the current share price value of one stock. Like EV, a market cap helps us understand the relative size of a company compared to others. There are three main types of market cap companies: large-cap, medium-cap, and small-cap. Large-cap companies have a value of $10billion or more. Medium-cap companies value between $2billion and $10billion. Small-cap companies value between $300million and $2billion.The difference between enterprise value and market cap is that cash and debt are omitted when calculating market cap. This means that the market cap only gives an outer picture but not a detailed estimate. The company is undervalued and has more cash than debt if the EV is less than the market cap. If EV is more, then the company is overvalued and has more debt.
  4. Earnings before interest, taxes, depreciation, and amortization (EBITDA): are used to evaluate a company’s operating performance. The calculation of EBITDA = Net Income + Interest +Taxes +Depreciation + Amortization. GAAP or IFRS does not recognize EBITDA because EBITDA is said to be unreliable and misleading if used alone. EBITDA does not take into account the changes in working capital.
  5. Price-to-Earnings ratio – calculates the ratio of a company’s current share price to its earnings-per-share(EPS). There are two types of P/E ratios:
    1. Trailing P/E: calculates the ratio of current market value divided by the earnings-per-share of the previous 12 months. The Trailing PE ratio is more reliable than the forward PE because it is based on previous performances. The Forward ratio is an estimate, so the EPS would not be completely accurate. MarketXLS calculates this as trailing twelve months (TTM). 
    2. Forward P/E: uses future earnings to estimate the earnings-per-share for the next 12 months. The Forward P/E ratio is mostly used to make investment decisions on which stocks are likely to perform better in the coming year.

Using MarketXLS

MarketXLS offers a comparable analysis valuation template which calculates many metrics. All the investor has to do is input the symbols of the stocks they wish to compare. Link to the template: https://marketxls.com/template/comparable-analysis-valutation-model-r/    

 In conclusion, comparable analysis valuation is a great financial tool for investors to evaluate their target companies with their competitors. Along with the comparable analysis model, investors can use the other equity valuation models to analyze better and assess a firm’s worth.   

References

https://einvestingforbeginners.com/relative-valuation-daah/ 

https://www.thebalance.com/calculating-the-enterprise-value-of-a-company-357495 

https://www.fidelity.com/learning-center/trading-investing/fundamental-analysis/understanding-market-capitalization

Interested in building, analyzing and managing Portfolios in Excel?
Download our Free Portfolio Template
Download Option Templates

Top 100 Gainers Today

Top 100 losers Today

Real gdpReal personal consumption expReal private investmentReal govt expenditureReal net exportsReal exportsReal importsFederal receiptsFederal outlaysFederal surplus or deficitFederal debtReal private investment nonresidentialReal private investment residentialReal potential gdpReal personal incomeReal personal consumption exp monthlyRpce durable goodsRpce nondurable goodsRpce servicesPersonal savings rateMonetary baseCurrency in circulationBank reservesMoney supply m1Money supply m2Sp500DjiaWilshire indexVixFinancial stress indexCorporate bond index aaCorporate bond index bbbFederal funds rateTreasury rate 3mTreasury rate 1yTreasury rate 5yTreasury rate 10yTips 5yTips 10yBond yield aaaBond yield baaMortgage rate 15yMortgage rate 30yUs dollar weighted averageUsdollar to euroUsdollar to poundYuan to usdollarCanadiandollar to usdollarYen to usdollarCpiCpi wo food energyCpi foodCpi energyChain price indexChain price index wo food energyGdp price deflatorPpi final demandPpi finished goodsPpi materialPpi crude goodsPpi final demand wo food energyPpi finished goods wo food energyHouse price indexHouse price index 20cityCrude oil priceGasoline priceNatural gas priceIndustrial productionCapacity utilisationInventoriesSales retail foodVehicle sales light weightManufacture orders durablesManufacture orders capital goodsLoansConsumer credit outstandingCorporate profitsHousing startsBuilding permitsResidential constructionEmployees nonfarmEmployees privateEmployees goods producingEmployees service providingEmployees governmentUnemployment rateInitial cliamsAverage weeks unemployedJob openingsHiresSeparationsQuitsLayoffs dischargesHours of productionHourly earningsReal outputPopulationLabor forceLabor force participation rate
Search for a stock

Top MarketXLS Rank stocks

Rush Enterprises Inc. Class B Common Stock logo

Rush Enterprises Inc. Class B Common Stock

51.55
 
USD
 
1.94
 
(3.91%)
81
Rank
Optionable: No
Market Cap: 2,753 M
Industry: Auto & Truck Dealerships
52 week range    
35.64   
   57.55
Booz Allen Hamilton Holding Corporation logo

Booz Allen Hamilton Holding Corporation

92.84
 
USD
 
2.48
 
(2.74%)
81
Rank
Optionable: Yes
Market Cap: 11,592 M
Industry: Business Services
52 week range    
69.32   
   93.45
BWX Technologies Inc. logo

BWX Technologies Inc.

56.44
 
USD
 
1.35
 
(2.45%)
80
Rank
Optionable: Yes
Market Cap: 4,846 M
Industry: Aerospace & Defense
52 week range    
42.22   
   61.75
Ritchie Bros. Auctioneers Incorporated logo

Ritchie Bros. Auctioneers Incorporated

67.49
 
USD
 
2.43
 
(3.74%)
77
Rank
Optionable: Yes
Market Cap: 6,928 M
Industry: Business Services
52 week range    
48.44   
   75.28
Ituran Location and Control Ltd. logo

Ituran Location and Control Ltd.

24.33
 
USD
 
-0.16
 
(-0.65%)
77
Rank
Optionable: Yes
Market Cap: 504 M
Industry: Communication Equipment
52 week range    
19.49   
   29.33
General Mills Inc. logo

General Mills Inc.

75.79
 
USD
 
0.34
 
(0.45%)
76
Rank
Optionable: Yes
Market Cap: 42,311 M
Industry: Packaged Foods
52 week range    
55.38   
   75.96
CRA InternationalInc. logo

CRA InternationalInc.

89.15
 
USD
 
-0.17
 
(-0.19%)
76
Rank
Optionable: Yes
Market Cap: 646 M
Industry: Business Services
52 week range    
78.05   
   115.47
ConAgra Brands Inc. logo

ConAgra Brands Inc.

34.56
 
USD
 
0.32
 
(0.93%)
76
Rank
Optionable: Yes
Market Cap: 16,287 M
Industry: Packaged Foods
52 week range    
29.80   
   36.67
Agree Realty Corporation logo

Agree Realty Corporation

73.53
 
USD
 
1.40
 
(1.94%)
76
Rank
Optionable: Yes
Market Cap: 5,522 M
Industry: REIT - Retail
52 week range    
60.78   
   74.67
UNITIL Corporation logo

UNITIL Corporation

61.00
 
USD
 
2.28
 
(3.88%)
75
Rank
Optionable: Yes
Market Cap: 928 M
Industry: Utilities - Diversified
52 week range    
39.90   
   61.08

More Features

Stand with Ukraine

As the situation in Ukraine escalates, many of us in MarketXLS are left with emotions too overwhelming to name. If you’d like to show your support, but aren’t sure how to, we want to help make it easier for you to act.

For any amount donated, we’ll extend your MarketXLS subscription for double of the donated amount. Please send proof of your payment to support@marketxls.com to avail the extention

From all of us at MarketXLS, thank you!