international finance walmart project part 4
pdf
keyboard_arrow_up
School
Humber College *
*We aren’t endorsed by this school
Course
354
Subject
Finance
Date
Nov 24, 2024
Type
Pages
3
Uploaded by tastyyum9
Foreign Exchange Exposure
Walmart Incorporated is an American retail company that operates internationally, with
over 10,623 retail stores and 380 distribution facilities for a total of 11,003 stores throughout the
world as of January 31, 2023, according to statista.com. According to Walmart corporate
website, Walmart International operates in over 19 countries out of the U.S., including, Africa,
Central America, China, India and Mexico. With the International operations, Walmart has dealt
with significant Foreign Exchange Exposure as transaction exposure, economic exposure and
translation exposure.
The current business model of selling a high-volume of low-profit margin discounted
products that Walmart is currently using, forces the company to source low cost products from
all across the globe. This creates a great transaction exposure as when the company buys these
low cost products in foreign countries, especially in China, Walmart will typically pay in the
local currency. For example, “Only roughly 20% of Walmart’s retail products are from US-based
suppliers. According to estimates, 70 to 80% of Walmart products are from China, excluding
food, meat, and fresh produce.” (Jones, 2022). The Chinese currency the Renminbi, also known
as the Chinese Yuan, is currency trading at 1 USD to 7.16 CNY. However, approximately 1 year
ago, on January 12, 2023, the Yuan was trading at 1 USD to 6.74 CNY. This shows a difference
of 0.42 CNY per 1 USD in just under 12 months. This greatly affects Walmart as certain
purchases must be made in the Yuan, which when converted from the USD can cause a loss.
If the company was to buy $100,000 USD worth of product in January from China , it
would have cost the company just 674,000 CNY. However, if they were to wait until today's
exchange rate, that same product would have cost the company 716,000 CNY. This poses a threat
to great transaction exposure if all of the company's earnings are in one currency, such as the
USD. One of the ways that Walmart has attempted to mitigate this risk is through diversification
of currencies, including the use of forward currency contracts and keeping currencies in their
earned countries where feasible. This allows Walmart to mitigate risk by holding various
currencies, allowing for less conversions and therefore less costs and exposure.
Additionally, Walmart has been exposed to a great deal of economic exposure over the
last few years, especially since the covid-19 pandemic. This has a direct link to transaction
exposure, as certain economies may see increased costs to exports and imports as well as
manufacturing competition in booming economies. Walmart has done an excellent job of risk
mitigation for economic exposure, by diversifying their manufacturing facilities, as mentioned
before to almost 20 countries. This allows them to finance and produce products in an array of
markets, ultimately limiting the cost to export, import and sell products. Another way that
Walmart can further limit their economic exposure is through currency swaps. This is typically
done to eliminate risk and hedge long-term investments that can affect interest rate exposure
through two parties. “This is typically done with companies to find more favourable loan rates in
local currencies than they could find if they borrowed money from a bank in that country.”
(Segal, 2021).
As previously mentioned, Walmart is in 20 countries across the globe, which poses a
foreign exposure risk to translation. This is when a company may find their asset, liabilities, or
shareholder’s equity affected by the change in exchange rates. Similar to their transaction
exposure risk, the same goes for their balance sheet, as this may be affected when the exchange
rates change. This can be positive but also negative. For example, in the time from 2019 to 2023,
the following data was provided by Finbox, which shows an analysis on the foreign exchange
rate adjustments based on Walmart. According to findbox, “ Walmart's foreign exchange rate
adjustments decreased in 2019 (-438 million, -189.9%) and 2022 (-140 million, -159.6%) and
increased in 2020 (-69 million, -84.2%), 2021 (235 million, -440.6%), and 2023 (-73 million,
-47.9%).’ This shows the volatility of currency and how foreign exchange is an important high
level issue for the company.
Throughout the years since being incorporated in 1962, Walmart has grown into an
international enterprise that has seen sales grow exponentially, and seen stores and investments
grow to over 20 countries around the world. With this expansion, the company has seen a vast
number of foreign exposure risks, such as transaction, economic and translation exposure.
Through the various risk mitigation strategies that Walmart uses, including but limited to forward
contracts, keeping profits in local currencies and currency swaps and hedging, the company has
limited their risks, however as seen in the stats provided by Finbox, the company is still very
much affected by the exposure to international markets and their foreign exchange exposures.
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
Related Questions
Hansaben
arrow_forward
Euroco is a foreign corporation that manufactures watches for sale worldwide. Euroco markets its watches in the United States through a branch sales office located in Boston. During Year 1, Euroco’s effectively connected earnings and profits are $12 million, and its U.S. net equity is $24 million at the beginning of the year, and $16 million at the end of the year. In addition, Euroco’s interest expense recorded and paid by the U.S. branch was $1,760,000 of portfolio interest paid to an unrelated foreign corporation and $800,000 of interest paid to a foreign corporation which owns 15% of the combined voting power of Euroco’s stock. During Year 2, Euroco’s effectively connected earnings and profits are $20 million, and its U.S. net equity at the end of the year is $18 million. In addition, Euroco’s U.S. branch had recorded interest paid of $640,000 paid to a U.S. corporation. Euroco is not in a treaty country.
What is Euroco’s branch profits tax, if any, for Year 2?
a.
$6,000,000…
arrow_forward
Company X is a U.S.-based IT company with operations and earnings in a
number of foreign countries. The company's profits by subsidiary, in local
currency (in millions), are shown in the following table for 2019 and 2020.
Net Income
Japanese Subsidiary
Britih Subsidiary
2019
JPY 200
GBP 100.00
2020
JPY 1,480
GBP 108.40
The average exchange rate for each year, by currency pairs, is the following.
Exchange Rate
USD = 1 GBP
JPY = 1 USD
2019
97.57
1.5646
2020
90.88
1.6473
Use the above data, Students answer the following questions.
a. What is Company X's consolidated profits in U.S. dollars in 2019 and 2020?
b. If the same exchange rates are used for both years, what is the change in
corporate earnings on a "constant currency" basis?
c. Using the results of the constant currency analysis in part b, is it possible
to separate Company X's growth in earnings between local currency
earnings and foreign exchange rate impacts on a consolidated basis?
arrow_forward
McDonald’s conducts operations worldwide and is managed in three primary geographic segments: U.S., International Lead Markets (including Australia, Canada, France, Germany, and the UK), and High Growth Markets (including China, Italy, Korea, Poland, Russia, Spain, Switzerland, and the Netherlands). A hybrid geographic/corporate segment, Foundational Markets & Corporate, reports on the results of all other countries as well as any unallocated amounts. McDonald’s allocates resources to, and evaluates the performance of, its segments based on operating income. The asset totals disclosed by geography are directly managed by those regions and include accounts receivable, inventory, certain fixed assets, and certain other assets. Corporate assets primarily include cash and cash equivalents, investments, deferred tax assets, and other assets. Refer to the following geographic segment data (in millions) from the 2017 annual report of McDonald’s Corp.:
arrow_forward
A multinational Corporation based in the United States of America has subsidiaries in the UK, Canada, and France. As at December 31, 2020, inter-company indebtedness were as follows:Debtors Creditors Amount CurrencyUK Canada 1,500,000 Can$UK France 600,000 Euro (€)France Canada 800,000 Can$Canada UK 94,000 Sterling (£)Canada France 400,000 Euro (€)It is the policy company’s policy to net off inter-company balances to the greatest extent possible. The central treasury department is to use the following exchange rates for these purposes:US$1 =Can$1.237/€0.8620/£0.729Required:Calculate the net payment to be made between the subsidiaries after netting off inter-company balances,by presenting the payoff in a matrix/table format.
arrow_forward
Assessing Translation Exposure
Assume the euro’s spot rate is presently equal to $1.00. All of the following firms are based in New York and are the same size. While these firms concentrate on business in the United States, their entire foreign operations for this quarter are provided here.
Company A expects its exports to cause cash inflows of 9 million euros and imports to cause cash outflows equal to 3 million euros.
Company B has a subsidiary in Portugal that expects revenue of 5 million euros and has expenses of 1 million euros.
Company C expects exports to cause cash inflows of 9 million euros and imports to cause cash outflows of 3 million euros, and will repay the balance of an existing loan equal to 2 million euros.
Company D expects zero exports and imports to cause cash outflows of 11 million euros.
Company E will repay the balance of an existing loan equal to 9 million euros.
Which of the five companies described here has the highest degree of translation exposure?
arrow_forward
Newberry, Inc., whose reporting currency is the U.S. dollar ($), has a subsidiary in Argentina, whose functional currency also is the $. The subsidiary acquires inventory on credit on November 1, 2017, for 100,000 pesos that is sold on January 17, 2018, for 130,000 pesos. The subsidiary pays for the inventory on January 31, 2018. Currency exchange rates are as follows:Cost of goods sold . . .. LCU 5,000,000Beginning inventory . . . . . . . 500,000Ending inventory . . . . . . . . . . 600,000November 1, 2017 . . . . $0.16 = 1 pesoDecember 31, 2017 . ...... . . 0.17 = 1January 17, 2018 . . . . . . . . . 0.18 = 1January 31, 2018 . . . . . . . . 0.19 = 1What amount does Newberry’s consolidated income statement report for cost of goods sold for the year ending December 31, 2018?a. $16,000.b. $17,000.c. $18,000.d. $19,000.
arrow_forward
!
Required information
Newberry, Inc., whose reporting currency is the U.S. dollar ($), has a subsidiary in Argentina, whose functional
currency also is the $. The subsidiary acquires inventory on credit on November 1, 2017, for 210,000 pesos
that is sold on January 17, 2018, for 243,000 pesos. The subsidiary pays for the inventory on January 31,
2018. Currency exchange rates are as follows:
$0.54 =1 peso
November 1, 2017
December 31, 2017
0.55 =1
January 17, 2018
January 31, 2018
0.56 =1
0.57 =1
arrow_forward
ABC Trading Company of Singapore purchases spices in bulk from around the world,
packages them into consumer size quantities and sells them through sales affiliates in Hong
Kong and the Unites States. For a recent month, the following payments matrix of inter-affiliate
cash flows, stated in Singapore dollars, was forecasted.
ABC Trading Company Payments Matrix (S$000)
Receipts by:
Singapore
Hong Kong
U.S.
S$170,000
S$152,000
S$405,000
Disbursements by:
S$322,000
Singapore
16
22
Hong Kong
80
50
Calculate, in Singapore dollars, the amount that the inter-affiliate foreign exchange transaction
will be reduced by with multilateral netting.
U.S.
110
44
arrow_forward
A U.S.-based multinational company has two subsidiaries, one in Mexico (local currency, Mexicanpeso, MP) and one in Japan (local currency, yen, ¥). Forecasts of business operations indicate the following short-term financing position for each subsidiary (in equivalent U.S. dollars):
Mexico:$80 million excess cash to be invested (lent)
Japan: $60 million funds to be raised (borrowed)
Currency
Item
US $
MP
¥
Spot exchange rates
MP11.60/US$
¥108.25/US$
Forecast percentage change
−3.00%
+1.50%
Interest rates
Nominal
Euromarket
4.00%
6.20%
2.00%
Domestic
3.75%
5.90%
2.15%
Effective
Euromarket
Domestic
Euromarket and the domestic market; then indicate where the funds should be invested and raised.…
arrow_forward
Balance-of-payments double-entry bookkeeping. Show how the following transactions should be recorded in the U.S. balance of payments using a double-entry accounting system:
■ Newmont Mining—a U.S. mining concern—exports $400 million worth of copper to China and is paid in the form of a payment drawn on a U.S. bank.
■ DuPont expands its plastics manufacturing capacity in its Polish plant by investing $250 million financed by a dollar bond issue in London (United Kingdom).
■ The central bank of the People’s Bank of China purchases $2.5 billion in the foreign exchange market to slow down the appreciation of the renmimbi. The dollars are invested in five-year U.S. Treasury bonds.
■ The U.S. government provides food assistance to Sudanese refugees in the amount of $25 million worth of flour.
arrow_forward
New Life is a multinational distribution company that started operating a Branch in Barbados on1 January 2023. The company’s Head Office is in the Cayman Islands and is part of a group whichearns more than USD 850 million for the year. It employed some of its staff from Barbados and imports good and services from the US, Cayman Islands, and other Caribbean countries. New Life repatriation policy is to transfer 50 % to 70% of its after-tax profits to the Cayman Islands.The company was of the view that for the first year of operation there was a window of no taxobligations. In December 2023, the company realized that their understanding was not correct and therefore engaged UWI Tax Consulting Services Limited to provide tax advisory and tax compliance services. Your Group was assigned this engagement.
Required.Advice New Life of the tax matters that needs to be considered when operating in Barbadosincluding any tax benefits or incentives they may consider.
arrow_forward
Newberry, Inc., whose reporting currency is the U.S. dollar ($), has a subsidiary in Argentina, whose functional currency also is the $. The subsidiary acquires inventory on credit on November 1, 2017, for 100,000 pesos that is sold on January 17, 2018, for 130,000 pesos. The subsidiary pays for the inventory on January 31, 2018. Currency exchange rates are as follows:
November 1, 2017 $0.16 = 1 peso
December 31, 2017 0.17 = 1
January 17, 2018 0.18 = 1
January 31, 2018 0.19 = 1
LO 8-2, 8-3
What amount does Newberry’s consolidated balance sheet report for this inventory at December 31, 2017?
$16,000.
$17,000.
$18,000.
$19,000.
arrow_forward
Newberry, Inc., whose reporting currency is the U.S. dollar ($), has a subsidiary in Argentina, whose functional currency also is the $. The subsidiary acquires inventory on credit on November 1, 2017, for 100,000 pesos that is sold on January 17, 2018, for 130,000 pesos. The subsidiary pays for the inventory on January 31, 2018. Currency exchange rates are as follows:
November 1, 2017 $0.16 = 1 peso
December 31, 2017 0.17 = 1
January 17, 2018 0.18 = 1
What amount does Newberry’s consolidated income statement report for cost of goods sold for the year ending December 31, 2018?
$16,000.
$17,000.
$18,000.
$19,000.
arrow_forward
Suppose that Canton Co. is a U.S.-based MNC with a foreign subsidiary in Germany, which deals in euros. The local earnings of this German subsidia
over a two-year period are shown in the following table, along with the weighted average exchange rate of the euro and the translated U.S. dollar
earnings of the subsidiary.
Period
Year 1
Year 2
Local Earnings of German
Subsidiary
(Euros, Millions)
20
20
Translated U.S. Dollar Earnings of
Weighted Average Exchange
German Subsidiary
Rate of Euro
$1.20
$1.00
(Dollars, Millions)
$24.00
$20.00
Suppose that Canton has no earnings from the U.S. and all of it's earnings come from the consolidated earnings from the German subsidiary. Also
suppose that the price of Canton stock is approximately equal to the mean P/E ratio in the industry multiplied by Canton's EPS. With these
assumptions, the
Consolidated
Earnings
(Euros, Millions)
Period
EPS (based on 10 million
shares)
Mean P/E Ratio
(Dollars,
Valuation of Canton Stock
Millions)
Price
Year 1
Year 2…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Related Questions
- Hansabenarrow_forwardEuroco is a foreign corporation that manufactures watches for sale worldwide. Euroco markets its watches in the United States through a branch sales office located in Boston. During Year 1, Euroco’s effectively connected earnings and profits are $12 million, and its U.S. net equity is $24 million at the beginning of the year, and $16 million at the end of the year. In addition, Euroco’s interest expense recorded and paid by the U.S. branch was $1,760,000 of portfolio interest paid to an unrelated foreign corporation and $800,000 of interest paid to a foreign corporation which owns 15% of the combined voting power of Euroco’s stock. During Year 2, Euroco’s effectively connected earnings and profits are $20 million, and its U.S. net equity at the end of the year is $18 million. In addition, Euroco’s U.S. branch had recorded interest paid of $640,000 paid to a U.S. corporation. Euroco is not in a treaty country. What is Euroco’s branch profits tax, if any, for Year 2? a. $6,000,000…arrow_forwardCompany X is a U.S.-based IT company with operations and earnings in a number of foreign countries. The company's profits by subsidiary, in local currency (in millions), are shown in the following table for 2019 and 2020. Net Income Japanese Subsidiary Britih Subsidiary 2019 JPY 200 GBP 100.00 2020 JPY 1,480 GBP 108.40 The average exchange rate for each year, by currency pairs, is the following. Exchange Rate USD = 1 GBP JPY = 1 USD 2019 97.57 1.5646 2020 90.88 1.6473 Use the above data, Students answer the following questions. a. What is Company X's consolidated profits in U.S. dollars in 2019 and 2020? b. If the same exchange rates are used for both years, what is the change in corporate earnings on a "constant currency" basis? c. Using the results of the constant currency analysis in part b, is it possible to separate Company X's growth in earnings between local currency earnings and foreign exchange rate impacts on a consolidated basis?arrow_forward
- McDonald’s conducts operations worldwide and is managed in three primary geographic segments: U.S., International Lead Markets (including Australia, Canada, France, Germany, and the UK), and High Growth Markets (including China, Italy, Korea, Poland, Russia, Spain, Switzerland, and the Netherlands). A hybrid geographic/corporate segment, Foundational Markets & Corporate, reports on the results of all other countries as well as any unallocated amounts. McDonald’s allocates resources to, and evaluates the performance of, its segments based on operating income. The asset totals disclosed by geography are directly managed by those regions and include accounts receivable, inventory, certain fixed assets, and certain other assets. Corporate assets primarily include cash and cash equivalents, investments, deferred tax assets, and other assets. Refer to the following geographic segment data (in millions) from the 2017 annual report of McDonald’s Corp.:arrow_forwardA multinational Corporation based in the United States of America has subsidiaries in the UK, Canada, and France. As at December 31, 2020, inter-company indebtedness were as follows:Debtors Creditors Amount CurrencyUK Canada 1,500,000 Can$UK France 600,000 Euro (€)France Canada 800,000 Can$Canada UK 94,000 Sterling (£)Canada France 400,000 Euro (€)It is the policy company’s policy to net off inter-company balances to the greatest extent possible. The central treasury department is to use the following exchange rates for these purposes:US$1 =Can$1.237/€0.8620/£0.729Required:Calculate the net payment to be made between the subsidiaries after netting off inter-company balances,by presenting the payoff in a matrix/table format.arrow_forwardAssessing Translation Exposure Assume the euro’s spot rate is presently equal to $1.00. All of the following firms are based in New York and are the same size. While these firms concentrate on business in the United States, their entire foreign operations for this quarter are provided here. Company A expects its exports to cause cash inflows of 9 million euros and imports to cause cash outflows equal to 3 million euros. Company B has a subsidiary in Portugal that expects revenue of 5 million euros and has expenses of 1 million euros. Company C expects exports to cause cash inflows of 9 million euros and imports to cause cash outflows of 3 million euros, and will repay the balance of an existing loan equal to 2 million euros. Company D expects zero exports and imports to cause cash outflows of 11 million euros. Company E will repay the balance of an existing loan equal to 9 million euros. Which of the five companies described here has the highest degree of translation exposure?arrow_forward
- Newberry, Inc., whose reporting currency is the U.S. dollar ($), has a subsidiary in Argentina, whose functional currency also is the $. The subsidiary acquires inventory on credit on November 1, 2017, for 100,000 pesos that is sold on January 17, 2018, for 130,000 pesos. The subsidiary pays for the inventory on January 31, 2018. Currency exchange rates are as follows:Cost of goods sold . . .. LCU 5,000,000Beginning inventory . . . . . . . 500,000Ending inventory . . . . . . . . . . 600,000November 1, 2017 . . . . $0.16 = 1 pesoDecember 31, 2017 . ...... . . 0.17 = 1January 17, 2018 . . . . . . . . . 0.18 = 1January 31, 2018 . . . . . . . . 0.19 = 1What amount does Newberry’s consolidated income statement report for cost of goods sold for the year ending December 31, 2018?a. $16,000.b. $17,000.c. $18,000.d. $19,000.arrow_forward! Required information Newberry, Inc., whose reporting currency is the U.S. dollar ($), has a subsidiary in Argentina, whose functional currency also is the $. The subsidiary acquires inventory on credit on November 1, 2017, for 210,000 pesos that is sold on January 17, 2018, for 243,000 pesos. The subsidiary pays for the inventory on January 31, 2018. Currency exchange rates are as follows: $0.54 =1 peso November 1, 2017 December 31, 2017 0.55 =1 January 17, 2018 January 31, 2018 0.56 =1 0.57 =1arrow_forwardABC Trading Company of Singapore purchases spices in bulk from around the world, packages them into consumer size quantities and sells them through sales affiliates in Hong Kong and the Unites States. For a recent month, the following payments matrix of inter-affiliate cash flows, stated in Singapore dollars, was forecasted. ABC Trading Company Payments Matrix (S$000) Receipts by: Singapore Hong Kong U.S. S$170,000 S$152,000 S$405,000 Disbursements by: S$322,000 Singapore 16 22 Hong Kong 80 50 Calculate, in Singapore dollars, the amount that the inter-affiliate foreign exchange transaction will be reduced by with multilateral netting. U.S. 110 44arrow_forward
- A U.S.-based multinational company has two subsidiaries, one in Mexico (local currency, Mexicanpeso, MP) and one in Japan (local currency, yen, ¥). Forecasts of business operations indicate the following short-term financing position for each subsidiary (in equivalent U.S. dollars): Mexico:$80 million excess cash to be invested (lent) Japan: $60 million funds to be raised (borrowed) Currency Item US $ MP ¥ Spot exchange rates MP11.60/US$ ¥108.25/US$ Forecast percentage change −3.00% +1.50% Interest rates Nominal Euromarket 4.00% 6.20% 2.00% Domestic 3.75% 5.90% 2.15% Effective Euromarket Domestic Euromarket and the domestic market; then indicate where the funds should be invested and raised.…arrow_forwardBalance-of-payments double-entry bookkeeping. Show how the following transactions should be recorded in the U.S. balance of payments using a double-entry accounting system: ■ Newmont Mining—a U.S. mining concern—exports $400 million worth of copper to China and is paid in the form of a payment drawn on a U.S. bank. ■ DuPont expands its plastics manufacturing capacity in its Polish plant by investing $250 million financed by a dollar bond issue in London (United Kingdom). ■ The central bank of the People’s Bank of China purchases $2.5 billion in the foreign exchange market to slow down the appreciation of the renmimbi. The dollars are invested in five-year U.S. Treasury bonds. ■ The U.S. government provides food assistance to Sudanese refugees in the amount of $25 million worth of flour.arrow_forwardNew Life is a multinational distribution company that started operating a Branch in Barbados on1 January 2023. The company’s Head Office is in the Cayman Islands and is part of a group whichearns more than USD 850 million for the year. It employed some of its staff from Barbados and imports good and services from the US, Cayman Islands, and other Caribbean countries. New Life repatriation policy is to transfer 50 % to 70% of its after-tax profits to the Cayman Islands.The company was of the view that for the first year of operation there was a window of no taxobligations. In December 2023, the company realized that their understanding was not correct and therefore engaged UWI Tax Consulting Services Limited to provide tax advisory and tax compliance services. Your Group was assigned this engagement. Required.Advice New Life of the tax matters that needs to be considered when operating in Barbadosincluding any tax benefits or incentives they may consider.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you