Question

EXCEL FORMAT ONLY, PLEASE AND THANK YOU Suppose a BMW 528i is priced at $68,750 in...

EXCEL FORMAT ONLY, PLEASE AND THANK YOU

Suppose a BMW 528i is priced at $68,750 in New York and €50,267 in Berlin. In which place is the car more expensive if the spot rate is $1.3677/€?

[EXCEL]Forward rate: If the spot rate was $1.0413/C$ and the 90-day forward rate was $1.0507/C$, how much more (in U.S. dollars) would you receive by selling C$1,000,000 at the forward rate than at the spot rate?

8. [EXCEL]Forward rate: Crane, Inc., sold equipment to an Irish firm and will receive €1,319,405 in 30 days. If the company entered a forward contract to sell at the 30-day forward rate of $1.3012/€, what is the dollar revenue received?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
EXCEL FORMAT ONLY Suppose a BMW 528i is priced at $68,750 in New York and €50,267...
EXCEL FORMAT ONLY Suppose a BMW 528i is priced at $68,750 in New York and €50,267 in Berlin. In which place is the car more expensive if the spot rate is $1.3677/€? [EXCEL]Forward rate: If the spot rate was $1.0413/C$ and the 90-day forward rate was $1.0507/C$, how much more (in U.S. dollars) would you receive by selling C$1,000,000 at the forward rate than at the spot rate? 8. [EXCEL]Forward rate: Crane, Inc., sold equipment to an Irish firm and...
Please no excel usage A Canadian company with operations in Germany expects to purchase 20 million...
Please no excel usage A Canadian company with operations in Germany expects to purchase 20 million euros worth of raw materials in three months. The company is considering using a three month forward contract on 20 million euros to mitigate exchange rate risk. The forward rate is C$1.25/euro. Assume that the spot rate at expiration is C$1.30/euro. What should the company do to hedge its exchange rate risk? A) Wait three months and buy 20 million euros in the foreign...
Can you please show work in Excel terms? New York City is the most expensive city...
Can you please show work in Excel terms? New York City is the most expensive city in the United States for lodging. The mean hotel room rate is $203 per night (USA Today, April 30, 2012). Assume that room rates are normally distributed with a standard deviation of $53. Use Table 1 in Appendix B. a. What is the probability that a hotel room costs $225 or more per night (to 4 decimals)? b. What is the probability that a...
ONLY COMPLETE USING EXCEL SHOWING WORK - THANK YOU! You are considering the purchase of a...
ONLY COMPLETE USING EXCEL SHOWING WORK - THANK YOU! You are considering the purchase of a quadruplex apartment building. Effective gross income during the first year of operations is expected to be $33,600 ($700 per month per unit). First-year operating expenses are expected to be $13,440 (at 40 percent of EGI). Ignore capital expenditures. The purchase price of the quadruplex is $200,000. The acquisition will be financed with $60,000 in equity and a $140,000 standard fixed-rate mortgage. The interest rate...
Please show all your work in Excel or written out. No graphing calculators thank you. At...
Please show all your work in Excel or written out. No graphing calculators thank you. At a large farm, the weights of all newborn pigs are recorded. Over the last 10 years, the daily rate has been in excess of 50 births per day. The mean and the sigma are listed below. Mu = 7.125 Sigma = 0.125 A.) What is the probability a baby pig born today will weigh 8 pounds or more? B.) What is the probability that...
Please answer only if you are sure about the solution. On 1 Nov 2016, Burwood Limited...
Please answer only if you are sure about the solution. On 1 Nov 2016, Burwood Limited based in Australia ordered inventories to the value of US $ 3000000 on FOB destination terms. The goods are shipped on 1 April 2017 and are paid for on 30 June 2017. Burwood Limited also entered into a forward exchange contract of  US $ 3000000 on 1 Nov 2016 with NYC Bank in which NYC Bank agrees to supply Burwood Limited with US $ 3000000...
21-) Given the following exchange rates, what arbitrage profit is available if you have $1 million?...
21-) Given the following exchange rates, what arbitrage profit is available if you have $1 million? ¥129.87/$, €1.1226/$, ¥115.74/€ Select one: a. $259,652 b. $460 c. -$460 d. $878 30-) The current U.S. dollar-yen spot rate is 125¥/$. If the 90-day forward exchange rate is 127 ¥/$ then the yen is selling at a per annum forward ________ of ________. Select one: a. premium; 1.57% b. discount; 6.30% c. premium; 6.30% d. discount; 1.57% 33-) Sarah bought a 3-month British...
Question 1 You are responsible for managing a US toy manufacturer. Recently your market share has...
Question 1 You are responsible for managing a US toy manufacturer. Recently your market share has dropped dramatically due to strong pricing competition from a China toy manufacturer. What could the US toy manufacturer do to offset this? What kind of help could the US toy manufacturer seek? Question 2 (4 points) The Canadian dollar per U.S. Dollar spot rate today, 3/1/2017 is 1.3500 / 1.3525 Canadian dollars per U.S. Dollar. The spot rate on 2/1/2017 was 1.3435 / 1.3450...
Section 2 Calculations. 5pt each, 50 pts total. Show your work! Suppose, the spot exchange rate...
Section 2 Calculations. 5pt each, 50 pts total. Show your work! Suppose, the spot exchange rate is Euro €1.00 = $1.50 and the rates of inflation expected to prevail for the next year in the U.S. is 2% and 1% in the euro zone. Under the PPP, what is the one-year forward rate, €1 = $_________, that should prevail, round to 4 decimal places? Yesterday, you entered into a futures contract to buy Euro 62,500 at $1.5500 per Euro. Your...
Excel retirement problem:  You just got your first job and plan to start saving for...
Excel retirement problem:  You just got your first job and plan to start saving for retirement by investing with each monthly paycheck.  You plan to retire in 45 years.  In 50 years, you want to give your daughter a gift of $1,000,000.  You will receive an inheritance from a rich great-uncle of $250,000 in 20 years.  You think you will want $150,000 every year when you retire, starting the day you retire. You plan to...