Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Data Table use excel Here is a table with the provided information: | Year | ABC Returns | B Returns | |------|--------------|-----------| | 2005 |
Data Table use excel Here is a table with the provided information: | Year | ABC Returns | B Returns | |------|--------------|-----------| | 2005 | -3.5% | 16.1% | | 2006 | 1.1% | -7.8% | | 2007 | -30.9% | -25.9% | | 2008 | -11.2% | -4.8% | | 2009 | 29.4% | 11.3% | | 2010 | 24.7% | 10.3% | | 2011 | 23.8% | 5.2% | | 2012 | 50.2% | 41.2% | | 2013 | 38.2% | 40.3% | | 2014 | 29.5% | 40.2% | | 2015 | 26.3% | 13.5% | | 2016 | 5.1% | -0.1% | | 2017 | 43.3% | 26.4% | The following table. Contains annual retums for the slocks of ABC Corp. (ABC) and Company B (B). The refurns are calculated using end-of-year prices (adjusted for dividends and stock splits) Use the informatien for ABC Corp (ABC) and Company B(B) to create an Excel spreadsheot that calculates the average retums for portolios comprised of ABC and B using the following. respective, weightings: (1.0.0.0),(0.9,0.1),(0.8,0.2),(0.7,0.3),(0.6,0.4),(0.5,0.5),(0.4,0.6),(0.3,0.7),(0.2,0.8),(0.1,0.9) and (0.0,1.0), The average annual returns for ABC and B are 17.385 . and 12.76% respectively Also, calculate the portfolio standard devistion associated with each portfolio composition. The standard deviation for ABC Corp. and Company B and Cheir correlason coefficient are 23.54%,20.36%, and 0.85329 respectively (Hint Review Tabla 52 ) The following table, contains annual returns for the stocks of ABC Corp. (ABC) and Company B (B). The retums are calculated using end-of-year prices (adjusted for dividends and stock splits) Use the intormation for ABC Corp. (ABC) and Company B(B) to create an Excol sproadsheot that calculates the average refums for porffolios comprised of ABC and B using the following. respective, weightings: (1.0,0.0),(0.9,0.1),(0.8,0.2),(0.7,0.3),(0.6,0.4),(0.5,0.5),(0.4,0.6),(0.3,0.7),(0.2,0.8),(0.1,0.9), and (0.0,1.0) The average annual returns for ABC and B are 17.38% and 12.76% respectively. Asso, calculate the portlolio standard deviation associated with each portiolo composition. The standard deviaton for ABC Corp. and Company B and their correlaton coefficient are 23.54%,20.36%, and 0.85329 respectivaly. (Hint Review Table 5 2) Enter the average retum and standard deviation for a porfolio with 70% ABC Corp. and 30% Compary B in the tabie below (Round to two decimal places) Enter the average return and standard deviation for a portfolio with 60% ABC Corp. and 40% Company B in the tabie below. (Round to two decimal places.) The following table, contains annual returns for the slocks of ABC Corp. (ABC) and Company B (B). The returns are calculated using end-of-year prices (adfusted for dividends and stock splits Use the information for ABC Corp (ABC) and Company B(B) to creato an Excol spreadshoet that calculates the average retums for portfolos comprised of ABC and B using the following. respective, weightings: (1.0,0.0),(0.9,0.1),(0.8,0.2),(0.7,0.3),(0.6,0.4),(0.5,0.5),(0.4,0.6),(0.3,0.7),(0.2,0.8),(0.1,0.9), and (0.0,1.0). The average annual teturns for ABC and B are 17.38% and 12.76% respectively Aso, caloulate the portfolio standard deviation associated with each portfolio composition. The standard deviation for ABC Corp. and Company B and their correlaton coefficent are 23.54%,20.36%, and 0.85329 respectively. (Hint Roview Table 5.2.) Enter the average return and standard deviation for a portlolio with 40% ABC Corp. and 60% Company B in the table below. (Round to two decimal places.) Enter the average return and standard deviation for a portfolio with 30% ABC Corp. and 70% Company B in the tabie below. (Round to fwo decimal places.) Enter the averaga return and standard deviation for a portolio wh 20% ABC Corp. and 50% Consany 8 in the table below. (Round to two decimat places.) Enter the average retum and standard deviation for a portfolio with 20% ABC Corp: and 80% Compony 8 in the tabie below. (Round is two decimal places.) \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Portfolio Weights } & \multicolumn{2}{|c|}{ Portolio Average Retum } & \multirow[t]{2}{*}{ Pertgip Standard Deviation } \\ \hlinewRSC & wB & rABC=17.38% & r0=12.76% & \\ \hline 0.2 & 0.6 & & & % \\ \hline \end{tabular} Enter the average retum and standard deviation for a pertiolo win 10% ABC Corp and 90% Company B in the table below (Round to Bwo decimal places) \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Portfoto Weights } & \multicolumn{2}{|c|}{ Pontfolio Average Rehum } & \multirow[t]{2}{*}{ Portolo Standart Devation } \\ \hlinewMaC & m0 & rase =17.38% & f6=1276% & \\ \hline 04 & 0.9 & & & % \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|} \hline \multicolumn{2}{|c|}{ Portolo Weshits } & \multicolumn{2}{|c|}{ Portoto Average Rtum } & \multirow[t]{2}{*}{ Portolio Standard Oevation } \\ \hline WABC & n0 & rAeC=1739% & fe=12.76% & \\ \hline 0.0 & 10 & & & \\ \hline \end{tabular} Data table (Click on the icon here in order to copy its contents of the data table below a spreadsheet.)
Data Table use excel
Here is a table with the provided information:
| Year | ABC Returns | B Returns |
|------|--------------|-----------|
| 2005 | -3.5% | 16.1% |
| 2006 | 1.1% | -7.8% |
| 2007 | -30.9% | -25.9% |
| 2008 | -11.2% | -4.8% |
| 2009 | 29.4% | 11.3% |
| 2010 | 24.7% | 10.3% |
| 2011 | 23.8% | 5.2% |
| 2012 | 50.2% | 41.2% |
| 2013 | 38.2% | 40.3% |
| 2014 | 29.5% | 40.2% |
| 2015 | 26.3% | 13.5% |
| 2016 | 5.1% | -0.1% |
| 2017 | 43.3% | 26.4% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started