Question: please answer using the excel, thank you. Mattel is a US-based company whose sales are roughly two thirds in dollars (Asia and the Americas) and

please answer using the excel, thank you.
please answer using the excel, thank you. Mattel is a US-based company

Mattel is a US-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, Belgium. 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.1800/ in 90 days. Advise Mattel on which hedging alternative is probably preferable if it prefers to play it safe Which alternative should Mattel choose if it is willing to take a reasonable risk and has a directional view that the euro may be appreciating vs. the dollar during the next three months? What is the break-even rate between different hedges? Prepare an Excel file that shows different hedges with concise explanation for the answers Spot rate: Credit Suisse 90-day forward quote: Barclays 90-day forward quote: Mattel's cost of capital: 90-day euro investment (deposit) rate: 90-day euro borrowing rate Three-month put option on $1.2186/E $1.2170/ $1.2210/E 9.600% 4.400% 6.400% strike price of $1.1600/: 3.40% premium euros at Mattel is a US-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, Belgium. 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.1800/ in 90 days. Advise Mattel on which hedging alternative is probably preferable if it prefers to play it safe Which alternative should Mattel choose if it is willing to take a reasonable risk and has a directional view that the euro may be appreciating vs. the dollar during the next three months? What is the break-even rate between different hedges? Prepare an Excel file that shows different hedges with concise explanation for the answers Spot rate: Credit Suisse 90-day forward quote: Barclays 90-day forward quote: Mattel's cost of capital: 90-day euro investment (deposit) rate: 90-day euro borrowing rate Three-month put option on $1.2186/E $1.2170/ $1.2210/E 9.600% 4.400% 6.400% strike price of $1.1600/: 3.40% premium euros at

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!