Question: The Excel file posted with this assignment contains 53 weekly market closing values for five prominent assets: SP500 = S&P 500 index MSFT = Microsoft

The Excel file posted with this assignment contains 53 weekly market closing values for five prominent assets: SP500 = S&P 500 index MSFT = Microsoft (dollars per share) BRK-B = Berkshire Hathaway B-shares (dollars per share) AAPL = Apple (dollars per share) BTC = Bitcoin (dollars per coin) For each asset, you should compute the weekly log-return as 100*(ln(Y_t) - ln(Y_{t-1})) where Y_t is the index value for week t and Y_{t-1} is the index value for the preceding week (t-1). An example is provided in the spreadsheet for the first log-return of each series (cells H4 to L4), and you should copy this cell formula to generate the log-returns for the other weeks and assets (cells H5 to L55). Although the asset values are stated in difference units, we can use the weekly log-returns (measured in percentage changes) to compare the performance of the different assets. Due to the differencing operation, you should recover 52 log-returns for weeks 2 to 53

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!