Spreadsheet Exercises 6-1 Warren Buffett, arguably the most famous investor in the United States, is the CEO of Berkshire Hathaway (BRK), a company that has enjoyed great success in terms of its stock price. Below are the actual year-end stock prices for BRK-A from 1965 through 2011 (Yes these are the actual stock prices, believe it or not a. Calculate the retum relatives for exh year starting in 1966 Use two decimal places b. Calculate the arithmetic mean and geometric mean for these price relatives, using three decimal places c. Calculate the cumulative wealth index for 1966-2011, assuming an initial investment of 51.000, and $10,000 State the answers without decimal places Year-End Price Year End Price 1976 1956 1967 1750 2035 3700 9400 138.00 15700 320.00 1920 560.00 1982 7000 1972 1973 1974 1994 7100 000 77500 31000 127500 247000 2.82000 Spreadsheet Exercises 173 Year-End Price Year-End Price 2000 2002 2003 2004 750.00 1989 1990 1991 1993 1993 1994 1995 199 1997 71000.00 75.600.00 72.750,00 14250.00 87.900.00 1862000 109.990.00 141,600.00 9660000 99200.00 12045000 114755.00 2006 2060000 32.100.00 100.00 2010 2011 70.000.00 54.10000 1999 Gore