This web page is designed to support "Investment Valuation", the second edition. The publisher is John Wiley and Sons. You can navigate the site by either going to individual chapters and getting supporting material by chapter, or by going to the supporting material directly. The supporting material includes:
- Chapter Outlines and overheads: These are saved as pdf files, and you need Adobe Acrobat to read them. You can download Adobe Acrobat by going to the Adobe site. (www.adobe.com) The overheads are categorized by topic, rather than chapter. To go to overheads, click here.
- Derivations and Discussion: These represent interesting questions that often come up in the context of the specified topic, with discussions and analyses.
- Readings: These are readings from business and academic publications that supplement the specific topic.
- Solutions: The solutions to each chapter are at the end of each chapter in the web site below.
- Powerpoint Presentations: These are power point presentations that are designed for use by instructors. You will need the password to download these as well.
- Spreadsheets: These are spreadsheets that supplement the topic. They are in Microsoft Excel 95 format, and can be used on either a Mac or Windows system.
- Datasets: These are useful datasets to supplement each chapter. They generally include industry averages for key variables and represent updates on many of the tables in the book.
- Web Casts: These are webcasts of the lectures from the valuation class that I teach at Stern. You can use the lecture notes and the text book to follow the lectures.
You can read the preface to the book by clicking here. If you are an instructor using this book, click here .
You can pick the chapter that you would like to go to, to see illustrations, solutions and other supporting material.
Chapter 1 | Chapter 2 | Chapter 3 | Chapter 4 | Chapter 5 | Chapter 6 |
Chapter 7 | Chapter 8 | Chapter 9 | Chapter 10 | Chapter 11 | Chapter 12 |
Chapter 13 | Chapter 14 | Chapter 15 | Chapter 16 | Chapter 17 | Chapter 18 |
Chapter 19 | Chapter 20 | Chapter 21 | Chapter 22 | Chapter 23 | Chapter 24 |
Chapter 25 | Chapter 26 | Chapter 27 | Chapter 28 | Chapter 29 | Chapter 30 |
Chapter 31 | Chapter 32 | Chapter 33 | Chapter 34 | Chapter 35 |
Or you can pick the material that you are interested in.
Chapter 1: Introduction to Valuation
Chapter 2: Approaches to Valuation
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 2.1: Effects of mismatching cashflows and discount rates Illustration 2.2. The potential for misuse with comparable firms |
Data Sets | |
Spreadsheets | |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 3: Understanding Financial Statements
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 3.1: Asset Values for Boeing and the Home Depot |
Data Sets | mgnroc.xls: Operating margins, turnover ratios and returns on capital of firms in the United States, classified by industry. rocroe.xls: Return on capital, debt equity ratios, book interest rates and returns on equity of firms in the United States, classified by industry. wcdata.xls: Working capital ratios for firms in the United States, classified by industry. covratio.xls: Interest coverage and fixed charge coverage ratios for firms in the United States, classified by industry. dbtfund.xls: Book value debt ratios and market value debt ratios for firms in the United States, classified by industry. |
Spreadsheets | finratio.xls: Compute the profitability ratios for a firm, based upon financial statement data. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 4: The Basics of Risk
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 4.1: Calculation of standard deviation using historical returns: Boeing and the Home Depot |
Data Sets | optvar.xls: There is a dataset on the web that summarizes standard deviations and variances of stocks in various sectors in the United States |
Spreadsheets | |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 5: Option Pricing Theory and Models
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 5.1: Binomial Option Valuation |
Data Sets | optvar.xls: There is a dataset on the web that summarizes standard deviations and variances of stocks in various sectors in the United States |
Spreadsheets | optst.xls: This spreadsheet allows you to estimate the value of a short term option, when the expected dividends during the option life can be estimated. optlt.xls: This spreadsheet allows you to estimate the value of an option, when the underlying asset has a constant dividend yield. bstobin.xls: This spreadsheet allows you to estimate the parameters for a binomial model from the inputs to a Black-Scholes model. warrant.xls: This spreadsheet allows you to estimate the value of an option, when there is a potential dilution from exercise. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
Chapter 6: Market Efficiency - Definition, Tests and Evidence
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 6.1: Example of an event study - Effects of Option Listing on Stock prices |
Answers to Concept Checks/ Critical Thinking | Concept Checks |
Data Sets | |
Spreadsheets | |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 7: Riskless Rates and Risk Premiums
Topic | Details |
Overheads | Download as pdf file |
Illustrations | |
Answers to Concept Checks/ Critical Thinking | Concept Checks |
Data Sets | histretSP.xls: Summarizes historical returns on stocks, T.Bonds and T.Bills going back to 1926. ratings.xls: This dataset includes default spreads for bonds in different ratings classes. ctryprem.xls: Contains the updated ratings for countries and the risk premiums associated with each. histimpl.xls: Shows the inputs used to calculate the premium in each year for the U.S. market. |
Spreadsheets | implprem.xls: This spreadsheet allows you to estimate the implied equity premium in a market. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 8: Estimating Risk Parameters and Costs of Financing
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 8.1: Estimating a Regression Beta for Boeing |
Data Sets | betas.xls: Updated betas and unlevered betas by business sector in the United States. spearn.xls: Earnings changes, by year, for the S&P 500 going back to 1960. wacc.xls: Costs of debt, costs of equity, debt ratios and costs of capital, by industry group, for firms in the United States. |
Spreadsheets | accbeta.xls: Estimate the accounting beta on a division or firm. risk.xls.Run a regression of stock returns against market returns and estimate risk parameters. levbeta.xls.Estimate the unlevered beta for a firm and compute the betas as a function of the leverage of the firm. ratings.xls: This spreadsheet allows you to estimate the synthetic rating and cost of debt for any firm. oplease.xls: This spreadsheet allows you to convert operating lease expenses into debt. wacccalc.xls: This spreadsheet allows you to convert book values of debt into market values. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 9: Measuring Earnings
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 9.1: Updated Earnings for Ariba: June 2000 |
Data Sets | |
Spreadsheets | R&Dconv.xls: This spreadsheet allows you to convert R&D expenses from operating to capital expenses. oplease.xls: This spreadsheet allows you to convert operating lease expenses into debt. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 10: From Earnings to Cashflows
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 10.1: Effect of Tax Rate assumptions on value |
Data Sets | taxrate.xls: There is a dataset on the web that summarizes average effective tax rates by industry group in the United States for the most recent quarter. |
Spreadsheets | R&Dconv.xls: This spreadsheet allows you to convert R&D expenses from operating to capital expenses. oplease.xls: This spreadsheet allows you to convert operating lease expenses into debt. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 11: Estimating Earnings Growth
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 11.1: Differences between Arithmetic and Geometric Averages: Motorola |
Data Sets | histgr.xls: There is a dataset on the web that summarizes historical growth rates in earnings and revenues by industry group for the United States. fundgrEB.xls: There is a dataset on the web that summarizes reinvestment rates and return on capital by industry group in the United States for the most recent quarter. margins.xls: This dataset on the web summarizes operating margins, by industry, for the United States. |
Spreadsheets | chgrowth.xls: This spreadsheet allows you to estimate the expected growth rate in operating income for a firm where the return on capital is expected to change over time. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 12: Closure in Valuation: Estimating Terminal Value
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 12.1: Length of High Growth Period |
Data Sets | betas.xls: This dataset on the web summarizes the average levered and unlevered betas, by industry group, for firms in the United States. eva.xls: This dataset on the web summarizes the returns on capital (equity), costs of capital (equity) and excess returns, by industry group, for firms in the United States. wacc.xls: This dataset on the web summarizes the debt ratios and costs of debt, by industry group, for firms in the United States. divfund.xls: This dataset on the web summarizes retention ratios, by industry group, for firms in the United States. capex.xls: This dataset on the web summarizes the reinvestment rates, by industry group, for firms in the United States. |
Spreadsheets | impliedROC.xls: Solves for the return on capital implied in terminal value assumptions about growth and reinvestment. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 13: Dividend Discount Models
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 13.1: Value a regulated firm: Consolidated Edison in May 2001 |
Data Sets | divfund.xls: This dataset on the web summarizes retention ratios, by industry group, for firms in the United States. |
Spreadsheets | DDMst.xls: This spreadsheet allows you to value a stable growth firm, with stable firm characteristics (beta and retun on equity) and dividends that roughly match cash flows. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 14: Free Cashflow to Equity Discount Models
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 14.1: Estimating Free Cash Flows to Equity – The Home Depot and Boeing |
Data Sets | divfcfe.xls: There is a dataset on the web that summarizes dividends, cash returned to stockholders and free cash flows to equity, by sector, in the United States. |
Spreadsheets | dividends.xls: This spreadsheet allows you to estimate the free cash flow to equity and the cash returned to stockholders for a period of up to 10 years FCFEst.xls: This spreadsheet allows you to value the equity in a firm in stable growth, with all of the inputs of a stable growth firm FCFE2st..xls: This spreadsheet allows you to value a firm with a temporary period of high growth in FCFE, followed by stable growth FCFE3st..xls: This spreadsheet allows you to value a firm with a temporary period of high growth in FCFE, followed by a transition period, followed by stable growth |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 15: Valuing a Firm: Free Cashflow to Firm and APV Models
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 15.1: Valuing a firm with a stable growth FCFF Model: Tube Investments of India (TI) |
Data Sets | betas.xls: Updated betas and unlevered betas by business sector in the United States. ratings.xls: This dataset includes default spreads for bonds in different ratings classes. wacc.xls: Costs of debt, costs of equity, debt ratios and costs of capital, by industry group, for firms in the United States. |
Spreadsheets | fcffginzu.xls: This spreadsheet allows you to estimate the value of a firm using the FCFF approach. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 16: Estimating Equity Value Per Share
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 16.1: Consolidated versus Separate Valuation Illustration 16.2: Cash Invested at below market rates Illustration 16.3: Discount for Poor Investments in the Future Illustration 16.4: Microsoft's cash and marketable securities Illustration 16.5: Valuing a closed-end fund Illustration 16.6: Valuing Holdings in other company Illustration 16.7: Fully Diluted Approach to estimating Value per Share: Commerce One Illustration 16.8: Treasury Stock Approach: Commerce One Illustration 16.9: Option Value Approach: Commerce One |
Answers to Concept Checks/ Critical Thinking | Concept Checks |
Data Sets | cash.xls: There is a dataset on the web that summarizes the value of cash and marketable securities by industry group in the United States for the most recent quarter. |
Spreadsheets | warrants.xls: This spreadsheet allows you to value the options outstanding in a firm, allowing for the dilution effect. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 17: Fundamental Principles of Relative Valuation
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 17.1: Comparing PE ratios and growth rates across firms: Beverage Companies |
Data Sets | |
Spreadsheets | |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
Chapter 18: Earnings Multiples
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 18.1: Estimating the PE ratio for a high growth firm in the two-stage model |
Data Sets | pedata.xls: There is a dataset on the web that summarizes price earnings ratios and fundamentals by industry group in the United States for the most recent year vebitda.xls: There is a dataset on the web that summarizes value to earnings multiples and fundamentals by industry group in the United States for the most recent year |
Spreadsheets | eqmult.xls: This spreadsheet allows you to estimate the price earnings ratio for a stable growth or high growth firm, given its fundamentals. firmmult.xls: This spreadsheet allows you to estimate firm value multiples for a stable growth or high growth firm, given its fundamentals. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 19: Book Value Multiples
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 19.1: Estimating the PBV ratio for a stable firm - Volvo |
Data Sets | pbvdata.xls: There is a dataset on the web that summarizes price to book and value to book multiples and fundamentals by industry group in the United States for the most recent year |
Spreadsheets | eqmult.xls: This spreadsheet allows you to estimate the price to book ratio for a stable growth or high growth firm, given its fundamentals. firmmult.xls: This spreadsheet allows you to estimate firm value multiples for a stable growth or high growth firm, given its fundamentals. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 20: Revenue and Sector-specific Multiples
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 20.1: Estimating the PS ratio for a high growth firm in the two-stage model |
Data Sets | psdata.xls: There is a dataset on the web that summarizes price to sales and value to sales ratios and fundamentals by industry group in the United States for the most recent year. |
Spreadsheets | eqmult.xls: This spreadsheet allows you to estimate the price to sales ratio for a stable growth or high growth firm, given its fundamentals. firmmult.xls: This spreadsheet allows you to estimate firm value multiples for a stable growth or high growth firm, given its fundamentals. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 21: Valuing Financial Services Firms
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 21.1: Stable Growth Dividend Discount Model – Citigroup |
Data Sets | |
Spreadsheets | eqexret.xls: Estimates the value of a financial service firm from the expected excess returns in the future. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 22: Valuing Firms with Negative Earnings
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 22.1: Normalizing Earnings for a Firm after a Poor Year: Daimler Benz in 1995 |
Data Sets | dbtfund.xls: There is a dataset on the web that summarizes book and market value debt ratios by industry group in the United States for the most recent year |
Spreadsheets | normearn.xls: This spreadsheet allows you to normalize the earnings for a firm, using a variety of approaches |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 23: Valuing Young and Start-up Firms
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 23.1: Commerce One: Last Financial Year versus Trailing 12 Months |
Data Sets | |
Spreadsheets | higrowth.xls: Values a high growth firm, based on revenue growth and target margins. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 24: Valuing Private Firms
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 24.1: Estimating Accounting Betas –– InfoSoft |
Data Sets | |
Spreadsheets | liqdisc.xls: This spreadsheet allows you to estimate the illiquidity discount on a private firm. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings | Restricted stock discounts |
Chapter 25: Acquisitions and Takeovers
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 25.1: A Status Quo Valuation of Digital |
Data Sets | |
Spreadsheets | synergy.xls: This spreadsheet allows you to estimate the approximate value of synergy in a merger or acquisition. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 26: Valuing Real Estate
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 26.1: Valuing an office building |
Data Sets | |
Spreadsheets | reval.xls: Values a income-generating real estate properties. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 27: Valuing Other Assets
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 27.1: Valuing a New York City Cab Medallion: June 1994 |
Data Sets | |
Spreadsheets | |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 28: The Option to Delay and Valuation Implications
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 28.1: Valuing the Option to Delay a Project |
Data Sets | optvar.xls: Standard deviations in firm value and equity value by industry group in the United States |
Spreadsheets | delay.xls: Estimate the value of an option to delay an investment. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 29: The Option to Expand and Abandon: Valuation Implications
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 29.1: Valuing an Option to Expand: Ambev and Guarana |
Data Sets | optvar.xls: Standard deviations in firm value and equity value by industry group in the United States |
Spreadsheets | expand.xls: This spreadsheet allows you to estimate the value of the option to expand a project to cover new markets or new products, using the Black-Scholes model. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 30: Valuing Equity in Distressed Firms
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 30.1: Valuing Equity as an Option |
Data Sets | optvar.xls: Standard deviations in firm value and equity value by industry group in the United States |
Spreadsheets | equity.xls: Estimate the value the equity in a troubled firm as an option. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 31: Value Enhancement: A Discounted Cashflow Perspective
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 31.1: Potential for value creation from divestiture: Boeing |
Data Sets | cfbasics.xls: There is a dataset on the web that summarizes operating margins, tax rates and non-cash working capital as a percent of revenues by industry group for the United States. |
Spreadsheets | valenh.xls: This spreadsheet allows you to estimate the approximate effect of changing the way a firm is run on its value. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 32: Value Enhancement: EVA, CFROI and Other Tools
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 32.1: Discounted Cashflow Value and Economic Value Added |
Data Sets | eva.xls: Firm and Equity EVAs by industry group for the United States |
Spreadsheets | fcffeva.xls: This spreadsheet allows you to convert a discounted cash flow valuation into an EVA valuation and vice versa |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
|
Chapter 33: Valuing Fixed Income Securities
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 33.1: Valuing a straight bond at issue |
Data Sets | optvar.xls: Standard deviations in firm value and equity value by industry group in the United States |
Spreadsheets | bondval.xls: Estimates the value of a straight bond |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
Chapter 34: Valuing Futures Contracts
Topic | Details |
Overheads | Download as pdf file |
Illustrations | Illustration 34.1: Futures versus Forward Contracts - Gold Futures Contract |
Data Sets | |
Spreadsheets | commfuture.xls: Estimates fair price for a storable commodity future |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions | |
Readings |
Chapter 35: Overview and Conclusions
Topic | Details |
Overheads | Download as pdf file |
Illustrations | |
Data Sets | |
Spreadsheets | model.xls: Chooses the right model to value your firm. |
Solutions to Problems | Download as pdf file |
Estimation Issues and Questions |
|
Readings |
Overheads
Topic | Chapters |
Introduction to Valuation | Chapter 1-2 |
Discounted Cashflow Valuation: Estimating Inputs | Chapter 3,4,6-12, 16 |
Discounted Cashflow Valuation: Examples | Chapter 13-15, 21-23 |
Relative Valuation | Chapters 17-20 |
Valuing Private Companies | Chapter 24 |
Option Applications in Valuation | Chapter 28-30 |
Valuing Acquisitions | Chapter 25 |
Value Enhancement | Chapter 31-32 |
Closing thoughts | Chapter 35 |
Estimation Issues and Questions
1 | 2 | 3 | 4 | 5 | 6 | |
7 | 8 | 9 | 10 | 11 | 12 | |
13 | 14 | 15 | 16 | 17 | 18 | |
19 | 20 | 21 | 22 | 23 | 24 | |
25 | 26 | 27 | 28 | 29 | 30 | |
31 | 32 | 33 | 34 | 35 | ||
Posted by: juanjuanhinzeer10264953.blogspot.com
Source: https://pages.stern.nyu.edu/~adamodar/New_Home_Page/Inv2ed.htm
0 Comments