Calculate annual growth rate of commercial loans

Assignment Help Financial Management

Reference no: EM132199761

Project Instructions

Part I

1. Calculate annual 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 monthly basis. Graph the year over year change updating on a monthly 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 first link. Click on Non-Seasonally Adjusted under Consumer Price Index for All Urban Consumers: All Items. 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.

• Plot the real growth in M2 and its moving average.

4. Calculate Fed's monetary base adjusting for excess reserves.

• Google Monetary Base Fed. Click on first link. Click Monthly Non-Seasonally Adjusted. Download from 1984 to the most recent date.

• Google excess reserves Fed. Download from 1984 to the most recent date.

• Subtract the two and Graph.

5. Calculate Baa-Aaa spread.

• Google Baa Fed. Click first link and download data from 1970 to the most recent date.

• Do the same for Aaa Fed.

• Subtract the two and graph.

• Subtract the two and divide by the Aaa yield and graph.

6. Calculate yield curve

• Find the closing yields for all Treasury securities.

• Copy and paste the yields to Excel and graph the Treasury Yield Curve.

7. Calculate bid to cover ratio for 10 year Treasuries.

• Calculate the bid to cover ratio for 10-year Treasury auctions for every month of this year.

• Google bid to cover ratio treasury auction results. Select first Treasury direct link you find.

• Click Announcement and Press Release. Click Note and 10 year. Click pdf under competitive results for all years.

• Collect all data for this year and chart.

8. Write one paragraph that is a forecast of the US economy. What is the direction of the US economy in the next 12 months after netting the results from the previous seven questions? What is the direction of interest rates and inflation?

Part II

9. Evaluate the stock price of Goldman Sachs using two techniques.

• DDM

• Relative Valuation

Create a nice formatted table in Excel that shows all the steps/work. Copy and paste the table into your professional Word Document

1. To calculate g use two methods. 1. Use ROE x (1-payout ratio). 2. Go to yahoo finance enter GS. Click on the "Analysts" link. Use next 5 years growth estimate. To find the data go to yahoo finance. Enter GS for the ticker. Click on statistics.

Choose the go you think is the most appropriate to use. To calculate r use the CAPM, 10 year Treasury yield + beta * (7.6%). Use the forwarded annual dividend rate.

2. To use the relative valuation approach use google finance. Use the P/E, P/BV, and P/S ratios of the related companies.

3. Determine if GS over or under valued using both techniques.

10. Use put-call ratio.

• Determine if GS's put/call parity holds. Go to yahoo finance. Enter GS in ticker search box. Click on options. Find the date that is closes to one year from today.

• Find the call and put premium for a strike price that is close to GS's current price.

• Find the yield on a one year Treasury bill.

• Determine if the put/call parity holds using the equation.

Reference no: EM132199761

Questions Cloud

Explain the five factors of communication in detail : Explain the five factors of communication in detail. A firm that wants decisions to be made by managers who are closer to the issue at hand should choose.

Information about the chance of being successful : You are contemplating making one of 3 investments, A, B, or C. Here is some information about the chance of each being successful:

Carrier of haemophilia : From family background, it is known that with probability 1 2 a woman is a carrier of haemophilia. If she is a carrier, then with probability 1 2 her male

Decision-making strategies in considering the new program : Discuss how you would apply the six principles to decision-making strategies in considering the new program.

Calculate annual growth rate of commercial loans : FIN 353 : Calculate the annual percent change updating on a quarterly basis. Graph the change as well. Calculate real growth rate of money supply.

Center for disease control : "Graduating is good for your health," according to a headline in the Boston Globe (3 April 1998). The article noted "According to the Center for Disease Control

Walter disney founder of disney world leadership styles : Discuss Walter Disney founder of Disney World leadership styles/traits in terms of what we have learned from our reading.

Number of axles on a vehicle and the gas mileage : If you believe they are? correlated, state whether the correlation is positive or negative. Explain your reasoning.

Reading talks about audience-purpose and exigency : The reading talks about audience, purpose, exigency, and context all as being important to writing.

User Account

All Pages