***PROVIDE EXCEL FORMULAS***

Stock Valuation at Raga Engines

Larissa has been talking with the company's directors about the future of East Coast Yachts. To this point, the company has used outside suppliers for various key components of the company's yachts, including engines. Larissa has decided that East Coast Yachts should consider the purchase of an engine manufacturer to allow East Coast Yachts to better integrate its supply chain and get more control over engine features. After investigating several possible companies, Larissa feels that the purchase of Ragan Engines, Inc. is a possibility. She has asked Dan Ervin to analyze Ragan's value.

Ragan Engines, Inc., was founded nine years ago by a brother and sister-Carrington and Genevieve Ragan-and has remained a privately owned company. The company manufactures marine engines for a variety of applications. Ragan has experienced rapid growth because of a proprietary technology that increases the fuel efficiency of its engines with very little sacrifice in performance. The company is equally owned by Carrington and Genevieve. The original agreement between the siblings gave each 150,000 shares of stock. Larissa has asked Dan to determine a value per share of Ragan stock. To accomplish this. Dan has gathered the following information about some of Ragan's competitors that are publicly traded:

EPS DPS Stock Price ROE R

Blue Ribband Motors Corp. $1.19 $.19 $16.32 10.00% 12.00%

Bon Voyage Marine, Inc. $1.26 $.55 $13.94 12.00% 17.00%

Nautilus Marine Engines ($.27) $.57 $23.97 N/A 16.00%

Industry average $.73 $.44 $18.08 11.00% 15.00%

Nautilus Marine Engines's negative earnings per share (EPS) were the result of an accounting write-off last year. Without the write -off, EPS for the company would have been $2.07. Last year, Ragan had an EPS of $5.35 and paid a dividend to Carrington and Genevieve of $320,000 each. The company also had a return on equity of 21 percent. Larissa tells Dan that a required return for Ragan of 18 percent is appropriate.

Assume the company's growth rate declines to the industry average after five years. What percentage of the stock's value is attributable to growth opportunities?

Carrington and Genevieve are not sure if they should sell the company. If they do not sell the company outright to East Coast Yachts, they would like to try and increase the value of the company's stock. In this case, they want to retain control of the company and do not want to sell stock to outside investors. They also feel that the company's debt is at a manageable level and do not want to borrow more money. What steps can they take to try to increase the price of the stock? Are there any conditions under which this strategy would not increase the stock price?