### Capital asset pricing model-kellogg common equity

Assignment Help Finance Basics
##### 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).

#### 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?

### Write a Review

#### Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

#### A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

#### Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

#### Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

#### Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

#### What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

#### State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

#### Effect of financial leverage

The Effect of Financial Leverage and working capital management

#### Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

#### Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

#### Time value of money

Time Value of Money project