Excel Activity: Multinational Financial Management affect dollar exchange rates. Note: Column 2 equals 1.0 divided by cosumn 1, nowever, ruunumy unterverew un vur: Source: Adapted from The Wall Street Journal (ws) com), October 7, 2020. Note: Column 1 shows how many units of each foreign currency a U.S. dollar would buy, column 2 shows how many units a franc would buy; and so on for the other columns. Source: Adapted trom data provided in Table Exchange Rates for October 7, 2020. Spot and Forward Exchange Rates (Number of Units of Foreign Currency per U.S. Dollar): Wednesdav, Octeher ? 2020 b. What is the dollar profit that Yohe makes on the sale of the 5Y20 ? Round your answer to the nearest cent. $ What is the percentage profit? Round your answer to two decimal places. c. If the U.S. dollar was to weaken by 12\% against all foreign currencies, what would be the dollar and percentage profits for the SY-20? Round your answer for the dolar profit to the nearest cent and for the percentage profit to two decimal places. Dollar profit: $ Percentage profit d. If the U.S. dollar was to weaken by 12% only against the Japanese ven and remained constant relative to all other foreign currencies, what would be the dolar and percentage profits for the SY-20? Round your answer for the dollar profit to the nearest cent and for the percentage profit to two decimal places. Dollar profit: $ Percentage profit: e. Using the 180-day forward exchange information, calculate the return on 1-year securities in Swtzertand assuming the rate of return on 1-year securities in the United Stact is 4.9\%. Assume that there are 360 days in a year. Round your answer to two decimal places. % 1. Asstming that purchasing power parity (PPP) holds, what would be the sale price of the SY-20 if it was sold in the United Kingdom rather than lapan? Round your answer to the nearest penny. Excel Activity: Multinational Financial Management affect dollar exchange rates. Note: Column 2 equals 1.0 divided by cosumn 1, nowever, ruunumy unterverew un vur: Source: Adapted from The Wall Street Journal (ws) com), October 7, 2020. Note: Column 1 shows how many units of each foreign currency a U.S. dollar would buy, column 2 shows how many units a franc would buy; and so on for the other columns. Source: Adapted trom data provided in Table Exchange Rates for October 7, 2020. Spot and Forward Exchange Rates (Number of Units of Foreign Currency per U.S. Dollar): Wednesdav, Octeher ? 2020 b. What is the dollar profit that Yohe makes on the sale of the 5Y20 ? Round your answer to the nearest cent. $ What is the percentage profit? Round your answer to two decimal places. c. If the U.S. dollar was to weaken by 12\% against all foreign currencies, what would be the dollar and percentage profits for the SY-20? Round your answer for the dolar profit to the nearest cent and for the percentage profit to two decimal places. Dollar profit: $ Percentage profit d. If the U.S. dollar was to weaken by 12% only against the Japanese ven and remained constant relative to all other foreign currencies, what would be the dolar and percentage profits for the SY-20? Round your answer for the dollar profit to the nearest cent and for the percentage profit to two decimal places. Dollar profit: $ Percentage profit: e. Using the 180-day forward exchange information, calculate the return on 1-year securities in Swtzertand assuming the rate of return on 1-year securities in the United Stact is 4.9\%. Assume that there are 360 days in a year. Round your answer to two decimal places. % 1. Asstming that purchasing power parity (PPP) holds, what would be the sale price of the SY-20 if it was sold in the United Kingdom rather than lapan? Round your answer to the nearest penny
