a. From the table calculated in Excel, the value of the stock based on an 11 percent discount
rate would be $23.97.
b. From the table, the value of the stock based on a 10 percent discount rate would be
$28.92 and based on a 12 percent discount rate would be $20.44.
c. From the table, the value of the stock that grows at 6 percent (rather than 5 percent) in
year 7 and after causes a higher stock value than a future 5 percent growth.
d. Assumptions are crucially important in stock valuation. Minor changes in either the
discount rate or the growth assumption rate can have a big impact on stock valuation.
research it!
Stock Screener
Investors can choose from many thousands of stocks. The large number to choose from can be
quite daunting to new investors. Fortunately, some good stock screeners are available for free on
the Internet that will find only the kinds of companies the investor is looking for. Looking for
small value companies? A stock screen at Yahoo! Finance will show all the stocks that meet the
three criteria of (1) market capitalization between $250 million and $1 billion, (2) P/E ratio less
than or equal to 10, and (3) a quick ratio greater or equal to 1.0. In September of 2010, 127 firms
met all three of these criteria. Yahoo! Finance provides 18 screens like this one to choose from.
Pick one of these preset screens. Discuss the kinds of stocks the screen will find and report on
those companies.(http://screener.finance.yahoo.com/presetscreens.html)
SOLUTION: Consider the preset screen for Large Cap Value. The stock screener description is
integrated mini-case: Valuing Carnival Corporation
Carnival Corp. provides cruises to major vacation destinations. Carnival operates 100 cruise
ships with a total capacity of 180,746 passengers in North America, Europe, the United
Kingdom, Germany, Australia, and New Zealand. The company also operates hotels, sightseeing
motor coaches and rail cars, and luxury day boats. These activities generated earnings per share
of $1.67 for 2012. The stock price at the end of 2012 was $36.77. The previous stock prices and
dividends are shown in the following table.