Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please explain how to do this through microsoft excel. Stock Valuation at Ragan, Inc. Ragan, Inc, was founded nine years ago by brother and sister

image text in transcribed
image text in transcribed
Please explain how to do this through microsoft excel.
Stock Valuation at Ragan, Inc. Ragan, Inc, was founded nine years ago by brother and sister Carrington and Genevieve Ragan. The company manufactures and installs commercial heating, ventilation, and cooling (HVAC) units. Ragan, Inc, has experienced rapid growth because of a proprietary technology that ircreases the energy effieiency of its units. The company is equally owned by Carrington and Genevieve. The original partnership agteement between the siblings gave each 50,000 shares of stock. In the event either wished to sell stock, the shares first had to be offered to the other at a discounted price. Although neither sibling wants to sell, they have decided they should value their holdings in the company. To get started, they have gathered the information about their main competitors in the table below. Expert HVAC Corporation's negative earnings per share were the result of an accounting write-off last year. Without the write-off, earnings per share for the company would have been \$1.06. The ROE for Expert HVAC is based on net income excluding the write-off. Last year, Ragan, Inc, had an EPS of $4.54 and paid a dividend to Carrington and Genevieve of $60,000 each. The company also had a return on equity of 18 percent. The siblings believe that 15 percent is an appropriate required return for the company. 4. Carrington and Genevieve are unsure how to interpret the price-earnings ratio. After some head scratching, they've come up with the following expression for the priceearnings ratio: E1P0=R(ROEb)1b Beginning with the constant dividend growth model, verify this resuit. What does this expression imply about the relationship between the dividend payout ratio, the required return on the stock, and the company's ROE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Financial Management

Authors: Eugene F. Brigham, Phillip R. Daves

11th edition

978-1111530266

More Books

Students also viewed these Finance questions

Question

Why are red blood cells Red in colour?

Answered: 1 week ago

Question

Define Consumerism.

Answered: 1 week ago

Question

Name the system that includes heart, blood vessels and blood?

Answered: 1 week ago