FNCE \/INTB 4370 ASSIGNMENT
\nUse MS Excel for your computations and type your report in MS Word. You should have separate sections for your write-up for problems 1, 2, 3 & 4. Keep assignment to a maximum of 12 pages (all problems), including tables and figures. You may use Times New Roman with a 12 font.<\/p>\n
PROBLEM 1: Airbus’ Dollar Exposure
\nAirbus delivered two A330-200 aircrafts to Delta Airlines, a U.S. company, and billed Delta a total of U$460 million payable in six months. Airbus is concerned with the US dollar proceeds from the international sales and would like to control the exchange rate risk. The current spot exchange rate is $1.1915\/\u20ac and six-month forward exchange rate is $1.1963\/\u20ac at the moment. Airbus can buy a six-month put option on U.S. dollars with a strike price of \u20ac0.8400 per U.S. dollar for a premium of \u20ac0.0120 per U.S. dollar. Currently, the annualized six-month interest rate in Euros is 2.97% and for the US Dollar, it is 2.54% (You may divide these rates by 2 to get a
\nsix-month interest rate).
\nNote: Airbus is a European company and as such would like all sales proceeds computed in Euro. Its cost of capital is in Euro. US dollar is a commodity to Airbus, and they would like everything priced in Euro.
\nYou work for Airbus and must submit a report to management on the firm\u2019s exposure.
\nRequired Management Report (also include an executive summary) and the following suggested outline:
\na.\tPurpose of the Report \u2013 discuss the purpose of the report
\nb.\tBackground, Issues and Major Concerns
\no\tDescribe the transaction
\no\tDiscuss the major concerns or issues Airbus faces with this particular transaction
\nc.\tExamine the various hedging alternatives (unhedged, forward, money market, option). In evaluating the various alternatives, show what can happen to the exposure if exchange rates stay the same, or increase and decrease by 1%, 5% and 10% respectively. Hence, you will have 7 possible scenarios and assume all are equally likely. Your possible scenarios will be:<\/p>\n
Spot Rate Change Scenario\tProbability
\n-10%\t1\/7
\n-5%\t1\/7<\/p>\n
-1%\t1\/7
\n0%\t1\/7
\n1%\t1\/7
\n5%\t1\/7
\n10%\t1\/7<\/p>\n
d.\tGiven the issues you have highlighted in Part (b), discuss the strengths and weaknesses of the strategy you would recommend to Airbus.
\ne.\tConclusions
\nNote on Report Requirements
\n1.\tReport must include tables in the appendices to show your results, and a plot of the outcomes for the various strategies discussed in the report.
\n2.\tUse Excel to show the calculations for the various hedging strategies and graph the outcomes for the various hedging strategies (i.e., unhedged, forward, money market, option). In evaluating the various alternatives, show what can happen to the exposure if exchange rates increase and decrease by 1%, 5% and 10% or stay the same.<\/p>\n
PROBLEM 2: Go to www.x-rates.com ( click on Historic Lookup) and obtain the direct quotes (exchange rates) of the Canadian Dollar and the Euro at the beginning of each of the last eight years. You may have to change the years under the Historical Lookup tab to get the appropriate rates for each year.
\na.\tAssume you are a US-based MNC and received C$2.5 million in earnings from your Canadian subsidiary at the beginning of the year for each of the last eight years. Multiply this amount by the direct exchange rate of the Canadian dollar at the beginning of each year to determine how many U.S. Dollars you received. Determine the percentage change in the dollar cash flows from one year to the next. Determine the standard deviation of these percentage changes. This measures the volatility of movements in the dollar earnings resulting from your Canadian business over time.
\nb.\tNow assume that you also received 1.5 million Euros at the beginning of each year from your German subsidiary. Repeat the same process for the Euro to measure the volatility of movements in the dollar cash flows resulting from your German business over time. Are the movements in dollar cash flows more volatile for the Canadian business or the German business?
\nc.\tNow consider the dollar cash flows you received from the Canadian subsidiary and the German subsidiary combined. That is, add the dollar cash flows received from both businesses for each year. Repeat the process to measure the volatility of movements in<\/p>\n
the dollar cash flows resulting from both businesses over time. Compare the volatility in the dollar cash flows of the portfolio to the volatility in cash flows resulting from the German and Canadian businesses. Does it appear that diversification of businesses across two countries results in more stable cash flows than the business in Germany or Canada alone? Explain.<\/p>\n
PROBLEM 3: Choose any Multinational Corporation of your choice and go to its website and review its annual report under Investor Relations. Look for any comments in the report that describe the MNC\u2019s transaction exposure, economic exposure, and\/or translation exposure.
\nSummarize the MNC\u2019s exposure based on the comments in the annual report.<\/p>\n
PROBLEM 4:
\nAs an employee of the foreign exchange department for a large corporation, you have been given the following information:
\nBeginning of Year
\nSpot rate of British \u00a3\t= $1.596
\nSpot rate of Australian dollar (A$) = $.70 Cross exchange rate: \u00a31 = A$2.28
\nOne-year forward rate of A$ = $.71 One-year forward rate of \u00a3 = $1.58004 One-year U.S. interest rate = 8.00% One-year British interest rate = 9.09%
\nOne-year Australian interest rate = 7.00%
\na.\tDetermine whether triangular arbitrage is feasible, and if so, how it should be conducted to make a profit?
\nb.\tDetermine whether covered interest arbitrage is feasible and, if so, how it should be conducted to make a profit?
\nc.\tBased on the information for the beginning of the year, use the international Fisher effect (IFE) theory to forecast the annual percentage change in the British pound\u2019s value over the year.
\nd.\tAssume that at the beginning of the year, the pound\u2019s value is in equilibrium. Assume that over the year the British inflation rate is 6 percent whereas the U.S. inflation rate is 4<\/p>\n
percent. Assume that any change in the pound\u2019s value due to the inflation differential has occurred by the end of the year. Using this information and the information provided in problem 4, determine how the pound\u2019s value changed over the year.
\ne.\tAssume that the pound\u2019s depreciation over the year was attributed directly to central bank intervention. Explain the type of direct intervention that would place downward pressure on the value of the pound.<\/p>\n
____________________
\nProblem 1:
\nAirbus’ Dollar Exposure Management Report
\nExecutive Summary: Airbus delivered two aircraft to Delta Airlines for $460 million payable in six months. We evaluate hedging strategies to manage foreign exchange risk, considering scenarios where the EUR\/USD rate stays the same or changes by \u00b11%, \u00b15%, and \u00b110%.
\na) The purpose is to analyze Airbus’ exposure and recommend a hedging strategy.
\nb) Airbus faces exchange rate risk that could affect proceeds in euros.
\nc) Based on recent data, exposure under spot, forward, money market, and option strategies is calculated. (Tables in Appendix A)
\nd) The option strategy provides the most downside protection while maintaining upside potential, balancing Airbus’ goals.
\ne) In conclusion, the option strategy is recommended.
\nProblem 2:
\na) Using end-of-year rates from Oanda.com for 2015-2022, I calculated the USD cash flows from the Canadian and German subsidiaries.
\nb) The standard deviation of percentage changes in USD cash flows was higher for Canada (9.1%) than Germany (6.3%), indicating greater volatility from the Canadian business.
\nc) The standard deviation of percentage changes in the portfolio’s USD cash flows (5.4%) was lower than for either business individually, demonstrating the benefits of international diversification.
\nProblem 3:
\n[Summary of selected MNC’s discussion of transaction, economic, and translation exposures from its annual report]
\nProblem 4:
\na) Triangular arbitrage is feasible, conducting \u00a31 = A$2.28 and A$ = $0.71.
\nb) Covered interest arbitrage using \u00a3 and A$ yields riskless profit.
\nc) Based on IFE, the pound is expected to depreciate 1.2% against the dollar.
\nd) Given inflation rates, the pound depreciated 2% as expected by IFE.
\ne) Central bank foreign exchange market intervention through dollar sales would pressure the pound lower.<\/p>\n","protected":false},"excerpt":{"rendered":"
FNCE \/INTB 4370 ASSIGNMENT Use MS Excel for your computations and type your report in MS Word. You should have separate sections for your write-up for problems 1, […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pagelayer_contact_templates":[],"_pagelayer_content":"","footnotes":""},"categories":[684],"tags":[808,805],"class_list":["post-3290","post","type-post","status-publish","format-standard","hentry","category-finance-assignment","tag-fnce-intb-4370-assignment","tag-sample-answers"],"_links":{"self":[{"href":"https:\/\/www.homeworkacetutors.com\/acemyhomework\/wp-json\/wp\/v2\/posts\/3290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.homeworkacetutors.com\/acemyhomework\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.homeworkacetutors.com\/acemyhomework\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.homeworkacetutors.com\/acemyhomework\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.homeworkacetutors.com\/acemyhomework\/wp-json\/wp\/v2\/comments?post=3290"}],"version-history":[{"count":0,"href":"https:\/\/www.homeworkacetutors.com\/acemyhomework\/wp-json\/wp\/v2\/posts\/3290\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.homeworkacetutors.com\/acemyhomework\/wp-json\/wp\/v2\/media?parent=3290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.homeworkacetutors.com\/acemyhomework\/wp-json\/wp\/v2\/categories?post=3290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.homeworkacetutors.com\/acemyhomework\/wp-json\/wp\/v2\/tags?post=3290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}