you will find monthly returns for four stocks plus the FTSE All-share index (the market index)....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
you will find monthly returns for four stocks plus the FTSE All-share index (the market index). Calculate the standard deviation for the monthly return of each stock and the FTSE, and put the results in the following table. Standard Deviation Expected Return Sainsbury Reckitt Benckiser Rio Tinto Standard Life FTSE all share Beta Sainsbury Reckitt Benckiser Rio Tinto Apr-30-2018 29.39699025 -3.976711573 9.277208276 May-31-2018 3.009722367 1.034725069 7.450582781 Jun-30-2018 3.252492143 8.297171097 -0.919811435 Jul-31-2018 1.80572272 8.943740547 -0.107117603 Aug-31-2018 -0.856277084 -2.488343631 -10.61853616 Sep-30-2018 -0.740300636 6.967526605 6.039899259 Oct-31-2018 -3.29396546 -9.734892485 -1.971649761 Nov-30-2018 -1.023760434 2.826465795 -6.428287659 Dec-31-2018 -13.11477145 -7.662776422 4.804717878 Jan-31-2019 7.622665515 -2.494596044 12.2654156 Feb-28-2019 -19.70547184 -1.637386091 3.546270588 Mar-31-2019 2.925774511 10.6641228 10.78765466 Apr-30-2019 -5.600368476 -1.211905923 0.089666426 May-31-2019 -10.06738312 2.436663898 1.60134428 Jun-30-2019 1.907572251 -2.110900787 7.582938707 Jul-31-2019 0.357216572 2.542644466 -3.739371538 Aug-31-2019 -0.279663359 1.615362737 -7.87282092 Sep-30-2019 12.08565767 -0.859508073 1.433908103 Oct-31-2019 -7.415805379 -5.989912526 -4.632929667 Nov-30-2019 7.021545301 1.710261377 4.671152184 Dec-31-2019 7.279517679 1.038575354 7.176007481 Standard Life Aberdeen FTSE 5.519374422 5.99643 -4.05147387 2.289916 -7.075604723 -0.47252 -4.114221136 1.215149 3.863263541 -3.46008 -3.47114111 0.530089 -8.942288594 -5.41865 -1.885372073 -2.07183 -3.259257586 -3.87839 -1.986341392 4.096845 -1.947154849 1.651713 6.970619226 2.300819 11.43992232 2.254645 -4.159214138 -3.54262 10.21324421 3.389845 1.425688721 1.901621 -14.05465882 -4.37837 14.64099223 2.750249 6.19314122 -1.68116 4.415160055 1.834866 3.534241689 3.190305 Aug-31-2020 -1.789985666 -1.602797405 2.918953132 Sep-30-2020 3.890094645 Oct-31-2020 5.577364799 Nov-30-2020 10.24287377 Dec-31-2020 6.821411653 Jan-31-2021 8.381374723 0.665778961 0.442286707 -10.05291005 -6.411772434 -3.176470588 10.94790126 -0.637910085 13.15680595 -5.258330786 2.175503205 Feb-28-2021 -7.446808511 -3.194578896 10.69958806 Mar-07-2021 1.547303271 4.5 -0.939058467 -2.570343842 1.840933 -4.721753794 -1.80087 -0.663716814 -3.99063 20.66815145 12.42683 3.839055002 3.690829 7.394241024 -0.8631 2.879841112 1.660373 0.836550837 1.872791 you will find monthly returns for four stocks plus the FTSE All-share index (the market index). Calculate the standard deviation for the monthly return of each stock and the FTSE, and put the results in the following table. Standard Deviation Expected Return Sainsbury Reckitt Benckiser Rio Tinto Standard Life FTSE all share Beta Sainsbury Reckitt Benckiser Rio Tinto Apr-30-2018 29.39699025 -3.976711573 9.277208276 May-31-2018 3.009722367 1.034725069 7.450582781 Jun-30-2018 3.252492143 8.297171097 -0.919811435 Jul-31-2018 1.80572272 8.943740547 -0.107117603 Aug-31-2018 -0.856277084 -2.488343631 -10.61853616 Sep-30-2018 -0.740300636 6.967526605 6.039899259 Oct-31-2018 -3.29396546 -9.734892485 -1.971649761 Nov-30-2018 -1.023760434 2.826465795 -6.428287659 Dec-31-2018 -13.11477145 -7.662776422 4.804717878 Jan-31-2019 7.622665515 -2.494596044 12.2654156 Feb-28-2019 -19.70547184 -1.637386091 3.546270588 Mar-31-2019 2.925774511 10.6641228 10.78765466 Apr-30-2019 -5.600368476 -1.211905923 0.089666426 May-31-2019 -10.06738312 2.436663898 1.60134428 Jun-30-2019 1.907572251 -2.110900787 7.582938707 Jul-31-2019 0.357216572 2.542644466 -3.739371538 Aug-31-2019 -0.279663359 1.615362737 -7.87282092 Sep-30-2019 12.08565767 -0.859508073 1.433908103 Oct-31-2019 -7.415805379 -5.989912526 -4.632929667 Nov-30-2019 7.021545301 1.710261377 4.671152184 Dec-31-2019 7.279517679 1.038575354 7.176007481 Standard Life Aberdeen FTSE 5.519374422 5.99643 -4.05147387 2.289916 -7.075604723 -0.47252 -4.114221136 1.215149 3.863263541 -3.46008 -3.47114111 0.530089 -8.942288594 -5.41865 -1.885372073 -2.07183 -3.259257586 -3.87839 -1.986341392 4.096845 -1.947154849 1.651713 6.970619226 2.300819 11.43992232 2.254645 -4.159214138 -3.54262 10.21324421 3.389845 1.425688721 1.901621 -14.05465882 -4.37837 14.64099223 2.750249 6.19314122 -1.68116 4.415160055 1.834866 3.534241689 3.190305 Aug-31-2020 -1.789985666 -1.602797405 2.918953132 Sep-30-2020 3.890094645 Oct-31-2020 5.577364799 Nov-30-2020 10.24287377 Dec-31-2020 6.821411653 Jan-31-2021 8.381374723 0.665778961 0.442286707 -10.05291005 -6.411772434 -3.176470588 10.94790126 -0.637910085 13.15680595 -5.258330786 2.175503205 Feb-28-2021 -7.446808511 -3.194578896 10.69958806 Mar-07-2021 1.547303271 4.5 -0.939058467 -2.570343842 1.840933 -4.721753794 -1.80087 -0.663716814 -3.99063 20.66815145 12.42683 3.839055002 3.690829 7.394241024 -0.8631 2.879841112 1.660373 0.836550837 1.872791
Expert Answer:
Answer rating: 100% (QA)
To calculate the standard deviation for the monthly returns of each stock and the FTSE Allshare inde... View the full answer
Related Book For
Corporate Finance Core Principles and Applications
ISBN: 978-1259289903
5th edition
Authors: Stephen Ross, Randolph Westerfield, Jeffrey Jaffe, Bradford Jordan
Posted Date:
Students also viewed these finance questions
-
In a survey of 3363 adults, 1464 say they have started paying bills online in the last year. Construct a 99% confidence interval for the population proportion. Interpret the results. A 99% confidence...
-
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 spread sheet (I've listed the...
-
You have just started working for a financial planning firm and have been asked to analyze the performance and risk of the following 10 stocks to decide on the optimal portfolio for your client: The...
-
Assume that a security is selling at INR 217 and American call and American put options are available on the stock with 3 months maturity and an exercise price of INR 210. The call is selling at INR...
-
Draw a three-circle Venn diagram and shade the portion corresponding to the set. 1. R S T' 2. R' S' T 3. R (S T) 4. R (S T)
-
Last year, JL Corporation's tax liability was $900,000. For the current year, JL Corporation reported the following taxable income at the end of its first, second, and third quarters (see table...
-
Why are negative coefficients unusual?
-
Transactions to incorporate and run a business. The following events relate to shareholders equity transactions of Wilson Supply Company during the first year of its existence. Present journal...
-
EatFresh executives wanted a dashboard that would plot sales by day by store. The best attribute for designating the day of a customer bill is: 1) dayOfSale: Format(DateAdd("d", 1. (BillTimestamp])....
-
(a) A loop of wire in the shape of a rectangle of width w and length L and a long, straight wire carrying a current I lie on a tabletop as shown in Figure P31.9. (a) Determine the magnetic flux...
-
Island Novelties, Incorporated, of Palau makes two products-Hawaiian Fantasy and Tahitian Joy. Each product's selling price, variable expense per unit and annual sales volume are as follows: Selling...
-
Objective: Demonstrate an understanding of quality tools. Take a look around your workplace (your immediate area/modality, department, and organization), school, or walk into a healthcare...
-
2. You are holding four units of a sovereign junk bond. The face value and the recovery rate are respectively $1000 and 70%. The term to maturity is 5 years. If the country defaults at any time in...
-
Adrian's TV currently sells small televisions for $180 (per unit). It has costs of $140 (per unit). A competitor is bringing a new small television to market that will sell for $150 (per unit)....
-
Financial accounting TranscribedText: Prepare a balance sheet for the Ryder Roofing Company, from the items listed b the month of September 2023. Retained earnings, September 1 $35,000 Common stock...
-
Smart Stay is a hotel that is currently financed with 30% debt. The debt expected return is 6%. The expected rate of return on Smart Stay's equity is 16%. The expected return on the stock market...
-
Part 1: Practice Fusion EMR. Go to https://www.practicefusion.com/ehr/case-studies/orthopedic-surgeon/ 1. What problems did he have with his previous EHR implementation? 2. According to the website,...
-
On average there are four traffic accidents in a city during one hour of rush-hour traffic. Use the Poisson distribution to calculate the probability that in one such hour there arc (a) No accidents...
-
The Gecko Company and the Gordon Company are two firms whose business risk is the same but that have different dividend policies. Gecko pays no dividend, whereas Gordon has an expected dividend yield...
-
J&R Renovation, Inc., is trying to determine its cost of debt. The firm has a debt issue outstanding with 14 years to maturity that is quoted at 95 percent of face value. The issue makes semiannual...
-
The following table presents the long-term liabilities and stockholders equity of Information Control Corp. one year ago: Long-term...
-
Jud's Manufacturing Company produces one product, Kebo. Because of wide fluctuations in demand for Kebo, the Assembly Department experiences significant variations in monthly production levels. The...
-
Lorch Company uses budgets in controlling costs. The May 2002 budget report for the company's Packaging Department is as follows. The budget amounts in the report were on the master budget For the...
-
Lakem elder Dutch manufactures expensive watch eases sold as souvenirs. Three ol its sales departments are: Retail Sales, Wholesale Sales, and Outlet Sales. The Retail Sales Department is a profit...
Study smarter with the SolutionInn App