Company Valuations

These 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

DCF Valuations

1. Con Ed: A Stable Growth Dividend Discount Valuation
2. ABN Amro: A Two-stage Dividend Discount Model Valuation
3. Goldman Sachs: A Three-Stage Dividend Discount Model Valuation
4. Deutsche Bank: A FCFE model for a bank
5. S&P 500: A Dividend Discount Model Valuation
6. S&P 500: Dividends augmented with buybacks
7. S&P 500: Dividends augmented with buybacks, fundamental growth
8. Tsingtao Breweries: Valuation with Changing ROE...
9. Toyota: Normaliziung Earnings
10. Tube Investments: A Two-stage FCFF Valuation
11. Tube Investments: Higher Marginal Return on Capital
12. Tube Investments: Higher Return on Capital (both existing assets and marginal)
13. KRKA: Valuing a company with a mix of country risk
14. Tata Steel
15. Tata Chemicals
16. Tata Motors
17. Tata Consulting Services (TCS)
18. Amazon.com in January 2000: A Valuation of a Company on the Dark Side
19. Amazon.com in January 2001
20. Amazon.com in July 2002
21. Amazon.com in October 2003
22. Amazon in 2011
23. Amgen: The R&D Adjustment
24. Sears: A company in decline
25. Las Vegas Sands: Valuing a company in distress and estimating default probability

Other valuations
Sony: A Stable Growth FCFE Valuation
Brahma: A Three-stage FCFE Valuation
Brahma: An Updated Valuation
The Home Depot: An Operating Lease Adjusted Valuation
Embraer: Valuation of an emerging market company with significant international sales
Hyundai Heavy: The cross holding effect

Relative Valuations

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

Option Pricing Applications in Valuation

Value of Avonex: A Patent Valuation
Value of Financial Flexibility: Disney
Eurotunnel DCF Valuation
Eurotunnel Option Pricing Valuation

Acquisition Valuation

Valuing Digital (status quo)
Valuing Digital (optimally managed)
Valuing Compaq (stand-alone)
Valuing Compaq-Digital (no synergy)
Valuing Compaq-Digital (with synergy)

Value Enhancement

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