Foreign Exchange Trading at Baldwin Enterprises Baldwin Enterprises is a large manufacturing company with operations and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Foreign Exchange Trading at Baldwin Enterprises Baldwin Enterprises is a large manufacturing company with operations and sales divi- sions located in the United States and several other countries. The CFO of the organiza- tion, Wes Hamrick, is concerned about the amount of money Baldwin has been paying in transaction costs in the foreign exchange markets and has asked you to help optimize Baldwin's foreign exchange treasury functions. With operations in several countries, Baldwin maintains cash assets in several dif- ferent currencies: U.S. dollars (USD), the European Union's euro (EUR), Great Britain's pound (GBP), Hong Kong dollars (HKD), and Japanese yen (JPY). To meet the different cash-flow requirements associated with the company's operations around the world, Baldwin must often move funds from one location (and currency) to another. For in- stance, to pay an unexpected maintenance expense at the company's facility in Japan, Baldwin may need to convert some of its holdings in U.S. dollars to Japanese yen. The foreign exchange (FX) market is a network of financial institutions and bro- kers in which individuals, businesses, banks, and governments buy and sell the currencies of different countries. They do so in order to finance international trade, invest or do business abroad, or speculate on currency price changes. The FX market operates 24 hours a day and represents the largest and most liquid marketplace in the global economy. On average, the equivalent of about $1.5 trillion in different currencies is traded daily in the FX market around the world. The liquidity of the market provides businesses with access to international markets for goods and ser- vices by providing the foreign currency necessary for transactions worldwide (see http://www.ny.frb.org/fxc). The FX market operates in much the same way as a stock or commodity market where there is a bid price and ask price for each commodity (or, in this case, currency). A bid price is the price at which the market is willing to buy a particular currency, and the ask price is the price at which the market is willing to sell a currency. The ask prices are typically slightly higher than the bid prices for the same currency-- representing the transaction cost or the profit earned by the organizations that keep the market liquid. The following table summarizes the current FX rates for the currencies Baldwin currently holds. The entries in this table represent the conversion rates from the row currencies to the column currencies. Convert To USD EUR GBP HKD JPY USD 1 0.9724 1.5593 0.12812 0.00843 EUR 1.01864 1 1.5881 0.1304 0.00856 GBP 0.6409 0.6295 1 0.0821 0.0054 HKD 7.7985 7.6552 12.154 1 0.0658 JPY 118.55 116.41 184.97 15.1005 1 For example, the table indicates that 1 British pound (GBP) can be exchanged (or sold) for 1.5593 U.S. dollars (USD). Thus, $1.5593 is the bid price, in U.S. dollars, for 1 British pound. Alternatively, the table indicates 1 U.S. dollar (USD) can be exchanged (sold) for 0.6409 British pounds (GBP). So, it takes about 1.5603 U.S. dollars (or 1/0.6409) to buy 1 British pound (or the ask price, in U.S. dollars, for 1 British pound is roughly $1.5603). Notice that if you took 1 British pound, converted it to 1.5593 U.S. dollars, and then converted those 1.5593 dollars back to British pounds, you would end up with only 0.999355 British pounds (that is, 1 X 1.5593 X 0.6409 = 0.999355). The money you lose in this exchange is the transaction cost. Baldwin's current portfolio of cash holdings includes 2 million USD, 5 million EUR, 1 million GBP, 3 million HKD, and 30 million JPY. This portfolio is equivalent to $9,058,560 USD under the current exchange rates (given earlier). Wes has asked you to design a currency trading plan that would increase Baldwin's euro and yen holdings to 8 million EUR and 54 JPY, respectively, while maintaining the equivalent of at least $250,000 USD in each currency. Baldwin measures transaction costs as the change in the USD equivalent value of the portfolio. 1. Create a spreadsheet model for this problem and solve it. 2. What is the optimal trading plan? 3. What is the optimal transaction cost (in equivalent USD)? 4. Suppose another executive thinks that holding $250,000 USD in each currency is excessive and wants to lower the amount to $50,000 USD in each currency. Does this help to lower the transaction cost? Why or why not? 5. Suppose the exchange rate for converting USD to GBP increased from 0.6409 to 0.6414. What happens to the optimal solution in this case? Foreign Exchange Trading at Baldwin Enterprises Baldwin Enterprises is a large manufacturing company with operations and sales divi- sions located in the United States and several other countries. The CFO of the organiza- tion, Wes Hamrick, is concerned about the amount of money Baldwin has been paying in transaction costs in the foreign exchange markets and has asked you to help optimize Baldwin's foreign exchange treasury functions. With operations in several countries, Baldwin maintains cash assets in several dif- ferent currencies: U.S. dollars (USD), the European Union's euro (EUR), Great Britain's pound (GBP), Hong Kong dollars (HKD), and Japanese yen (JPY). To meet the different cash-flow requirements associated with the company's operations around the world, Baldwin must often move funds from one location (and currency) to another. For in- stance, to pay an unexpected maintenance expense at the company's facility in Japan, Baldwin may need to convert some of its holdings in U.S. dollars to Japanese yen. The foreign exchange (FX) market is a network of financial institutions and bro- kers in which individuals, businesses, banks, and governments buy and sell the currencies of different countries. They do so in order to finance international trade, invest or do business abroad, or speculate on currency price changes. The FX market operates 24 hours a day and represents the largest and most liquid marketplace in the global economy. On average, the equivalent of about $1.5 trillion in different currencies is traded daily in the FX market around the world. The liquidity of the market provides businesses with access to international markets for goods and ser- vices by providing the foreign currency necessary for transactions worldwide (see http://www.ny.frb.org/fxc). The FX market operates in much the same way as a stock or commodity market where there is a bid price and ask price for each commodity (or, in this case, currency). A bid price is the price at which the market is willing to buy a particular currency, and the ask price is the price at which the market is willing to sell a currency. The ask prices are typically slightly higher than the bid prices for the same currency-- representing the transaction cost or the profit earned by the organizations that keep the market liquid. The following table summarizes the current FX rates for the currencies Baldwin currently holds. The entries in this table represent the conversion rates from the row currencies to the column currencies. Convert To USD EUR GBP HKD JPY USD 1 0.9724 1.5593 0.12812 0.00843 EUR 1.01864 1 1.5881 0.1304 0.00856 GBP 0.6409 0.6295 1 0.0821 0.0054 HKD 7.7985 7.6552 12.154 1 0.0658 JPY 118.55 116.41 184.97 15.1005 1 For example, the table indicates that 1 British pound (GBP) can be exchanged (or sold) for 1.5593 U.S. dollars (USD). Thus, $1.5593 is the bid price, in U.S. dollars, for 1 British pound. Alternatively, the table indicates 1 U.S. dollar (USD) can be exchanged (sold) for 0.6409 British pounds (GBP). So, it takes about 1.5603 U.S. dollars (or 1/0.6409) to buy 1 British pound (or the ask price, in U.S. dollars, for 1 British pound is roughly $1.5603). Notice that if you took 1 British pound, converted it to 1.5593 U.S. dollars, and then converted those 1.5593 dollars back to British pounds, you would end up with only 0.999355 British pounds (that is, 1 X 1.5593 X 0.6409 = 0.999355). The money you lose in this exchange is the transaction cost. Baldwin's current portfolio of cash holdings includes 2 million USD, 5 million EUR, 1 million GBP, 3 million HKD, and 30 million JPY. This portfolio is equivalent to $9,058,560 USD under the current exchange rates (given earlier). Wes has asked you to design a currency trading plan that would increase Baldwin's euro and yen holdings to 8 million EUR and 54 JPY, respectively, while maintaining the equivalent of at least $250,000 USD in each currency. Baldwin measures transaction costs as the change in the USD equivalent value of the portfolio. 1. Create a spreadsheet model for this problem and solve it. 2. What is the optimal trading plan? 3. What is the optimal transaction cost (in equivalent USD)? 4. Suppose another executive thinks that holding $250,000 USD in each currency is excessive and wants to lower the amount to $50,000 USD in each currency. Does this help to lower the transaction cost? Why or why not? 5. Suppose the exchange rate for converting USD to GBP increased from 0.6409 to 0.6414. What happens to the optimal solution in this case?
Expert Answer:
Answer rating: 100% (QA)
a The initial table is Exchange Rates USD EUR GBP HKD JPY USD 1 09724 15593 012812 000843 St... View the full answer
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these accounting questions
-
a. Create a spreadsheet model for this problem and solve it. b. What is the optimal trading plan? c. What is the optimal transaction cost (in equivalent USD)? d. Suppose that another executive thinks...
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
Googles ease of use and superior search results have propelled the search engine to its num- ber one status, ousting the early dominance of competitors such as WebCrawler and Infos- eek. Even later...
-
Use the following information to answer the questions that follow.... The Big Cheese Company * 2019 2020 Interest Expense 200 1950 Cash 180 30 Property, Plant, and Equipment 16000 39550 Inventories...
-
The Stratton Township Park is located on a piece of property that contains two golf courses, a swimming pool, and 800 acres of woods and open spaces. Three years ago, the Stratton Park Department...
-
Determine the symmetry elements of objects with the same shape as the boundary surface of (a) A p orbital, (b) A d xy orbital, (c) A d z 2 orbital.
-
Suppose a trader buys a European Put on a share for \(\$ 4\). The stock price is \(\$ 53\) and the strike price is \(\$ 49\). (a) Under what circumstances will the trader make a profit? (b) Under...
-
The common-size balance sheets from five companies follow: Alcoa, a major producer of aluminum products; Delta Air Lines, a major airline; Duke Energy, a leading energy company focused on electric...
-
gure AV ww 202 50 www 15 V +51 Part A In (Figure 1), what is the current in the wire to the right of the junction? Suppose that AV = 6 V. Express your answer as an integer and include the appropriate...
-
The following information is available for the preparation of the governmentwide financial statements for the city of Southern Springs as of April 30, 2020: From the preceding information, prepare,...
-
Q1. Prove that as Show that the series does not converge. Solution: = = 0 Put (n + 1) = - m So, 0 Now, = = [where M is a huge number] This is an alternating series almost close to 1. Now we test...
-
Tempura, Inc., is considering two projects. Project A requires an investment of $50,000. Estimated annual receipts for 20 years are $20,000; estimated annual costs are $12,500. An alternative...
-
Consider a portfolio of options on a single asset. Suppose that the delta of the portfolio is 12, the value of the asset is $10, and the daily volatility of the asset is 2%. Estimate the 1-day 95%...
-
A design change being considered by Mayberry, Inc., will cost \(\$ 6,000\) and will result in an annual savings of \(\$ 1,000\) per year for the 6-year life of the project. A cost of \(\$ 2,000\)...
-
Nadine Chelesvig has patented her invention. She is offering a potential manufacturer two contracts for the exclusive right to manufacture and market her product. Plan A calls for an immediate single...
-
Several years ago, a man won \(\$ 27\) million in the state lottery. To pay off the winner, the state planned to make an initial \\($1\) million payment immediately followed by equal annual payments...
-
Why did miscommunication usually occur? Explain
-
The production budget of Artest Company calls for 80,000 units to be produced. If it takes 30 minutes to make one unit and the direct labor rate is $16 per hour, what is the total budgeted direct...
-
Use regression analysis to fit a quadratic trend model to the data set. a. What is the estimated regression function? b. Compare the adjusted-R2 value for this model to that of the linear trend...
-
Use Holts method to create a model that minimizes the MSE for the data set. Use Solver to determine the optimal values of and . a. What are the optimal values of and ? b. Prepare a line graph...
-
a. Draw the network diagram for this problem. b. Implement the model for this problem in your spreadsheet and solve it. c. How much fuel should US Express purchase at each departure point and what is...
-
Yamindi was raised on a farm in the Northern Territory and loves animals. When he finished secondary school, Yamindi had nearly \($5000\) in a savings account. He used his savings to start a business...
-
\({ }^{235} \mathrm{U}\) decays to \({ }^{207} \mathrm{~Pb}\) via the decay series shown in Figure 30.15. The first decay in the chain, that of \({ }^{235} \mathrm{U}\), has a half-life of \(7.0...
-
A firecracker explodes on the ground in front of Martin just as Lisa passes by at 0.5c. 30 ,s later, according to Martin, a second firecracker explodes in front of him. Using what you've learned from...
Study smarter with the SolutionInn App