In case anyone is wondering, i cannot provide type the data on this question since it would be too long for the question... The method towards finding the data is actually provided with the instructions given below- Example being if it tells you to go to 'yahoo finance and enter the ticker APPL' you should probably just do that...it specifically states doing that... this is literally all the information we ourselves have been provided so its definitely manageable...i hope I'm not just wasting my money here... maybe I should switch to coursehero :(
1 Project Exercise 1 1. Find growth rate of commercial and industrial loans. Google" commercial and industrial loans fed" Download monthly non-seasonally data. Use start date of January 1970. Download the data. Calculate the annual growth rate of the loans updating on a mont hly basis. Graph the year over year change for every month. Then calculate the sample mean. Graph the sample mean on the same graph. 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 the data and graph the data in Excel. Calculate the annual growth rate on a quarterly basis and its two year moving average. 3. Find real growth rate in money supply. . Google M2 Fed. Click on first link. Click Monthly Non-Seasonally Adjusted. Download from 1970 to the present. Calculate the annual growth of M2 stock updating on a monthly basis . Google CPI Index Fed. Click on first link. Click on monthly Non-Seasonally Adjusted under Consumer Price Index for All Urban Consumers: All Items. Download fronm 1970 to the present. 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 Plot the real growth in M2 and its 4 year-moving average. 1 Project Exercise 1 1. Find growth rate of commercial and industrial loans. Google" commercial and industrial loans fed" Download monthly non-seasonally data. Use start date of January 1970. Download the data. Calculate the annual growth rate of the loans updating on a mont hly basis. Graph the year over year change for every month. Then calculate the sample mean. Graph the sample mean on the same graph. 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 the data and graph the data in Excel. Calculate the annual growth rate on a quarterly basis and its two year moving average. 3. Find real growth rate in money supply. . Google M2 Fed. Click on first link. Click Monthly Non-Seasonally Adjusted. Download from 1970 to the present. Calculate the annual growth of M2 stock updating on a monthly basis . Google CPI Index Fed. Click on first link. Click on monthly Non-Seasonally Adjusted under Consumer Price Index for All Urban Consumers: All Items. Download fronm 1970 to the present. 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 Plot the real growth in M2 and its 4 year-moving average
