Question

**Please use and show all formulas using excel. I cannot
understand the answer if I can't see the formulas for each. Thank
you very much.**

**Common stock value: Constant growth **

**Seagate Technology is a global leader in data storage
solutions and a high-yield dividend payer. From 2015 through
2019, Seagate paid the followingper-share dividends:**

**Year Dividend per share**

**2019 $2.52**

**2018 2.25**

**2017 1.83**

**2016 1.19**

**2015 1.52**

**Assume that the historical annual growth rate of Seagate
dividends is an accurate estimate of the future constant annual
dividend growth rate. Use a 20% required rate of return to find
the value of Seagate's stock immediately after it paid its 2019
dividend of $2.52.**

Answer #1

1.)Seagate Technology is a global leader in data storage
solutions and a high-yield dividend payer. From 2015 through
2019,
Seagate paid the following per-share dividends:
Year
Dividen
2019
2.56
2018
2.29
2017
1.82
2016
1.18
2015
1.56
Assume that the historical annual growth rate of Seagate
dividends is an accurate estimate of the future constant annual
dividend growth rate. Use a 21%
required rate of return to find the value of Seagate's stock
immediately after it paid its2019
dividend of$2.56...

Please show all calculations and formulas. If using Excel (or
tables), please show data, formulas, etc.
Practice question 14:
Calculate the company’s w.a.c.c. using the info
below.
***assume this is a corporate bond that pays 2x annually when
calculating the PV of the bond
Harvey LLC’s capital structure consists of a 25-year bond issued
5 years ago with a coupon of 6% and a par value of $14,000,000. The
company’s main competitor just issued a similar bond paying 5%. The...

Answer question with excel functions showing all steps;
Using the data for a firm shown in the following table,
calculate the cost of retained earnings and the cost of new common
stock using the constant-growth valuation model
Current market price per share $48
Dividend growth rate 8%
Projected dividend per share next year $1.92
Underpricing per share $1.00
Flotation cost per share $2.25

Please show all work. I need to see the formulas in order to
understand the question
Thank you
You are given the follwing information for Lighting. Co
Debt: 7,500 bonds outstanding with a 7.8% coupon, $1,000 par
value, 20 years to maturity, selling for 104 percent of par. These
bonds make semiannually payments.
Preferred Stock: 12,000 shares of 5.75% preferred stock
outstanding, currently selling for a price of 2.0% below par per
share.
Common Stock: 210,000 shares outstanding, selling for...

Can you please show steps and formulas
6) A company recently paid out a $4 per share dividend on their
stock. Dividends are projected to grow at a constant rate of 5%
into the future, and the required return on investment is 8%. If we
buy the stock today and hold it for one year, what is our holding
period return for that one year?

PLEASE ANSWER ALL, if you are not going to answer all, DO NOT
answer at all ! thank you !!
2.Gary King is interested in buying the stock of First National
Bank. While the bank's management expects no growth in the near
future, Gary is attracted by the dividend income. Last year the
bank paid a dividend of $7.20. If Gary requires a return of 12.5
percent on such stocks, what is the maximum price he should be
willing to...

Non-constant growth model problem Show all work.
Formulas:
DAA's stock is selling for $15 per share. The firm's income,
assets, and stock price have been growing at an annual 15 percent
rate and are expected to continue to grow at this rate for 3 more
years. No dividends have been declared as yet, but the firm intends
to declare a dividend of D3 = $2.00 at the end of the last year of
its supernormal growth. After that, dividends are...

Calculate the annual dividend growth rate for the last
10 years. Kindly provide excel formulas.
Based on the annual dividend growth rate for data
provided, will you forecast a constant or non-constant growth in
dividends? Please explain.
Date
Dividends
8/11/2010
0.303
12/8/2010
0.303
3/9/2011
0.365
5/11/2011
0.365
8/10/2011
0.365
12/7/2011
0.365
3/8/2012
0.398
5/9/2012
0.398
8/8/2012
0.398
12/5/2012
0.398
3/8/2013
0.47
5/8/2013
0.47
8/7/2013
0.47
12/4/2013
0.47
3/7/2014
0.48
5/7/2014
0.48
8/6/2014
0.48
12/3/2014
0.48
3/11/2015
0.49
5/6/2015
0.49
8/5/2015...

Integrative Risk and valuation
Giant Enterprises' stock has a required return of 16.7 %. The
company, which plans to pay a dividend of $1.69 per share in the
coming year, anticipates that its future dividends will increase
at an annual rate consistent with that experienced over 2013 -2019
period, when the following dividends were paid
2019 $1.61
2018 $1.53
2017 $1.46
2016 $1.39
2015 $1.32
2014 $1.26
2013 $1.20
a. If therisk-freerate is 6%,what is the risk premium
onGiant'sstock?
b. ...

Please show all work and include: i) timeline, ii)
equation set up, iii) answer visibly circled or highlighted. The
answer is listed so the work is most important.
Ex 4) The CI Corp. has just paid a cash dividend of $2 per
share. If investors require 16% return from investments such as
this and the dividend is expected to grow at a steady 8% per year,
what is the current value of the stock? What will the stock be
worth in...

ADVERTISEMENT

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 48 seconds ago

asked 48 seconds ago

asked 12 minutes ago

asked 16 minutes ago

asked 49 minutes ago

asked 57 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago