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

3 pts Question 38 Questions 37-40 are based on the following information: (15 points in total) A U.S. frm 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% .6 1200 20% 1.2 2000 Probability Spot rate (S/E) P*(E) 2090 1.3 1800 20% 1.5 1400 20% 1.4 1600 $1920 $2100 $2240$2340 $2400 In the above table, Pt is the pound price (local price) of the asset in UK held by the U.S. firm and P is the dollar price of the asset. The variance of the dollar price of this asset if the U.S. firm remains unhedged against this exposure is