Question

In: Finance

no excel please The Pet Company has recently discovered a type of rock which, when crushed,...

no excel please

The Pet Company has recently discovered a type of rock which, when crushed, is extremely absorbent.  It is expected that the firm will experience (beginning now) an unusually high growth rate (40%) during the period (3 years) when it has exclusive rights to the property where this rock can be found. However, beginning with the fourth year the firm's competition will have access to the material, and from that time on the firm will assume a normal growth rate of 5% annually.  During the rapid growth period, the firm's dividend payout ratio will be relatively low (20%), to conserve funds for reinvestment. However, the decrease in growth will be accompanied by an increase in dividend payout to 60%.  Last year's earnings were $10.00 per share (E0) and the firm's cost of equity is 16%.  What should be the current price of the common stock?

                        a.           $  95.64         d.           $109.53

                        b.          $104.20         e.           $106.01

                        c.          $116.95

Solutions

Expert Solution

The correct Answer is D

Let us understand how to compute the same.

Gievn the Last years earnings = $10 per share. Also given that growth in earnings for the next year is 40 %.

Therefore Earnings At the end of Year 1 = = $10 * 1.40 = $14

Earnings at the end of Year 2 = $14 * 1.40 = $ 19.60

Similarly we compute the following :-

Year 1 Year 2 Year 3 Year 4
Growth Rate (A) 40% 40% 40% 5%
EPS (B)         14.00         19.60         27.44         28.81
Dividend Payour Ratio ('C) 20% 20% 20% 60%
Dividend (D=C x B)           2.80           3.92           5.49         17.29

Now given that from year 4 the earnings are expected to 5%.

We can compute the value of share at the end of year 3 by using the formula = D4/ (Re-G)

Where D4 = Dividend at the end of year 4 = $17.29

Re= Cost of Equity = 16%

G= Growth Rate= 5%

Therefore Value of Share at Year 3 = 17.29/(16-5)% =$ 157.16

Now using the dividend Discount Model we can compute the value of share today

=D1/(1- Re) + D2/(1- Re)^2 + D3/(1- Re)^3 + Value of Share At the end of Year 3/ (1- Re)^3

Where D1, D2 and D3 are the Dividend at the end of Year 1, 2 and 3 Respectively.

Therefore Value of Share today

Year 1 Year 2 Year 3
Dividend 2.80 3.92 5.49
Value of Share At year 3 as computed       157.16
Total Cash Flows (A) 2.8 3.92 162.6444
Discount Factors @16% (B) 0.862069 0.743163 0.640658
Present Value (C=A x B) 2.414 2.913 104.199

A summation of all the present Values = $ 109.53 is the Value of the share today.


Related Solutions

amSuppose you are studying a recently discovered population of rock pocket mice woth dark-colored fir that...
amSuppose you are studying a recently discovered population of rock pocket mice woth dark-colored fir that lives on volcanic rock. You take a DNA sample from a member of this new population and determine the DNA sequence of a gene known to play a role in fir color. The sequence you get is identical to that of the same gene in another rock pocket mouse population with dark-colored fur that lives on a different patch of volcanic rock. Which of...
NPI is a health research and manufacturing company which recently discovered that increased sulforaphane( at least...
NPI is a health research and manufacturing company which recently discovered that increased sulforaphane( at least 5,000 mg every 2 days) in a persons diet has been able to extend a persons life span by at least 30 years. The company developed a new product called "Sustain Your Life" which is a small tablet that contains 5,000 mg of sulforaphane in each tablet. The health tablet market size is currently measured at 150 million units(15 tablets per bottle) of which...
NPI is a health research and manufacturing company which recently discovered that increased sulforaphane( at least...
NPI is a health research and manufacturing company which recently discovered that increased sulforaphane( at least 5,000 mg every 2 days) in a persons diet has been able to extend a persons life span by at least 30 years. The company developed a new product called "Sustain Your Life" which is a small tablet that contains 5,000 mg of sulforaphane in each tablet. The health tablet market size is currently measured at 150 million units(15 tablets per bottle) of which...
In Python Please Dennis has always loved music, and recently discovered a fascinating genre. Tautograms are...
In Python Please Dennis has always loved music, and recently discovered a fascinating genre. Tautograms are a special case of alliteration, which is the appearance of the same letter at the beginning of adjacent words. In particular, a sentence is a tautogram if all its words begin with the same letter. For example, the following sentences are tautograms. French flowers bloom, Sam Serrano whistles softly, Pedro ordered pizza. Dennis wants to dazzle his wife with a romantic letter full of...
The following table belongs to a pet boarding company. Each pet that is kept has a...
The following table belongs to a pet boarding company. Each pet that is kept has a type (species) and weight, an owner and the information where it is kept (which pen). The fee depends on the pen. It also depends on the owner because owners can have special rates.    Pet_id Type Weight Pen Fee Owner_id O_name 2800 Cat 9.2 P02 20 11 Susan 1739 Cat 7.5 P01 25 28 Brett 9981 Dog 3.3 P02 30 29 Jason Identify the...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an estimated 2% annual rise from inflation in years 2-6.  The sales price is expected to drop...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed...
Can you do in excel please and show Formulas The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an estimated 2% annual rise from inflation in years 2-6.  The sales price is expected to drop...
Bisbee Aeropsace Factor Rating Matrix (please use excel to complete this exercise) Bisbee Aerospace has recently...
Bisbee Aeropsace Factor Rating Matrix (please use excel to complete this exercise) Bisbee Aerospace has recently entered the market for commercial space flights. The executive team at Bisbee is considering proposals from its engineering group for five possible commercial space shuttle designs. The engineering group, in cooperation with the marketing division, has done a thorough job in preparing a business case for each design, and executive team members have carefully reviewed the documentation. Bisbee has a policy in place for...
Can you do in excel please The Air Marshal Co. has recently completed a $10,000,000 two-year...
Can you do in excel please The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an estimated 2% annual rise from inflation in years 2-6.  The sales price is expected to drop to $90,000 in...
Can you do in excel please The Air Marshal Co. has recently completed a $10,000,000 two-year...
Can you do in excel please The Air Marshal Co. has recently completed a $10,000,000 two-year marketing study.  Based on the results of this study, Air Marshal has estimated that 800 units of its new security electro-optical human scanning hardware, known as "Marshal Dillon," could be sold annually over the next 12 years, at a price of $110,000 the first year with an estimated 2% annual rise from inflation in years 2-6.  The sales price is expected to drop to $90,000 in...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT