In: Finance
Terry, who lives in London, invested £4 million in JMDJ, a U.S. company, trading at a market value of $100 per share. The conversion rate for pounds to dollars was £1 to $1.4 at the time of the investment. Assume that after two years, he sells the stock, for $250 per share when the conversion rate for pounds to dollars is £1 to $1.30. How much is his gain? Show work in Excel.
-PLEASE WORK IN EXCEL SPREADSHEET. EXPLAIN ALL STEPS - ALSO HOW TO PUT INTO EXCEL.