A possible investment candidate

Reference no: EM131108101

Fundamental Toys Inc. is looking to expand its stock portfolio. You receive an urgent text message from Bob:

I need you to analyze a Stock X as a possible investment candidate for the company's stock portfolio. The CFO has asked me to make a decision ASAP. I left the data you need on your desk.

Fortunately, Excel has the capability of performing regression analysis with built-in algorithms. This frees the analyst from complicated algebraic formulations and data management.

The following data has been collected to help you run a linear regression between Stock X and the New York Stock Exchange (NYSE) on which Stock X is traded. Use CAPM as the investment decision model.

Data from Bob

	Historical Rates of Return
Year	NYSE	Stock X
1	(30%)	(19.0%)
2	32.5	20.5
3	21.6	16.5
4	(9.8)	0.5
5	7.8	9.7
6	22	20.5
7	33.5	19.8
(Source: Intermediate Financial Management, Brigham and Davies, 10th edition)

The NYSE is the independent variable, X-axis, which is the proxy market portfolio. Stock X is the dependent variable, Y-axis. Also, assume a market return (NYSE) of 12%, the risk-free rate of 4% and the market return of Stock X of 7.85%.

Submit the following items in to the online drop box.

The Excel regression function (the regression equation).
The SML constructed from the risk-free rate, beta (slope of the regression function), and the market return provided above.
Your conclusion on the stock purchase given your CAPM analysis and the market return of Stock X. Provide support for your decision.

Reference no: EM131108101

Questions Cloud

Is the flow choked : Determine the mass fux of air flowing through the nozzle if the receiver exits to the atmosphere. (a) Use equations and (b) use the appropriate table.

The discount is amortized on a straight line basis : Prepare the entry(ies) to record the interest expense and conversion on April 30, 2011. Reversing entries were made on January 1, 2011.

Expected value of information : A firm's expected profit without information is $49,495, while its expected value with test information is $57,902. If the cost of the test is $14,710, then the expected value of information is

What events lead to the great war or world war i : What events lead to the great war or world war I? What did american gain, and what did they lose during this time

A possible investment candidate : I need you to analyze a Stock X as a possible investment candidate for the company's stock portfolio. The CFO has asked me to make a decision ASAP. I left the data you need on your desk.

In what ways was chinese history similar to roman history : In what ways was Chinese history similar to Roman history during the classical period? Was the Chinese empire created in a similar way to the Roman Empire? Did it have a similar effect on Chinese society

Calculate the net present value (npv) : Calculate the net present value (NPV), Indicate whether to accept or reject the machine, and Explain your decision.

Draw a conclusion about the impacts of new technologies : Draw a conclusion about the impacts of new technologies and understandings of nature and humanity on medieval culture. Consider both Christian and Arab developments

Sharp metal edge of a table : A century ago, there was, of course, no such thing as KFC; automobiles were still a novelty; and if you cut your finger on the sharp metal edge of a table, you ran a real risk of dying from blood poisoning. The entire masterpiece gives?

User Account

All Pages