Question

In: Finance

Melissa Popp is thinking about buying some shares of R.H. Lawncare​ Equipment, at $ 40.88 per...

Melissa Popp is thinking about buying some shares of R.H. Lawncare​ Equipment, at $ 40.88 per share. She expects the price of the stock to rise to $57.32 over the next 3 years. During that time she also expects to receive annual dividends of $4.38 per share.

a. What is the intrinsic worth of this​ stock, given a required rate of return of 11%​?

b. What is its expected​ return?

THIS QUESTION IS POSTED AS IS, MORE SO HOW DOES SHE KNOW THE STOCK IS GOING TO RAISE TO $57.32, ALSO, (I used Excel for this and it is giving me an error probably I am doing something wrong). PLEASE USE EXCEL AND ALSO A CALCULATOR WHEN SOLVING THIS QUESTION AND BE SPECIFIC WITH THE STEPS.

THANK YOU

Solutions

Expert Solution

Before starting the solution, expectation of 57.32 after 3 years is just her expectation. She might have used any model or some technical analysis to come to that figure. Anyways, since the question has already mentioned value after 3 years, we should not get into this right now as that is not the learning objective of this topic.

A. Intrinsic Value

Using Excel.

We discount the future cashflows at 11% to find the intrinsic value. We use a discount factor for each year and multiply that by Cashflows .

We sum the present values to get the intrinsic value.

DF for each year = 1/(1+R)^N i.e forr year 1 = 1/(1+11%)^1

11%
Cashflows DF PV
1 4.38 0.900901 3.945946
2 4.38 0.811622 3.554906
3 4.38 0.731191 3.202618
3 57.32 0.731191 41.91189
52.61536

We get Intrinsic Value of 52.61536

Using Financial Calculator:

We feed follwoing :

I/Y interest rate = 11%

N No of years = 3

PMT Dividend per year = 4.38

FV = End value of shares = 57.32

Calculate PV we get 52.62

B. What is the return of the shares.

Using Excel. We use goal seek function such that Total of present value is 40.88 and interest rate is variable.

In goal seek function, we select the cell where we have sum up the present value and set to value = 40.88, by changing cell where we have selected the interest rate  We get interest rat of 21.60%

Using Fin Calc:

Now we feed PV Present Value as -40.88 as that is our outflow.

Keeping N, PMT and FV same as above.

Then we calculate I/Y interest Rate we get 21.60%


Related Solutions

Melissa Popp is thinking about buying some shares of R.H. Lawncare​ Equipment, at $ 41.71 per...
Melissa Popp is thinking about buying some shares of R.H. Lawncare​ Equipment, at $ 41.71 per share. She expects the price of the stock to rise to $ 57.67 over the next 3 years. During that time she also expects to receive annual dividends of $ 4.78 per share. a. What is the intrinsic worth of this​ stock, given a required rate of return of 12 %​? b. What is its expected​ return?
Melissa Popp is thinking about buying some shares of R.H. Lawncare​ Equipment, at $ 52.24 per...
Melissa Popp is thinking about buying some shares of R.H. Lawncare​ Equipment, at $ 52.24 per share. She expects the price of the stock to rise to $ 69.68 over the next 3 years. During that time she also expects to receive annual dividends of $ 3.44 per share. a. What is the intrinsic worth of this​ stock, given a required rate of return of 9 %​? b. What is its expected​ return?
Melissa Cutt is thinking about buying some shares of EZLawn​ Equipment, at $33.74 per share. She...
Melissa Cutt is thinking about buying some shares of EZLawn​ Equipment, at $33.74 per share. She expects the price of the stock to rise to $43.94 over the next 3 years. During that time she also expects to receive annual dividends of $5.11 per share. a. What is the intrinsic worth of this​ stock, given a required rate of return of 12%​? b. What is its expected​ return?
It is early 2015, and you are thinking about buying some Greek bonds. a. You know...
It is early 2015, and you are thinking about buying some Greek bonds. a. You know that Greek bonds have very risky. Why would you still want to buy them, given that there is a high chance of default and non-payment? b. For the following situations, sketch a demand and supply diagram and explain what happens with the 1) price, 2) quantity of bonds sold and 3) the interest rate. Write 1-2 sentences to explain. 1. There are protests in...
Jack is thinking about buying shares in ABC Car Company, Inc. However, Jack can’t decide if...
Jack is thinking about buying shares in ABC Car Company, Inc. However, Jack can’t decide if he should buy shares of common stock or shares of preferred stock. What are some of the things he should consider in order to help him determine the type of share he should buy?
?You're thinking about buying some stock in Affiliated Computer Corporation and want to use the? P/E...
?You're thinking about buying some stock in Affiliated Computer Corporation and want to use the? P/E approach to value the shares. ? You've estimated that next? year's earnings should come in at about $4.58 a share. In? addition, although the stock normally trades at a relative? P/E of 1.26 times the? market, you believe that the relative?P/E will rise to 1.41 whereas the market? P/E should be around 19.1 times earnings. Given this? information, what is the maximum price you...
Ratana is thinking of buying shares in Deniliquin Forestry Limited. She estimates that the required rate...
Ratana is thinking of buying shares in Deniliquin Forestry Limited. She estimates that the required rate of return for this company is 10% per annum. She has forecast the Income Statement and Balance Sheet for the next four years, and estimates that the company can pay the following dividends: Year 1: Nil Year 2: 12 cents per share Year 3: 15 cents per share Year 4: 21 cents per share. Longer term Ratana estimates that dividends can grow at 3%...
Aiko is thinking of buying some vitamin supplement to boost her immunity. a)   In considering the...
Aiko is thinking of buying some vitamin supplement to boost her immunity. a)   In considering the purchase, which situational self (or selves) of Aiko should be the most active? b)   In what 3 different ways Aiko’s reference groups can influence her purchase? c)   Will her reference groups be equally influential? d)   Explain 3 types of social power a drugstore salesclerk can use to influence Aiko’s purchase. Please Answer all A-D question
You are thinking about buying a piece of art that costs $50,000. The art dealer is...
You are thinking about buying a piece of art that costs $50,000. The art dealer is proposing the following? deal: He will lend you the? money, and you will repay the loan by making the same payment every two years for the next 10 years? (i.e., a total of 5 ?payments). If the interest rate is 7% per? year, how much will you have to pay every two? years?
Ace Movers is thinking about buying a truck. In the first year it expects to earn...
Ace Movers is thinking about buying a truck. In the first year it expects to earn $9,000 and then during the second year it will be retro-fitted so it can burn natural gas. After that it will earn $14,000 per year for third, fourth and fifth years. Its cash flows can be summarized as follows: Year Cash Flow 0 -26,000 1 9,000 2 -6,000 3 14,000 4 14,000 5 14,000 Ace Mover's cost of capital (the interest rate on money...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT