英语论文网

h) Count how many years Berkshire bid S&P500. Reference your final estimation in cell C23:D24 of the “Summary Report” worksheet.

i) Create a new worksheet named as “T-tests”. In the worksheet uses t-test to answer the following questions:

i) Did Berkshire outperform S&P500 historically? Report your answer in cell C29 of the “Summary Report” worksheet.

ii) Did Berkshire outperform S&P500 for more than 5% annually? Report your answer in cell C30 of the “Summary Report” worksheet.

iii) Did Berkshire outperform S&P500 for more than 10% annually? Report your answer in cell C31 of the “Summary Report” worksheet.

专业定制留学生作业，找论文就上英语论文网

iv) Provide a brief comment on your results and reference it in cell C32 of the “Summary Report” worksheet.

v) Reference this worksheet in cell C33 of the “Summary Report” worksheet.

Note:

Use 95% confidence level as criteria for statistical significances for the tests in this question.

2) The “Data - Monthly” worksheet contains monthly price level of Berkshire Hathaway Inc and S&P500 index from Jan 1988 to Dec 2008. It also contains monthly 1m T-bill rates. In this question, the Berkshire Hathaway's investment performance is evaluated using capital asset pricing model (CAPM).

a) Calculate the monthly simple returns of the Berkshire Hathaway Inc and S&P 500 index. Calculate the excess return of the Berkshire Hathaway Inc and S&P 500 index. Reference this worksheet in cell C37 of the “Summary Report” worksheet.

b) Estimate the correlations between the returns and interest rate series in the Data - Monthly worksheet and reference your results in cells C40:E42 of the “Summary Report” worksheet.

c) Estimate the betas and alphas of the Berkshire Hathaway Inc for the whole sample period, first half and second half of your sample. Reference your results in cells C45:E47 of the “Summary Report” worksheet.

d) Plot the monthly excess return of Berkshire Hathaway Inc against S&P 500 excess return for the whole sample period, first half and second half of your sample. Add a trend line and a regression equation in the chart. Place them in a new worksheet name Excess Return Plot. Reference this worksheet in cell C49 of the “Summary Report” worksheet.

Part II. Written Essay

Title: Measuring the Investment Performance of Berkshire Hathaway Inc

Prepare a https://www.51lunwen.org/ukthesis.html report for evaluating the Investment Performance of Berkshire Hathaway Inc. The following points need to be addressed.

Background of Berkshire Hathaway Inc.
Description and analysis of Berkshire's performance over time.
Comparison of Berkshire's performance with S&P 500.
Analysis of Berkshire's performance using CAPM.

Your conclusion

You should refer your discussion to the relevant excel analyses in Part I. However, the Essay is a standalone piece of work. Readers should be able to understand your arguments without looking at your excel workouts. When including the results from your excel analyses, descriptions of the analyses should be given and tables/figures should be formatted and captioned. You are encouraged to use additional analysis to support your argument. When do so, please clear本论文由英语论文网提供整理，提供论文代写，英语论文代写，代写论文，代写英语论文，代写留学生论文，代写英文论文，留学生论文代写相关核心关键词搜索。