Using the 2 years of nancial crisis data (Jan 1, 2007 to Dec 31, 2008) compute VaR and ES at 99% and 99.5%. Assume that the losses/gains are normally distributed with mean = mean of Losses/gains and SD = standard Deviation of Losses/gains.

Answer using an excel sheet and show work plus formulas done, ty

A passive long only Equity portfolio Manager with asset under management (AUM) of $1.5 Billion has the following investments: A passive long only Equity portfolio Manager with asset under management (AUM) of $1.5 Billion has the following investments