Use the table of annual returns in Problem for Home Depot (HD) and Lowes (LOW) to create an Excel spreadsheet that calculates the standard deviation of annual returns for HD, LOW, and the equally weighted portfolio of HD and LOW In problem Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 20 11 HD Returns ( ) 52 6 49 0 21 5 4 3 1 0 31 2 114 30 6 24 9 23 5 Low Returns(96) 19 1 48 0 4 2 16 1 6 0 26 8 3 3 10 6 9 2 3 4

Question: Use the table of annual returns in Problem for Home Depot (HD) and Lowes (LOW) to create an Excel spreadsheet that calculates the standard deviation

Use the table of annual returns in Problem for Home Depot (HD) and Lowe€™s (LOW) to create an Excel spreadsheet that calculates the standard deviation of annual returns for HD, LOW, and the equally weighted of HD and LOW.
In problem

Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 20 11 HD Returns (%) 52.6 49.0 21.5 -4.3 1.0 31.2 -114 30.6 24.9 23.5 Low Returns(96) -19.1 48.0 4.2 16.1 -6.0 26.8 -3.3 10.6 9.2 3.4

Step by Step Solution

★★★★★

3.38 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Referring to the solution for problem The standard deviation o... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

446-B-F-F-M (6150).docx

120 KBs Word File

Students Have Also Explored These Related Finance Questions!

Kam Company purchased a machine on January 2, 2019, for $20,000. The machine had an expected life of 8 years and a residual value of $300. The double-declining-balance method of depreciation is used....

The following gure shows an Excel spreadsheet that calculates weighted X and Y coordinates, based on values for up to ve demand points. Re-create this spreadsheet in Excel. While your formatting does...

The following figure shows an Excel spreadsheet that calculates the benefit of pooling safety stock. Specically, the sheet calculates how much could be saved in annual holding costs if the safety...

The following gure shows an Excel spreadsheet that calculates the value index for each of two alternative suppliers. Re-create this spreadsheet in Excel. You should develop the spreadsheet so that...

Use the table of annual returns in Problem for Home Depot (HD) and Lowes (LOW) to create an Excel spreadsheet that calculates returns for portfolios comprised of HD and LOW using the following,...

The following table contains annual returns for the stocks Home Depot ( HD ) and Lowes ( LOW ) . The returns are calculated using end - of - year prices ( adjusted for dividends and stock splits ) ....

The following table contains annual returns for the stocks Home Depot ( HD ) and Lowes The tivo atoicks, E Yphoad Wocd Tlewith ancwers'and Exrel File for proigramnung cnelef ( LOW ) . The returns are...

G1 IG2 P5.12 Use the table of annual returns in Problem 5.9 for Home Depot (HD) and Lowe's (LOW) to create an Excel spreadsheet that calculates returns for portfolios that comprise HD and LOW using...

problems 12 to 14 only 203 CHAPTERS I MODERN PORTFOLIO CONCEPTS HD Returns -4.3% 1.0% -31.1% -11,4% 30.5% 25.0% 23.5% 50.3% 35.9% 30.2% LOW Returns 16.1% -61% -26.8% -3.3% 10.6% 9.2% 3.4% 42.9% 41.8%...

Use the table of annual returns in Problem 5.9 for Home Depot (HD) and Lowes (LOW) to create an Excel spreadsheet that calculates the average returns for portfolios that comprise HD and LOW using the...

January 10, 20X8Lumbee State College received a $100,000 government grant to be used to finance a study of the effects of the Tax Reform Act of 20X6 on the regional economy. During 20X8Expenditures...

Calculate the quadrupole potential (at point located in $vec{r}$) for the cubic configuration shown in the figure. From the above result determine the expression of the electric field (at point...

Calculate the derivative of the following function. y = ( c s c x c o t x ) 7 d y d x =

The ratio in which the plane r.(i-2 j+3k) = 17 divides the line joining the points -2i+4j+7k and si-5j+8k 1) 1:5 2) 1: 10 3) 3:5 4) 3: 10 If the points (1, 1, -3) and (1, 0, -3) lie on opposite sides...

58. In which of the following configuration will liquid level change? (Water does not come out or oil does not enter vessel):- Oit 12.5m 13 O Ol (0 Oil Water Oil Waer Water Water2 50

54 A siphon tube is discharging a liquid of specifie gravity 0.9 from a reservoir as shown in & fig., here g-10 mis, P 10 Pa 55 LSm AP P" 54. What is the velocity of the liquid coming out of siphon...

Mr. Ahmed is appointed as auditor in Peacock Company. During the audit, he observed that the sales manager is seriously involved in fraud. He observed that the company understated its sales. The...

Find the value of X 5y 8 7y-12 (6x+4)9 (9x- 14) 25 F.

describe an issuers on-the-run yield curve.

What is diversification? How does the diversification of risk affect the risk of the portfolio compared to the risk of the individual assets it contains?

Discuss how the correlation between asset returns affects the risk and return behavior of the resulting portfolio. Describe the potential range of risk and return when the correlation between two...

What benefit, if any, does international diversification offer the individual investor? Compare and contrast the methods of achieving international diversification by investing abroad versus...

if prepaid cost are initially recorded as an asset, no adjusting entries will be required in the future. True or false

How to explain this using R commands. Show R code . Problem 11: R Problem A data set movies2009 (available at http://users. stat. umn . edu/~parky/movies2009. csv contains the following variables : -...

How many instances of a given value are allowed by map and set while inserting a element into container? 1 2 none no limit