Assume that the risk-free rate is 3% and the market risk premium 6%. ty: Historical Return: Expected
Fantastic news! We've Found the answer you've been seeking!
Question:
Assume that the risk-free rate is 3% and the market risk premium 6%.
Transcribed Image Text:
ty: Historical Return: Expected and Required Rates of Return Year 2011 2012 2013 2014 2015 Stock X 13 % 20 -15 2 23 Stock Y 12 % 6 -3 1 9 Market 12 % 10 -12 2 15 Assume that the risk-free rate is 3% and the market risk premium is 6%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. What is the beta of Stock X? Do not round intermediate calculations. Round your answer to two decimal places 0.45 What is the beta of Stock Y? Do not round intermediate calculations. Round your answer to two decimal places. 0.45 b. What is the required rate of return on Stock X? Do not round intermediate calculations. Round your answer to one decimal place. 11.96 My What is the required rate of return on Stock Y? Do not round intermediate calculations. Round your answer to one decimal place. 5.71 % c. What is the required rate of return on a portfolio consisting of 80% of Stock X and 20% of Stock Y? Do not round intermediate calculations. Round your answer to one decimal place. 10.71 % ty: Historical Return: Expected and Required Rates of Return Year 2011 2012 2013 2014 2015 Stock X 13 % 20 -15 2 23 Stock Y 12 % 6 -3 1 9 Market 12 % 10 -12 2 15 Assume that the risk-free rate is 3% and the market risk premium is 6%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet a. What is the beta of Stock X? Do not round intermediate calculations. Round your answer to two decimal places 0.45 What is the beta of Stock Y? Do not round intermediate calculations. Round your answer to two decimal places. 0.45 b. What is the required rate of return on Stock X? Do not round intermediate calculations. Round your answer to one decimal place. 11.96 My What is the required rate of return on Stock Y? Do not round intermediate calculations. Round your answer to one decimal place. 5.71 % c. What is the required rate of return on a portfolio consisting of 80% of Stock X and 20% of Stock Y? Do not round intermediate calculations. Round your answer to one decimal place. 10.71 %
Expert Answer:
Answer rating: 100% (QA)
Rf Risk Free Rate Risk Premium Rm Rf Market Ret Risk free Ret Marke... View the full answer
Related Book For
Applied Calculus
ISBN: 9781119275565
6th Edition
Authors: Deborah Hughes Hallett, Patti Frazer Lock, Andrew M. Gleason, Daniel E. Flath, Sheldon P. Gordon, David O. Lomen, David Lovelock, William G. McCallum,
Posted Date:
Students also viewed these finance questions
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
Aim:- Write a PROLOG Program to generate query based on family relationship.
-
Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant...
-
Bloomberg Intelligence listed 50 companies to watch in 2018 (www .bloomberg.com/features/companies-to-watch-2018). Twelve of the companies are listed here with their total assets and 12-month sales....
-
Leslie is a single taxpayer who is under age 65 and in good health. For 2016, she has a salary of $24,000 and itemized deductions of $1,000. Leslie is entitled to one exemption on her tax return. a....
-
How have medical technologies affected our understanding of death? How have they affected legal definitions of death? How do we know when it is time to "unplug" a loved one? Why do we spend so much...
-
Give a brief outline of the historical development of auditing.
-
Below are several factors that can result in project delays and cost overruns. Explain how these problems can be overcome. a. Poorly defined milestones b. Poor estimating techniques c. A missing...
-
In Exercises 33 and 34, use the product rules in Exercises 31 and 32. A vector field F is incompressible if div (F) = 0 and is irrotational curl (F) = 0. 33. Let F be an incompressible vector field...
-
You are working on a free-form Packet Tracer challenge activity as seen in Figure 1, you have been given the London Railways network.' The purpose of this EMA question is to build upon each of the...
-
a. Kristi is considering an investment that will pay $7,500 a year for eight years, starting one year from today. How much should she pay for this investment if she wishes to earn a 6% rate of...
-
What type of study would you undertake to collect data for the variable in your qualitative research question? If a survey, attach a copy of your survey to your report and explain what medium you...
-
4. If a direct quote of the Mexican peso (MXN) is $0.05, what is the number of MXN you need to purchase one U.S. dollar?
-
Huron Company produces a commercial cleaning compound known as Zoom. The direct materials and direct labor standards for one unit of Zoom are given below: Direct materials Direct labor Standard...
-
Fly Jet is an airline currently advertising through multiple media channels. They are interested in better understanding the profit their marketing efforts are generating by calculating the Return on...
-
Explain the unique types of manufacturing cost categories and how each is used to predict cost behaviors related to variable and fixed costs. Support your rationale with examples and provide one...
-
SAP plans to develop a new enterprise resource planning (ERP) software with the following financial implications: Development Costs: $1.2 billion Estimated Annual Revenue: $600 million Operating...
-
As indicated by mutual fund flows, investors tend to beat the market seek safety invest in last year's winner invest in last years loser
-
Find the partial derivatives in Problems. The variables are restricted to a domain on which the function is defined. f u and f v if f(u, v) = u 2 + 5uv + v 2
-
Fill in the missing values in Table 9.3 given that dydt = 0.5t. Assume the rate of growth, given by dydt, is approximately constant over each unit time interval. Table 9.3 t y 0 1 2 3 8 4
-
Differentiate the functions in Problems. Assume that A and B are constants. f(0) = sin 0 0
-
Feld Hospital purchased a special x-ray machine. The machine, which cost $623,120, was expected to last ten years, with an estimated residual value of $63,120. After two years of operation (and...
-
On January 13, 2006, Silverio Oil Company purchased a drilling truck for $45,000. Silverio expects the truck to last five years or 200,000 miles, with an estimated residual value of $7,500 at the end...
-
Percival Burglar Alarm Systems Company purchased a computer for $1,120. It has an estimated useful life of four years and an estimated residual value of $120. Compute the depreciation charge for each...
Study smarter with the SolutionInn App