4. The Excel file Stock Data contains monthly data for Stock A and the S&P 500...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4. The Excel file Stock Data contains monthly data for Stock A and the S&P 500 Index (i.e., the market). Assume the risk free rate of return is 4%. a. Compute the monthly returns for Stock A and the S&P 500. b. Compute the average monthly return for Stock A and the S&P 500. c. Compute the annualized return for Stock A and the S&P 500. d. Compute the annual risk of Stock A and the S&P 500. e. Compute Beta for Stock A using the Covariance/Variance relationship. f. Compute the equation: RSTOCK A + BSTOCK ART and include the R² and the t-statistics for the equation and its coefficients. g. Are the Betas computed in parte and part f the same value? h. Plot the monthly returns on a graph. On this graph include a trendline, the computed equation, and the R' value. Label the axes and include a title for the graph. i. What is the technical name for this equation? J. What does a measure? k. What does ß measure? 1. What is the Beta for Security A? m. What is the Beta for the S&P 500? n. What are the t-statistics for a and 3? o. Are either of these t-statistics Significant? p. Compute the cost of equity (required rate of return) for Stock A using the classic CAPM. Also, explain how you determined the cost of equity. q. Compute the tax-adjusted cost of equity (required rate of return) for Stock A if the corporate tax rate is 35%. r. Compute the Weighted Average Cost of Capital (WACC) for Stock A using the classic CAPM if the corporate tax rate is 35%, the cost of debt is 20% and the capital structure is: 80% equity and 20% debt. Date 1-Jul-03 990.31 1-Aug-03 1008.01 S&P 500 2-Sep-03 995.97 1-Oct-03 1050.71 3-Nov-03 1058.20 1-Dec-03 1111.92 2-Jan-04 1131.13 2-Feb-04 1144.94 Stock A 3-Jan-05 1181.27 1-Feb-05 1203.60 1-Mar-05 1180.59 1-Apr-05 1156.85 2-May-05 1191.50 1-Jun-05 1191.33 1-Jul-05 1234.18 19.49 19.14 19.59 20.93 22.70 24.23 25.71 23.16 1-Mar-04 1126.21 23.57 1-Apr-04 1107.30 20.911 3-May-04 1120.68 22.37 1-Jun-04 1140.84 23.70 1-Jul-04 1101.72 20.92 2-Aug-04 1104.24 18.76 1-Sep-04 1114.58 18.10 1-Oct-04 1130.20 19.21 1-Nov-04 1173.82 18.75 1-Dec-04 1211.92 19.32 18.04 17.42 17.89 17.27 19.40) 19.08 19.15 4. The Excel file Stock Data contains monthly data for Stock A and the S&P 500 Index (i.e., the market). Assume the risk free rate of return is 4%. a. Compute the monthly returns for Stock A and the S&P 500. b. Compute the average monthly return for Stock A and the S&P 500. c. Compute the annualized return for Stock A and the S&P 500. d. Compute the annual risk of Stock A and the S&P 500. e. Compute Beta for Stock A using the Covariance/Variance relationship. f. Compute the equation: RSTOCK A + BSTOCK ART and include the R² and the t-statistics for the equation and its coefficients. g. Are the Betas computed in parte and part f the same value? h. Plot the monthly returns on a graph. On this graph include a trendline, the computed equation, and the R' value. Label the axes and include a title for the graph. i. What is the technical name for this equation? J. What does a measure? k. What does ß measure? 1. What is the Beta for Security A? m. What is the Beta for the S&P 500? n. What are the t-statistics for a and 3? o. Are either of these t-statistics Significant? p. Compute the cost of equity (required rate of return) for Stock A using the classic CAPM. Also, explain how you determined the cost of equity. q. Compute the tax-adjusted cost of equity (required rate of return) for Stock A if the corporate tax rate is 35%. r. Compute the Weighted Average Cost of Capital (WACC) for Stock A using the classic CAPM if the corporate tax rate is 35%, the cost of debt is 20% and the capital structure is: 80% equity and 20% debt. Date 1-Jul-03 990.31 1-Aug-03 1008.01 S&P 500 2-Sep-03 995.97 1-Oct-03 1050.71 3-Nov-03 1058.20 1-Dec-03 1111.92 2-Jan-04 1131.13 2-Feb-04 1144.94 Stock A 3-Jan-05 1181.27 1-Feb-05 1203.60 1-Mar-05 1180.59 1-Apr-05 1156.85 2-May-05 1191.50 1-Jun-05 1191.33 1-Jul-05 1234.18 19.49 19.14 19.59 20.93 22.70 24.23 25.71 23.16 1-Mar-04 1126.21 23.57 1-Apr-04 1107.30 20.911 3-May-04 1120.68 22.37 1-Jun-04 1140.84 23.70 1-Jul-04 1101.72 20.92 2-Aug-04 1104.24 18.76 1-Sep-04 1114.58 18.10 1-Oct-04 1130.20 19.21 1-Nov-04 1173.82 18.75 1-Dec-04 1211.92 19.32 18.04 17.42 17.89 17.27 19.40) 19.08 19.15
Expert Answer:
Answer rating: 100% (QA)
A Compute the monthly returns for Stock A and the SP 500 Monthly Returns for Stock A July 03 194919141914 189 August 03 19141959119591 229 September 03 1959120932093 603 October 03 209322702270 807 No... View the full answer
Related Book For
Financial Markets and Institutions
ISBN: 978-0077861667
6th edition
Authors: Anthony Saunders , Marcia Cornett
Posted Date:
Students also viewed these mathematics questions
-
The risk- free rate of return is 8 percent, the expected rate of return on the market portfolio is 15 percent, and the stock of Xyrong Corporation has a beta coefficient of 1.2. Xyrong pays out 40...
-
Judy Johnson is choosing between investing in two Treasury securities that mature in five years and have par values of $1,000. One is a Treasury note paying an annual coupon of 5.06 percent. The...
-
A particular securitys equilibrium rate of return is 8 percent. For all securities, the inflation risk premium is 1.75 percent and the real risk-free rate is 3.5 percent. The securitys liquidity risk...
-
H. Brown (Portsmouth) Ltd produces a range of central heating systems for sale to builders merchants. As a result of increasing demand for the businesss products, the directors have decided to expand...
-
Discuss the circumstances in which CVP analysis might be useful.
-
A1 x 10 -3 m -3 chunk of material has a mass of 3 kg. a. What is the material's density? b. Would a 2 x 10 - 3 m 3 chunk of the same material have the same mass? Explain. c. Would a 2 x 10 -3 m 3...
-
A machine is said to be reversible, if its efficiency is (a) equal to \(100 \%\) (b) less than \(50 \%\) (c) more than \(50 \%\) (d) equal to \(50 \%\)
-
How does the balanced scorecard empower managers to understand and compare the interests of all the organizations stakeholders ?
-
Why would it be a good idea to do international business or start an business in Canada? with supporting details related to and backing the point.
-
I SEE THE LIGHT (ISTL) is a subchapter S corporation that manufactures children's lamps/nightlights for use in bedrooms. These lamps are sold nationwide through a group of independent sales...
-
2)On a hot summer day, you decide to mix some Kool-Aid and freeze it into popsicles. The water used for the Kool-Aid was 75F and the freezer has a temperature of -20F. Use Newton's Law of Cooling....
-
What is GAAP and why is it important to the users of financial statements? Please explain.
-
Ben and Janet conduct an inspection of the property and report back that the length of the property seems to be a bit over a metre shorter than the title plan indicates. Which specific clause in the...
-
A particle of charge 2.3 x 10C experiences an upward force of magnitude 5.0 x 10-6 N when it is placed in a particular point in an electric field. (Indicate the direction with the signs of your...
-
Ted the manager Paradise Cafe , decided to change the software used to conduct transactions and enter customers orders Rather than creating a step by - step manual and training employees on how to...
-
Assume: annual inflation rate is 3.5% in the U.S. and 1.5% in the U.K.; the current spot rate is $1.50/ Calculate the price of USD 1year from now based on relative PPP. Write your answer as a number...
-
A car rental firm has 455 cars. Sixty-one of these cars have defective turn signals and 38 have defective tires. (Enter your probabilities as fractions.) (a) What is the probability that one of these...
-
(a) Explain why the concentration of dissolved oxygen in freshwater is an important indicator of the quality of the water. (b) How is the solubility of oxygen in water affected by increasing...
-
Can all assets and loans be securitized? Explain your answer.
-
Who are the demanders of loanable funds?
-
What is a mutual fund? In what sense is it a financial institution?
-
Honeybees accumulate charge as they fly, and they transfer charge to the flowers they visit. Honeybees are able to sense electric fields; tests show that they can detect a change in field as small as...
-
A platypus foraging for prey can detect an electric field as small as 0.002 N/C. To give an idea of the sensitivity of the platypuss electric sense, how far from a +10 nC point charge does the field...
-
Raindrops acquire an electric charge as they fall. Suppose a 2.5-mm-diameter drop has a charge of +15 pC; these are both typical values. If the strength of the earths electric field is 100 N/C, how...
Study smarter with the SolutionInn App