Question: Hi, i need the second and third portion done for the question. First ones been done. For Part I please copy and paste all figures
Hi, i need the second and third portion done for the question. First ones been done.

For Part I please copy and paste all figures and tables from questions 1 through 7. In addition, each group must include an interpretation below each figure and table. After providing all the tables and figures and at least two sentences interpreting graph include a summary conclusion of your opinion on the direction of the US economy. Tip: Please do not define the graph but provide an interpretation. For example, suppose you include a graph of the yield curve. Do not define what the yield curve is by saying "it is a map of all the Treasury yields". However, say somet hing like this, "it is downward sloping which mean the market expects interest rates to decline in the next 12 months suggesting a large probability of an economic recession For Part II each group oly has to include whether Goldman Sachs is over, under, or tairly valued for question 9. For question 10 just note if the put/call parity holds for Goldman Sachs. Include the equations with numbers used in the project report. 1 Part I 1. Calculate annual growth rate of commercial and industrial loans . Google"commercial and industrial loans fed". Download mont hly non-seasonally data. Use start date of January 1970. Download the data. Calculate the annual growth rate of the loans updating on a monthly basis. Graph the year over year change updating on a mont hly basis. Calculate the average growth rate from 1970 until today. Include the average on the graph along with the growth rate 2. Find Household Debt Service Payments as a Percent of Disposable Personal Income Google "household debt service payments as a percent of disposable personal income and Fed" Click the St. Louis Fed link. Download data and graph. Calculate the annual percent change updating on a quarterly basis. Graph the change as well 3. Calculate real growth rate of money supply Google M2 Fed. Click on first link. Click Monthly Non-Seasonally Adjusted. Download from 1970 to the most recent date. Calculate the annual growth of M2 stock updating on a monthly basis. Google CPI Index Fed. Click on irst link. Click on Non-Seasonally Adjusted under Consumer Price Index for All Urban Consumers: All Its. Download from 1970 to the most recent date. Calculate the annual growth rate of CPI index updating on a monthly basis. Subtract the difference between the M2 and CPI growth rate to calculate the real growth rate in M2 Calculate the four year moving average of the real growth rate in M2
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
