Question: Financial data should be tracked starting January 2017-Present. A) Each series below should be tracked and presented in numerical form in an excel spreadsheet. (
Financial data should be tracked starting January 2017-Present.
A) Each series below should be tracked and presented in numerical form in an excel spreadsheet. ( the date in the left hand column and each series in the row.)
B) Each series should be presented graphically overtime and analyzed for its direction and strength. (Once the data is in excel, we need highlighting the series, then at the top hitting the insert button, then hitting the line graph button and excel will automatically graph.)
C) After analyzing the data, we should make monetary policy recommendations based on the analysis.
Financial data to track in the project include:
1) Money: Measured as M1 and M2 seasonally adjusted. Monetary Base and money multiplier.
2) S-T Interest Rates: Measured as Effective Federal Funds interest rate and constant maturity 3 month T-Bill interest rates.
3) L-T Interest Rates: Measured as a 30 year AAA corporate Bond Rate, the Baa Corporate bond rate, a 30 year fixed mortgage rate and the 30 Year constant maturity Treasury bond rate. Price and yield of any bond with a maturity of 5 years or more.
4) Yield Curve: Measured as the difference between the short term 3 month T-Bill rate and the long term 30 year Treasury Bond rate.
5) Stock Market: Measured as Dow Jones Industrial Average (DJIA), NASDAQ, and the S&P 500. Price, yield, and P/E Ratio of any stock of your choice.
6) Derivative/Commodity: Price of Gold and Oil.
7) Prices (P) and Inflation: Prices measured CPI - consumer price index (CPI for all items), PPI - producer price index, Core price expenditures, and Inflation measured as the change in CPI, inflation expectations, measured as the 5 year forward rate.
8) Output and its Components: Real GDP (output) and its components (real Consumption (C), real Investment (I), housing, Government Spending (G), and real Net Exports (NX)).
9) Value of the Dollar: Value of the Dollar to the Euro, Yen and Yuan.
10) Unemployment Civilian Unemployment rate.
- This information can be found at http://research.stlouisfed.org/fred2/. It may also be obtained at WWW.wsj.com, http://www.bls.gov/, http://www.bea.doc.gov/, or Data stream. We can use any source that we like, we just need siting the source.
- After each section, discussing the general movements in the data series.
- We need writing a FOMC statement outlining the state of the U.S. economy, the risks to the economy, and their groups monetary policy recommendations.
We can find all of the data on the FRED (St. Louis Federal Reserve) Website.Each series should be downloaded into a column on an excel spreadsheet ( 1 sheet for the monthly data and 1 sheet for the quarterly data) and each series should be graphed over time.After looking at the data, then we need making policy recommendations based on where inflation and unemployment are headed.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
