{"id":216686,"date":"2018-09-15T21:32:52","date_gmt":"2018-09-15T21:32:52","guid":{"rendered":"http:\/\/localhost\/wordpress\/index.php\/2018\/09\/15\/fin-419-week-5-individual-my-financelab-with-excel-file\/"},"modified":"2018-10-24T08:55:47","modified_gmt":"2018-10-24T08:55:47","slug":"fin-419-week-5-individual-my-financelab-with-excel-file","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/fin-419-week-5-individual-my-financelab-with-excel-file\/","title":{"rendered":"FIN 419 Week 5 Individual My FinanceLab (with Excel File)"},"content":{"rendered":"<p>With Excel File (This Tutorial contains excel file to solve question for any values)\t\u00a0\tP18-1\tForeign exchange and commodity prices.&#8221;\ufffd&#8221;\ufffdWhile traveling in the following&#8221;\ufffd\u00a0countries, you see&#8221;\ufffd\u00a0twenty-ounce plastic bottles of&#8221;\ufffd\u00a0Coca-Cola. You know the price in the United States for a Coke is\t&#8220;\ufffd$0.990.99&#8243;\ufffd,\tbut the countries have the following&#8221;\ufffd\u00a0prices:\t&#8220;\ufffd&#8221;\ufffd\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t&#8220;\ufffdCanada:&#8221;\ufffd&#8221;\ufffd\t\t\t\t\t\t\t\t\t&#8220;\ufffdC$1.54\t\t\t\t\t\t\t\t\t&#8220;\ufffdJapan:&#8221;\ufffd&#8221;\ufffd\t\t\t\t\t\t\t\t\t&#8220;\ufffd\u00a5155\t\t\t\t\t\t\t\t\t&#8220;\ufffdEngland:&#8221;\ufffd&#8221;\ufffd\t\t\t\t\t\t\t\t\t&#8220;\ufffd\u00a30.46\t\t\t\t\t\t\t\t\tEuropean&#8221;\ufffd\u00a0Union:&#8221;\ufffd&#8221;\ufffd\t\t\t\t\t\t\t\t\teuro\u20ac0.89\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\u00a0\t\t\t\t\t\t\tWhat is the implied exchange rate for U.S. dollars and these four&#8221;\ufffd\u00a0currencies?\t\u00a0\t\u00a0\tP18-3\tYou are taking a trip to six European countries. It is a&#8221;\ufffd\u00a0ten-day trip, and you are taking $ 3900\u00a0 The current direct conversion rate is\u00a0 &#8220;\ufffd$1.1723\u00a0 for euros. While in&#8221;\ufffd\u00a0Europe, you spend\u00a0 euro\u20ac3 161.323 You convert your remaining euros back to U.S. dollars upon your return. If the exchange rates remained the same over your&#8221;\ufffd\u00a0trip, how much do you have left in U.S.&#8221;\ufffd\u00a0dollars?\t\u00a0\tP18-4\t\u00a0\tCurrency exchange rates.&#8221;\ufffd&#8221;\ufffdOn the day you arrive in&#8221;\ufffd\u00a0England, the exchange rate for U.S. dollars and British pounds is &#8220;\ufffd$1:pound 0.53 You have &#8220;\ufffd$3900&#8243;\ufffd, which you convert to pounds. While you remain in England for the next two&#8221;\ufffd\u00a0weeks, the exchange rate falls to &#8220;\ufffd$1:\u00a30.490 As you leave&#8221;\ufffd\u00a0England, you convert the\u00a0 &#8220;\ufffd\u00a3126 you have left to dollars. How much did you spend in England in U.S.&#8221;\ufffd\u00a0dollars? Did the movement in the exchange rate help or hurt&#8221;\ufffd\u00a0you?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>With Excel File (This Tutorial contains excel file to solve question for any values) \u00a0 P18-1 Foreign exchange and commodity prices.&#8221;\ufffd&#8221;\ufffdWhile traveling in the following&#8221;\ufffd\u00a0countries, you see&#8221;\ufffd\u00a0twenty-ounce plastic bottles of&#8221;\ufffd\u00a0Coca-Cola. You know the price in the United States for a <a href=\"https:\/\/www.benedictsol.com\/blogs\/fin-419-week-5-individual-my-financelab-with-excel-file\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-216686","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/216686","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=216686"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/216686\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=216686"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=216686"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=216686"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}