Question: I need help! i need someone to explain the steps I need to do in order to answer these two questions: 5% Value at Risk

I need help! i need someone to explain the steps I need to do in order to answer these two questions: 5% Value at Risk (VaR) of monthly returns and 5% Expected Shortfall of monthly returns while using excel!!!

Below is the information:

the Excel spreadsheet GroupProject1.xlsx. It contains the monthly returns of value-weighted equity indexes divided into various groups:

North America Canada and the United states

Japan

Asia Pacific Australia, Hong Kong, New Zealand, and Singapore

Europe Austria, Belgium, Denmark, Finland, France, Germany, Greece, Ireland, Italy, the Netherlands, Norway, Portugal, Spain, Sweden, Switzerland, and the United Kingdom

Global All of the above countries.

All index returns are in US dollar terms. In addition, the file contains the 1-month US risk-free rate.

Each return is it this format for 1990-2013

Date North_America Japan Asia_exJapan Europe Global Rf
199007 (0.82%) 0.78% 4.85% 5.05% 1.47% 0.68%
199008 (8.93%) (11.25%) (7.82%) (10.20%) (10.10%) 0.66%
199009 (5.41%) (17.43%) (8.25%) (11.74%) (11.64%) 0.60%
199010 (1.33%) 25.59% (1.58%) 7.27% 10.26% 0.68%
199011 6.43% (13.52%) (2.29%) 0.17% (3.30%) 0.57%
199012 3.11% 2.34% (0.61%) (0.95%) 1.63% 0.60%
199101 4.73% 1.67% 6.03% 2.12% 2.99% 0.52%
199102 7.70% 12.81% 9.26% 7.78% 9.57% 0.48%

ETC...

I have already found arithmetic average of monthly and annualized arithmetic return, geometric average and annualized geo return, stardard deviation and annualized standard deviation, sharpe ratio of monthly returns and annualized sharpe ratio, skewness and kurtosis, and variance.

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 Finance Questions!