All-in-one Valuation Models
- Choosing The Right Valuation Model - This program
provides a rough guide to which discounted cash flow model may be best suited to your firm.
- High Growth - This
spreadsheet can be used to value tough-to-value firms, with negative earnings, high growth in revenues and few comparables. If you have a dot.com firm, this is your best choice.
- Dividend Discount Model - A complete
dividend discount model that can do stable growth, 2-stage or 3-stage valuation. This is your best choice if you are analyzing financial service firms.
- FCFE Valuation Model - A complete FCFE valuation model
that allows you to capital R&D and deal with options in the context of a valuation model.
- FCFF Valuation Model - This
model tries to do it all, with all of the associated risks and rewards. I hate having to work with a dozen spreadsheets to
value a firm, and I have tried to put them all into one spreadsheet - a ratings estimator, an earnings normalizer, an R&D
converter, an operating lease converter, a bottom-up beta estimator and industry averages. Try it out and make your own additions.
Note
You will need MS Excel 97 of hire to use this spreadsheets. If you do not
have MS Excel and you are trying to open it with different Excel-like software
please note that some of the functions may not work properly.