Suppose you and your group members are a team in the Risk Management Department of Bank One responsible for formulating hedging strategy for the bank's net exposure in foreign currencies. < < You are working in a US-based institution with some assets and liabilities. < < Your manager asks your team to write a brief report about how to hedge the current Forex exposure according to each question. The content of your report should include, but not limited to, the followings for each question: < Net exposure of the bank for that currency < - - - < The expected loss/gain of the bank in US$ if the FX rate moves to the level as specified in each question. < Analysis and decision of Futures hedging strategy, including the selection of the suitable future contract, determination of position of the future contract, and the application of regression analysis of hedge ratio (based on the range of historical data that are provided), R, number of the futures contract for hedging,...etc Extract the historical data in that you use in the hedge ratio regression analysis in proper Excel format and attached as a one-page appendix; < Show as appendix your regression analysis output tables < You do not need to consider other costs or expenses in your above report < < So you need to identify and calculate the following and present to your manager for the report. < Net exposure and risk exposure identification < Loss/Gain estimation under no hedging < Selection of futures and determination of number of contract < Hedge ratio analysis < Screen captures required; Good use of sub-heading < The data are provided to you by your staff, you are required to study the data and they are the FX rate of Spot GBPUSD, USDJPY, USDSGD, and the future prices and the contract size. You need to study the FX rate and see how you should prepare the data for analysis. < < Question 1 < Your bank has British assets of GBP18,000,000 and British liabilities of GBP10,000,000. The expected FX rate in indirect quote will be 0.90 in the future.