logo about writing tools
teaching data blog



Company Valuations - Spring 2015


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. 3M: Pre-crisis valuation
  3. 3M: Post-crisis valuation
  4. S&P 500: A Dividend Discount Model Valuation
  5. S&P 500: Dividends augmented with buybacks
  6. S&P 500: Dividends augmented with buybacks, fundamental growth
  7. Amazon.com in January 2000: A Valuation of a Company on the Dark Side
  8. Amazon.com in January 2001
  9. Hormel Foods (Status Quo vs Optimal value, Optimal capital structure)
  10. Sears: A company in decline
  11. Las Vegas Sands: Valuing a company in distress and estimating default probability
  12. Embraer: Valuation of an emerging market company with significant international sales
  13. Tube Investments: A Two-stage FCFF Valuation
  14. Tube Investments: Higher Marginal Return on Capital
  15. Tube Investments: Higher Return on Capital (both existing assets and marginal)
  16. The Tata Group: Tata Steel, Tata Chemicals, Tata Motors, Tata Consulting Services (TCS)
  17. ABN Amro: A Two-stage Dividend Discount Model Valuation
  18. Goldman Sachs: A Three-Stage Dividend Discount Model Valuation
  19. Wells Fargo: Valuing a bank in the middle of a banking crisis
  20. Deutsche Bank: A FCFE model for a bank
  21. Amgen: The R&D Adjustment
  22. Toyota: Valuing a cyclical company with normalized earnings
  23. Exxon Mobil: Valuing a commodity company

Relative Valuations

To be added

Private company Valuations

To be added

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

To be added

Value Enhancement

To be added