help with questions 1-6 within excel and with formulas

Stock Valuation at Ragan Engines Larissa has been talking with the company's directors about the future of East Coast Yachits. To this point, the company has used outside suppliers for various key components of the company's yachts, including engines. Larissa bas decided that East Coast Yachis slsould consider the purchase of an engine manufacturer to allow East Coast Yachis to better integrate its supply chain and get more control over engine features. After investigating several postible companies, Larissa feels that the purchase of Ragan Engines, Ine, 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 enzines for a variety of applications. Ragan has experienced rapid growth because of a proprietary technology that inereases the tuel effeiency of its engines with very little sacriflce in performance. The cocupany is equally. owned by Carrington aisd Genevieve. The original agreement between the siblings gave each 50,000 shares of stock. Larissa bas 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: Nautilus Marine Engines's nezative earnings per share (EPS) were the result of an aceouniting write-off last year. Without the write-off, EPS for the company would have been \$1.60. Last year, Ragan had an EPS of \$4.54 and paid a dividend to Carrington and Genevieve of $60,000 each. The company ahso had a return on equity of 18 pereent. Larissa tells Dan that a required return for Ragan of 18 pereent is appropriate. 1. Assuming the company continues its current growth rate, what is the value per share of the company's stock? 2. Dan has examined both the company's fnancial statements and those of its competitors. Although Ragan currently has a technological advantage, Dan's research indicates that Ragan's competitors are investigating other methods to improve efficiency. Given this, Dan believes that Ragan's technological advantage will last only for the next five years. After that period, the companys growth will fikely slow to the industry average. Additionally. Dan believes that the required return the company uses is too high. He believes the industry average required return is more appropriate. Under Dan's assumptioas, what is the estimated stock price? 3. What is the industry average priceearnings ratio? What is Ragan's priceearnings ratio? Comment on any differences and explain why they may exist. 4. 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? 5. Assume the company's growth rate slows to the industry average in five years. What fature return on equity does this imply? 6. 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 inerease the price of the stock? Are thete any conditions under which this strategy would not increase the stock price