Hoping someone could help me with this question thank you

Problem 14-16 (algorithmic) 55 Question Help a Grupo Modelo s.A.B. do c.v. Grupo Modelo, a brewery out of Mexico that exports such well-known varieties as Corona, Modelo, and Pacico, is Mexican by incorporation. However, the company evaluates all business results, including nancing costs, in us. dollars. The company needs to borrow $30,000,000 or the foreign currency equivalent for four years. For all issues, interest is payable onoe per year, at the end of the year Available alternatives are as follows: a. Sell Japanese yen bonds at par yielding 3.10% per annum. The current exchange rate is 108.00/$, and the yen is expected to strengthen against the dollar by 2.4% per annum. What is the effective cost of the yen-denominated loan for Grupo Modelc? b. Sell euro-denominated bonds at par yielding 6.70% per annum. The current exchange rate is $1.1950/, and the euro is expected to weaken against the dollar by 2.3% per annum. What is the effective cost of the euro-denominated loan for Grupo Modelo? c. Sell US. dollar bonds at par yielding 5.30% per annum. What is the effective cost of the dollar-denominated loan for Grupo Modelo? d. Which course of action do you recommend Grupo Modelo take and why? a. Complete the following table to calculate the dollar cost of the yen-denominated debt for years 0 through 4. Enter a positive number for a cash inow and a negative number for a cash outow. (Round the amount to the nearest whole number and the exchange rate to two decimal places.) Year 0 Year 1 Year 2 Year 3 Year 4 Cash flow in Exchange rate, l$ 108.00 Cash ow in $ $ 30,000,000 $ $ $ $ Enter any number in the edit fields and then click Check Answer. parts . remaining Clear All