Company ValuationsThese are excel spreadsheets with the valuations that are included in the lecture notes. Feel free to download them and have fun changing the inputs or updating the information
Con
Ed: A Stable Growth Dividend Discount Valuation
ABN Amro: A
Two-stage Dividend Discount Model Valuation
S&P 500:
A Conservative Dividend Valuation
S&P 500:
An Optimistic FCFE Valuation
Sony: A Stable
Growth FCFE Valuation
Nestle: A
Two-stage FCFE Valuation
Nestle:
Valuation after New Information
Tsingtao
Breweries: Valuation with Changing ROE...
Brahma: A Three-stage
FCFE Valuation
Brahma:
An Updated Valuation
Daimler Chrysler:
A Stable Growth FCFF Valuation
Tube Investments:
A Two-stage FCFF Valuation
Tube
Investments: Higher Marginal Return on Capital
Tuble
Investments: Higher Return on Capital (both existing assets and marginal)
The Home Depot:
An Operating Lease Adjusted Valuation
Bristol Myers:
An R&D Adjusted Valuation
Amazon.com
in January 2000: A Valuation of a Company on the Dark Side
Amazon.com
in January 2001
PE and Fundamentals
Developed
Market PE Ratios: 2000
Emerging Market
PE Ratios: 2000
US Market
PE Ratios: 1960-2000
Beverage
Companies
Global Telecommunication
firms
PEG Ratios
and Fundamentals
Beverage
Company PEG Ratios
Relative
PE and Fundamentals
Auto firm
Relative PE ratios
Value/EBITDA
and Fundamentals
Trucking
Company Value/EBITDA Multiples
PBV Ratio
and Fundamentals
Oil Company
PBV Ratios: 2000
Large Cap
PBV Ratios
Bank PBV
Ratios
IBM: PBV and
ROE
Value/Book
and Fundamentals
PS Ratios and
Fundamentals
Greek
Retailers PS ratios
Internet
Stock PS Ratios
Coca Cola:
Valuing a Brand Name
Value of Avonex: A Patent Valuation
Value of Financial Flexibility: Disney
Eurotunnel DCF Valuation
Eurotunnel Option Pricing Valuation
Valuing Digital (status quo)
Valuing Digital (optimally managed)
Valuing Compaq (stand-alone)
Valuing Compaq-Digital (no synergy)
Valuing Compaq-Digital (with synergy)
Valuing Compaq (status quo)
Valuing Compaq (restructured)
Valuing Telecom Italia (status quo)
Valuing Telecom Italia (restructured
Compaq's optimal capital structure
Telecom Italia's optimal capital structure