Application of Value at Risk (VaR) In this project, you are estimating the 1 month VaR for a portfolio of two currencies. The weight of British pound in the portfolio is 70%, and the weight for Euro is 30%. The market approach is used to forecast the percentage change in the exchange rate for both Pounds and Euro. In other words, we are using the spot rate to forecast the exchange rate next month, which will results a 0 percentage change in exchange rate. The sample period is Jan 1, 2000 to Dec. 1, 2015. Please estimate the 1 month VaR for 95% confidence level. Please submit the Excel file containing your estimation of portfolio risk using Value at Risk. Add 4 column: Date, exchange rate for British pound, exchange rate for British pound et-et-1/et-1, change of exchange rate for t et-et-1/et-1 =Std ev, S ( ) Calculate correction coefficient e=correction( ) Use this link to get figures: https://research.stlouisfed.org/fred2/categories subject international finance