International Financial Management

cocoddy
PROJECT-Spring2020.pdf

1

FIN 4213 - Term Project – Spring 2020

Due Thursday, April 30, 2020

(100 points)

For your term project, you will make a recommendation on managing risk exposure for a

hypothetical multinational corporation (MNC) with (assigned) foreign currency cash flows scheduled

to occur in 3 months. The information you collect and analyze will help you assess the risk of your

firm’s foreign exchange exposure, forecast the exchange rate of one currency in 3 months, and make a

decision about hedging the transaction exposure for cash flows due in three months.

Information Sources: Use current financial and economic information in your analysis. You can

use data sources on the internet that are authentic or official. Some suggested resources are:

General Information

The Wall Street Journal – Foreign Exchange Quotations, as well as information on current

events of many countries.

Financial Times - – Foreign Exchange Quotations, Currency Futures and option quotes as well

as information on current events of many countries.

The Economist – Information in the back about interest rates, inflation rates and other

economic information for industrialized and developing economies. It is also a good

source for current events worldwide.

World Bank Reports and Data for Regions and Individual Countries

www.worldbank.org/html/extdr/regions.htm

CIA Fact Book https://www.cia.gov/library/publications/the-world-factbook/ General

information on every country. Very extensive, but a good source of background

information on the politics and environment of each country.

Exchange Rate Data and Information

OANDA website – www.oanda.com.

Financial Times – www.ft.com

International Monetary Fund –www.imf.org

Options and Futures Quotes and Information

Chicago Mercantile Exchange Home Page (www.cme.com) – more complete and extensive

information on currency futures.

2

Philadelphia Stock Exchange (www.phlx.com) provides a good source of information for

option contracts on currencies

Other Data Sources

Home Pages for Central Banks – Some are more helpful than others, but they are worth a look.

The final report should be a Word or pdf document of about 3 to 6 double-spaced typed pages,

including all tables, exhibits, and graphs. Do not include the raw data (such as exchange rates) in

your report. Structure your project so that it flows well. Grading will be based upon content and

writing style.

General Writing/Format Guidelines

Your analysis should be structured to be the three-month window beginning from April 1,

2020.

Finally, be sure to cite the sources of your data and information in the bibliography at the end

of your report.

The suggested structure of the report is as following.

The first section is an introduction to the project. The introduction should indicate that your firm is a

U. S. MNC doing business in country ____, the foreign currency cash flows faced by your firm (see

below and the document “Project currency assignment” for currency and cash flow assigned to your

firm), and the purpose of the analysis. Also include in this section the current exchange rate system

(floating, fixed, pegged, etc) that your currency has against the US dollar. To find the information on

the exchange rate system, the central banks’ home pages may be useful sources as is the IMF website.

Section I. Introduction

3

Net Transaction Exposure for the currency chosen for your MNC

(parentheses indicate cash outflow of the foreign currency)

Country Currency Net Exposure Country Currency Net Exposure

1. Argentina Peso 152,500,000 9. Malaysia Ringgit (81,520,000)

2. Australia Dollar (12,750,000) 10. Mexico Peso 126,350,000

3. Brazil Real 55,800,000 11. New Zealand Dollar (23,250,000)

4. Canada Dollar (22,600,000) 12. South Korea Won 7,650,000,000

5. China Renminbi 60,250,000 13. Sweden Krona (10,300,000)

6. Eurozone Euro (20,465,000) 14. Switzerland Franc 54,750,000

7. India Rupee 687,500,000 15. Thailand Baht (58,915,000)

8. Japan Yen (925,000,000) 16. UK Pound 9,750,000

In the section part, you assess the risk faced by the MNC. First, assess the current (or most recent

developments in) Economic, financial and (possibly) political environments for the country chosen,

and make comments on their stability or risk. If you are assigned the Eurozone, you can assess the

whole Eurozone or one specific country in the eurozone (e.g., France, Italy, Germany, etc). The

sources listed under General Information are a good place to begin this assignment.

Section II. Risk Analysis:

Be certain to cite

your sources within the text of your report and include it in the bibliography

.

Then assess the exchange rate risk. Use OANDA.com to collect daily exchange rates for the one-year

period, April 1, 2019 – March 31, 2020, for the currency assigned to you. Go to

https://www.oanda.com/fx-for-business/historical-rates, register for a 30-day free trial pro account

and sign in, choose the time range and currencies, and download the historical daily exchange rates.

Use direct quotes, i.e., number of US dollars per foreign currency. Specifically, choose your assigned

currency as “Currency I have”, and US Dollar as “Currency I want”. Set the frequency to Daily. You

can use either ask, bid or mid price. The free trial account allows only one download. So double check

the specified time range and currencies before clicking on “Download”. Save the daily exchange rate

in an excel spreadsheet.

4

Next, do the following statistical analysis in excel:

(1). calculate the daily percentage change in exchange rate.

(2). for the whole one-year period and each of the four quarters, compute the mean of daily

exchange rate, standard deviation of daily percentage change in exchange rate, and appreciation or

depreciation rate (in percentage) over the period.

April 1, 2019 – March 31, 2020 (1-year period)

April 1, 2019 – June 30, 2019 (Quarter 1)

July 1, 2019 – September 30, 2019 (Quarter 2)

October 1, 2019 – December 31, 2019 (Quarter 3)

January 1, 2020 - March 31, 2020 (Quarter 4)

Create a table to report the mean, standard deviation, and appreciation or depreciation rate for the five

periods. Include the table in your report. An example of such table is as below.

1-year period Quarter 1 Quarter 2 Quarter 3 Quarter 4

Mean of daily rates

Std.dev. of daily % change

Appreciation/depreciation rate

Also, create a line graph plotting the daily exchange rates for the entire one-year period (the dates on

the horizontal axis), and include the graph in your report.

Write a description of what you observe from the statistical data reported in the table and the graph,

focusing on the movement and variability of exchange rate during those periods. Do not turn in the

exchange rates you have collected.

In this section you forecast exchange rate. Use the spot exchange rate for the currency as of April 1,

2020 as the current exchange rate and make forecasts of the exchange rate in 3 months. You will make

three forecasts. Two forecasts are based on purchasing power parity (PPP) and international Fisher

Section III. Exchange rate forecasting :

5

effect (IFE), respectively. See the spreadsheet file “Project data” for inflation and interest rates data.

Show every step in your calculation.

For example, when you make forecast using PPP, write down the formula for PPP:

ef = (1+Ih)/(1+If) – 1

Explain the variables in the equation. State the inflations rates for the home country (US) and the

foreign country. Plug in the inflation rates into the equation to calculate ef. Then estimate the forecast

as St = S0 (1+ ef), where S0 is the current spot rate (the spot rate on April 1, 2020) and St is the

forecast.

Show the similar calculation details for forecasting using IFE.

In addition, use current spot rate as the third forecast.

From the three alternative forecasts, choose one as the single point forecast for the currency and justify

your choice (i.e., briefly explain why you choose that forecast).

Finaly, construct a forecast interval for the currency. The forecast interval specifies a range (the highest

or lowest values) that the currency could be in 3 months, i.e., the predicted maximum and minimum

exchang rate above and below your point forecast. The conventional forecast interval is at 95%

confidence level, and is within two standard deviations from the point forecast:

95% forecast interval : [St – 2Stσ, St + 2Stσ]

where, St is the point forecast that you choose, and σ is the standard deviation of daily percentage

changes in exchange rate that you calculate in section II. Clearly show your calculation of the

forecast range.

Write an assessment of the risk of your firm’s exposure. This assessment should include the size of the

foreign cash flow, whether it is an inflow or outflow, and the US dollar equivalent of the cash flow

(calculated using the spot rate on April 1, 2020).

Section IV. Hedging decision:

6

Make a decision on whether and how to hedge the foreign cash flow. Explain your hedging strategy

you would use given your firm’s exposure in the foreign currency.. If you decide to hedge using

currency derivations, check CME.com to see if forward, futures or option contracts exist for the

currency. If none of the currency derivatives exist, suggest an alternative way to hedge. If you decide

not to hedge, justify your decision.

+ Bibliography

Submit your final rep ort in a Word or pdf document through Canvas . Include your name and section

number on the first page of your report . The submission deadline is m idnight of Thursday, April 30,

2020.

Submission

  • Dollar