50.1K

Verified Solution

Link Copied!

im looking for the yearly returns and return relatives for each year of the data.

i also need the yearly returns for each year.

1. (10 pts.) Complete Spreadsheet Exercise 6.1. Note I made a slight change in part b. 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. The actual year-end stock prices for BRK-A from 1965 through 2011 are in the file attached to this assignment. (Yes, these are the actual stock prices, believe it or not.) a. Calculate the return relatives for each year starting in 1966. Use two decimal places. b. Calculate the arithmetic and geometric means for these price return relatives, using three decimal places. c. Calculate the cumulative wealth index for 19662011, assuming an initial investment of $1,000 and $10,000. 1. (10 pts.) Complete Spreadsheet Exercise 6.1. Note I made a slight change in part b. 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. The actual year-end stock prices for BRK-A from 1965 through 2011 are in the file attached to this assignment. (Yes, these are the actual stock prices, believe it or not.) a. Calculate the return relatives for each year starting in 1966. Use two decimal places. b. Calculate the arithmetic and geometric means for these price return relatives, using three decimal places. c. Calculate the cumulative wealth index for 19662011, assuming an initial investment of $1,000 and $10,000

Answer & Explanation Solved by verified expert

See Answer