Remember to properly label and cite your data and graphs.

Q1) Find data on the effective Federal Funds Rate. Gather data from Jan, 1972 to the present.

• Find monthly, not-seasonally adjusted rates.
• What is the current FFR? What year was the highest and lowest Federal Funds rate in your data series.
• Download into Excel and construct a graph of the Effective Federal Funds Rate.

Q2) Find data for the following:

• Prime Bank Loan Rate
• 30 year Conventional Mortgage Rate (monthly, not-seasonally adjusted, Jan, 1972-Sep, 2016)
• Automobile Lending Rates from (commercial banks, new autos 48 months loan, from Jan, 1972 to the present)

Q3) Also find data (from 1981 to the present) for:

• 3 month treasuries constant maturity
• 3 year tresuries constant maturity
• 30 year treasuries constant maturity

Construct two graphs:

• Graph One - should include the effective Federal Funds rate, Prime Bank Loan Rate; Mortgage Rate; and Automobile Lending Rates.
• Graph Two - effective Federal Funds Rate, 3 month treasuries constant maturity; 3 year treasuries constant maturity; and 30 year treasuries constant maturity.

These graphs are to be imported into a Word Document. Write a short paragraph discussing some observations you have about the data for each graph.

You are expected to present the assignment formally with proper citations.

The goals of this assignment are the following:

• Illustrate your ability to utilize primary sources.
• Give you experience creating tables using Excel.
• Give you experience creating graphs using excel.
• Give you experience presenting the graphs and table in a Word document.