You are provided with exchange rate figures in an excel file. The figures are given as the number

of various currencies per unit of the US dollar. Use the figures for the work below.

1. Use excel to calculate the price of the various currencies in dollar terms.

2. Draw the values of the various currencies as calculated in question 1 on one graph and

comment on the trends of the currencies. Be mindful in your graphing that some

currencies have more value than others.

3. Use excel to generate the appreciation/depreciation of the various currencies.

4. Generate the cumulative appreciation/depreciation of the various currencies vis--vis

with the dollar and draw them on a graph. Interpret your observations.