a456dcb5b0cc1efaa8a0973b2a2241fb5fe7074c.xlsPage 1Using the models in this disketteThe spreadsheet programs on this diskette are designed to supplement thebook on valuation. While short descriptions of the models are provided,detailed questions can be best answered by referencing the appropriatesection in the book.What do you need to run these programs?1. Either Lotus 3.* or Excel 4.* (IBM) or Excel 4 (Mac).2. The data for the firm that you want to value.A short descriptionThere are three groups of programs on this diskette --I. Discounted Cashflow Valuation: (1) Dividend Discount Models (Steady State, 2 stage, 3 stage, H model)(2) Free Cashflow to Equity Models (Steady State, 2 stage, 3 stage)(3) Free Cashflow to Firm Models (2 stage, General)II. Relative Valuation:(1) PE Multiples(2) PBV Multiples(3) PS MultiplesIII. Option Pricing Models(1) Valuing Equity (2) Valuing Product Patents/ Start-up firms(3) Valuing Natural Resource firmsA suggested sequence for the first-time userIf you know the model you need, go directly to the program you need.
This is the end of the preview.
access the rest of the document.