Apple INC is my company. Complete excel worksheet
First, review the annual financial statements (Form 10-K) for your selected company. You can either retrieve the statements from the webpage SEC EDGAR Company Filings or directly from the company’s website, often listed under “Investor Information.” Review the Module Five resources, including the website Historical Exchange Rates, and review the Module Three and Four resources.
Next, complete the Milestone Two: Foreign Currency Impact spreadsheet found in the module task, which analyzes the foreign currency impact on your selected company. To complete this part of the milestone, you will need to review at least three years’ worth of annual financial reports.
Finally, complete the Final Project Milestone Two section in the Final Project Template. The paper should outline what hedging techniques your selected company is currently using. You need to research the annual statement and look for foreign currencies and their treatment, the derivative contract specifically used for hedging, and any other notes on hedging in the company’s annual financial statements. Further, you will need to analyze specific foreign currency transactions listed in the financial statements.
The following critical elements must be addressed:
Section 2: Risk Mitigation Strategies
A. Determine current financial and strategic impacts of international risks to inform risk mitigation strategies. In other words, what kind of risks is your company exposed to (translation, transaction, economic, operating, etc.) and why?
B. Explain how to mitigate foreign exchange rate risk.
C. Identify the tools the company is currently using to mitigate its foreign exchange risk. This should be done using the annual financial statements.
D. Calculate the financial impacts of international foreign exchange risk to inform risk mitigation strategies. This will be done in an Excel spreadsheet. There are instructions in the spreadsheet to guide you step-by-step through the exercise.
E. Propose future mitigation strategies based on the prospective market for your corporation including addressing risks that are not currently being efficiently mitigated for your corporation.
Be sure to reference your completed Final Project Milestone One document as well as any other pertinent course resources to support your responses.