Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 :(

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance

Authors: Angelico Groppelli, Ehsan Nikbakht

7th Edition

1438010362, 9781438010366

More Books

Students also viewed these Finance questions

Question

6.5 Identify at least 10 methods used for external recruitment.

Answered: 1 week ago

Question

6.6 Explain two strategies used to recruit nonpermanent staff.

Answered: 1 week ago