PLEASE HELP I HAVE NO IDEA WHAT IM DOING, excel formulas included would be appreciated!
Excel Activily: Multinational financial Management Yohe Telecommunicabions is a multinational corporation that produces and distributes telecommunications technology. Although its corporate headquarters are located in Mantiand, Flocida, Yothe usually buys its raw materials in several different foreign countries using several different foreign currencles. The matter is further complicated becouse Yobe often selis ats products in other foreign countries. One product in particular, the 5Y20 radio tranumittec, draws Component X, Compooent Y, and Component 2 (its principal componenta) from Switzerland, France, and the United Kingdom, respectively. Spechically, Component x costs 160 Swtss francs, Component y casts 15 eutos, and component z costs 120 Eritish pounds. The largest market for the 5y20 is Japan, where the product sells for 47,500 lapanese yen, Naturally, rohe is intimately concemed with econcmic conditons that could adversely affect dollar exchange rates Source: Adapted from the Waif skreet fournal (ws) com), September 15, 2020. Note: Column 1 shews now many units of each roregn currency a u.5, dollar would bwy, celumn 2 show how many units a tranc would buy, and so on for the other columns. Source: Adapted from data provided in Table Exchange Rates for September 15, 2020. Spot and Forward Exchange Hates (Number of Units of Foreign currency per U.S. Dollar): Tuesday, Seotember 15,2020 The data has been collected in the Microsoft rxcel he below Downlosd the spreadhacet and perform the required analyss to answer the questions belav. Do not round intesmediate cakcilatices 3. How much in dollars does it cost Yohe to produce the Sr-207 Round your answer to the nearest cent: 5 3 What is the doliar sale price of the 5r207 Round yout answer to the nearest cent. 1 b. What is the doallar proft that Yohe makes on the sale of the sr-20?-Round your anser to the nearest cent 3 What is the percentage profit? plound your anser to two decimal places. profit to the nearest cent and for the percertage proft to two decinsal places. Doliar profitis Percentage profit: d. If the U.5. dollar was to weaken by 8% only against the fapanese yen and remained comant relatre to all other foreign curtencies. what would be the dollat and percentage pronts for the 5Y20? Round your answer for the dollar profit to the nearest cent and for the percentage profit to two decimal places botlar proft: 5 Percentage protit: C If the U.S. dotiar was to weaken by Bth against all foreign currencies, what would be the doltar and percentage protits for the 5Y207 Round your answer for the dollar profit to the nearest cent and for the percentage profit to two decimal plsces. Dobiar protiti $ Percentage profit d. If the U.5, dollar was to wesken by aw only against the Japanese yen and remained constant relative to all other forelign currencies, what would be the dollar and percentage protits for the 5Y20 ? Round your answer for the dottar profit to the nearest cent aod for the percentage profin to two decimal placei. Dolthat profit: 5 Percentage prent: e. Using the 180 -day forward exchange informatioe, cakculate the retum on L.year securibes in switreriand assuming the rate of return on 1 -year securibies in the tinited States is 4.8%, Assume that there are 360 days in a year. Round your answer to two decimal places. 1. Assuming that purchasing power panity (PPP) holds, what would be the sale price of the 5Y-20 if it was sald in the United kingdom rather thian Jopan? Aound your?answer to the nestest penty. Excel Activily: Multinational financial Management Yohe Telecommunicabions is a multinational corporation that produces and distributes telecommunications technology. Although its corporate headquarters are located in Mantiand, Flocida, Yothe usually buys its raw materials in several different foreign countries using several different foreign currencles. The matter is further complicated becouse Yobe often selis ats products in other foreign countries. One product in particular, the 5Y20 radio tranumittec, draws Component X, Compooent Y, and Component 2 (its principal componenta) from Switzerland, France, and the United Kingdom, respectively. Spechically, Component x costs 160 Swtss francs, Component y casts 15 eutos, and component z costs 120 Eritish pounds. The largest market for the 5y20 is Japan, where the product sells for 47,500 lapanese yen, Naturally, rohe is intimately concemed with econcmic conditons that could adversely affect dollar exchange rates Source: Adapted from the Waif skreet fournal (ws) com), September 15, 2020. Note: Column 1 shews now many units of each roregn currency a u.5, dollar would bwy, celumn 2 show how many units a tranc would buy, and so on for the other columns. Source: Adapted from data provided in Table Exchange Rates for September 15, 2020. Spot and Forward Exchange Hates (Number of Units of Foreign currency per U.S. Dollar): Tuesday, Seotember 15,2020 The data has been collected in the Microsoft rxcel he below Downlosd the spreadhacet and perform the required analyss to answer the questions belav. Do not round intesmediate cakcilatices 3. How much in dollars does it cost Yohe to produce the Sr-207 Round your answer to the nearest cent: 5 3 What is the doliar sale price of the 5r207 Round yout answer to the nearest cent. 1 b. What is the doallar proft that Yohe makes on the sale of the sr-20?-Round your anser to the nearest cent 3 What is the percentage profit? plound your anser to two decimal places. profit to the nearest cent and for the percertage proft to two decinsal places. Doliar profitis Percentage profit: d. If the U.5. dollar was to weaken by 8% only against the fapanese yen and remained comant relatre to all other foreign curtencies. what would be the dollat and percentage pronts for the 5Y20? Round your answer for the dollar profit to the nearest cent and for the percentage profit to two decimal places botlar proft: 5 Percentage protit: C If the U.S. dotiar was to weaken by Bth against all foreign currencies, what would be the doltar and percentage protits for the 5Y207 Round your answer for the dollar profit to the nearest cent and for the percentage profit to two decimal plsces. Dobiar protiti $ Percentage profit d. If the U.5, dollar was to wesken by aw only against the Japanese yen and remained constant relative to all other forelign currencies, what would be the dollar and percentage protits for the 5Y20 ? Round your answer for the dottar profit to the nearest cent aod for the percentage profin to two decimal placei. Dolthat profit: 5 Percentage prent: e. Using the 180 -day forward exchange informatioe, cakculate the retum on L.year securibes in switreriand assuming the rate of return on 1 -year securibies in the tinited States is 4.8%, Assume that there are 360 days in a year. Round your answer to two decimal places. 1. Assuming that purchasing power panity (PPP) holds, what would be the sale price of the 5Y-20 if it was sald in the United kingdom rather thian Jopan? Aound your?answer to the nestest penty
