Question

To please be done in excel: XYZ Ltd. is expected to pay a dividend of $8.00...

To please be done in excel: XYZ Ltd. is expected to pay a dividend of $8.00 per share in the coming year and a $9.00 dividend in the year thereafter. Afterwards, the company is expected to maintain a constant 5 per cent growth rate in dividends forever. If the required return on the share is 10 per cent, what is the fair value of the share?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

SEE IMAGE

ANY DOUBTS, FEEL FREE TO ASK

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
To please be done in excel: XYZ Ltd is a typical young company. It has not...
To please be done in excel: XYZ Ltd is a typical young company. It has not paid any dividends to date but the company’s earnings per share (EPS) have been growing at an average annual growth rate of 20% p.a. for the last five years. The company has just announced that it will declare the following dividends in the next 3 years: $10, $12 and $13.50 per share starting in exactly one year’s time. The required rate of return for...
XYZ company is expected to pay a dividend per share of $1.1 for the coming year....
XYZ company is expected to pay a dividend per share of $1.1 for the coming year. It expected that company can maintain a dividend growth of 15% a year for the next 3 years. Given an in-depth analysis, it comes to term that the growth rate will decline to 5 per cent per annum and remains at that level indefinitely. The required rate of return on the shares is 12 per cent per annum. Calculate the current share price. If...
Bruin Corporation is expected to pay the following dividends over the next 3 years: $1.72, $10...
Bruin Corporation is expected to pay the following dividends over the next 3 years: $1.72, $10 and $3.60. Afterwards, the company pledges to maintain a constant 5 percent growth rate in dividends forever. If the required return on the stock is 12 percent, what is the current share price? a. 47.61 b. 42.36 c. 69.51 d. 50.51 e. 73.54 Please show workings using Excel
Stone Corporation is expected to pay the following dividends over the next four years: $9, $15,...
Stone Corporation is expected to pay the following dividends over the next four years: $9, $15, $17, and $3. Afterwards, the company pledges to maintain a constant 5 percent growth rate in dividends, forever. If the required return on the stock is 10 percent, what is the current share price?
Leisure Lodge Corporation is expected to pay the following dividends over the next four years: $21.8,...
Leisure Lodge Corporation is expected to pay the following dividends over the next four years: $21.8, $13.17, $6.53 and $3.71. Afterwards, the company pledges to maintain a constant 3 percent growth rate in dividends forever. If the required return on the stock is 15 percent, what is the current share price?
A business is to pay a dividend per share of $1.1 for the upcoming year. It's...
A business is to pay a dividend per share of $1.1 for the upcoming year. It's expected they can maintain a dividend growth of 15% each year for the next 3 yrs. It comes to term that the growth rate is going to decrease to 5 per cent p.a. and remains at that level forever. The required rate of return on the shares is 12 per cent p.a. What is the current share price If the market is $20.00, should...
Q) XYZ Ltd last paid a dividend of $0.20 three years ago. Today the company announced...
Q) XYZ Ltd last paid a dividend of $0.20 three years ago. Today the company announced they will resume paying dividends. The planned dividends are $0.65 in one year's time, $0.75 in two years' time, and thereafter dividends will increase by a constant rate of 4% p.a. indefinitely. If the required rate of return for XYZ is 12%, what is a fair price for one share today? a. $9.38 b. $8.37 c. $0.58 d. $8.95 e. $9.15
Alfonso Ltd will not pay dividends until year 3, whereby it is expected to pay $5...
Alfonso Ltd will not pay dividends until year 3, whereby it is expected to pay $5 in dividends. Dividends are then expected to grow at 20%, 10% and 5% in years 4, 5 and 6. Afterwards, dividend growth will stabilize to 2% consistently. If the rate of return is 10%, determine the stock price in year 3. (With all the FORMULAS AND STEPS)
XYZ Corporation is expected to pay a dividend in Year 1 of $3.00, a dividend in...
XYZ Corporation is expected to pay a dividend in Year 1 of $3.00, a dividend in Year 2 of $2.00, and a dividend in Year 3 of $1.00. After Year 3, dividends are expected to decline at the rate of 2% per year. An appropriate required return for the shares is 8%. How much the shares should be worth today?
GHI Ltd. is not currently paying a dividend. In five years, it expects to pay a...
GHI Ltd. is not currently paying a dividend. In five years, it expects to pay a dividend of $0.50, and dividends are expected to grow at 4% a year afterward. If the return demanded is 12%, what should GHI be worth today? Our company projects the following FCFs for the next 3 years: $5,000,000; $5,500,000; $6,000,000. Future growth is expected to slow to 5% beyond year 3. What is the terminal value of the company in year 3 if the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT