***I NEED THE QUESTIONS ANSWERED USING EXCEL FORMULAS ONLY*** 1. BOSTON COMPANY

Question

***I NEED THE QUESTIONS ANSWERED USING EXCEL FORMULAS ONLY***

1. BOSTON COMPANY HAS JUST PAID DIVIDENDS OF $2.5 PER SHARE, WHICH THE COMPANY PROJECTS WILL GROW AT A CONSTANT RATE OF 5 PERCENT FOREVER. IF BOSTON COMPANYS SHAREHOLDER REQUIRES 15 PERCENT RATE OF RETURN, WHAT IS THE PRICE OF ITS COMMON STOCK?

2. you plan to buy bulldog corportation stock. you predict that bulldog will pay dividends of $2 in year 1 and $3 in year 2, respectively. you are also confident that you can sell the stock for $100 per share at the end of year 2. if you require a 10 percent return on sock, what is its fair price from your perspective?

3. company BMI will experience a supernatural growth rate of 20% in the next two years. the growth rate will then level off to 5% from year 3 and beyond. the most recent dividend payment was $2.00 and the requaired rate of return for XYZ stock is 10%. what is the intrinsic value of BMI stock?

4. beverly company will pay a dividend of $2 per share next year, which will continue to grow at a constast rate forever. current stock price is $20 and the required rate of return is 15 percent. what is the constand dividend growth rate?

5. BFI corporation has a preferred stock issue outstanding, which carries a par value of $100 and a fixed divident rate of 10 percent. if the market requires a rate of return of 10 percent to hold this preferred stock, what is its market price today?

Explanation / Answer

Price = D / (Ke – G)

Price = $2.5 / (15% - 5%) = $25
In Excel, you can type “ =(2.5/(10%-5%))” to get the answer.

PV of dividend for Year 1 = $2.4/(1.10) = $2.18
PV of dividend for Year 2 = $2.88/(1.10)2 = $2.38
PV of terminal Value = $49.98 / (1.10)3 = $37.55

Intrinsic Value of the share = $37.55 + $2.38 + $2.18 = $42.11

$20 = $2 / (15% - G)
G = 0.05 or 5%

= $10/10% = $100
So, the stock price will be equal to its par value

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.