Question: 1 all stocks have the same weight 2 portfolio average monthly return portfolio averager monthly return return variance buta stocks return variance beta Unilever PLC

return portfolio averager monthly return return variance buta stocks return variance beta

Unilever PLC (ULVEL 0.69% 0.25% 0.45501386 Un dever PLC (ULVRU) 0.69 0.25%

0.455013858 0.95% 0.66% 0.91601333 -15 169X 1.15 Rio Tinto plc (RO) GlaxoSmithKline

1 all stocks have the same weight 2 portfolio average monthly return portfolio averager monthly return return variance buta stocks return variance beta Unilever PLC (ULVEL 0.69% 0.25% 0.45501386 Un dever PLC (ULVRU) 0.69 0.25% 0.455013858 0.95% 0.66% 0.91601333 -15 169X 1.15 Rio Tinto plc (RO) GlaxoSmithKline ple 0.25% 0.00011330 0.49% -1.03% 1036701926 esset plc (ZILI Vodafone Group PIC VODU Ple, WAP | Rio Tinto plo) 6 2 -0.44 0.45% 1110 portfolio 0.95% 0.6 0.91001017 stocks were monthly return return variance beta 1SN 1 1.600015 10 awet plc 15% 1. Rolls Royce Holdings ple IRRI GlaxoSmithKlinec IGSKL The Royal Bank of Scotland Group 1915 0.31 0.25% 00011150 Vodafone Groupe IV0011 1,01% 0.4 1.01670193 1.95 10 1.722001 pl 00N 0.45 12 1110 0.05% 0.2 Rolls Royce Holdings ple IRL United Utilities Group PLC ULLI Legal & General Group PIEGEND 0.467151003 > 3660822 LIN 1.6800210 0.59% The Royal Bank of Scotland Group plc -1.95% LORS 172234 14 Lepa & General Group CLONA 0.47 0594 11366908 15 10 b- If you rank portfolio A, B and C according to their betas and return variances respectively, will the three portfolios have same ranking? Can you provide economic reasons as to why the two rankings should be (in)consistent with each other? (8 marks) C- Construct your own portfolio which consists of a different number of stocks from Portfolio A, B, and C and is "the best" for its return/risk characteristics. And can you justify why you choose such a portfolio? (6 marks) L M 0.5996 portfolio A portfolio avreage monthly return portfolio return variance portfolio beta portfolio C portfolio avreage monthly return -1.58% portfolio return variance 12.72% portfolio beta 3.420127334 4.03% 0.615352815 portfolio standard deviation portfolio standard deviation 0.16396 1.62% portfolio B portfolio avreage monthly return portfolio return variance -2.18% 16.95% , 2.664418437 portfolio beta portfolio Standard deviation 2.87% 1 all stocks have the same weight 2 portfolio average monthly return portfolio averager monthly return return variance buta stocks return variance beta Unilever PLC (ULVEL 0.69% 0.25% 0.45501386 Un dever PLC (ULVRU) 0.69 0.25% 0.455013858 0.95% 0.66% 0.91601333 -15 169X 1.15 Rio Tinto plc (RO) GlaxoSmithKline ple 0.25% 0.00011330 0.49% -1.03% 1036701926 esset plc (ZILI Vodafone Group PIC VODU Ple, WAP | Rio Tinto plo) 6 2 -0.44 0.45% 1110 portfolio 0.95% 0.6 0.91001017 stocks were monthly return return variance beta 1SN 1 1.600015 10 awet plc 15% 1. Rolls Royce Holdings ple IRRI GlaxoSmithKlinec IGSKL The Royal Bank of Scotland Group 1915 0.31 0.25% 00011150 Vodafone Groupe IV0011 1,01% 0.4 1.01670193 1.95 10 1.722001 pl 00N 0.45 12 1110 0.05% 0.2 Rolls Royce Holdings ple IRL United Utilities Group PLC ULLI Legal & General Group PIEGEND 0.467151003 > 3660822 LIN 1.6800210 0.59% The Royal Bank of Scotland Group plc -1.95% LORS 172234 14 Lepa & General Group CLONA 0.47 0594 11366908 15 10 b- If you rank portfolio A, B and C according to their betas and return variances respectively, will the three portfolios have same ranking? Can you provide economic reasons as to why the two rankings should be (in)consistent with each other? (8 marks) C- Construct your own portfolio which consists of a different number of stocks from Portfolio A, B, and C and is "the best" for its return/risk characteristics. And can you justify why you choose such a portfolio? (6 marks) L M 0.5996 portfolio A portfolio avreage monthly return portfolio return variance portfolio beta portfolio C portfolio avreage monthly return -1.58% portfolio return variance 12.72% portfolio beta 3.420127334 4.03% 0.615352815 portfolio standard deviation portfolio standard deviation 0.16396 1.62% portfolio B portfolio avreage monthly return portfolio return variance -2.18% 16.95% , 2.664418437 portfolio beta portfolio Standard deviation 2.87%

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!

GRW Company has the following account balances at the end of the year, before adjusting and closing entries. (All numbers are in thousands of dollars.) Required: Calculate and interpret the year-end...

portfolio A stocks weight average monthly return 0.69% return beta variance 0.25% 0.455044 standard deviation 5.09% 0.333 Unilever PLC (ULVR.L) Rio Tinto plc (RIO.L) GlaxoSmithKline plc (GSK.L) 0.95%...

Assignment 2 Directions: Create the spreadsheet for the mean-variance optimized portfolio using the 5 stocks and weights you chose previously. Steps for creating the optimized portfolio in Excel:...

this is for the question calcualte average monthly return. this the additional information for the other question when it requires to work out average monthly return and standard deviation. i think...

You are given price information on 10 stocks, the FTSE All Share Index, and risk-free rate (UK T- bill rate) from 07/2015 to 05/2020. Data can be accessed via the images below. You are required to...

Answer Using Spreadsheet Below You are given price information on 10 stocks, the FTSE All Share Index, and risk-free rate (UK T- bill rate) from 07/2015 to 05/2020. Data can be accessed in the Excel...

You are given price information on 10 stocks, the FTSE All Share Index, and risk-free rate (UK T- bill rate) from 07/2015 to 05/2020. Data can be accessed via the images below. You are required to...

THE STOCK MARKET & THE FIRMS? FUNDAMENTALS Stock market facilitates the exchange of securities between buyers and sellers. It is an important place for firms to raise money and for shareholders to...

GROUP TASK THE STOCK MARKET & THE FIRMS? FUNDAMENTALS Stock market facilitates the exchange of securities between buyers and sellers. It is an important place for firms to raise money and for...

You are given price information on 10 stocks, the FTSE All Share Index, and risk-free rate (UK T- bill rate) from 07/2015 to 05/2020. Data can be accessed via the images below. You are required to...

How would I implement a linkedList using the EntryIterator and iterator method used in the following classes in a HashTable Main Class? public String[] getKeys() { String[] keys = new...

Why is it important to know the basic steps in the folk dance?

GBA - 3 9 8 Integrated Perspectives on Business Accounting - Compliance in Actouming Which one of the following is the primary reason for establizhing internal controls in an organization? A To...

Questions Q1. Write a Python program to retrieve the first and last colors from the following list: color_list = ["red", "green", "white", "blue", "black") Q2. Given the following dictionary,...

1. Summarize your own opinion about whether videoconferencing is appropriate for meetings that your firm conducts. Are there any meetings that would not be right for videoconferencing?

2-29. COLLABORATION: PLANNING MEETINGS; MEDIA SKILLS: EMAIL SKILLS [LO-3] Youve probably worked as a volunteer on a committee or with team members for class assignments. You know how hard it is to...

2-25. COMMUNICATION ETIQUETTE: ETIQUETTE IN THE WORKPLACE [LO-6] As the regional manager of an international accounting firm, you place high priority on professional etiquette. Not only does it...