Assignment 1

.docx

School

Simon Fraser University *

*We aren’t endorsed by this school

Course

316

Subject

Finance

Date

Feb 20, 2024

Type

docx

Pages

4

Uploaded by ColonelPencil2684

Special Topics in International Financial Management Assignment 1 – 10 points Shrewsbury Herbal Products, located in central England close to the Welsh border, is an old-line producer of herbal teas, seasonings, and medicines. Its products are marketed all over the United Kingdom and in many parts of continental Europe as well. Shrewsbury Herbal generally invoices in British pound sterling when it sells to foreign customers in order to guard against adverse exchange rate changes. Nevertheless, it has just received an order from a large wholesaler in central France for £320,000 of its products, conditional upon delivery being made in three months’ time and the order invoiced in euros . Shrewsbury’s controller, Elton Peters, is concerned with whether the pound will appreciate versus the euro over the next three months, thus eliminating all or most of the profit when the euro receivable is paid. He thinks this is an unlikely possibility, but he decides to conduct an ad hoc analysis of the EUR/GBP historical exchange rate trend. 1. (3 points) In Excel, plot a line chart of the EUR/GBP historical exchange rates from January 1, 2022 to April 30, 2022 using data downloaded from http://fx.sauder.ubc.ca/data.html . Comment on the exchange rates general trend. Do you noticed any extremes? If so, describe them and provide possible explanations of those extremes. If you were Mr. Peters, what assumptions would you make of the next 3 months? Answer either here (include the chart from Excel) or directly in Excel.
While the fluctuations in the chart may seem large, they are actually not very volatile currencies and the general variance is between 1.18 and 1.21 Euro per GBP. There are no discernible statistical extremes that would be considered an “outlier”. If I were Mr. Peters, I wouldn’t expect the currencies to have major fluctuations in the next three months. I would expect the variance to generally stay the same – between 1.18 and 1.21 Euro per GBP. Mr. Peters decided to contract the firm’s banker for suggestions about hedging the exchange rate exposure. He learns from the banker that the current spot exchange rate is EUR/GBP = 1.1660, thus the invoice amount should be €373,120. Mr. Peters also learns that the three-month forward rates for the pound and the euro versus the U.S. dollar are $1.3897/£1.00 and $1.1929/€1.00, respectively. The banker offers to set up a forward hedge for selling the euro receivable for pound sterling based on the €/£ forward cross-exchange rate implicit in the forward rates against the dollar. 2. (2 points) What would you do if you were Mr. Peters? The cross-exchange rate is $1.3897/$1.1929 = 1.1648 1.1648*£320,000 = €372,736 1.1660*£320,000 = €373,120 D = €373,120-€372,736 = €384 Mr. Peters would be giving up €384 if he accepted the hedge offered by the banker, 1/4/2022 1/7 /20 22 1/1 2/2 022 1/1 7/2 022 1/2 0/2 022 1/2 5/2 022 1/28/2022 2/2/2022 2/7 /20 22 2/1 0/2 022 2/1 5/2 022 2/18/2022 2/2 4/2 022 3/1 /20 22 3/4 /20 22 3/9/2022 3/14/2022 3/1 7/2 022 3/22/2022 3/25/2022 3/3 0/2 022 4/4 /20 22 4/7/2022 4/1 2/2 022 4/18/2022 4/2 1/2 022 4/26/2022 4/2 9/2 022 1.16 1.17 1.18 1.19 1.2 1.21 1.22 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.19 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.19 1.18 1.18 1.19 1.19 1.19 1.19 1.2 1.19 1.19 1.2 1.2 1.2 1.2 1.2 1.19 1.2 1.2 1.2 1.21 1.21 1.21 1.2 1.19 1.19 1.19 1.19 1.19 1.19 1.18 1.19 1.19 1.2 1.2 1.2 1.2 1.19 1.18 1.18 1.19 1.19 1.19 1.2 1.2 1.2 1.2 1.2 1.2 1.2 1.21 1.21 1.2 1.2 1.2 1.19 1.19 1.18 1.19 1.19 1.19 Rates
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help