Question

In: Finance

PLEASE SHOW THE FORMULAS EMBEDDED INTO EACH CELL SO THAT I CSN MIMICK THE FORMULAS MYSELF...

PLEASE SHOW THE FORMULAS EMBEDDED INTO EACH CELL SO THAT I CSN MIMICK THE FORMULAS MYSELF

3. (10 pts.) Mathematically show whether the stock price of company A, which features a required rate of return five times the value of it's expected growth rate, is necessarily lower than the stock price of company B, which features a required rate of return three time the value of it's expected growth rate.

Solutions

Expert Solution

Po =   D1
Ke-G

Where,
P0 = . Fair Value of Stock
D1 = Expected Dividend

Ke = Required Rate of return

G = Growth Rate.

Lets take Example :

Company A: required rate of return five times the value of it's expected growth rate :
Expected Dividend = $10 ; Required rate of return = 10% ; Growth Rate = 2%

Now calculate the P0 with above formula = $10
0.10-0.02

P0 = $125

Lets take Example 2.  

Company B : Required rate of return three time the value of it's expected growth rate.
: Expected Dividend = $10 ; Required rate of return = 6% ; Growth Rate = 2%

Now calculate the p0 in same manner only values changed :

So, P0 = $10
0.06-0.02

P0 = $250

In view of the above we can conclude that Higher the Required rate of return lower will be the fair value of stock.
We can find the same in our example where Company A : required rate is higher so, its fair value of Stock price is lower compare to Company B. Because company b have lower required rate of return.


Related Solutions

PLEASE SHOW ALL WORK. I am teaching myself so I need step by step. If you...
PLEASE SHOW ALL WORK. I am teaching myself so I need step by step. If you use charts, please let me know what was multiplied, divided, etc. for that cell box. Thank you! The Chapman Manufacturing Company has two service departments — manufacturing support and facilities management, and two production departments — assembly and packing/shipping. The distribution of each service department's efforts to the other departments is shown below: FROM TO Support Facilities Assembly Pack/Ship Support 0 % 45 %...
Use excel and show both the numbers and the formulas so I can learn how to...
Use excel and show both the numbers and the formulas so I can learn how to do it If I want to invest $1200 a year for 20 years and then stop investing for 10 years, to pay for my slacker child to get a doctorate, how much will I need to invest a year in my final 10 years of work to get my $2,000,000 to make me really happy at 12% interest?
Please show formulas, I just want to verify that I was doing the work correctly and...
Please show formulas, I just want to verify that I was doing the work correctly and please show one example of the case rate and ratio of cases, Thank you The population of a state is 2,100,000. In a surveillance project lasting three months, investigators found communicable disease reports documenting one case of anthrax, three cases of mumps, 132 cases of pertussis, 27 cases of tuberculosis, 10 cases of primary and secondary syphilis, and 374 cases of gonorrhea. Calculate the...
Please show all calculations and formulas. If using Escel, please show data/formulas. practice 10: Show the...
Please show all calculations and formulas. If using Escel, please show data/formulas. practice 10: Show the effects of these transactions on the balance sheet equity accounts. Presently the stock price is $20 per share. You started with: common stock ($1 par value) $10,000, capital surplus $100,000, retained earnings $200,000: a. 12% stock dividend b. repurchased 1,000 shares (repurchase price is PV of 20)
Please use EXCEL to answer and show all formulas. I can't understand the answer if I...
Please use EXCEL to answer and show all formulas. I can't understand the answer if I can't see the formulas for each field. Thank you very much. Newman manufacturing is considering a cash purchase of the stock of Grips Tool. During the year just​ completed, Grips earned $4.25 per share and paid cash dividends of ​$2.55 per share ​(D0=$2.55). Grips' earnings and dividends are expected to grow at 25​% per year for the next 3​ years, after which they are...
PLEASE SHOW THE EXCEL INPUTS AND FORMULAS AS I AM VERY NEW TO THIS SUBJECT AND...
PLEASE SHOW THE EXCEL INPUTS AND FORMULAS AS I AM VERY NEW TO THIS SUBJECT AND WANT TO LEARN EXCEL INPUTS. Problem 7-18 Abandonment We are examining a new project. We expect to sell 6,300 units per year at $57 net cash flow apiece for the next 10 years. In other words, the annual operating cash flow is projected to be $57 × 6,300 = $359,100. The relevant discount rate is 12 percent, and the initial investment required is $1,740,000....
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so I can see how you solved the question 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...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so I can see how you solved the question 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...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so I can see how you solved the question 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...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so...
Can you please post the excel answers and post the (SHOW FORMULAS) button as well so I can see how you solved the question 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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT