2. You are given the excel file which contains daily information for the SP500 index. Using excel, perform the following task on the Adj Close which is the adjusted closing price:

I. Produce a graph that shows the time-series evolution of the stock price

II. Calculate the series of log returns

III. Produce a table with essential descriptive statistics

IV. Assuming an invested capital of $10 million, calculate the daily VaR at 95% confidence level and 99% confidence leve

l V. Estimate for both VaR in IV the equivalent 10 days VaR.