Question: Please answer using EXCEL, also please include steps used to answer questions. Thank you! 11. Here are some historical data on the risk characteristics of

Please answer using EXCEL, also please include steps used to answer questions. Thank you!

11. Here are some historical data on the risk characteristics of Ford and Harley Davidson.

Ford Harley Davidson

Beta 1.36 0.87

Annual Standard Deviation of return (%) 32.4 16.2

a) The correlation coefficient of Fords return versus Harley Davidson is 0.41. What is the standard deviation of a portfolio invested half in each share?

b) What is the standard deviation of a portfolio invested one-third in Ford, one-third in Harley Davidson,and one-third in risk-free Treasury bills?(Hint: treat the whole portfolio as a portfolio in part a) plus risk-free assets. You need to figure out the new weights.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

PLEASE COMPLETE IN EXCEL AND LIST FORMULAS YOU USED ATC Inc. is a manufacturing company that produces industrial valves. As the operations manager, you need to determine the production schedule...

The word document has all the instructions and they need to be answered in excel. I have attached the excel worksheet as well. Please answer in excel and show all the calculations as well as answer...

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...

please help with the clear steps to understand this questions . thank you Question 3 of 11 This tabe 100 pontosable This question: 10 points) possible Warner Containers currently uses a recycled...

I am having a hard time creating the balance sheet with the data given on page page 2 and 3. I know I am not suppose to include dining out, hobbies, maid, dry cleaning and parking tolls but do I...

CASE STUDY ANALYSIS: BRANDING IS FOREVER: A framework for revitalizing, declining and dead brand 1) Summarize key trends in Branding 2) Identify the various alternative solutions that the companies...

Case Study "Polaris & Victory: Entering & Growing the Motorcycle Business" Steve Menneto, vice president in charge of the Motorcycle Division at Polaris Industries, gazed up at company headquarters...

hi, please the question is done, but can someone explain how did you find the number in the answear G- What should Kim ford recommend regarding an investment nike? how did you find the number...

I need your help with this: Can you please quote from the attached chapters / resource if possible? Corporations often use different costs of capital for different operating divisions. Using an...

Please see attachment. All three question need to be answered in narrative format. If you have questions, just let me know. Normal requirement for references are 2 outside our course text....

What's this story about? A Lot of Weeding Masa walked slowly toward the house, stopping now and then to snip off fading flowers, or to pull out weeds growing between the plants. But there were very...

Suppose that X1, . . . , Xn form a random sample from a Poisson distribution for which the value of the mean is unknown ( > 0). Let T = and for i = 1, . . . , n, let the statistic Yi be defined as...

Which of the following mortgage forms best identifies the mortgage scenario in which there are scheduled required periodic payments of principal, but the principal is not paid off completely over the...

Skills necessary for success in marketing include Multiple select question. analytical thinking advertising industry experience infallibility ability to work with others

=+6. How could you make the site more interactive and engaging? What links would you add?

=+Think small screen and small space. Less is more. You might have to not only cut copy, but also use fewer subheads per page. Perhaps you would include more links and less copy. Focus on what are...

=+ What participatory activities would you include? Perhaps a drawing tool to customize a product.