Question: in this assignment, you are required to construct a $10,000 worth portfolio thatconsists of FOUR assets (with a weight of $1000, $2000, $2500, $4500) and

in this assignment, you are required to construct a $10,000 worth portfolio thatconsists of FOUR assets (with a weight of $1000, $2000, $2500, $4500) and analyseits risk profiles with the use of VaR and ES. The data can be retrieved from WINDdatabase. Specifically, please complete the following five tasks: (i) Download the data from WIND database (suggested) or other platforms on aDAILY frequency with data points. Plot the time series of prices as well as dailyreturns by calculating ln(p/p-). Please also comment briefly on the volatility ofthese four assets that you have picked up (e.g. which asset is more/less volatileand whether the volatility has grown stronger over time). (ii) Calculate the expected return and standard deviation of the four assets as wellas this entire portfolio. (ili) Calculate the Value-at-Risk (VaR) and Expected Shortfalls (ES) by using model-building approach with both equal weight and EWMA approach (with =0.94 byconvention). (iv) Calculate the Value-at-Risk (VaR) and Expected Shortfalls (ES) by usingmodel-building approach with the Markowitz optimal portfolio instead of theoriginal portfolio weights. Please also use both equal weight and EWMA approach(with =0.94 by convention). (v) Calculate the VaR and ES by using historical simulations with both equal weightapproach and cumulative weight approach (with =0.995 by convention). (vi) Please comment on the reasons behind the differences of VaR and ES withdifferent methods of calculation that you have done. Which method may offer amore accurate estimation of VaR and ES? Please submit BOTH the excel working sheet as well as a pdf document withbrief a explanation of the results

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!