Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

IT

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.)

Make on excel

Part One

  1. In the table below are the euro-dollar exchange rates for the first two weeks of October 2019. The data shows dollars per euro. Draw a line chart that shows the evolution of the euro relative to the dollar. Add a trendline.

USD

11/10/2019

1,1043

10/10/2019

1,1030

09/10/2019

1,0981

08/10/2019

1,0986

07/10/2019

1,0993

04/10/2019

1,0979

03/10/2019

1,0951

02/10/2019

1,0925

01/10/2019

1,0898

30/09/2019

1,0889

2. Your company manufactures and exports electrical generators. The table below shows a series of generators and their price in Euros. Create the table in excel. Insert the dollar rate on the 30/09/2019 in the cell below Dollar rate. Create a formula that allows you to see all the prices of the generators in dollars; if the dollar should change then updating the dollar rate cell updates all the prices in the column. Repeat the procedure for the rate on 11/10/2019.

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

image text in transcribed

Part Two

  1. Create a memo in Word. Comment on the trend shown in question 1 above. Is the euro rising or falling?
  2. If your businesss products are priced in euros, and assuming the trend shown in question 1 continues, what would be the consequences for your companys exports?

Date Date Dollar rate: Dollar rate: Price in dollars Difference Generator Price in Euros Price in dollars 275 KVA 46890 385 KVA 59890 550 KVA 89990 660 KVA 106790 770 KVA 119790 825 KVA 186900 935 KVA 148890 Date Date Dollar rate: Dollar rate: Price in dollars Difference Generator Price in Euros Price in dollars 275 KVA 46890 385 KVA 59890 550 KVA 89990 660 KVA 106790 770 KVA 119790 825 KVA 186900 935 KVA 148890

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Financial Accounting Concepts Paperback By Edmonds Thomas P O

Authors: Thomas P. Edmonds, Christopher Edmonds, Mark A. Edmonds, Jennifer Edmonds, Philip R. Olds

11th Edition

9781264266234, 1264266235

More Books

Students also viewed these Accounting questions