This question is related to Foreign exchange and international finance. It will be best to use excel functions for the answer. Thanks, and definite thumbs up for answers!

3 pts Question 37 Questions 37-40 are based on the following information: (15 points in total) A U.S. firm holds an asset in UK and considers selling it in one year. The firm faces the following scenario of the future spot rates in one year: State 1 State 2 State 3 State 4 State 5 20% 1.6 1200 20% 20% 1.4 1600 20% 1.3 1800 2000 20% 1.5 1400 Probability 1.2 Spot rate ($/E) p*(E) P ($) In the above table, P' is the pound price (local price) of the asset in UK $1920 $2100 $2240 $234O $2400 held by the U.S. firm and P is the dollar price of the asset The asset exposure faced by the U.S. firm is 3 pts Question 37 Questions 37-40 are based on the following information: (15 points in total) A U.S. firm holds an asset in UK and considers selling it in one year. The firm faces the following scenario of the future spot rates in one year: State 1 State 2 State 3 State 4 State 5 20% 1.6 1200 20% 20% 1.4 1600 20% 1.3 1800 2000 20% 1.5 1400 Probability 1.2 Spot rate ($/E) p*(E) P ($) In the above table, P' is the pound price (local price) of the asset in UK $1920 $2100 $2240 $234O $2400 held by the U.S. firm and P is the dollar price of the asset The asset exposure faced by the U.S. firm is