Key Concepts
                    
                    
					
                        - Relative Valuation Intuition
 
            
                        - Trading Comps Steps
 
                        
                            - Selecting Comps
 
                            - Common Multiples
 
                            - Last-Twelve Months vs Forward
 
                            - Application
 
                        
                        - Transaction Comps
 
                        - Excess Cash
 
                    
                 
                
                
                
                
                    Relative Valuation
                    The value of an asset is compared to the values assessed by the market for similar or comparable assets
                    
                   
                        - Most asset valuations are relative
 
                       - Most equity valuations on Wall Street are relative valuations (approx. 85% of equity research)
 
                       - DCF valuations are often influenced by multiples
 
                       - Terminal value is often calculated using multiples
 
                       - Relative valuation is pricing not valuation.
 
                    
 
                    
                
                
                
                
                    Why Relative?
                    
                        - More likely to reflect market perceptions and moods
 
                        - Will always lead to significant number of securities that are undervalued or overvalued
 
                        - Tailors to portfolio managers (evaluation is relative)
 
                        - Require much less information
 
                    
                
                
            
                
                    What is a multiple?
                    Standardized estimate of price
                    
                    $Multiple=\frac{\text{What you are paying for an asset}}{\text{What you are getting in return}}$
                    
                    
                        - Numerator: MV of Equity or Enterprise Value
 
                        - Denominator
 
                        
                        - Revenues or Drivers
 
                        - Earnings
 
                        - Cash flow
 
                        - Book Value
 
                        
                    
                
                
                
                    Three Multiple Checks
                    
                        - Define the multiple
 
                        - Describe the multiple
 
                        - Apply the multiple
 
                    
                
                
                
                    Define the Multiple
                    
                        - Value and standardizing variable must be to same claimholder
 
                        - Multiple must be uniformly estimated for comparable assets
 
                    
                
                
                
                    Example:Price to earnings
                    
                    
                        - Price: Current or average?
 
                        - EPS: Most recent, trailing 12 month, forecast
 
                    
                
                
                
                    Describe the Multiple
                    
                    
                        - Average and standard deviation
 
                        - Median: can be more reliable depending on sample size and outliers
 
                        - How to deal with outliers?
 
                            - Throw out? Does this bias estimate?
 
                        - Multiples have skewed distributions
 
                    
                
                
                
                    Apply the multiple
                    
                        - What is a comparable firm?
 
                            - Same risk, growth, and cash flow characteristics
 
                        - Sampling trade-off:
 
                        - Small sample that are "just like you"
 - Large sample that are "mostly kinda like you"
 
                        - Conclude stock is under or over valued relative to comparable group. 
 
                    
                
                
                
                    Market Assumption
                    
                    Market is efficient on average but can be "off" when pricing individual assets.
                    
                
                
                
                    Relative Valuation Steps
                    
                        - Select comparable companies
 
                        - Pick which multiples you will use
 
                        - Pick timeframe (LTM vs forward)
 
                        - Select distributional statistics
 
                        - Apply statistic to corresponding metric to arrive at a value
 
                    
                
                
                
                    Selecting comparables
                    
                        - Ideally want to match on value drivers
 
                        - Almost always will be comparing apples to oranges
 
                        - Sources:
 
                        
                            - Equity research
 
                            - 10-K
 
                            - SIC code screens
 
                            - Mergent (other financial website)
 
                        
                        - Given list of possible comps, narrow based on nature of business and growth prospects (value drivers)
 
                    
                
                
                
                    Common Multiples
                    
                    
                        - Equity Multiples
 
                        - P/E ratio
 - PEG ratio
 - Price to book Ratio
 
                        - Enterprise Multiples
 
                        - EV/EBIT
 - EV/EBITDA
 - EV/Revenue
 
                    
                
                
                
                    P/E Ratio
                    $P/E=\frac{Share Price}{EPS}=\frac{Equity Value}{Net Income}$
                    
                    
                        - Issues:
 
                        - Requires similar capital structure
 - Relies on accounting profits
 
                        - Value drivers:
 
                        - PE=f(Payout Ratio, g, cost of equity)
 
                    
                
 
                
                    PEG Ratio
                    $PEG=\frac{PE ratio}{g}$
                    
                    
                        - Issues:
 
                        - Does not actually solve for g issue
 - Relationship is non-linear
 
                        - Value drivers:
 
                        - PEG=f(Payout Ratio, g, cost of equity)
 
                    
                
                 
                  
                    Price to book Ratio
                      
                    $P/BV=\frac{Equity Value}{Book Value of Equity}$
                      
                    
                        - Issues:
 
                        - BV can be negative
 - Still a historical cost
 
                        - Value drivers:
 
                        - Price to Book=f(ROE, g, cost of equity, payout ratio)
 
                    
                 
                
                   
                    EV/EBIT
                    $=\frac{Enterprise Value}{EBIT}$
                       
                    
                        - Removes leverage
 
                        
                        - Value drivers:
 
                        - EV/EBIT=f(rate of reinvestment, g, WACC, t)
 
                    
                   
                
                
                    EV/EBITDA
                    $=\frac{Enterprise Value}{EBITDA}$
                    
                    
                        - Removes leverage
 
                        - Useful if D&A is large 
 
                        - Value drivers:
 
                        - EV/EBITDA=f(rate of reinvestment, g, WACC, t, DA)
 
                    
                 
                  
                    EV/Sales
                    $=\frac{Enterprise Value}{Sales}$
                      
                    
                        - Assumes comparable cost structure
 
                        - Useful for negative earnings companies
 
                        - Value drivers:
 
                        - EV/Sales=f(after-tax operating margin,rate of reinvestment, g, WACC)
 
                    
                 
                
                
                    Other multiples
                    
                    
                        - EV/monthly subscribers
 
                        - EV/website hits
 
                    
                
                
                
                
                
                    Period of Measurement
                    
                        - Need to measure denominator
 
                        - Two common periods:
 
                        
                            - Last (trailing) twelve months
 
                            - Forward looking (estimate next year)
 
                        
                    
                
                
                
                
                
                
                    LTM Practice
                    
                   Find the LTM Sales, EBIT, and Net Debt for Microsoft (MSFT), Best Buy (BBY) , and Walt-Disney (DIS)
                
                
                
                    Select Statistic
                    
                    
                        - Most common is to use average
 
                        - Why might average be misleading?
 
                        - Median reduces impact of outliers
 
                        - Important to view/analyze the distribution
 
                    
                
                
                
                    Example 1: Apply the Multiple
                    Go Nuts trades at $30 a share and has 30 million shares outstanding. They had revenue of $1 billion, EBITDA of $200 million, Net income of $75 million and Net Debt of $200 million What is Go Nuts implied share price under each multiple? Are they overvalued/undervalued? What are the ratios for Go Nuts? 
                    
                    
                        
                            
                                | Peer Firm | 
                                EV/Sales | 
                                EV/EBITDA | 
                                P/E | 
                            
                        
                        
                            | Blue Star | 
                            1.0x | 
                            6.0x | 
                            15.0x | 
                        
                        
                            | Voodoo | 
                            2.0x | 
                            8.0x | 
                            19.0x | 
                        
                         
                            | Randy's | 
                            1.5x | 
                            6.5x | 
                            17.0x | 
                        
                        
                            | Donut Man | 
                            1.0x | 
                            5.8x | 
                            14.6x | 
                        
                        
                            | Average | 
                            1.4x | 
                            6.6x | 
                            16.4x | 
                        
                    
                
                
                 
                    Example 1: Solution
                                     
                        
                            
                                 | 
                                EV/Sales | 
                                EV/EBITDA | 
                                P/E | 
                            
                        
                        
                            | Average (from Peers) | 
                            1.4x | 
                            6.6x | 
                            16.4x | 
                        
                        
                            | Enterprise Value |                  
                            1.4x1000=1400 | 
                            6.6x200=1320 | 
                            N/A | 
                        
          
                        
                            | Equity Value | 
                            1400-200=1200 | 
                            1320-200=1120 | 
                            16.4*75=1230 | 
                        
                        
                            | Share Price |                  
                            1200/30=40 | 
                            1120/30=37.3 | 
                            1230/30=41 | 
                        
                        
                            | Overvalued |                  
                            No (30<40) | 
                            No (30<37.3) | 
                            No (30<41) | 
                        
 
                        
                            | Go Nuts Ratio | 
                            1100/1000=1.1x | 
                            1100/200=5.5x | 
                            900/75=12x | 
                        
                    
   
                    
                    
                
                     
                
                    Transaction Comps
                    
                    
                        - Transaction Value/ Target EBITDA
 
                        - TV/ Target Revenue
 
                        - TV/ Target EBIT
 
                        - Offer Price per share/ Target EPS
 
                        - Offer value/Target NI
 
                        
                    
                    
 
                    TV is EV and Offer Value is Equity Value in M&A context 
                
                
                
                    Transaction Comps Example
                    Your company has revenue of $20B, EBITDA of $6.5B, Net income of $5B, and net debt of $1B. There are currently 1B shares outstanding and the current stock price is $50. Given the information below what is the implied share price under each transaction comparable?
                    
                        
                            
                                | Transaction | 
                                TV/Revenue | 
                                TV/EBITDA | 
                                Offer Price/EPS | 
                            
                        
                        
                            | A | 
                            2.00 | 
                            8.00 | 
                            16.00 | 
                        
                                                
                            | B | 
                            3.00 | 
                            12.00 | 
                            20.00 | 
                        
                                                
                            | C | 
                            1.50 | 
                            11.00 | 
                            16.00 | 
                        
                                                
                            | D | 
                            2.50 | 
                            13.00 | 
                            18.00 | 
                        
                                                
                            | Mean | 
                            2.25 | 
                            11.00 | 
                            17.50 | 
                        
                    
                
                
                
                    Solution
 
                    
                        
                            
                                 | 
                                TV/Revenue | 
                                TV/EBITDA | 
                                Offer Price/EPS | 
                            
                        
                        
                            | Mean | 
                            2.25 | 
                            11.00 | 
                            17.50 | 
                        
                        
                        
                            | TV | 
                            2.25*20=45 | 
                            11*6.5=71.5 | 
                            N/A | 
                        
                        
                            | Offer Value | 
                            45-1=44 | 
                            71.5-1=70.50 | 
                            17.5*5=87.5 | 
                        
                          
                            | Offer Price | 
                            44/1=44 | 
                            70.5/1=70.50 | 
                            87.5/1=87.5 | 
                        
  
                          
                            | Overvalued? | 
                            Yes (50>44) | 
                            No (50<70.5) | 
                            No (50<87.5) | 
                        
  
                    
                
                
                
                    Excess Cash
                    Cash Holdings in excess of expected cash holdings
                    
                        - Use peer average Cash as a % of Total Assets as proxy for expected cash
 
                        - Excess cash is then the Max of Cash-Expected Cash and zero
 
                    
                    
                
                
                
                    Excess Cash Example
                    
                    Your firm has cash holdings of $29.5M and Total assets of $800M. You calculate that the average Cash as a % of TA for your peer firms is 8.9%. What is the level of excess cash for your firm?
                    =MAX(29.5-(800*.089),0)=0
                
                    What if Total Assets were $300M?
                    
                    =MAX(29.5-(300*.089),0)=2.8