1 / 13

FCFFginzu.xls Using the Valuation Spreadsheet

FCFFginzu.xls Using the Valuation Spreadsheet. Aswath Damodaran A podcast. Overview. Suited for: most non-financial service firms What the spreadsheet tries to do: Value the operating assets of the firm by disconting the cashflows to the firm at the cost of capital

chadscott
Download Presentation

FCFFginzu.xls Using the Valuation Spreadsheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. FCFFginzu.xlsUsing the Valuation Spreadsheet Aswath Damodaran A podcast

  2. Overview • Suited for: most non-financial service firms • What the spreadsheet tries to do: • Value the operating assets of the firm by disconting the cashflows to the firm at the cost of capital • Augments this value with the value on non-operating assets such as cash and cross holdings • Estimates the value of equity and equity per share

  3. A picture of the model…

  4. Inputs: Financial Statement numbers

  5. Capitalizing R&D

  6. Capitalizing Leases…

  7. Normalizing Earnings..

  8. Market Inputs

  9. Ratings and Options (if any)

  10. A high growth period?

  11. Stable growth inputs

  12. Valuation Summary and Diagnostics..

  13. Reading the Output

More Related