Accounting, writing homework help

Would you like us to handle your paper? Use our company for better grades and meet your deadlines. When you need high quality assignment help online, we are here to help you

Order a Similar Paper Order a Different Paper

Please answer in excel. 7 questions. I’ve already completed the first one.


A. ABC Corp. just paid a dividend of $1.95 and the dividends are expected to indefinitely grow at a constant rate of 4.1% p.a. If investors require a return of 10.2% p.a. on this stock, what is the current value? Value in there years? In 15 years? CV=33.28 , Value in 3 years=37.54, Value in 15 years=60.80

Current Value 1.95*(1+4.1%)/(10.2%-4.1%)

Value in 3 years 1.95*(1+4.1%)^4/(10.2%-4.1%)

Value in 15 years 1.95*(1=4.1%)^16/(10.2%-4.1%)

B. XYZ Corp’s next dividend will be $2.30 per share, and the constant dividend growth rate is 4.5% forever. If the current stock price is $39.85, what is the rate of return that investors require? What is the dividend yield? Expected capital gains yield? Required rate of return=10.27%, Dividend Yield=5.77%

Required return rate 2.30/39.85=4.5%

Dividend Yield 2.30/39.85

2. If a constant dividend growth rate is 4.9%, and a dividend yield is 5.7% for a company, what is the required rate of return on this company stock?

3. FD Corp. pays a constant $12 dividends on tis stock for the next 9 years, then will cease paying dividends forever. If investors require 10% return on this stock, what is the current value of the stock?

4. CCC Corp’s preferred stock pays a $3.80 dividend every year, in perpetuity. If the issue currently sells for $78.45, what is the required return?

5. The stock price of QRS Inc. is $68. Investors require 11% return on similar stocks and QRS Inc. plans to pay a dividend of $3.85 next year. What growth rate is expected for the stock?

6. A. EEE Corp. has a new issue of preferred stock it calls 20/20 preferred. The stock will pay $20 dividends but the first dividend will not be paid until 20 years from today. if you require a return of 8% on this stock, how much would you pay today?

B. MBI Corp. will not pay any dividends over the next nine years. It will pay a dividend of $15 per share 10 years from today and increase the dividend by 5 percent per year thereafter. If investors require 14% return on similar stocks, what is the current stock value?

7. A. A company is expected to pay $3, $10, $15 and $3.05 dividends over the next four years. Afterwards, the company will maintain a constant 5% dividend growth rate forever. If the required return on the stock is 11%, what is the current stock value?

B. YYY Corp. just paid a $2.50 dividend and its dividends are expected to grow at 25% rate for the next three years, then at a constant rate of 6% thereafter forever. If investors require 13% return on this stock, what is the current stock value?

8. Daniela Company has the following historical information:

Year 1

Year 2

Year 3

Year 4

Stock price

$ 49.50

$ 58.12

$ 67.34

$ 60.25






Earnings growth rate


Using the company’s average PE as a benchmark, estimate the target stock price in one year.

Once you get frustrated and struggling to accomplish your work on time, you need online assignment help. We understand your needs and provides you with reliable writing specialists to complete your projects at an affordable price.

Order a Similar Paper Order a Different Paper

Looking for this or a Similar Assignment? Order a Paper Now