Macroeconomic Duplicate Excel Paper

From the following website, duplicate the three charts provided using EXCEL.Attach this page to the front of your three charts.

Answer the questions asked in the blank spaces provided.

https://news.research.stlouisfed.org/2020/01/teaching-fiscal-policybring-fred-into-the-classroomjanuary-2020/

Quiz Yourself on the Different Tools of Fiscal Policy

  1. Government Revenue Sources
  • Using Excel, duplicate the FRED graph on sources of government revenue
  • Use this Title: Chart 1 – Sources of Government Tax Revenue
  • Provide your name below the title.

Q1. As of the last available observation, which is the source of the largest volume of tax revenue? _______________

Q2. When were tax receipts on corporate income the lowest among the four sources of tax revenue plotted? _______________Q.3 What percentage of total tax receipts do taxes from the rest of the world represent? ________________

  1. Categories of Government Spending
  • Using Excel, duplicate the FRED graph on government spending categories.
  • Use this Title: Chart 2 – Government Spending Categories
  • Provide your name below the title.

Q1. As of the last available observation, which is the largest category of government spending? __________________

Q2. When was government consumption the highest among the three categories of government spending plotted?________________

Q3. In which decade were interest payments at their highest, relative to the two other categories of government spending plotted? _______________

  • Federal Debt Holders
  • Using Excel, duplicate the FRED graph on Federal debt holders.
  • Use this Title: Chart 3 – Federal Debt Holders
  • Provide your name below the title.

Q1. As of the last available observation, who holds the largest share of U.S. federal debt? ________________Q2. When did the share of U.S. federal debt held by foreign private investors peak? ________________

Q3. What has been the largest share of federal debt held by Federal Reserve Banks? When was that value recorded? _______________