The assignment is consisted of 3 computational questions that must be solved using spreadsheet and 2 written (open) questions that are related to the computational questions but evaluate application of theory.

finance

Description

Task

The assignment is consisted of 3 computational questions that must be solved using spreadsheet and 2 written (open) questions that are related to the computational questions but evaluate application of theory.

·         In the computational part, you are asked to apply the calculations and knowledge of spreadsheets studied in class to the scenarios provided.

·         In the written part, make reference to the theory studied in class and provide examples to support your points.

You must upload the written answers and the spreadsheet via Turn-it-in. Save your documents with the filename: Axxxxxxx (where xxxxxxx is your last name). (Note: You should save two files. One should be an EXCEL document and the other should be a Word document.)

Questions: (Each question is 20% of the assignment)

Part One

1.    In the table below are the euro-dollar exchange rates for the first ten days of August 2018. The data shows dollar per euro. Draw a line chart that shows the evolution of the euro relative to the dollar. Add a trendline.                                                                                                                                                 

                                                                                                                                                               

                                                USD                                                                                                      

                10/08/2018         1,0698                                                                                                                  

                09/08/2018         1,0886                                                                                                                  

                08/08/2018         1,0688                                                                                                                  

                07/08/2018         1,0778                                                                                                                  

                06/08/2018         1,0643                                                                                                                  

                05/08/2018         1,0848                                                                                                                  

                04/08/2018         1,0712                                                                                                                  

                03/08/2018         1,0457                                                                                                                  

                02/08/2018         1,0390                                                                                                                  

                01/08/2018         1,0149                                                                                                                  

                                                                                                                                                               

2.    Your company manufactures and exports industrial machinery. The table below shows a series of models and their price in Euros. Create the table in excel. Insert the dollar rate on the 01/08/2018 in the cell below ´´Dollar rate´´. Create a formula that allows you to see all the prices of the models in dollars; if the dollar rate changes, the dollar rate cell updates all the prices in the column. Repeat the procedure for the rate on 10/08/2018.                                                                                                                                                               

                                                                                                                                                               

3.      In the column marked difference, show the difference in dollars between the two dates.                                                                                                                                                 

 

 

Date

Date

 

 

 

 

 

 

 

 

Dollar rate

Dollar rate

 

 

 

 

 

 

Model

Price in euros

Price in dollars

Price in dollars

Difference

250 GRM

31000

 

 

 

650 GRM

55600

 

 

 

325 CFV

68900

 

 

 

400 GRM

104600

 

 

 

525 VRG

154200

 

 

 

475 CFV

192400

 

 

 

750 MTY

201400

 

 

 

                                                                                                                                                               

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?                                                                                                                                                               

                                                                                                                                                               

5.    Most of your exports to the US belong to the model 475 CFV. The experience shows that, if the price of this product rises over 193000 dollars, the exported units will be reduced. If 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?                                 


Related Questions in finance category