Spreadsheet on international finance | Business & Finance homework help

Don't use plagiarized sources. Get Your Assignment on
Spreadsheet on international finance | Business & Finance homework help
Just from $13/Page
Order Now

Spreadsheet Assignment on International Finance


Yohe Telecommunications is a multinational corporation that produces and distributes telecommunications technology. Although its corporate headquarters are located in Maitland, Florida, Yohe usually must buy its raw materials in several different foreign countries using several different foreign currencies. The matter is further complicated because Yohe usually sells its products in other foreign countries. One product in particular, the SY-20 radio transmitter, draws its principal components, Component X, Component Y, and Component Z, from Switzerland, France, and England, respectively. Specifically, Component X costs 165 Swiss francs, Component Y costs 20 Euros, and Component Z costs 105 British pounds. The largest market for the SY-20 is in Japan, where it sells for 38,000 Japanese yen. Naturally, Yohe is intimately concerned with economic conditions that could adversely affect dollar exchange rates. You will find the three accompanying tables useful for this problem.


a.How much, in dollars, does it cost for Yohe to produce the SY-20? What is the dollar sale price of the SY-20?


b.What is the dollar profit that Yohe makes on the sale of the SY-20? 


c. If the U.S. dollar were to weaken by 10 percent against all foreign currencies, what would be the dollar profit for the SY-20?


d.If the U.S. dollar were to weaken by 10 percent only against the Japanese yen and remained constant relative to all other foreign currencies, what would be the dollar profit for the SY-20?


e.Assuming the Interest Rate Parity holds, calculate the rate of return on 90-day securities in Switzerland, if the rate of return on comparable 90-day securities in the U.S. is 4.9 percent. 


f.Assuming that purchasing power parity (PPP) holds, what would be the sale price of the SY-20 if it were sold in England rather than in Japan?


g.Attach a digital copy of your spreadsheet to your report. 





Recent Blog Posts

No recent articles to show.

Other Blog Posts

What are the key elements of an essay

You may clearly understand what an essay is and have had the experience of writing a number. However, it is […]

Feb 25th, 2022

How to write a research paper fast

The day inevitably comes; you need to submit your assignment. You have been procrastinating on writing your paper until the […]

Feb 24th, 2022

220+ best humanities research paper topics

Choosing a paper topic can be a daunting task for any assignment. A student may face agony trying to come […]

Feb 24th, 2022

How to write a media analysis essay

The media is an integral part of modern society. Think of what would happen to the world if there were […]

Feb 23rd, 2022

Great tricks on how to write a hypothesis in 2022

A hypothesis is a statement that can be proven by scientific research. It proves the theory of action and reaction, […]

Feb 22nd, 2022

How to get better at math

Math is not difficult. However, it is complex and tough compared to other subjects and requires a little bit more […]

Feb 22nd, 2022