Finance Assignment<\/p>\n
SCENARIO: John Doe’s company, Big Money Inc, has consulting contracts with companies based in numerous foreign countries. These companies prefer to both be billed and to pay in their home currency, so Mr. Doe monitors exchange rates closely. His customers wire payment in their currency to his concentration account and his bank converts the funds into U.S. Dollars (USD) prior to crediting the account. Below are the invoices that are due his company in the next 10 days:<\/p>\n
Toyota (Japan) – 10 million Yen (JPY)<\/p>\n
Fiat (Italy) – 50,000 Euro (EUR)<\/p>\n
Zenn (Canada) – 25,000 Canadian Dollar (CAD)<\/p>\n
Holden (Australia) – 35,000 Australian Dollar (AUD)<\/p>\n
Mastretta (Mexico) – 2 million Peso (MXN)<\/p>\n
Kia (South Korea) – 100 million Won (KRW)<\/p>\n
Volvo (Sweden) – 300,000 Krona (SEK)<\/p>\n
Rinspeed (Switzerland) – 80,000 Franc (CHF)<\/p>\n
BAIC (Hong Kong) – 400,000 Hong Kong Dollar (HKD)<\/p>\n
PSO (Poland) – 250,000 Zloty (PLN)<\/p>\n
ASSIGNMENT: 1) Utilizing the foreign currency exchange rates (in U.S. Dollars) below, calculate the U.S. Dollar equivalent for all 10 full invoice amounts, which Mr. Doe expects to receive into his business account (assuming the rates below will be the same when payment is received). 2) Show the grand total of the receipts in U.S. Dollars.<\/p>\n
Present your work in Excel and show all formulas used. There are numerous exchange rate calculators online you can use to verify your answers.<\/p>\n
AUD-USD 0.6950<\/p>\n
CAD-USD 0.7278<\/p>\n
CHF-USD 0.9511<\/p>\n
EUR-USD 1.0526<\/p>\n
HKD-USD 0.1208<\/p>\n
JPY-USD 0.00849<\/p>\n
KRW-USD 0.0008263<\/p>\n
MXN-USD 0.0506<\/p>\n
PLN-USD 0.2527<\/p>\n
SEK-USD 0.1061<\/p>\n
Preferred language style\u00a0\u00a0 US English<\/p>\n","protected":false},"excerpt":{"rendered":"
Finance Assignment SCENARIO: John Doe’s company, Big Money Inc, has consulting contracts with companies based in numerous foreign countries. These companies prefer to both be billed and to pay in their home currency, so Mr. Doe monitors exchange rates closely. Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-425110","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/425110","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=425110"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/425110\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=425110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=425110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=425110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}