ANSWERS TO DATA ANALYSIS PROBLEMS
1. Go to the St. Louis Federal Reserve FRED database, and find data on Moody’s Aaa
corporate bond yield (AAA) and Moody’s Baa corporate bond yield (BAA). Download the
data into a spreadsheet.
b. Calculate the spread again, for the same month but one year prior, and compare the
result to your answer to part (a). What do your answers say about how the risk premium
has changed over the past year?
2. Go to the St. Louis Federal Reserve FRED database, and find daily yield data on the
following U.S. treasuries securities: one-month (DGS1MO), three-month (DGS3MO), six-
month (DGS6MO), one-year (DGS1), two-year (DGS2), three-year (DGS3), five-year
(DGS5), seven-year (DGS7), 10-year (DGS10), 20-year (DGS20), and 30-year (DGS30).
Download the last full year of data available into a spreadsheet.
a. Construct a yield curve by creating a line graph for the most recent day of data
available, and for the same day (or as close to the same day as possible) one year prior,
across all the maturities. How do the yield curves compare? What does the changing
slope say about potential changes in economic conditions?
b. Determine the date of the most recent Federal Open Market Committee policy statement.
Construct yield curves for both the day before the policy statement was released and the