Calculate the correct equations for each of the tables, and determine the best strategy to use

Hedge or Not to Hedge? Suppose that the U.S. Boeing Corporation has just exported a Boeing 747 to British Airways and billed 10 million, payable in one year. At the same time, the corporation has also imported several key components for manufacturing the airplanes from Germany and has been billed 10 million, payable in one year. The Assistant Treasurer at the Corporation oversees finding ways to hedge its foreign currency risk of British pounds and euros. Lately, the pounds and euros are very volatile against U.S. dollars. He is considering forward, money market, and options hedge. The Assistant Treasurer just finished collecting the spot, forward, and currency options quotes from the Bloomberg terminal, which are as follows: The treasurer keeps note that he can borrow and lend foreign currencies at the ask and bid rates, respectively. He also reminds himself that he has learned from his finance courses in the university: always buy at the ask and sell at the bid. He needs to prepare a memo analysing currency hedging for the Finance Committee in two days addressing which strategy would be better: forward hedge? Money market hedge? Option hedge? He is considering five possible exchange rate scenarios for dollar-pound and dollar-euro in one year so that he can show his analysis to the Committee. These exchanges rates are: $1.30/f,$1.40/f,$1.46/f, $1.50/,$1.60/ for dollar-pound and $1.00/,$1.10/,$1.18/,$1.20/,$1.30/ for dollareuro. After doing all the calculations, he wants to decide which hedging strategy would be preferable. First, he plans to find the outcomes of the forward and money market hedging, then use the same forward rates as the strike exchange rates for options market hedging. After that, he plans to find the future spot rates that would make him indifferent between option and forward outcomes. He believes that this process would help him in identifying whether an option hedge would be helpful, given that options require up-front costs. He has prepared a few tables for the forward and options outcomes that can be used to understand the overall situation better