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...
-
Fraud experts often say that there are three primary factors that contribute to employee fraud. Identify the three factors and explain what is meant by each.
-
In Exercises 1150, evaluate the limit if it exists. If not, determine whether the one-sided limits exist. For limits that dont exist indicate whether they can be expressed as = or = lim x-b x - 6...
-
Repeat the numerical integration in Example 15-5, except use the quadrature formula, Eq. \((9-12)\) Example 5-5 Equation (9-12) A steady-state system of ethanol and water has equimolar...
-
Lipex, Ltd., of Birmingham, England, is interested in cutting the amount of time between when a customer places an order and when the order is completed. For the first quarter of the year, the...
-
If something cannot be objectively measured, it should be reported at its original purchase price in accordance with the: Question 1 options: Conservatism principle Cost principle Going concern...
-
Lewis Company reports the following fixed budget and actual results for May. Prepare a flexible budget performance report showing variances between budgeted and actual results. (Indicate the effect...
-
Evans (2022) explains theories as a framework that describes, explains, and predicts social outcomes. This is a more straightforward explanation of theoretic evidence and its relationship to social...
-
1. What is diet as tolerated? Indications? Examples 2. You are taking care of a patient who has been ordered to undergo a surgery requiring general anesthesia. Clear liquid diet was ordered. What is...
-
In building business relationships, there are many ways that you can record the interactions you have. What type of information should you keep record of? How does your personal appearance affect the...
-
Carryless Arithmetic is basic arithmetic but with the carry from each column ignored. For example, using carryless multiplication, 4 * 4 = 6 but 3* 3 still equates to 9. Below is an example using...
-
discuss the ethical issues surrounding performance appraisal and provide Examples
-
1. What makes up a teacher's unique teaching philosophy, and why is it essential for educators to define their own? How does a teacher's distinct teaching philosophy enrich the overall educational...
-
Smith buys a $250,000 house. She makes a $50,000 payment immediately and borrows $200,000 from the bank. The bank charges interest at the rate of 1% per month, compounded monthly. Smith makes level...
-
Consider the activities undertaken by a medical clinic in your area. Required 1. Do you consider a job order cost accounting system appropriate for the clinic? 2. Identify as many factors as possible...
-
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...
-
Decade, Inc., recorded certain capital stock transactions shown in the following journal entries: (1) issued common stock for \(\$ 25\) cash per share, (2) purchased treasury shares at \(\$ 40\) per...
-
Label each of the following characteristics of a corporation as either an (A) advantage or a (D) disadvantage: a. Limited liability b. Taxation c. Regulations d. Transferability of ownership
-
The following information relates to Ontario Components, Inc.: a. Calculate the company's return on common stockholders' equity for 2018 and 2019. b. Calculate the company's dividend yield for 2018...
Study smarter with the SolutionInn App