Please read the instructions carefully. The following questions are related to the following risky securities issued...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Please read the instructions carefully. The following questions are related to the following risky securities issued by: Sainsbury: J Sainsbury PLC (Reg. no: 00185647). The holding company whose subsidiaries engaged in the food, general merchandise and clothing retailing, and financial services activities in the United Kingdom. BAT: British American Tobacco PLC (Reg. no: 03407696). The holding company owns, directly or indirectly, investments in the numerous companies constituting the British American Tobacco Group activities include the manufacture, distribution or sale of tobacco and nicotine products. GSK: Glaxosmithkline PLC (Reg. no: 03888792). It manufactures various pharmaceutical products. (Source: FAME) Required: Choose from the above three, two securities of interest to you to address the following questions: a) Calculate the monthly rates of return for each of the chosen securities • Your calculation should be using the monthly closing stock prices from December 2012 to December 2019. you can use Yahoo finance. • You can use Microsoft Excel functions to expedite your calculation, but please show the mathematical formula used. • Please show rates of return up to three digits after decimal point. For example, 0.000 instead of 0.000%. (8 marks) b) Based on your calculation in (a), calculate for each of the chosen securities: i. ii. Average monthly rate of return (Note: Assume each monthly return has equal chance to occur). Standard deviation of the monthly rates of return in the sample. (You can use Microsoft Excel functions to expedite your calculation. Please show answers up to three digits after decimal point) (4 marks) c) Calculate the weighted average rate of return and standard deviation of retums for the portfolio containing the combination of your two chosen securities in varying weights as indicated below. Then, choose a recommended portfolio. Summarize your answers in the following table. For example, for Sainsbury-BAT portfolio: Weight Portfolio 123456 2 3 4 6 7 8 9 10 11 Sainsbury 0.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 BAT 1.0 0.9 0.8 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0.0 Weighted average rate of return Standard deviation of returns Recommended portfolio (Please tick V only one) (Note: You can use Microsoft Excel functions to expedite your calculations. Please show answers up to three digits after decimal point) (4 marks) d) For each of the portfolios in (c) above, plot the portfolio risk-return for different weights of assets (Note: For the risk-return plots, return is on vertical axis and risk is on horizontal axis). Discuss what do you learn from this analysis. (4 marks) Please read the instructions carefully. The following questions are related to the following risky securities issued by: Sainsbury: J Sainsbury PLC (Reg. no: 00185647). The holding company whose subsidiaries engaged in the food, general merchandise and clothing retailing, and financial services activities in the United Kingdom. BAT: British American Tobacco PLC (Reg. no: 03407696). The holding company owns, directly or indirectly, investments in the numerous companies constituting the British American Tobacco Group activities include the manufacture, distribution or sale of tobacco and nicotine products. GSK: Glaxosmithkline PLC (Reg. no: 03888792). It manufactures various pharmaceutical products. (Source: FAME) Required: Choose from the above three, two securities of interest to you to address the following questions: a) Calculate the monthly rates of return for each of the chosen securities • Your calculation should be using the monthly closing stock prices from December 2012 to December 2019. you can use Yahoo finance. • You can use Microsoft Excel functions to expedite your calculation, but please show the mathematical formula used. • Please show rates of return up to three digits after decimal point. For example, 0.000 instead of 0.000%. (8 marks) b) Based on your calculation in (a), calculate for each of the chosen securities: i. ii. Average monthly rate of return (Note: Assume each monthly return has equal chance to occur). Standard deviation of the monthly rates of return in the sample. (You can use Microsoft Excel functions to expedite your calculation. Please show answers up to three digits after decimal point) (4 marks) c) Calculate the weighted average rate of return and standard deviation of retums for the portfolio containing the combination of your two chosen securities in varying weights as indicated below. Then, choose a recommended portfolio. Summarize your answers in the following table. For example, for Sainsbury-BAT portfolio: Weight Portfolio 123456 2 3 4 6 7 8 9 10 11 Sainsbury 0.0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1.0 BAT 1.0 0.9 0.8 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0.0 Weighted average rate of return Standard deviation of returns Recommended portfolio (Please tick V only one) (Note: You can use Microsoft Excel functions to expedite your calculations. Please show answers up to three digits after decimal point) (4 marks) d) For each of the portfolios in (c) above, plot the portfolio risk-return for different weights of assets (Note: For the risk-return plots, return is on vertical axis and risk is on horizontal axis). Discuss what do you learn from this analysis. (4 marks)
Expert Answer:
Answer rating: 100% (QA)
a Monthly Rates of Return for Sainsbury and BAT Sainsbury J Sainsbury PLC Date Closing Price Previous Month Closing Price Monthly Return Dec2012 29450 29050 00137 Jan2013 29450 29450 00000 Feb2013 301... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Please read the instructions carefully and provide what is being requested. A new client of yours, Bailey Waters wants to open a small dessert cafe selling cupcakes, pie slices, custard, ice cream...
-
The following are the monthly rates of return for Madison Corp. and for Sophie Electric during a six-month period. a. Compute the average monthly rate of return for each stock. b. Compute the...
-
The following are the monthly rates of return for Madison Cookies and for Sophie Electric during a six-month period. Compute the following. a. Average monthly rate of return Ri for each stock b....
-
Aneko Company reports the following ($000s): net sales of $14,800 for 2018 and $13,990 for 2017; end-of-year total assets of $19,100 for 2018 and $17,900 for 2017. Compute its total asset turnover...
-
Federal law requires most interstate truckers to obtain a permit that reflects compliance with certain federal requirements. The 1965 version of the law authorized states to require proof that a...
-
The customer help center in your company receives calls from customers who need help with some of the customized software solutions your company provides. Your company claims that the average waiting...
-
Retelsdorf Ltd manufactures tablet screens. Recently, the company has been producing slightly below 75% of capacity and management is considering how to use currently unused plant capacity. One...
-
Muhsin Company has gathered the information shown on the next page about its product. Direct materials: Each unit of product contains 4.5 pounds of materials. The average waste and spoilage per unit...
-
A company has established that the relationship between the sales price for one of its product and the quantity sold per month is approximately p = 75 - 0.1D units (D is the demand or quantity sold...
-
Seawater with a concentration of 8000 g/m3 is pumped into a well-mixed tank at a rate of 0.6 m3/hr. Because of faulty design work, water is evaporating from the tank at a rate of 0.025 m3/hr. The...
-
According to the "impossible trinity," it is not possible to simultaneously have 1) a fixed exchange rate regime, 2) perfect capital mobility, and 3) an independent monetary policy. Based on the...
-
Tom Brady attempts to kick a field-goal barefoot. He imparts a speed of 32 m/s to a football initially at rest. If the football has a mass of 0.23 kg and the time of contact with the ball is 0.011 s,...
-
If Apex chooses to produce 500 units of product B instead of 460 of them, why must it give up the production of 400 units of product A? Apex Industries Production Possibilities Frontier 1,000 A E...
-
How can I find a rival hypothesis for my current thesis of Walmart's CEO should implement intra-team communication for all associates to help with communication barriers between managers and...
-
Explain the difference between Deductive and Inductive reasoning in communication.Provide an example of effectively commutating a negative message. Scenario: You have received audit feedback that...
-
How can the circular wait condition be detected and broken to prevent deadlock in complex systems with multiple interdependent resources ?
-
Based on the following data for Privett Company, what is the quick ratio, rounded to one decimal point? Privett Company Accounts payable Accounts receivable Accrued liabilities Cash Intangible assets...
-
Classify each of the following activities as proper or prohibited under the various consumer statutes you have studied. a. Calling a hospital room to talk to a debtor who is a patient there. b....
-
In June of 2012, Maureen's house is vandalized during a long-term power failure after a hurricane hit the city. The president of the United States declares Maureen's city a disaster area as a result...
-
Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...
-
Carl and Jenny adopt a Russian orphan. The adoption takes 2 years and two trips to Russia and is final in 2012. They pay $6,000 in 2011 and $7,500 in 2012 of qualified adoption expenses, and have AGI...
-
Use the Any Entry pattern to model entries in a spreadsheet style application. a. Draw a class diagram of using Any Entry pattern. b. Generate a significant use case for this context. c. Map the use...
-
List and explain essential properties of analysis patterns.
-
Why is it important that each pattern must focus on one specific problem?
Study smarter with the SolutionInn App