ECON 340 ISU Balance of Payments & International Investment Statistics Excel Task

Xabjnoyr

Economics

Econ 340

Indiana State University

ECON

Question Description

Hello please I need help in this assignment to answering some of the questions attached down below

Unformatted Attachment Preview

ECON 340 / POSC 346 Fall 2020 Problem 8.6 Name: Consider the market for gloves in Portugal, as defined below. Draw the supply and demand schedules on the grid below. Price Qs 0 1 2 3 4 5 6 7 8 9 Qd 0 2 4 6 8 10 12 14 16 18 18 16 14 12 10 8 6 4 2 0 a. Assume that Germany and France can supply gloves to Portugal at a price of $2 and $3, respectively. With free trade, which nation exports gloves to Portugal? How many gloves does Portugal produce, consume, and import? b. Suppose Portugal levies a 100 percent nondiscriminatory tariff on its glove imports. Which nation exports gloves to Portugal? How many gloves will Portugal produce, consume, and import? c. Suppose Portugal forms a customs union with France. Determine the trade creation effect and the trade diversion effect of the customs union. What is the customs union’s overall effect on the welfare of Portugal, relative to the tariff in Part b? d. Suppose instead that Portugal forms a customs union with Germany. Is this a trade diverting or trade creating customs union? By how much does the customs union increase or decrease the welfare of Portugal, relative to the situation under the tariff in part b. ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

Attached. Please let me know if you have any questions or need revisions.

Student Name
Course ID
Instructor Name
Date:

Part 1: Exchange Rates
1- My country of analysis is Germany and Euro is its current currency.
2- Fluctuation of EURO against USD:

Fluctuation of EURO against US
Dollar
EURO $& USD

2
1.5
1
0.5
0

YEARS
Euro

USD

The data retrieved by using IMF’s historical currency tool ranging from January 1, 2009 to 3
December 3, 2020 revealed that the representative average exchange rate of Euro is 1.2378 and
average of USD is 1.The graph is showing that there is no fluctuation in USD since 2009 to 2020
whereas Euro is fluctuating against USD during this period (International Monetary Fund, 2020).

Part 2

2009
2010
2011
2012
2013
2014
2015
2016
2017
2018

Current Account
201,134.90
196,171.90
231,971.70
251,550.80
245,384.30
278,660.80
288,620.70
295,080.00
287,217.70
239,188.10

Capital Account
2,597.40
(1,615.10)
(604.30)
608.70
823.90
(4,039.40)
18.70
(2,354.10)
3,534.50
(759.10)

Financial Account
184,612.30
123,715.50
167,796.40
194,173.60
300,812.70
318,091.20
259,481.50
288,761.80
319,882.20
281,073.40

Capital + Financial
187,209.70
122,100.40
167,192.10
194,782.30
301,636.60
314,051.80
259,500.20
286,407.70
323,416.70
280,314.30

Germany Balance of Payments 2009-2018
Euro
350,000.00
300,000.00
250,000.00
200,000.00
150,000.00
100,000.00
50,000.00
2009 2010 2011 2012 2013 2014 2015 2016 2017 2018
Current Account

Capital + Financial Account

The above graph shows balance of payments ranging from year 2009 to 2018. In year
2010, there is lowest balance of current account and in 2016 the balance is highest i.e. 295,080.0.
Current account balance decreased considerably from year 2017-2018. Similarly, the combining
balance of capital plus financial account is lowest in 2010 i.e. 122,100.40 and the highest balance
in 2017. Capital plus financial account decreased considerably from year 2017-2018.

References
International Monetary Fund (2020). IMF Exchange Rates. Retrieved December 3, 2020
from
https://www.imf.org/external/np/fin/ert/GUI/Pages/Report.aspx?CT=%27DEU%27,%27USA%2
7&EX=REP&P=DateRange&Fr=633663648000000000&To=637425504000000000&CF=Com
pressed &CUF=Period&DS=Ascending&DT=Blank
International Monetary Fund (2020). Balance of Payments and International Investment
Position Statistics. Retrieved December 3, 2020 from http://data.imf.org/?sk=7A51304B-642640C0-83DD-CA473CA1FD52&ss=1409773422141

I also have excel file of Euro exchange rates I am sending you this file but do not send it to your professor because he do not need excel file. It is for your information

Attached. Please let me know if you have any questions or need revisions.

Representative rates for the period January 01, 2009 - December 03, 2020

Date
2-Jan-2009
5-Jan-2009
6-Jan-2009
7-Jan-2009
8-Jan-2009
9-Jan-2009
12-Jan-2009
13-Jan-2009
14-Jan-2009
15-Jan-2009
16-Jan-2009
19-Jan-2009
20-Jan-2009
21-Jan-2009
22-Jan-2009
23-Jan-2009
26-Jan-2009
27-Jan-2009
28-Jan-2009
29-Jan-2009
30-Jan-2009
2-Feb-2009
3-Feb-2009
4-Feb-2009
5-Feb-2009
6-Feb-2009
9-Feb-2009
10-Feb-2009
11-Feb-2009
12-Feb-2009
13-Feb-2009
16-Feb-2009
17-Feb-2009
18-Feb-2009
19-Feb-2009
20-Feb-2009
23-Feb-2009
24-Feb-2009
25-Feb-2009
26-Feb-2009
27-Feb-2009
2-Mar-2009
3-Mar-2009
4-Mar-2009
5-Mar-2009
6-Mar-2009
9-Mar-2009

U.S.
Euro
dollar
(EUR)
(USD)
1,3866
1,3582
1,3332
1,3595
1,3617
1,3684
1,3394
1,3262
1,3173
1,3085
1,327
1,3182
1,293
1,291
1,2984
1,2795
1,299
1,3174
1,326
1,3111
1,2816
1,276
1,2849
1,2818
1,2829
1,2796
1,3008
1,2967
1,2938
1,2833
1,2823
1,2765
1,2634
1,2596
1,2705
1,2591
1,2798
1,2763
1,2795
1,2782
1,2644
1,2596
1,2615
1,2555
1,2555
1,2658
1,2565

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

10-Mar-2009
11-Mar-2009
12-Mar-2009
13-Mar-2009
16-Mar-2009
17-Mar-2009
18-Mar-2009
19-Mar-2009
20-Mar-2009
23-Mar-2009
24-Mar-2009
25-Mar-2009
26-Mar-2009
27-Mar-2009
30-Mar-2009
31-Mar-2009
1-Apr-2009
2-Apr-2009
3-Apr-2009
6-Apr-2009
7-Apr-2009
8-Apr-2009
9-Apr-2009
10-Apr-2009
13-Apr-2009
14-Apr-2009
15-Apr-2009
16-Apr-2009
17-Apr-2009
20-Apr-2009
21-Apr-2009
22-Apr-2009
23-Apr-2009
24-Apr-2009
27-Apr-2009
28-Apr-2009
29-Apr-2009
30-Apr-2009
1-May-2009
4-May-2009
5-May-2009
6-May-2009
7-May-2009
8-May-2009
11-May-2009
12-May-2009
13-May-2009
14-May-2009
15-May-2009
18-May-2009
19-May-2009
20-May-2009

1,2783
1,2786
1,2782
1,2905
1,3042
1,2942
1,313
1,3671
1,3549
1,3558
1,3507
1,3494
1,3607
1,3295
1,3193
1,3308
1,3246
1,3392
1,3425
1,3496
1,3255
1,3231
1,3273

1,3276
1,3173
1,3196
1,3058
1,2966
1,2932
1,2947
1,305
1,3232
1,3125
1,2992
1,3266
1,3275
1,3223
1,3403
1,3322
1,3363
1,3425
1,3574
1,3683
1,3623
1,3563
1,3518
1,3494
1,3612
1,369

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

21-May-2009
22-May-2009
25-May-2009
26-May-2009
27-May-2009
28-May-2009
29-May-2009
1-Jun-2009
2-Jun-2009
3-Jun-2009
4-Jun-2009
5-Jun-2009
8-Jun-2009
9-Jun-2009
10-Jun-2009
11-Jun-2009
12-Jun-2009
15-Jun-2009
16-Jun-2009
17-Jun-2009
18-Jun-2009
19-Jun-2009
22-Jun-2009
23-Jun-2009
24-Jun-2009
25-Jun-2009
26-Jun-2009
29-Jun-2009
30-Jun-2009
1-Jul-2009
2-Jul-2009
3-Jul-2009
6-Jul-2009
7-Jul-2009
8-Jul-2009
9-Jul-2009
10-Jul-2009
13-Jul-2009
14-Jul-2009
15-Jul-2009
16-Jul-2009
17-Jul-2009
20-Jul-2009
21-Jul-2009
22-Jul-2009
23-Jul-2009
24-Jul-2009
27-Jul-2009
28-Jul-2009
29-Jul-2009
30-Jul-2009
31-Jul-2009

1,3771
1,3972
1,401
1,3908
1,3901
1,3856
1,4098
1,422
1,4238
1,4207
1,4095
1,4177
1,3866
1,3959
1,4102
1,3969
1,4004
1,385
1,389
1,384
1,392
1,3932
1,3858
1,3978
1,4029
1,394
1,4096
1,4058
1,4134
1,4096
1,4049
1,4009
1,3897
1,4019
1,3901
1,399
1,3901
1,3975
1,3991
1,4089
1,413
1,409
1,4217
1,4223
1,4191
1,4229
1,4227
1,4269
1,4229
1,4104
1,4053
1,4138

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

3-Aug-2009
4-Aug-2009
5-Aug-2009
6-Aug-2009
7-Aug-2009
10-Aug-2009
11-Aug-2009
12-Aug-2009
13-Aug-2009
14-Aug-2009
17-Aug-2009
18-Aug-2009
19-Aug-2009
20-Aug-2009
21-Aug-2009
24-Aug-2009
25-Aug-2009
26-Aug-2009
27-Aug-2009
28-Aug-2009
31-Aug-2009
1-Sep-2009
2-Sep-2009
3-Sep-2009
4-Sep-2009
7-Sep-2009
8-Sep-2009
9-Sep-2009
10-Sep-2009
11-Sep-2009
14-Sep-2009
15-Sep-2009
16-Sep-2009
17-Sep-2009
18-Sep-2009
21-Sep-2009
22-Sep-2009
23-Sep-2009
24-Sep-2009
25-Sep-2009
28-Sep-2009
29-Sep-2009
30-Sep-2009
1-Oct-2009
2-Oct-2009
5-Oct-2009
6-Oct-2009
7-Oct-2009
8-Oct-2009
9-Oct-2009
12-Oct-2009
13-Oct-2009

1,4303
1,4384
1,441
1,437
1,4357
1,4202
1,4166
1,417
1,4293
1,4294
1,4072
1,4101
1,4112
1,4243
1,433
1,4323
1,4324
1,427
1,4268
1,4364
1,4272
1,4314
1,422
1,4335
1,4262
1,433
1,4473
1,4522
1,4545
1,4594
1,4561
1,4611
1,4671
1,4712
1,4705
1,4658
1,478
1,4783
1,4768
1,467
1,465
1,4549
1,4643
1,4539
1,4537
1,4616
1,4722
1,4694
1,4763
1,475
1,4765
1,4864

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

14-Oct-2009
15-Oct-2009
16-Oct-2009
19-Oct-2009
20-Oct-2009
21-Oct-2009
22-Oct-2009
23-Oct-2009
26-Oct-2009
27-Oct-2009
28-Oct-2009
29-Oct-2009
30-Oct-2009
2-Nov-2009
3-Nov-2009
4-Nov-2009
5-Nov-2009
6-Nov-2009
9-Nov-2009
10-Nov-2009
11-Nov-2009
12-Nov-2009
13-Nov-2009
16-Nov-2009
17-Nov-2009
18-Nov-2009
19-Nov-2009
20-Nov-2009
23-Nov-2009
24-Nov-2009
25-Nov-2009
26-Nov-2009
27-Nov-2009
30-Nov-2009
1-Dec-2009
2-Dec-2009
3-Dec-2009
4-Dec-2009
7-Dec-2009
8-Dec-2009
9-Dec-2009
10-Dec-2009
11-Dec-2009
14-Dec-2009
15-Dec-2009
16-Dec-2009
17-Dec-2009
18-Dec-2009
21-Dec-2009
22-Dec-2009
23-Dec-2009
24-Dec-2009

1,4881
1,4864
1,4869
1,4918
1,4971
1,4921
1,5
1,502
1,5019
1,4874
1,4785
1,4788
1,48
1,4772
1,4658
1,4761
1,4867
1,4862
1,4984
1,4966
1,5037
1,4922
1,4868
1,4965
1,4875
1,4957
1,4863
1,4815
1,4968
1,4969
1,5083
1,5071
1,4918
1,5023
1,5074
1,509
1,512
1,5068
1,4787
1,4774
1,4768
1,473
1,4757
1,4647
1,4541
1,456
1,4343
1,4337
1,4368
1,4279
1,4276
1,4398

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

28-Dec-2009
29-Dec-2009
30-Dec-2009
31-Dec-2009
4-Jan-2010
5-Jan-2010
6-Jan-2010
7-Jan-2010
8-Jan-2010
11-Jan-2010
12-Jan-2010
13-Jan-2010
14-Jan-2010
15-Jan-2010
18-Jan-2010
19-Jan-2010
20-Jan-2010
21-Jan-2010
22-Jan-2010
25-Jan-2010
26-Jan-2010
27-Jan-2010
28-Jan-2010
29-Jan-2010
1-Feb-2010
2-Feb-2010
3-Feb-2010
4-Feb-2010
5-Feb-2010
8-Feb-2010
9-Feb-2010
10-Feb-2010
11-Feb-2010
12-Feb-2010
15-Feb-2010
16-Feb-2010
17-Feb-2010
18-Feb-2010
19-Feb-2010
22-Feb-2010
23-Feb-2010
24-Feb-2010
25-Feb-2010
26-Feb-2010
1-Mar-2010
2-Mar-2010
3-Mar-2010
4-Mar-2010
5-Mar-2010
8-Mar-2010
9-Mar-2010
10-Mar-2010

1,4405
1,4433
1,4338
1,4406
1,4389
1,4442
1,435
1,4304
1,4273
1,4528
1,4481
1,4563
1,4486
1,4374
1,4369
1,4279
1,4132
1,4064
1,4135
1,4151
1,4085
1,4072
1,3999
1,3966
1,3913
1,3937
1,3984
1,3847
1,3691
1,3675
1,376
1,374
1,3718
1,3572
1,3607
1,3649
1,3726
1,3567
1,3519
1,3626
1,3577
1,3547
1,3489
1,357
1,3525
1,3548
1,3641
1,3668
1,3582
1,3662
1,3557
1,361

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

11-Mar-2010
12-Mar-2010
15-Mar-2010
16-Mar-2010
17-Mar-2010
18-Mar-2010
19-Mar-2010
22-Mar-2010
23-Mar-2010
24-Mar-2010
25-Mar-2010
26-Mar-2010
29-Mar-2010
30-Mar-2010
31-Mar-2010
1-Apr-2010
2-Apr-2010
5-Apr-2010
6-Apr-2010
7-Apr-2010
8-Apr-2010
9-Apr-2010
12-Apr-2010
13-Apr-2010
14-Apr-2010
15-Apr-2010
16-Apr-2010
19-Apr-2010
20-Apr-2010
21-Apr-2010
22-Apr-2010
23-Apr-2010
26-Apr-2010
27-Apr-2010
28-Apr-2010
29-Apr-2010
30-Apr-2010
3-May-2010
4-May-2010
5-May-2010
6-May-2010
7-May-2010
10-May-2010
11-May-2010
12-May-2010
13-May-2010
14-May-2010
17-May-2010
18-May-2010
19-May-2010
20-May-2010
21-May-2010

1,3657
1,3765
1,3705
1,3723
1,3756
1,366
1,3548
1,3471
1,3519
1,3338
1,3356
1,3353
1,3471
1,3482
1,3479
1,3468

1,3396
1,334
1,3296
1,3384
1,3585
1,3583
1,3615
1,3544
1,3535
1,3432
1,3486
1,3373
1,3339
1,3311
1,3321
1,329
1,3245
1,3256
1,3315
1,3238
1,3089
1,2924
1,2727
1,2746
1,2969
1,2698
1,2686
1,2587
1,2492
1,2349
1,2428
1,227
1,2334
1,2497

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

24-May-2010
25-May-2010
26-May-2010
27-May-2010
28-May-2010
1-Jun-2010
2-Jun-2010
3-Jun-2010
4-Jun-2010
7-Jun-2010
8-Jun-2010
9-Jun-2010
10-Jun-2010
11-Jun-2010
14-Jun-2010
15-Jun-2010
16-Jun-2010
17-Jun-2010
18-Jun-2010
21-Jun-2010
22-Jun-2010
23-Jun-2010
24-Jun-2010
25-Jun-2010
28-Jun-2010
29-Jun-2010
30-Jun-2010
1-Jul-2010
2-Jul-2010
5-Jul-2010
6-Jul-2010
7-Jul-2010
8-Jul-2010
9-Jul-2010
12-Jul-2010
13-Jul-2010
14-Jul-2010
15-Jul-2010
16-Jul-2010
19-Jul-2010
20-Jul-2010
21-Jul-2010
22-Jul-2010
23-Jul-2010
26-Jul-2010
27-Jul-2010
28-Jul-2010
29-Jul-2010
30-Jul-2010
2-Aug-2010
3-Aug-2010
4-Aug-2010

1,236
1,2223
1,2309
1,2255
1,2384
1,2155
1,2218
1,2268
1,206
1,1959
1,1942
1,201
1,2045
1,2127
1,2249
1,2258
1,2277
1,2363
1,2372
1,2391
1,2258
1,2271
1,2262
1,2294
1,2339
1,2198
1,2271
1,2328
1,2548
1,2579
1,2567
1,266
1,2637
1,2572
1,2569
1,2703
1,2828
1,3
1,2957
1,2844
1,2817
1,285
1,2897
1,2931
1,3033
1,2992
1,3069
1,3028
1,3073
1,3221
1,3206

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

5-Aug-2010
6-Aug-2010
9-Aug-2010
10-Aug-2010
11-Aug-2010
12-Aug-2010
13-Aug-2010
16-Aug-2010
17-Aug-2010
18-Aug-2010
19-Aug-2010
20-Aug-2010
23-Aug-2010
24-Aug-2010
25-Aug-2010
26-Aug-2010
27-Aug-2010
30-Aug-2010
31-Aug-2010
1-Sep-2010
2-Sep-2010
3-Sep-2010
7-Sep-2010
8-Sep-2010
9-Sep-2010
10-Sep-2010
13-Sep-2010
14-Sep-2010
15-Sep-2010
16-Sep-2010
17-Sep-2010
20-Sep-2010
21-Sep-2010
22-Sep-2010
23-Sep-2010
24-Sep-2010
27-Sep-2010
28-Sep-2010
29-Sep-2010
30-Sep-2010
1-Oct-2010
4-Oct-2010
5-Oct-2010
6-Oct-2010
7-Oct-2010
8-Oct-2010
12-Oct-2010
13-Oct-2010
14-Oct-2010
15-Oct-2010
18-Oct-2010
19-Oct-2010

1,3184
1,3176
1,3253
1,3133
1,3016
1,279
1,2799
1,282
1,286
1,288
1,2836
1,2711
1,2704
1,2611
1,2613
1,2693
1,2713
1,27
1,268
1,28
1,2818
1,2834
1,2744
1,2697
1,2715
1,2725
1,2801
1,285
1,2989
1,3078
1,306
1,3074
1,312
1,3364
1,3323
1,3412
1,3477
1,346
1,3611
1,3648
1,3726
1,3705
1,378
1,3856
1,397
1,3874
1,3833
1,3958
1,4101
1,4089
1,3896
1,3859

1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1

20-Oct-2010
21-Oct-2010
22-Oct-2010
25-Oct-2010
26-Oct-2010
27-Oct-2010
28-Oct-2010
29-Oct-2010
1-Nov-2010
2-Nov-2010
3-Nov-2010
4-Nov-2010
5-Nov-2010
8-Nov-2010
9-Nov-2010
10-Nov-2010
11-Nov-2010
12-Nov-2010
15-Nov-2010
16-Nov-2010
17-Nov-2010
18-Nov-2010
19-Nov-2010
22-Nov-2010
23-Nov-2010
24-Nov-2010
26-Nov-2010
29-Nov-2010
30-Nov-2010
1-Dec-2010
2-Dec-2010
3-Dec-2010
6-Dec-2010
7-Dec-2010
8-Dec-2010
9-Dec-2010
10-Dec-2010
13-Dec-2010
14-Dec-2010
15-Dec-2010
16-Dec-2010
17-Dec-2010
20-Dec-2010
21-Dec-2010
22-Dec-2010
23-Dec-2010
27-Dec-2010
28-Dec-2010
29-Dec-2010
30-Dec-2010
3-Jan-2011
4-Jan-2011

1,3861
1,4016
1,3934
1,4031
1,3912
1,3803
1,3857
1,3857
1,3926
1,4018
1,4014
1,4244
1,4084
1,3917
1,3945
1,377
1,37
...

uvanabherra (2722)
New York University

Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags