Name _____________________________ Date March 31, 2020
EXAM II – Take Home
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
- 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? ________________
- 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? _______________