1. Download the “Gross Domestic Product (GDP), implicit price deflator of GDP and per capita
    GDP” and “Government revenue (General Revenue Account and the Funds)” from Census
    and Statistics Department, HKSAR website (https://www.censtatd.gov.hk/home.html). Hint:
    you can look for these tables in the section of “All Tables, Publications, Charts and Articles”
    under Hong Kong Statistics.
  2. Extracting the real GDP and deflator, land premium and motor vehicle taxes from the
    corresponding tables. Match the government revenue data with the annual GDP and deflator
    data with starting year of the fiscal year, that is, government revenue for the fiscal year of
    1989-90 should be matched with the GDP/deflator of 1989.
  3. Compute the real value of land premium and motor vehicle taxes. Hint: In case you are not
    familiar with the concept of deflator and how to use it to compute the real value, there are
    many online videos that you can learn from them. The following link is an example
    https://www.khanacademy.org/economics-finance-domain/ap-macroeconomics/economiciondicators-and-the-business-cycle/real-vs-nominal-gdp/v/example-calculating-real-gdp-with-adeflator
  4. Compute the percentage change of the real GDP, real land premium and real motor vehicle
    taxes.
  5. Construct two scatter plots, one for the percentage change of real GDP and percentage
    change of real land premium and one for the percentage change of real GDP and percentage
    change of real motor vehicle. Include trend lines in both charts and show their linear
    equations (to make it logical, you should set real economic growth as y and government
    revenue as x). Hint: again, google how to do this if you do not know yet.
    Question:
    Discuss and compare the cyclicality of land premium and motor vehicle taxes (i.e. the relationship
    between economic growth and land premium as well as economic growth and motor vehicles).
    *Please include three worksheets in your excel file for submission. Two for the scatter plots and
    corresponding data and one for your answer of the above question.

Sample Solution

This question has been answered.

Get Answer