1 / 13

Valuation Spreadsheet Overview for Non-Financial Service Firms

This podcast provides an overview of using the FCFFginzu.xls Valuation Spreadsheet by Aswath Damodaran. The spreadsheet aims to value operating assets, non-operating assets, equity, and equity per share for most non-financial service firms. It covers inputs, normalizing earnings, market inputs, high growth period, stable growth inputs, and valuation summary.

chadscott
Download Presentation

Valuation Spreadsheet Overview for Non-Financial Service Firms

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