To determine intrinsic value you can use one of three intrinsic value models:
Build – your – own model: Using Excel, the worksheet model is fairly easy to construct; formulas will be shown along with sample results for both indefinite continuing value and the acquisition assumption.
Prepackaged Web – based analyzer: At this writing, the data and analysis package offered by iStockResearch is the best available for free.
Intrinsic value formula as developed by Ben Graham: This simple formula is easy to apply and gives surprisingly robust results.
The one highlighted in this section is built from scratch as an Excel spreadsheet. At the time of this writing, there is little in the way of PC or Web – based models available for use by consumer investors. As noted, the exception is iStockResearch, which offers a model to non – professional investors; I offer an example later in the chapter.
Of course, any time you use a tool, its good to know in advance what outcome to expect. With intrinsic value models, you get a single – figure result: the estimated per – share value of the company. One single number: Company ABC, for example, may have a projected worth of $34.97. If youre satisfied with this number and the assumptions supporting it, you can compare this intrinsic value with current market price and make a buying decision. More likely, youll want to model a range of intrinsic values based on different assumptions. Then to complete the value appraisal, youll want to consider strategic financials and intangibles before hitting the buy button.