Question

Please show how it would be done on EXCEL

the sleeping flower CO has earnings of $2.65 per share. The benchmark PE for the company is 18. What stock price would you consider appropriate ? what if the benchmark PE were 21?

Answer #2

answered by: anonymous

The Blooming Flower Co. has earnings of $2.10 per share. The
benchmark PE for the company from a comparables analysis is
10.
What stock price would you consider appropriate? (Do not
round intermediate calculations. Round your answer to 2 decimal
places, e.g., 32.16.)
Stock price
$
What if the benchmark PE were 13? (Do not round
intermediate calculations. Round your answer to 2 decimal places,
e.g., 32.16.)
Stock price
$

Flex Co. just paid total dividends of $800,000 and reported
additions to retained earnings of $2,400,000. The company has
605,000 shares of stock outstanding and a benchmark PE of 16.2
times. What stock price would you consider appropriate?

Ridgeway Construction has an EPS of $5.46. If the earnings are
expected to grow at 4.5% per year and the benchmark PE for the
company is 18. What is estimated current stock price? What should
the target stock price be in three years?

To please be done in excel: XYZ Ltd is a typical young company.
It has not paid any dividends to date but the company’s earnings
per share (EPS) have been growing at an average annual growth rate
of 20% p.a. for the last five years. The company has just announced
that it will declare the following dividends in the next 3 years:
$10, $12 and $13.50 per share starting in exactly one year’s time.
The required rate of return for...

Co-sleeping is when the child shares the bed with the parents.
There has been research done on this topic. It also has cultural
basis surrounding this activity. Read about co-sleeping and write
your opinion on the topic. Do you feel it has positive or negative
effects on a child’s development? If you feel it is positive, how
long do you feel it should be done for? And at what age do you
stop?

Kreeman's Inc. has earnings per share of $12. If the industry
average PE ratio is 20, what is the price of Kreeman's stock?
Please show work

*Please show how to do the problem in excel with references
showing*
You purchased shares of a stock one year ago at a price of
$64.79 per share. During the year you received dividend payments of
$2.21 and sold the stock for $71.91 per share.
If the inflation rate during that year was 2.95%, what was your
real rate of return?

To please be done in excel: XYZ Ltd. is expected to pay a
dividend of $8.00 per share in the coming year and a $9.00 dividend
in the year thereafter. Afterwards, the company is expected to
maintain a constant 5 per cent growth rate in dividends forever. If
the required return on the share is 10 per cent, what is the fair
value of the share?

please show me how to do this using excel you do not expect
there to be a dividend paid on a share of common stock next year.
after that you expect a $2 dividend that will grow at a constant
rate of 6% there after. how much would you pay for the stock
assuming a cost of equity of 10%

Explain work in detail please (include formulas and show your
logic)
The stock of Hobbit Corporation is currently selling for
$10 per share. Earnings per share in the coming year are expected
to be $2. The company has a policy of paying out 50% of its
earnings each year in dividends. The rest is retained and invested
in projects that earn a 20% rate of return per year. This situation
is expected to continue indefinitely.
Assuming the current market price...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 1 minute ago

asked 2 minutes ago

asked 9 minutes ago

asked 47 minutes ago

asked 48 minutes ago

asked 51 minutes ago

asked 56 minutes ago

asked 56 minutes ago

asked 56 minutes ago

asked 59 minutes ago

asked 1 hour ago

asked 1 hour ago