for homework help1234 spreadsheet

here is what we discussed.

2< /

td>< /

td>>Ch

0

7

P2

0 Build a Model

that must be written, only Excel formulas that use cell references or functions will be accepted for credit.

per year in recent years. This same growth rate is expected to last for another 2 years (g1

g2 = 20%).

=

0

, rs = 10%, and gn =

%

, what is TTC’s stock worth today? What are its expected dividend yield and capital gains yield at this time?

D0 $1.60
rs

20%

s 1-2 only.

5%

20% 5%
Year 0 1 2 3

gL

=

/ P0

/

Dividend yield =

– Dividend yield

Cap. Gain yield= –
Cap. Gain yield=

= P2

P1 = +
P1 =
Cap. Gain yield=

/ P0

Cap. Gain yield= /

Cap. Gain yield=

D0 $1.60
rs 10.0%

20%

gL

20% 6%
Year 0 1 2 3

5 6

Dividend
PV of dividends

=

Dividend yield = D1 / P0
Dividend yield = /
Dividend yield =

Cap. Gain yield= Expected return – Dividend yield
Cap. Gain yield= –
Cap. Gain yield=

Dividend yield =

/

Dividend yield = /
Dividend yield =

Cap. Gain yield= Expected return – Dividend yield
Cap. Gain yield= –
Cap. Gain yield=

Spring 2, 20

1

3

7/22/12

Chapter 7. Ch 07 P20 Build a Model

Except for charts and answe Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper

rs

Numeric answers in cells will not be accepted.

Rework Problem 7-19. Taussig Technologies Corporation (TTC) has been growing at a rate of

20%

=

a. If

D0

$1.

6

5

1. Find the price today.

10.0%

gs

Short-run g; for

Year

gL

Long-run g; for Year 3 and all following years.

Dividend

PV of dividends

= D3

= Terminal value = P2 =

= rs

–

=

P0

2. Find the expected dividend yield.

Recall that the expected dividend yield is equal to the next expected annual dividend divided by the price at the beginning of the period.

Dividend yield

D1

Dividend yield =

3. Find the expected capital gains yield.

The capital gains yield can be calculated by simply subtracting the dividend yield from the total expected return.

Cap. Gain yield=

Expected return

Alternatively, we can recognize that the capital gains yield measures capital appreciation, hence solve for the price in one year, then divide the change in price from today to one year from now by the current price. To find the price one year from now, we will have to find the present values of the terminal value and second year dividend to time period one.

P1

+

D2

(1 + rs)

(P1 – P0)

b. Now assume that TTC’s period of supernormal growth is to last for 5 years rather than 2 years. How would this affect its price, dividend yield, and capital gains yield?

1. Find the price today.

gS

Short-run g; for Years 1-5 only.

6%

Long-run g; for Year 6 and all following years.

4

= D6

Kenneth D. Jackson: Discounted 5 years

Kenneth D. Jackson: Discounted two years

Horizon value = P5 =

= P0

= rs – gL

Part 2. Finding the expected dividend yield.

Part 3. Finding the expected capital gains yield.

c. What will TTC’s dividend yield and capital gains yield be once its period of supernormal growth ends? (Hint: These values will be the same regardless of whether you examine the case of 2 or 5 years of supernormal growth, and the calculations are very easy.)

We used the 5-year supernormal growth scenario for this calculation, but ultimately it does not matter which example you use, as they both yield the same result.

Dn+1

Pn

Upon reflection, we see that these calculations were unnecessary because the constant growth assumption holds that the long-term growth rate is the dividend growth rate and the capital gains yield, hence we could have simply subtracted the long-run growth rate from the required return to find the dividend yield.

Sheet2

7/22/12