Question: I need the work done in excel! please show formulas for reference! The correlation between the returns of three stocks A,B,C are given in the

I need the work done in excel! please show formulas for

I need the work done in excel! please show formulas for reference!

The correlation between the returns of three stocks A,B,C are given in the following tables: The expected rates of returns on A,B, and C are 16%,12%, and 15% respectively. The corresponding standard deviations of the returns are 25%,22%, and 25%. a. What is the standard deviation of a portfolio invested 25% in stock A,25% in stock B, and 50% in Stock C? (17.80%) b. You plan to invest 50% of your money in the portfolio constructed the part a and 50% in the risk-free assets. The risk-free interest rate is 5%. What is the expected return on this investment? What is the standard deviation of the returns on this investment? (9.75%,8.9%)

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 follow these 4 file to finish a project. Read those file carefully and meet all requirements Assignment 1 International Portfolio Allocation You should write a polished and persuasive letter...

**PLEASE COMPLETE IN EXCEL & SHOW FORMULA'S** The correlation between the returns of three stocks A, B, C are given in the following tables: A Stock A B B A 1.00 1 2 3 4 B 0.80 1.00 D 0.10 0.15 1.00...

Please show me how to find the answer in Microsoft Excel. I need to know the formula/inputs used in the solution. The correlation between the returns of three stocks A, B, C are given in the...

please show all work ! 3. The correlation between the returns of three stocks A, B, C are given in the following tables: A D B A 1.00 B Stock A 1 2 3 4 0.80 1.00 0.10 0.15 1.00 The expected rates of...

DO IN EXCEL The correlation between the returns of three stocks A, B, C are given in the following tables: The expected rates of returns on A,B, and C are 16%,12%, and 15% respectively. The...

Q1. Portfolio Rebalancing You have 100 million dollars in your investment account and choose to keep your money allocated in the following proportion and rebalance each quarter: i. 60% in stocks via...

The correlation between the returns of three stocks A, B, C are given in the following tables: A B C D 1 STOCK A B C 2 A 1.00 0.8 0.10 3 B 1.00 0.15 4 C 1.00 The expected rates of returns on A, B,...

No excel please, show formulas and step by step. 22. Portfolio Returns and Deviations Consider the following information about three stocks: a. If your portfolio is invested 40 percent each in A and...

Only need the excel section completed. I will do the written report stuff. Model is the format I want it complete in. Thanks Date 6/1/2010 7/1/2010 8/1/2010 9/1/2010 10/1/2010 11/1/2010 12/1/2010...

I need help with what formulas to use for this assignment to make the whole system work with the markup cost. detailed instructions on how to set up the excel sheet and the proper formulas would be...

Journalize the following transactions for Brunswick Supply, Inc., that occurred during the month of October. Oct 3 Purchased $5,200 of merchandise on account, terms 2/10, n/30, FOB shipping point....

1. Observe Closely the painting "Harmony" by Pamela Allegretto 2. What can you say about the painting? Telk ehat you like most about it. ALLEGREttG

the LIFO method. the weighted-average method. the specific identification method. the LCM method

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

Many different people can conduct performance appraisals.

What are some reasons that people give for getting rid of performance appraisal?

2. This chapter provides an overview of the fi eld of communication and notes how it has evolved in response to social changes and issues. As a class, identify major changes you anticipate in U.S....