Question

In: Finance

Mattel is a U.S.-based company whose sales are roughly two-thirds in dollars (Asia and the Americas)...

Mattel is a U.S.-based company whose sales are roughly two-thirds in dollars (Asia and the Americas) and one-third in euros (Europe). In September Mattel delivers a large shipment of toys (primarily Barbies and Hot Wheels) to a major distributor in Antwerp. The receivable, €30 million, is due in 90 days, standard terms for the toy industry in Europe. Mattel’s treasury team has collected the following currency and market quotes. The company’s foreign exchange advisors believe the euro will be at about $1.4200/€ in 90 days. What are the various hedging options available to Mattel.

Assumptions

Values

90-day A/R (€)

€ 30,000,000.00

Current spot rate ($/€)

$1.4158

Credit Suisse 90-day forward rate ($/€)

$1.4172

Barclays 90-day forward rate ($/€)

$1.4195

Expected spot rate in 90 days ($/€)

$1.4200

90-day eurodollar interest rate

4.000%

90-day euro interest rate

3.885%

     Implied 90-day forward rate (calculated, $/€)

$1.4162

90-day eurodollar borrowing rate

5.000%

90-day euro borrowing rate

5.000%

3-month call option on Euro at 1.25% Premium ($/€)

                            $1.4230

Homework 5

3-month put option on Euro at 1.25% Premium ($/€)                                                                                     $1.4220

Solutions

Expert Solution

Settling the 90days A/R at Market rate i.e. remain unhedge -

Spot rate in 90 days are same a current spot rate = €3,00,00,000 * $ 1.4158 = $42,474,000

Spot rate in 90 days are same a Barclays forward rate = €3,00,00,000 * $ 1.4195 = $42,585,000

Spot rate in 90 days are same a credit suisee forward rate= €3,00,00,000 * $ 1.4172 = $42,516,000

Spot rate in 90 days are expected spot rate= €3,00,00,000 * $ 1.4200 = $42,600,000

Sell Euro forward 90 days -

Amount Recieved at credit suisee forward rate = $42,516,000.

Amount Recieved at Barclays forward rate = $42,585,000.

Money Market Hedge -

First we need to calculate how much euro borrows against 90 days A/R =

€30,000,000 =

Borrowed amount against 90day A/R = €29,629,629.630

$ current value = €29,629,629.63 * $1.4158 = $41,949,629.630

WACC carry forward factor for 90 days = 1 + 1.25%

= 1.01125.

Future Value of Money Market hedge = $41,949,629.630 * 1.01125 = $42,421,562.96.

we does not enter in forward contract because amount is greater in expected rate.

If you have any query related to answer then feel free to ask in comments. Thanks


Related Solutions

Mattel is a​ U.S.-based company whose sales are roughly​ two-thirds in dollars​ (Asia and the​ Americas)...
Mattel is a​ U.S.-based company whose sales are roughly​ two-thirds in dollars​ (Asia and the​ Americas) and​ one-third in euros​ (Europe). In​ September, Mattel delivers a large shipment of toys​ (primarily Barbies and Hot​ Wheels) to a major distributor in Antwerp. The​ receivable, €36 ​million, is due in 90​ days, standard terms for the toy industry in Europe.​ Mattel's treasury team has collected the following currency and market quotes in the table below. The​ company's foreign exchange advisers believe the...
Mattel Toys.  Mattel is a​ U.S.-based company whose sales are roughly​ two-thirds in dollars​ (Asia and...
Mattel Toys.  Mattel is a​ U.S.-based company whose sales are roughly​ two-thirds in dollars​ (Asia and the​ Americas) and​ one-third in euros​ (Europe). In​ September, Mattel delivers a large shipment of toys​ (primarily Barbies and Hot​ Wheels) to a major distributor in Antwerp. The​ receivable, €32 ​million, is due in 90​ days, standard terms for the toy industry in Europe.​ Mattel's treasury team has collected the following currency and market quotes in the popup​ window: The​ company's foreign exchange advisors...
A review of the Global equity markets, including Europe, Asia, the U.S. and the Americas. Discuss...
A review of the Global equity markets, including Europe, Asia, the U.S. and the Americas. Discuss the changes and what the financial press is claiming the causes are. Also include one stock that had a large price change and what caused what it. Here is an example: Stocks:                                    Value:                                     %Change DOW JONES (US)                24,360.14                                -0.50% S&P 500 (US)                        2,656.30                                  -0.29% FTSE 100 (UK)                     7,264.56                                  +1.4% NIKKEI 225 (JPN)                21,778.74                                +0.55% HANG SENG (HK)               30,808.38                               ...
Based on a recent study, roughly 14% of all college students in the U.S. are vegetarian...
Based on a recent study, roughly 14% of all college students in the U.S. are vegetarian or vegan. In a sample of 310 stats students at a particular university it was found that 13.8% are vegetarian or vegan. Does the data provide evidence that the proportion of students who are vegetarian or vegan in this university is lower than the national figure? 3. During the 2019 NFL regular season, the winning team of each game scored an average of 28.6...
In November 2012, a research study claimed that less than two-thirds of U.S. adults thought that...
In November 2012, a research study claimed that less than two-thirds of U.S. adults thought that President Obama would keep U.S. safe from terrorists during his second term. In a random sample of 1,009 adults, 655 stated that they believed this. Test the study's claim at 5% significance that less than two-thirds (67%) of U.S. adults thought that Obama would keep the U.S. safe from terrorists during his second term. A. Step 1: Determine the Hypotheses B. Step 2: Collect...
Mattel​ (U.S.) achieved significant sales growth in its major international regions between 2001 and 2004​. In...
Mattel​ (U.S.) achieved significant sales growth in its major international regions between 2001 and 2004​. In its filings with the United States Security and Exchange Commission​ (SEC), it reported both the amount of regional sales and the percentage change in those sales resulting from exchange rate changes. Mattel's Global Sales 2001 2002 2003 2004 Sales​ (000) Sales​ (000) Sales​ (000) Sales​ (000) Europe ​ $936,022 $1,124,887 $1,361,823 $1,415,367 Latin America 462,868 457,233 468,153 533,251 Canada 163,332 163,459 179,525 197,670 Asia...
In a recent year, about two-thirds of U.S. households purchased ground coffee. Consider the annual ground...
In a recent year, about two-thirds of U.S. households purchased ground coffee. Consider the annual ground coffee expenditures for households purchasing ground coffee, assuming that these expenditures are approximately distributed as a normal random variable with a mean of $75 and a standard deviation of $10. a. Find the probability that a household spent less than $65.00. b. Find the probability that a household spent more than $80.00. c. What proportion of the households spent between $65.00 and $80.00? d....
The chart below lists the sales in thousands of dollars based on the advertising budget for...
The chart below lists the sales in thousands of dollars based on the advertising budget for that quarter. The regression equation is Y' = 4.073 + 0.8351X. What is the correlation coefficient? Advertising ($hunderds) Sales ($thousands) 0 5 3 5.5 4 7 5 7.8 6 9 7 11 Multiple Choice 0.775 0.844 0.926 1.00
Consider a U.S.-based company that exports goods to Germany. The U.S. company expects to receive a...
Consider a U.S.-based company that exports goods to Germany. The U.S. company expects to receive a payment of €1,000,000 for the exports in one year. The U.S. company wants to hedge against a possible decline in the value of the euro that would lead to a drop in the dollar value of the euro receipt in one year. The current spot exchange rate is $1.20/€ and the one-year forward rate is $1.25/€. The annual interest rate is 5% in the...
the following are the monthly sales (in thousands of dollars) for a company in four regions...
the following are the monthly sales (in thousands of dollars) for a company in four regions of the country. North East South West 34 28 18 24 47 36 30 38 44 40 30 41 29 21 30 24 37 23 Does the data suggest that there is a difference in the mean monthly sales among the different regions?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT