ohio case study

Case Study 2 and Case Study 3 combined: Managing Foreign Exchange Risk through Options: A Case Study in International Business Release date: Wednesday, March 27, 2024. Due date: 11:00pm, Wednesday, April 17, 2024 This is a group case study. You can form a team with no more than four members. Introduction: XYZ Corporation, a multinational company with operations in the United States, Europe, and Asia, faces significant foreign exchange risk due to its extensive international operations. The headquarter is in Phoenix, AZ, U.S. The company transacts in multiple currencies, including the US Dollar (USD), Euro (EUR), and Chinese Yuan (CNY). Fluctuations in these currency exchange rates impact the company’s revenues, expenses, and overall profitability. To mitigate this risk, the company adopts a comprehensive risk management strategy, incorporating options on foreign currency as a key component. 1. Study of historical exchange rates Before implementing the options strategy, XYZ Corporation conducts a thorough assessment of its foreign exchange risk. This involves identifying key currencies impacting the business (USD, EUR, CNY), and understanding the historical volatility of these currencies. Your first task is to study the exchange rates by following the steps: Download the package tidyquant, and use the following sample codes to extract historical exchange rates: ####################################### library(tidyquant) av_api_key(‘ILEQRVXY1K13TPUG’) # You have to generate your own unique API key. jpy_usd = tq_get(“JPY/USD”, get = “alphavantage”, av_fun = “FX_DAILY”, outputsize = “full”) jpy_usd = as.data.frame(jpy_usd) ####################################### o Do a literature review about how to compute the volatility of exchange rates. Implement the computations in R to evaluate the volatility for the currencies in this case study. o 2. Foreign Exchange Risk Assessment Next, based on the understanding of historical exchange rates, you have to assess the potential impact on financial performance in various scenarios due to the fluctuation of the exchange rates. Your second task is to evaluate how the expenses and revenue of XYZ company (See Appendix A) would change corresponding to the fluctuation of exchange rates. You can use appropriate statistics (like percentiles) and plots (like histogram) to show the uncertainty of profit and revenue in dollars from the foreign business. 3. Hedging Strategy The finance team decides to use call and/or put options to create a balanced hedging strategy. Recall call options are used to protect against the depreciation of domestic currencies, while put options are employed to hedge against domestic currency appreciation. Your third task is to carefully select the option types, the expiration dates and strike prices based on XYZ company’s forecasted cash flows (See Appendix A) and risk tolerance. Regarding the risk tolerance, you can define it according to your risk appetite. For instance, with a specified probability level, the potential negative impact (for example, negative profit) is controlled to some amount you can accept. 4. Evaluation of the hedging cost Your fourth task is to evaluate the cost (in dollars) of the options you selected in the third task. The estimation is based on binomial option pricing methodology. You can use the R package “derivmkts” and the R function binomopt() will help you price the options you have chosen. Make sure that the number of binomial steps in this function is set up sufficiently. 5. Results and Impact Through the implementation of the options’ strategy, XYZ Corporation is expected to successfully mitigate a significant portion of its foreign exchange risk in USD, EUR, and CNY. Your fifth task is to quantify and evaluate how the above expectation could be potentially satisfied. For example, a critical question would be: Will the company experience enhanced financial stability, allowing for more accurate budgeting and planning? Stability can be quantified using different metrics, such as reduced uncertainty (i.e., standard deviation) of revenue and profit. Any other comments on this risk management strategy? Appropriate assumptions could be made if not given in this case study, but you should justify the assumptions that are employed. Deliverables: Submit a report to cover the required five tasks, as well as supporting calculations like R codes and Excel work. Note: In assessing the reports, quality takes precedence over the length of the document. The expectation is to deliver concise yet comprehensive report that effectively addresses each task with clarity, depth, and accuracy. Regarding the supporting calculations, make sure your work is readable and clear with appropriate comments/documentation. Appendix A: XYZ company’s forecasted cash flows in year 2025 For the business in China: (in Chinese yuan, CHN, millions) Month Expenses Revenue January 4500 6200 February 4000 5500 March 5200 6800 April 4300 5200 May 4500 5610 June 5100 6740 July 6500 9320 August 8000 11050 September 7500 10180 October 6800 9730 November 5700 7150 December 4800 6450 For the business in Europe: (in Euro, millions) Month Expenses January 1200 February 1360 March 1130 April 1280 May 1175 June 1349 July 1492 August 1338 September 1249 October 1471 November 1392 December 1480 Revenue 1500 1450 1400 1630 1568 1635 1758 1685 1549 1769 1680 1829

ohio case study

We offer the best custom writing paper services. We have answered this question before and we can also do it for you.


We offer the bestcustom writing paper services. We have done this question before, we can also do it for you.

Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.