​Its a question on Global finance. It is a question on exchange rate analysis. I have attached the excel sheet.

SUPERIOR-PAPERS.COM essay writing company is the ideal place for homework help. If you are looking for affordable, custom-written, high-quality and non-plagiarized papers, your student life just became easier with us. Click the button below to place your order.

Order a Similar Paper Order a Different Paper

I Have attached the excel sheet. It is 6 questions.

This sheet contains monthly exchange rate.
Value of each currency is quoted in USD
1. Which currency has the highest average percentage change (in absolute term)
For each currency, you calculate percentage change for each month
Then get the average percentage change
Use absolute value of the average above.
This absolute average shows you how exchange rate changes regradless of direction (up/down)
2. Which currency has the highest standard deviation of percentage change (not in absolute term)
3. On 2010-01-01, your company has:
CAD 1,000,000
JPY 100,000,000
MXN 5,000,000
THB 100,000,000
How much all these 4 positions worth in USD
4. If your company hold these 4 positions until 2011-01-01
How much all these 4 positions worth in USD
5. If your company holds these 4 positions for the whole period we analyze (2010/01/01-2013/02/01),
Which month the total USD value of these 4 positions is highest.
put your answer in format yyyymm (201101)
Q6 Each year, create a table for average monthly percentage for each currency
Which currency has all 4 average number greater than -0.01%?

Got stuck with a writing task? We can help! Use our paper writing service to score better grades and meet your deadlines.

Get 15% discount for your first order

Order a Similar Paper Order a Different Paper