Capital asset pricing model-kellogg common equity

Reference no: EM1333261

1. Use the Capital Asset Pricing Model (CAPM) to find the expected return on Kellogg common equity. Use monthly price data for the last ten years (ending June 2004). The following steps will guide you through this problem.

A. Using the FRED database, (https://research.stlouisfed.org/fred2/) calculate the average return on 10-year treasury constant maturity rate bonds. Use this as your estimate of the risk free rate.

B. Find the average return for the S&P 500 as an estimate of the return on the market. (One source for the past prices of stocks and levels of indices is MSN Money, (https://moneycentral.msn.com/home.asp) where the symbol for the S&P 500 index is '$INX' and for Kellogg is 'K').

C. Using the regression function in Excel, find the beta for Kellogg using the S&P 500 as a proxy for the market.

D. Using the data and results from the previous questions, find the expected return on Kellogg common equity according to the Capital Asset Pricing Model (CAPM).

Reference no: EM1333261

Questions Cloud

Increasing sales in the market : Apple's PowerBook would be classified as a Specialty Good in terms of behavioural effect on consumers.

Suppose that you are the top marketing manager : Suppose that you are the top marketing manager for the Pepsi-Cola Co. You are engaged in an intense battle for market share in domestic beverage market with Coca-Cola Co.

Important information about performance management : Important information about Performance Management - Describe at least methods you could use to measure employee morale and What are the advantages and disadvantages of each method

Explain an example of e-commerce : Explain an example of e-commerce and a restaurant publishes its menus on its Web site so customers can decide what they want before coming to the restaurant

Capital asset pricing model-kellogg common equity : Using the data and results from the previous questions, find the expected return on Kellogg common equity according to the Capital Asset Pricing Model (CAPM).

Describe how globalization impacts the capital budgeting : Describe how globalization impacts the capital budgeting decisions of multinational firms? Be sure to carefully explain your reasoning.

Find sql statements and screenshots of the result : Any other information you would like to retrieve from the database.

Copyright procedure to register and employment at will : What is a copyright? What is the procedure to register a copyright? How is a copyright different from a patent?

Find the expected time : A time was set at 0.20 hour per unit based on the fifty unit produced. Find the expected time for the 100th, 200th, and 400th units?

User Account

All Pages