• Class Material
  • Syllabus
  • Lecture Notes
  • Books
    • Investment Valuation, 3rd Ed
    • Damodaran on Valuation
    • The Dark Side of Valuation
    • The Little Book of Valuation
• Webcasts
  • NYU/Stern
  • Apple iTunes U
  • Yellowdig
  • YouTube
• The Projects
  • The "Big" Project
    • Project Description
    • Data for project
    • Past Projects
  • The Mystery Project
• Exams & Problems
  • Quiz Rules
  • Practice Problems
  • Past Quizzes and Exams
  • Quiz Reviews
• Add ins
  • In-class Valuations
  • Valuation of the week
  • Weekly Challenges
• In the loop
  • Calendar
  • Newsletters
  • Emails for the class
• Support
  • Data
  • Spreadsheets
  • Readings

 

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. Amazon.com in September 2018
10. Hormel Foods (Status Quo vs Optimal value, Optimal capital structure)
11. Sears: A company in decline
12. Las Vegas Sands: Valuing a company in distress and estimating default probability
13. Embraer: Valuation of an emerging market company with significant international sales
14. Tube Investments: A Two-stage FCFF Valuation
15. Tube Investments: Higher Marginal Return on Capital
16. Tube Investments: Higher Return on Capital (both existing assets and marginal)
17. The Tata Group: Tata Steel, Tata Chemicals, Tata Motors, Tata Consulting Services (TCS)
18. ABN Amro: A Two-stage Dividend Discount Model Valuation
19. Goldman Sachs: A Three-Stage Dividend Discount Model Valuation
20. Wells Fargo: Valuing a bank in the middle of a banking crisis
21. Deutsche Bank: A FCFE model for a bank
22. Amgen: The R&D Adjustment
23. Toyota: Valuing a cyclical company with normalized earnings
24. 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

Value Enhancement

To be added