Part One 1

Part One
1. Inthe table below are the euro-dollar exchange rates for the first ten days of November 2020. The data
shows dollar per euro. Draw a line chart that shows the evolution of the euro relative to the dollar. Add a
trendline. (See the picture as reference)
USD

10/11/2020 1,0385 Euro to Dollar Evolution

09/11/2020 1,0443 106

08/11/2020 11,0262 1 oe

07/11/2020 1,0481 =| Vo Lo

06/11/2020 —1,0385 . t-

05/11/2020 1,0566 _., Co

04/11/2020 1,0384 :

03/11/2020 —1,0301 “

02/11/2020  1,0139 . :

01/11/2020 1,0019 2s tae gigas) yas ayaa as sou

2. Your company manufactures and exports construction cranes. The table below shows a series of models
and their price in Euros.

e Create the table in excel.

e Insert the dollar rate on the 01/11/2020 in the cell below ‘’Dollar rate’’.

e Create a formula that allows you to see all the prices of the models in dollars.

e If the dollar rate changes, the dollar rate cell updates all the prices in the column.

® Repeat the procedure for the rate on 10/11/2020.

Model ae MR Lge]

3. Your table should look like the one below after the previous steps. Now, in the column marked
difference, show the difference in dollars between the two dates. Your table should look like the one
below.

Ea Ea
Dollar rate Dollar rate
Model dee MULL Priceindollars Priceindollars Difference

Part two
4. Create a memo in Word. Comment on the trend shown in question 1 above.
During the first 5 days, was the euro rising or falling? And during those 10 days? Write at least two
paragraphs giving your insights about the situation regarding the crane prices due to currency
exchange.
5. Most of your exports to the US belong to the model 400 RTM. The experience shows that, if the price of
this product rises over 78.0008, the exported units will be reduced.
This product is priced in euros, and assuming the trend shown in question 1 continues, what would be
the consequences for your company’s exports?
Reflect on this in your memo.