Conte X Chap X 0 Mail X Bb https x Airbr X C 1. Ho X New X New X New X New X New X + V X - C mylab.pearson.com/Student/PlayerTest.aspx?testld=252322592 Paused . . . Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% "XYZ = 12.62% 0.2 0.8 % % Enter the average return and standard deviation for a portfolio with 10% ABC Corp. and 90% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 0.1 0.9 % Enter the average return and standard deviation for a portfolio with 0% ABC Corp. and 100% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 0.0 1.0 % % 89.F Q Search 6:45 PM Mostly sunny LOCBAR W 6/10/2023Conte X Chap X 0 Mail X Bb https x Airbr X C 1. Ho X New X New X New X New X New X + V X C mylab.pearson.com/Student/PlayerTest.aspx?testld=252322592 J Paused The following table, , contains annual returns for the stocks of ABC Corp. (ABC) and XYZ Corp. (XYZ). The returns are calculated using end-of-year prices (adjusted for dividends and stock splits). Use the information for ABC Corp. (ABC) and XYZ Corp. (XYZ) to create an Excel spreadsheet that calcul average returns over the 10-year period for portfolios comprised of ABC and XYZ using the following, respective, weightings: (1.0, 0.0), (0.9, 0.1), (0.8, 0.2 (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 over the 10-year period for ABC and XYZ are 17. 12.62% respectively. Also, calculate the portfolio standard deviation over the 10-year period associated with each portfolio composition. The standard devi: the 10-year period for ABC Corp. and XYZ Corp. and their correlation coefficient are 24.32%, 20.26%, and 0.82851 respectively. (Hint: Review Table 5.2.) . . . Enter the average return and standard deviation for a portfolio with 100% ABC Corp. and U XYZ Corp. in the table below. (Round to two decimal places Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 1.0 0.0 % % Enter the average return and standard deviation for a portfolio with 90% ABC Corp. and 10% XYZ Corp. in the table below. (Round to two decimal places. 89.F 6:43 PM Mostly sunny Q Search LOCBE 6/10/2023Conte X Chap X Mail X Bb https x Airbr X C 1. Ho X New X New X New X New X New X + X C mylab.pearson.com/Student/PlayerTest.aspx?testld=252322592 J Paused prices (adjusted for dividends and stock splits). Use ine Information for ABC Corp. (ABC) and XYZ Corp. (XYZ) to create an Excel spreadsheet that calcul average weightings: (1.0, 0.0), (0.9, 0.1), (0.8, 0.2 (0.6, 0.4 12.62% - X e 10-year period for ABC and XYZ are 17. Data table portfolio composition. The standard devi: the 10-y $51 respectively. (Hint: Review Table 5.2.) Year ABC Returns XYZ Returns 2005 - 5.9% 15.2% 2006 1.9% - 6.8% 2007 - 32.4% - 25.4% Enter th 2008 - 11.2% - 4.4% able below. (Round to two decimal places 2009 29.6% 11.2% 2010 27.7% 10.1% 2011 22.6% 4.3% 2012 51.2% 41.6% 2013 37.9% 42.2% Enter th 2014 29.2% 38.6% able below. (Round to two decimal places 2015 28.8% 11.8% 2016 4.5% - 0.2% 2017 44.6% 25.8% 89.F 6:43 PM Mostly sunny Q Search W 6/10/2023Conte X Chap X 0 Mail X Bb https x Airbr X C 1. Ho X New X New X New X New X New X + V X C mylab.pearson.com/Student/PlayerTest.aspx?testld=252322592 Paused . . . The following table. FAl. contains annual returns for the stocks of ABC Corp. (ABC) and XYZ Corp. (XYZ). The returns are calculated us . . . Enter the average return and standard deviation for a portfolio with 100% ABC Corp. and 0% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 1.0 0.0 % Enter the average return and standard deviation for a portfolio with 90% ABC Corp. and 10% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% "XYZ = 12.62% 0.9 0.1 % % Enter the average return and standard deviation for a portfolio with 80% ABC Corp. and 20% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 89.F 6:44 PM Mostly sunny Q Search LOCO 6/10/2023Conte X Chap X 0 Mail X Bb https x Airbr X C 1. Ho X New X New X New X New X New X + V X C mylab.pearson.com/Student/PlayerTest.aspx?testld=252322592 Paused . . . The following table. IFAl. contains annual returns for the stocks of ABC Corp. (ABC) and XYZ Corp. (XYZ). The returns are calculated us . . . Enter the average return and standard deviation for a portfolio with 80% ABC Corp. and 20% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 0.8 0.2 % % Enter the average return and standard deviation for a portfolio with 70% ABC Corp. and 30% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% "XYZ = 12.62% 0.7 0.3 % % Enter the average return and standard deviation for a portfolio with 60% ABC Corp. and 40% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ARC = 17.58% XYZ = 12.62% 89.F Q Search LOCO 6:44 PM Mostly sunny 6/10/2023Conte X Chap X 0 Mail X Bb https x Airbr X C 1. Ho X New X New X New X New X New X + V X C mylab.pearson.com/Student/PlayerTest.aspx?testld=252322592 Paused . . . The following table. IFAl. contains annual returns for the stocks of ABC Corp. (ABC) and XYZ Corp. (XYZ). The returns are calculated us . . . Enter the average return and standard deviation for a portfolio with 60% ABC Corp. and 40% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% "XYZ = 12.62% 0.6 0.4 % % Enter the average return and standard deviation for a portfolio with 50% ABC Corp. and 50% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 0.5 0.5 % % Enter the average return and standard deviation for a portfolio with 40% ABC Corp. and 60% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation 89.F Search 6:45 PM Mostly sunny LOCO 6/10/2023Conte X Chap X 0 Mail X Bb https x Airbr X C 1. Ho X New X New X New X New X New X + V X C mylab.pearson.com/Student/PlayerTest.aspx?testld=252322592 Paused . . . The following table. IFAl. contains annual returns for the stocks of ABC Corp. (ABC) and XYZ Corp. (XYZ). The returns are calculated us . . . Enter the average return and standard deviation for a portfolio with 40% ABC Corp. and 60% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% (XYZ = 12.62% 0.4 0.6 % % Enter the average return and standard deviation for a portfolio with 30% ABC Corp. and 70% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ "ABC = 17.58% "XYZ = 12.62% 0.3 0.7 % 1% Enter the average return and standard deviation for a portfolio with 20% ABC Corp. and 80% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation 89.F 6:45 PM Mostly sunny Q Search 6/10/2023Conte X Chap X 0 Mail X Bb https x Airbr X C 1. Ho X New X New X New X New X New X + V X C mylab.pearson.com/Student/PlayerTest.aspx?testld=252322592 Paused . . . The following table. IFAl. contains annual returns for the stocks of ABC Corp. (ABC) and XYZ Corp. (XYZ). The returns are calculated us . . . V . T v.V Enter the average return and standard deviation for a portfolio with 30% ABC Corp. and 70% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 0.3 0.7 % % Enter the average return and standard deviation for a portfolio with 20% ABC Corp. and 80% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 0.2 0.8 % % Enter the average return and standard deviation for a portfolio with 10% ABC Corp. and 90% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation 89.F Mostly sunny Q Search 6:45 PM 6/10/2023Conte X Chap X 0 Mail X Bb https x Airbr X C 1. Ho X New X New X New X New X New X + V X - C mylab.pearson.com/Student/PlayerTest.aspx?testld=252322592 Paused . . . Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% "XYZ = 12.62% 0.2 0.8 % % Enter the average return and standard deviation for a portfolio with 10% ABC Corp. and 90% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 0.1 0.9 % Enter the average return and standard deviation for a portfolio with 0% ABC Corp. and 100% XYZ Corp. in the table below. (Round to tw Portfolio Weights Portfolio Average Return Portfolio Standard Deviation WABC WXYZ ABC = 17.58% XYZ = 12.62% 0.0 1.0 % % 89.F Q Search 6:45 PM Mostly sunny LOCBAR W 6/10/2023