[ad_1]
on Money Banking, and Finance Reaction Paper and Data Analytics AssignmentYou work for a Large US agriculture company. Majority of your sales are in Japan. Your company is a major exporter for US products to Japan. You have competitors, which import their products into the US, but they are oversees. You notice that sales of your agriculture products are in-line with the US indicator for Net Exports (The equation for Net Exports is Exports-Imports). Part 1Download the Excel file Data attached to this file labeled Money and Banking Table for assignment Utilize the attached Net Export (NETEXP) and Japan / U.S. Foreign Exchange Rate (EXJPUS) Data between US and developed countries from 1999 to 2017 Convert your data into a table Directions-To convert data into a table, there are 4 ways to do it.From the Insert tab on the ribbon, there is an option called “table”From the Home tab on the ribbon, there is an option called “format as table”Click “ctrl L”,Click “ctrl T”.Make sure that there are no empty cells. Note: a quick way to make a chart in excel is by pressing “Alt F1”.Part 2 Develop a combined chart using a secondary axis in excel utilizing this data. To learn how watch this video – After completing all of the above parts, analyze the chart and your data by addressing the following questions;1.)Does the Japan/US Foreign Exchange Rate (EXJPUS) trend follow a similar trend as the Trade weighted Exchange rate graph found in your book at the top of page 266 under the Section labeled “Making the Connection”? Why or Why not?2.)What has been the trend in exchange rates of the Yen to the dollar over the past 10 years? Is there relationship between the Yen to Dollar exchange rate and US Net exports? Does the relationship display an immediate effect or a lag (lapse in time) effect between variables? 3) During periods when the Net Exports we’re significantly low (very negative), was the Dollar appreciating or depreciating against the Yen? Develop a graph in excel that indicates periods where the Net Exports were significantly low against the Exchange Rate 4.) After analyzing the trends and developing the charts, what do you think is the main macroeconomic driver that is causing foreign countries to not buy your products like before?5.) What are factors impact the exchange rate in the exchange rate? Explain in detailPart 2You work for a financial services firm and you are trying to determine if the yields on Japanese and US Bonds will impact the Yen to Dollar Exchange Rate. You decide the best way to determine the bonds impact on exchanges rates is analyze past data. Utilize the attached Interest Rates Government Bonds for Japan (INTJAP), US 3-Month Treasury Bill (USTB) and Japan / U.S. Foreign Exchange Rate (EXJPUS)Data between US and developed countries from 1999 to 2017 Convert your data into a table Directions-To convert data into a table, there are 4 ways to do it.From the Insert tab on the ribbon, there is an option called “table”From the Home tab on the ribbon, there is an option called “format as table”Click “ctrl L”,Click “ctrl T”.Make sure that there are no empty cells. Note: a quick way to make a chart in excel is by pressing “Alt F1”.Part 2 Develop a combined chart using a secondary axis in excel utilizing this data. To learn how watch this video – After completing all of the above parts, analyze the chart and your data by addressing the following questions;https://bsuonline.blackboard.com/bbcswebdav/pid-11…
[ad_2]Source link
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
