Equity Valuation Spreadsheet Using Present Financial Statement by hjn19897


Equity Valuation Spreadsheet Using Present Financial Statement document sample

More Info
More information from http://www.researchandmarkets.com/reports/1205722/

Equity Asset Valuation, 2nd Edition

Description:    A comprehensive look at the equity valuation process

                With the Second Edition of Equity Asset Valuation, the distinguished team of Jerald Pinto, Elaine
                Henry, Thomas Robinson, and John Stowe, fully update information associated with this important
                discipline. Blending theory with practice, they detail the contemporary techniques used to
                determine the intrinsic value of an equity security, and show you how to successfully apply these
                techniques in both foreign and domestic markets.

                Unlike alternative works in this field, the Second Edition of Equity Asset Valuation clearly integrates
                finance and accounting concepts into the discussion-providing the evenness of subject matter
                treatment, consistency of notation, and continuity of topic coverage that is so critical to the
                learning process.

                - Addresses essential issues in this arena, including the equity valuation process, discounted
                dividend valuation, free cash flow valuation, and residual income valuation

                Each author brings his own unique experiences and perspectives to the equity analysis process

                - Distills the knowledge, skills, and abilities you need to succeed in today's fast-paced financial

                - Companion Workbook also available

                Valuable for classroom study, self-study, and general reference, this book contains clear, example-
                driven coverage of many of today's most important valuation issues.

Contents:       Foreword



                CHAPTER 1 - Equity Valuation: Applications and Processes
                Learning Outcomes
                1. Introduction
                2. Value Defi nitions and Valuation Applications
                2.1. What Is Value?
                2.1.1. Intrinsic Value
                2.1.2. Going-Concern Value and Liquidation Value
                2.1.3. Fair Market Value and Investment Value
                2.1.4. Defi nitions of Value: Summary
                2.2. Applications of Equity Valuation
                3. The Valuation Process
                3.1. Understanding the Business
                3.1.1. Industry and Competitive Analysis
                3.1.2. Analysis of Financial Reports
                3.1.3. Sources of Information
                3.1.4. Considerations in Using Accounting Information
                3.2. Forecasting Company Performance
                3.3. Selecting the Appropriate Valuation Model
                3.3.1. Absolute Valuation Models
                3.3.2. Relative Valuation Models
                3.3.3. Valuation of the Total Entity and Its Components
                3.3.4. Issues in Model Selection and Interpretation
3.4. Converting Forecasts to a Valuation
3.5. Applying the Valuation Conclusion: The Analyst’s Role and Responsibilities
4. Communicating Valuation Results
4.1. Contents of a Research Report
4.2. Format of a Research Report
4.3. Research Reporting Responsibilities
5. Summary

CHAPTER 2 - Return Concepts
Learning Outcomes
1. Introduction
2. Return Concepts
2.1. Holding Period Return
2.2. Realized and Expected (Holding Period) Return
2.3. Required Return
2.4. Expected Return Estimates from Intrinsic Value Estimates
2.5. Discount Rate
2.6. Internal Rate of Return
3. The Equity Risk Premium
3.1. Historical Estimates
3.1.1. Arithmetic Mean or Geometric Mean
3.1.2. Long-term Government Bonds or Short-term Government Bills
3.1.3. Adjusted Historical Estimates
3.2. Forward-Looking Estimates
3.2.1. Gordon Growth Model Estimates
3.2.2. Macroeconomic Model Estimates
3.2.3. Survey Estimates
4. The Required Return on Equity
4.1. The Capital Asset Pricing Model
4.1.1. Beta Estimation for a Public Company
4.1.2. Beta Estimation for Thinly Traded Stocks and Nonpublic Companies
4.2. Multifactor Models
4.2.1. The Fama-French Model
4.2.2. Extensions to the Fama-French Model
4.2.3. Macroeconomic and Statistical Multifactor Models
4.3. Build-up Method Estimates of the Required Return on Equity
4.3.1. Build-up Approaches for Private Business Valuation
4.3.2. Bond Yield Plus Risk Premium
4.4. The Required Return on Equity: International Issues
5. The Weighted Average Cost of Capital
6. Discount Rate Selection in Relation to Cash Flows
7. Summary

CHAPTER 3 - Discounted Dividend Valuation
Learning Outcomes
1. Introduction
2. Present Value Models
2.1. Valuation Based on the Present Value of Future Cash Flows
2.2. Streams of Expected Cash Flows
3. The Dividend Discount Model
3.1. The Expression for a Single Holding Period
3.2. The Expression for Multiple Holding Periods
4. The Gordon Growth Model
4.1. The Gordon Growth Model Equation
4.2. The Links among Dividend Growth, Earnings Growth, and Value Appreciation in the Gordon
Growth Model
4.3. Share Repurchases
4.4. The Implied Dividend Growth Rate
4.5. The Present Value of Growth Opportunities
4.6. Gordon Growth Model and the Price-to-Earnings Ratio
4.7. Estimating a Required Return Using the Gordon Growth Model
4.8. The Gordon Growth Model: Concluding Remarks
5. Multistage Dividend Discount Models
5.1. Two-Stage Dividend Discount Model
5.2. Valuing a Non-Dividend-Paying Company
5.3. The H-Model
5.4. Three-Stage Dividend Discount Models
5.5. Spreadsheet (General) Modeling
5.6. Estimating a Required Return Using Any DDM
5.7. Multistage DDM: Concluding Remarks
6. The Financial Determinants of Growth Rates
6.1. Sustainable Growth Rate
6.2. Dividend Growth Rate, Retention Rate, and ROE Analysis
6.3. Financial Models and Dividends
7. Summary

CHAPTER 4 - Free Cash Flow Valuation
Learning Outcomes
1. Introduction to Free Cash Flows
2. FCFF and FCFE Valuation Approaches
2.1. Defi ning Free Cash Flow
2.2. Present Value of Free Cash Flow
2.2.1. Present Value of FCFF
2.2.2. Present Value of FCFE
2.3. Single-Stage (Constant-Growth) FCFF and FCFE Models
2.3.1. Constant-Growth FCFF Valuation Model
2.3.2. Constant-Growth FCFE Valuation Model
3. Forecasting Free Cash Flow
3.1. Computing FCFF from Net Income
3.2. Computing FCFF from the Statement of Cash Flows
3.3. Noncash Charges
3.4. Computing FCFE from FCFF
3.5. Finding FCFF and FCFE from EBIT or EBITDA
3.6. FCFF and FCFE on a Uses-of-Free-Cash-Flow Basis
3.7. Forecasting FCFF and FCFE
3.8. Other Issues in Free Cash Flow Analysis
3.8.1. Analyst Adjustments to CFO
3.8.2. Free Cash Flow versus Dividends and Other Earnings Components
3.8.3. Free Cash Flow and Complicated Capital Structures
4. Free Cash Flow Model Variations
4.1. An International Application of the Single-Stage Model
4.2. Sensitivity Analysis of FCFF and FCFE Valuations
4.3. Two-Stage Free Cash Flow Models
4.3.1. Fixed Growth Rates in Stage 1 and Stage 2
4.3.2. Declining Growth Rate in Stage 1 and Constant Growth in Stage 2
4.4. Three-Stage Growth Models
5. Nonoperating Assets and Firm Value
6. Summary

CHAPTER 5 - Residual Income Valuation
Learning Outcomes
1. Introduction
2. Residual Income
2.1. The Use of Residual Income in Equity Valuation
2.2. Commercial Implementations
3. The Residual Income Model
3.1. The General Residual Income Model
3.2. Fundamental Determinants of Residual Income
3.3. Single-Stage Residual Income Valuation
3.4. Multistage Residual Income Valuation
4. Residual Income Valuation in Relation to Other Approaches
4.1. Strengths and Weaknesses of the Residual Income Model
4.2. Broad Guidelines for Using a Residual Income Model
5. Accounting and International Considerations
5.1. Violations of the Clean Surplus Relationship
5.2. Balance Sheet Adjustments for Fair Value
5.3. Intangible Assets
5.4. Nonrecurring Items
5.5. Other Aggressive Accounting Practices
5.6. International Considerations
6. Summary

CHAPTER 6 - Market-Based Valuation: Price and Enterprise Value Multiples
Learning Outcomes
1. Introduction
2. Price and Enterprise Value Multiples in Valuation
2.1. The Method of Comparables
2.2. The Method Based on Forecasted Fundamentals
3. Price Multiples
3.1. Price to Earnings
3.1.1. Alternative Defi nitions of P/E
3.1.2. Calculating the Trailing P/E
3.1.3. Forward P/E
3.1.4. Valuation Based on Forecasted Fundamentals
3.1.5. Valuation Based on Comparables
3.1.6. P/Es in Cross-Country Comparisons
3.1.7. Using P/Es to Obtain Terminal Value in Multistage Dividend Discount Models
3.2. Price to Book Value
3.2.1. Determining Book Value
3.2.2. Valuation Based on Forecasted Fundamentals
3.2.3. Valuation Based on Comparables
3.3. Price to Sales
3.3.1. Determining Sales
3.3.2. Valuation Based on Forecasted Fundamentals
3.3.3. Valuation Based on Comparables
3.4. Price to Cash Flow
3.4.1. Determining Cash Flow
3.4.2. Valuation Based on Forecasted Fundamentals
3.4.3. Valuation Based on Comparables
3.5. Price to Dividends and Dividend Yield
3.5.1. Calculation of Dividend Yield
3.5.2. Valuation Based on Forecasted Fundamentals
3.5.3. Valuation Based on Comparables
4. Enterprise Value Multiples
4.1. Enterprise Value to EBITDA
4.1.1. Determining Enterprise Value
4.1.2. Valuation Based on Forecasted Fundamentals
4.1.3. Valuation Based on Comparables
4.2. Other Enterprise Value Multiples
4.3. Enterprise Value to Sales
4.4. Price and Enterprise Value Multiples in a Comparable Analysis: Some Illustrative Data
5. International Considerations When Using Multiples
6. Momentum Valuation Indicators
7. Valuation Indicators: Issues in Practice
7.1. Averaging Multiples: The Harmonic Mean
7.2. Using Multiple Valuation Indicators
8. Summary

CHAPTER 7 - Private Company Valuation
Learning Outcomes
1. Introduction
2. The Scope of Private Company Valuation
2.1. Private and Public Company Valuation: Similarities and Contrasts
            2.1.1. Company-Specifi c Factors
            2.1.2. Stock-Specifi c Factors
            2.2. Reasons for Performing Valuations
            3. Defi nitions (Standards) of Value
            4. Private Company Valuation Approaches
            4.1. Earnings Normalization and Cash Flow Estimation Issues
            4.1.1. Earnings Normalization Issues for Private Companies
            4.1.2. Cash Flow Estimation Issues for Private Companies
            4.2. Income Approach Methods of Private Company Valuation
            4.2.1. Required Rate of Return: Models and Estimation Issues
            4.2.2. Free Cash Flow Method
            4.2.3. Capitalized Cash Flow Method
            4.2.4. Excess Earnings Method
            4.3. Market Approach Methods of Private Company Valuation
            4.3.1. Guideline Public Company Method
            4.3.2. Guideline Transactions Method
            4.3.3. Prior Transaction Method
            4.4. Asset-based Approach to Private Company Valuation
            4.5. Valuation Discounts and Premiums
            4.5.1. Lack of Control Discounts
            4.5.2. Lack of Marketability Discounts
            4.6. Business Valuation Standards and Practices
            5. Summary



            About the Authors

            About the CFA Program


Ordering:   Order Online - http://www.researchandmarkets.com/reports/1205722/

            Order by Fax - using the form below

            Order by Post - print the order form below and sent to

                         Research and Markets,
                         Guinness Centre,
                         Taylors Lane,
                         Dublin 8,
                                                            Page 1 of 2

Fax Order Form
To place an order via fax simply print this form, fill in the information below and fax the completed form to 646-607-
1907 (from USA) or +353-1-481-1716 (from Rest of World). If you have any questions please visit


Order Information
Please verify that the product information is correct.

               Product Name:           Equity Asset Valuation, 2nd Edition
               Web Address:            http://www.researchandmarkets.com/reports/1205722/
               Office Code:            OC8HNQNRSPOXU

Product Format
Please select the product format and quantity you require:


               Hard Copy:                EURO €76.00 + Euro €25.00 Shipping/Handling

Contact Information
Please enter all the information below in BLOCK CAPITALS

      Title:                  Mr              Mrs            Dr           Miss            Ms         Prof

      First Name:                                                  Last Name:

      Email Address: *

      Job Title:




      Postal / Zip Code:


      Phone Number:

      Fax Number:

     * Please refrain from using free email accounts when ordering (e.g. Yahoo, Hotmail, AOL)
                                                              Page 2 of 2

Payment Information
Please indicate the payment method you would like to use by selecting the appropriate box.

          Pay by credit card:                     American Express

                                                  Diners Club

                                                  Master Card

                                           Cardholder's Name

                                           Cardholder's Signature

                                           Expiry Date

                                           Card Number

                                           CVV Number

                                           Issue Date
                                           (for Diners Club only)

          Pay by check:                    Please post the check, accompanied by this form, to:

                                           Research and Markets,
                                           Guinness Center,
                                           Taylors Lane,
                                           Dublin 8,

                                           Please transfer funds to:
          Pay by wire transfer:
                                           Account number                   833 130 83
                                           Sort code                        98-53-30
                                           Swift code                       ULSBIE2D
                                           IBAN number                      IE78ULSB98533083313083
                                           Bank Address                 Ulster Bank,
                                                                        27-35 Main Street,
                                                                        Co. Dublin,

     If you have a Marketing Code please enter it below:

           Marketing Code:

      Please note that by ordering from Research and Markets you are agreeing to our Terms and Conditions at

                                              Please fax this form to:
                                  (646) 607-1907 or (646) 964-6609 - From USA
                          +353 1 481 1716 or +353 1 653 1571 - From Rest of World

To top