You will each, individually pick a mutual fund, a hedge fund or an ETF that you are interested in$.$ Make sure that it does NOT track a major stock index such as the S&P$500.$ Then, perform a VAR analysis using $1\%$ and $5\%$ statistical significance on a daily and monthly basis using the $3$ VAR methodologies below: Parametric method, Historical method, Monte Carlo simulation method. For the analysis, download past $1-3$ years of daily data $($your decision and based on data availability$),$ and for the monthly calculations do the time horizon adjustment to your daily parameter estimates $($i$.$e$.$ convert your daily returns to monthly returns$).$ For data access, Yahoo or Google Finance is fine for our course purposes.Make sure to indicate your data source in your Excel file. For the historical and Monte Carlo simulation methods, estimate the expected shortfall $($conditional variance$)$ at the $1\%$ and the $5\%$ level of significance; and include a histogram of your daily observations and simulation values

Please show how to do this in excel while using formulas and show all work in excel.