1. Retrieve the file BUFFETTP. XLS. The book value per share of Berkshire Hathaway Inc. was $19.46 in 1964, as noted in ce1l A6. Column D reports the annual growth rate in book value for the next 53 years. 2. Calculate the book value per share for each year from 1965 through 2017. For example, the computed value in cell E6 equals the original value reported in cell A6 plus the calendar vear growth rate in book value appearing in cell D6. The value in cell E7 is equal to the computed value in cell E6 plus the annual growth rate in cell D7. Use the copy command to compute values for cells E7 :E58 3. Apply the =RATE financial function command in cell F60 to compute the average annual growth rate in book value per share from the starting value in cell A6 through the ending value in cell E58. In applying this command, enter 53 for the total number of years, zero for PMT and TYPE, and enter a GUESS of 15% or higher. 4. In cell F61 compute the total percentage rate of growth in book value per share from 1964 to 2017. [Hint: This value is very large, reflecting Berkshire Hathaway's remarkable record of owning and investing in companies.] 5. Assume that an investor's proportionate share in Berkshire's book value was $1,000 at yearend 1964. Apply the-rv financial function command in cell F62 to calculate the book value exactly 53 years later. Enter the value computed in cell F60 for RATE. [Hint: The compounded value in cell F62 is very large.] 6. Apply the -PV financial function command in cell F63 to verify that the value in cell E58, discounted for 53 years at the annual rate reported in cell F60, equals the book value per share in 1964. 7. Print the worksheet. 1. Retrieve the file BUFFETTP. XLS. The book value per share of Berkshire Hathaway Inc. was $19.46 in 1964, as noted in ce1l A6. Column D reports the annual growth rate in book value for the next 53 years. 2. Calculate the book value per share for each year from 1965 through 2017. For example, the computed value in cell E6 equals the original value reported in cell A6 plus the calendar vear growth rate in book value appearing in cell D6. The value in cell E7 is equal to the computed value in cell E6 plus the annual growth rate in cell D7. Use the copy command to compute values for cells E7 :E58 3. Apply the =RATE financial function command in cell F60 to compute the average annual growth rate in book value per share from the starting value in cell A6 through the ending value in cell E58. In applying this command, enter 53 for the total number of years, zero for PMT and TYPE, and enter a GUESS of 15% or higher. 4. In cell F61 compute the total percentage rate of growth in book value per share from 1964 to 2017. [Hint: This value is very large, reflecting Berkshire Hathaway's remarkable record of owning and investing in companies.] 5. Assume that an investor's proportionate share in Berkshire's book value was $1,000 at yearend 1964. Apply the-rv financial function command in cell F62 to calculate the book value exactly 53 years later. Enter the value computed in cell F60 for RATE. [Hint: The compounded value in cell F62 is very large.] 6. Apply the -PV financial function command in cell F63 to verify that the value in cell E58, discounted for 53 years at the annual rate reported in cell F60, equals the book value per share in 1964. 7. Print the worksheet