 |
 |
 |
 |
 |
 |
 |
- Philosophy
- Topics & Setup
- Regular classes
- Executive programs
- Online Classes
- Seminars/Short sessions
- Other
If you did find the valuation seminar useful, I do have more work for you. In this page, I have links to spreadsheets containing all of the companies we valued during the sessions. Feel free to download them, examine them, change the inputs that you don't like and make them your own. I have also posted links to data that was updated during the session that you may want to use.
Valuations
DCF Inputs
| Topic | Read this... | Try this out | Data to review.. |
Rskfreee Rates |
|||
Equity Risk Premiums |
|||
| Betas and Lambdas | Measuring Company Risk Exposure to Country Risk (Lambda) | Levered Beta Estimator | Betas by Sector |
Cash Flows |
Lease converter R&D converter |
Lease effect on parameters by sector | |
Expected Growth |
Growth Estimator |
Historical growth rates by sector: US Fundamental growth rates by sector: US |
|
Terminal Value |
Terminal Value: The Tail that wags the DCF Dog? | Imputed ROIC in terminal value |
Value Enhancement
| Topic | Read this... | Try this out |
Value Enhancement: Big Picture |
||
Optimizing capital structure |
Optimizing the mix of debt and equity Finding the right type of financing |
Optimium financing mix calculator |
Buyback Effects |
Assessing the effect of a buyback (blog post) | Buyback effect on value Buyback effect on EPS |
Loose Ends in Valuation
| Topic | Read this... | Try this out |
The value of cash and cross holdings |
||
The cost of complexity |
Information Transparency and Value | Complexity score estimator |
The value of synergy |
Synergy valuation spreadsheet | |
The cost of distress |
Valuing Distressed companies | Distress probability estimator |
The cost of illiquidity |
Cost of Illiquidity | Liquidity discount estimator |
The value of control |
Control valuation spreadsheet | |
Management options and restricted
stock |
Dealing with Employee compensation in equity | Valuing management options |
Following up on DCF Valuation
- Picking the right model to value a business/company
- Probabilistic approaches in valuation (A guide to distributions, in case you decide to use Monte Carlo Simulations)
- Ten
closing thoughts on valuation
Relative Valuation
| Topic | Sector Data | Try this out |
Earnings Multiples |
Intrinsic Equity Multiple Estimator Intrinsic Firm Value Multiple Estimator |
|
Book Value Multiples |
||
Revenue Multiples |
Real Options
| Topic | Sector Data | Try this out |
Real options |
Reference Reading