To determine Henkel''s corporate beta, unlever (and relever) the ordinary least squares (OLS) market betas for each company in the European Household and Personal Care segment. Prices can be found on the "Prices" tab of the "Select Market Data" spreadsheet.

To determine the OLS market beta, regress 10-year monthly returns against the MSCI World index denominated in the same currency. In Excel, this can be done using the "SLOPE" formula.

Next, unlever the market beta using each company''s year-end debt-to-equity ratio and the formula: bu = be/(1+D/E).

To determine Henkel''s corporate beta, re-lever the average industry beta using Henkel''s year-end debt-to-equity ratio.

Posted Date: 5/2/2013 7:04:49 AM | Location : United States

Posted Date: 4/23/2015 3:35:45 AM | Location : Malaysia

Ask an Expert

Related Discussions:- Interested in your answers for this as an example, Assignment Help, Ask Question on Interested in your answers for this as an example, Get Answer, Expert's Help, Interested in your answers for this as an example Discussions

Write discussion on Interested in your answers for this as an example
Your posts are moderated

Write your message here..

Related Questions

What is the hirfindahl-hirschman index, What is the Hirfindahl-Hirschman I... What is the Hirfindahl-Hirschman Index ? A: The Hirfindahl-Hirschman Index, or HHI, is the standard measure used by economists to evaluate market concentration. The greater th

Bond valuation, An investor buys a French government, 10-year bond, paying ... An investor buys a French government, 10-year bond, paying annual coupon of 4.5%. Face value = 1000. The investor is unsure of his investment horizon and considers 5 horizons: 5, 6

Explain internal rating system, Question 1: ‘An internal rating system ... Question 1: ‘An internal rating system may incorporate supplementary customer information which is usually out of the reach of an external credit assessment institution.' Discu

significant trends do you see in future for our industry, What significant... What significant trends do you see in the future for our industry? Ans) You will be fully well-known with the economic situation as it relates to banking or how recent legislati

Calculate the profitability ratio, You are a new member of the accounting t... You are a new member of the accounting team and have been asked to examine the accounts of Bellatrix and calculate appropriate ratios in order to evaluate the company's performance

Case study, Hallo I have to prepare a case study in cooperate finance. It i... Hallo I have to prepare a case study in cooperate finance. It is a balance sheet and different adjustments. I would need your help to reflect my results. Is this possible?

Accumulative swing index - asi, It is an indicator used by traders to judge... It is an indicator used by traders to judge a security's long-term trend by comparing bars which comprise its closing,   opening, high and low prices during a specific period of ti

Market beta portfolio management, solutions for this question solutions for this question

Capital Structure, A leveraged recap, in which Midco would issue debt and u... A leveraged recap, in which Midco would issue debt and use the proceeds to repurchase shares. A Midco industry has 20 million shares outstanding with market price of $15 per share

Before tax cost of bond using IRR, David Abbot is interested in purchasing ... David Abbot is interested in purchasing a bond issued by Sony. He has obtained the following information on the security: Par value $1000, coupon interest rate 6.0%, corporate tax