Question

In: Economics

To solve the following problem, it is recommended to use Excel. Table 1 provides the GDP...

To solve the following problem, it is recommended to use Excel.

Table 1 provides the GDP components expenditures and the current account balance amount at constant price 2010 (in Million US Dollars)

Table 1.UAE Expenditure, 2017 - 2019 (Million Dollars) at constant Price 2010

EXPENDITURE

2017

2018

2019*

Final Consumption Expenditure :

173792.00

179416.00

203809.00

Government Expenditure

44964.00

42732.00

48829.00

Private Expenditure        

128827.00

136684.00

154981.00

Fixed Capital Formation

71019.00

73579.00

73595.00

Change In Stocks:

49343.00

32889.00

38067.00

Gross Fixed Capital Formation

120362.00

106468.00

111662.00

Export of Goods And Services :

372072.00

414864.00

402704.00

Imports of Goods And Services :

272884.00

302726.00

313476.00

Current Account Balance at Constant Price

27474.00

40493.00

29645.00

Requirements:

  1. Complete table 2, based on in table 1 data.

Table 2

GDP at Constant Prices

Net Transfers

GDP Growth Rate

GNP

2. Complete Table 3 based the following statistics and your results in table 2 (GDP at constant price).

Table 3  United Arab Emirates Economic Variables, 2017– 2019

Economic Variable

2017

2018

2019*

Population ( in number)

9,304,000

9,367,000

9,504,000

Gross Domestic Product at Current Prices

(Nominal, in Million $)

385,606

422,215

421,142

GDP ( At Constant price calculated in table2)( Real in Million $)

GDP Deflator

Inflation rate (based on deflator)

-

C.P.I (2014 = 100)  

107.8

111.1

109

Inflation rate (based on CPI)

-

GDP Per Capita in thousands.

Annual Average Salary at current price

(Nominal in $)

20,523

21,077

21,054

Average Nominal Interest rate on credits

5.50%

5%

Average real Interest rate on credits

Average Nominal Interest rate on deposits

1.80%

1.60%

Average real Interest rate on deposits

Annual Average Salary in 2019 $

3. A worldwide recession (-4.5%) is expected during 2020 due to Covid-19. Assuming that the UAE experiences the same slowdown as the average for the world, what would be the UAE GDP in constant prices in the year 2020. (1 Mark)

4. Explain the different inflation rates obtained based on the CPI method and the inflation rates based on the GDP deflator method. (1 Mark)

.

5. (Bonus question) Illustrate graphically the GDP fluctuation during the period 2017-2020. (1 Mark)

Solutions

Expert Solution

GDP= Private Consumption + Private Investment + Government Investment + Government Spending + Exports - Imports

GNP = Private Consumption + Private Investment + Government Investment + Government Spending + Exports - Imports + Current Account balance

As Current Account Balance = (Exports - Imports )+ Net income + Net Transfers

It Implies, Net Transfers = Current Account Balance - (Exports - Imports)

GDP Growth Rate = GDP (current year ) - GDP (previous year) / GDP previous year *100

Inflation Rate (GDP deflator) = GDP deflator (current year) - GDP deflator (previous year) / GDP deflator (previous year) * 100

Inflation Rate (based on CPI) = CPI (current year) - CPI (previous year) / CPI (previous year) *100

Table 1 2017 2018 2019
Final Consumption Expenditure 173792 179416 203809
Gross Fixed Capital Formation (Investment) 120362 106468 111662
Export - Import of Goods & Services 99188 112138 89228
Gross Domestic Product at Constant Prices 2010 393342 398022 404699
Current Account Balance 27474 40493 29645
Gross National Product 420816 438515 434344
GDP Growth Rate % 1.18980429 1.677545462
Net Transfers -71645 -59583
Table 3
Economic Variable 2017 2018 2019*
Population ( in number) 9,304,000 9,367,000 9,504,000
Gross Domestic Product at Current Prices 385,606 422,215 421,142
(Nominal, in Million $)
GDP ( At Constant price calculated in table2)( Real in Million $) 393342 398022 404699
GDP Deflator 98.03 106.07 104.06
Inflation rate (based on deflator) - 8.20% -1.89%
C.P.I (2014 = 100)   107.8 111.1 109
Inflation rate (based on CPI) - 3.06% -1.89
GDP Per Capita in thousands. 41.45 45.07 44.31
Annual Average Salary at current price 20,523 21,077 21,054
(Nominal in $)
Average Nominal Interest rate on credits 5.50% 5%
Average real Interest rate on credits 2.44% 6.89%
Average Nominal Interest rate on deposits 1.80% 1.60%
Average real Interest rate on deposits -1.26% 3.49%
Annual Average Salary in 2019 $ 21451.92

Related Solutions

Use the table below to solve this problem. Level of Output and Income (GDP = DI)...
Use the table below to solve this problem. Level of Output and Income (GDP = DI) Consumption Saving APC APS MPC MPS $480 $488 $-8 1.0167 –0.0167 0.8 0.2 520 520 0 1.0000 0.0000 0.8 0.2 560 552 8 0.9857 0.0143 0.8 0.2 600 584 16 0.9733 0.0267 0.8 0.2 640 616 24 0.9625 0.0375 0.8 0.2 680 648 32 0.9529 0.0471 0.8 0.2 720 680 40 0.9444 0.0556 0.8 0.2 760 712 48 0.9368 0.0632 0.8 0.2 800 744...
Use the data below to solve the following problem using excel: 1 a) Import the data...
Use the data below to solve the following problem using excel: 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in each cell to determine the class for each vehicle. i. Class 1 if the vehicle horsepower is less than 80 HP. ii. Class 2 if the vehicle horsepower is between 81 and...
Use excel spreadsheet to solve the following problems Problem 1: A young engineer’s stating salary is...
Use excel spreadsheet to solve the following problems Problem 1: A young engineer’s stating salary is 55,000. The engineer expects annual raises of 3%. The engineer will deposit 10% of the annual salary at the end of each year in a savings account. What is the savings interest rate must be so that there will be $150, 000 in savings for a business start-up after 15 years. Your spreadsheet include at least columns for the year, the year’s salary, the...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...
(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...
#1) Use computer software packages, such as Excel, to solve this problem. The owner of Showtime...
#1) Use computer software packages, such as Excel, to solve this problem. The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Weekly Gross Revenue ($1,000s) Television Advertising ($1,000s) Newspaper Advertising ($1,000s) 105 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 93 3.0 3.3 94 3.5 2.3 94 2.5 4.2 a) Develop an estimated regression equation with the amount of television advertising as the independent variable (to...
#2) Use computer software packages, such as Excel, to solve this problem. Consider the following data...
#2) Use computer software packages, such as Excel, to solve this problem. Consider the following data for a dependent variable y and two independent variables, x1 and x2. x1 x2 y 30 12 95 46 11 108 24 18 113 51 16 178 40 6 94 52 19 175 74 8 170 36 12 117 60 14 142 77 17 211 a) If you ran a multiple regression model using both independent variable what would the p-value of the overall...
***Excel is required to solve this problem. Please use excel and show all formulas used in...
***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...
Use EXCEL to format this and solve using solve and explain. Biggest problem is once have...
Use EXCEL to format this and solve using solve and explain. Biggest problem is once have variables (which i have half done) is setting up in Excel. A farmer in the Midwst haas 1,000 acres of land on which she intends to plant corn, wheat, and soybeans. Each acre of corn costs $100 for preparation, requires 7 worker-days of labor, and yields a profit of $30. An acre of wheat costs $120 to prepare, requires 10 worker-days, and yields $40...
Use the following table solve the Benefit Cost Ratio , NPV benefits ( Please show excel...
Use the following table solve the Benefit Cost Ratio , NPV benefits ( Please show excel formulas) Discount rate 0.08 0 1 2 3 System A Costs Hardware 14000 3000 3000 3000 Software 12000 2000 2000 1000 Services 2500 2500 2500 2500 Benefits Increased productivity 15000 10000 5000 Lower Error rates 18000 5000 6000 System B Costs Hardware 15000 3000 3000 3000 Software 12000 4000 2000 5000 Services 7000 3000 3000 1000 Benefits Increased productivity 7000 10000 10000 Reduced Work...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of...
Use computer software packages, such as Minitab or Excel, to solve this problem. The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Television Newspaper Gross Revenue Advertising Advertising ($1,000s) ($1,000s) ($1,000s) 101 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 96 3.0 3.3 94 3.5 2.3 94 2.5 4.2 101 3.0 2.5 a. Develop an estimated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT