https://docs.google.com/spreadsheets/d/1NQgQM-oSymGk5gVp-qsDLNZU26Z0E47A/edit?usp=sharing&ouid=110753071646605914163&rtpof=true&sd=true Problem 2: Estimate the most current Weighted Average Cost of Capital of Rockwell Automation, Inc (ticker:
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Problem 2: Estimate the most current Weighted Average Cost of Capital of Rockwell Automation, Inc (ticker: ROK). Use CAPM to estimate the cost of equity. Assume that the capital structure (the market debt-to-equity ratio) observed as of the most recent annual financial statements remains in place forever for the company. Also assume that the market risk premium is 5% and that the marginal tax rate is 21%. Suggested sources of the data: 1. SEC's Edgar database - for financial statements and annual or quarterly report (10-K or 10-Q) 2. Stock returns from CRSP database - to calculate the beta (an Excel file with the data is available on CANVAS. Column G is the date of the end of the observation month, I is monthly returns on Rockwell's stock, L is CRSP value-weighted index, N is S&P 500 index returns). 3. FINRA'S TRACE database - for public bond yields and prices (https://finra-markets.morningstar.com/BondCenter/Default.jsp) 4. U.S. Treasury's web-site - for T-bond rates (https://home.treasury.gov/resource-center/data-chart-center/interest- rates/TextView?type-daily_treasury_yield_curve&field_tdr_date_value_month=202211) 5. Yahoo's finance web-site, NASDAQ.com, or NYSE.com - for the stock price around the date of the most recent financial report. Recipe: a) Calculate the cost of debt using most recent yields from a representative set of Rockwell public bonds. Ensure that the bond was issued by Rockwell Automation, Inc (CUSIP: 773903) b) Calculate the market value of Rockwell debt using book value of debt adjusted by the price to face value multiple of a set of public bonds of Rockwell. c) The marginal tax rate is provided. d) Calculate the market value of equity using number of shares outstanding from the most recent financial report and historical stock price as of that date from NASDAQ, NYSE, or Yahoo. e) Calculate the cost of equity using CAPM. For that, you are provided the market risk premium. Use current yield on the 10-year Treasury bond as the risk-free rate, and calculate the beta of Rockwell's stock using 5 years of monthly stock returns and VW CRSP portfolio as the market portfolio. Data on stock returns are provided in the Excel file using CRSP database. f) Combine it all to calculate Weighted Average Cost of Capital (WACC) for Rockwell. Problem 2: Estimate the most current Weighted Average Cost of Capital of Rockwell Automation, Inc (ticker: ROK). Use CAPM to estimate the cost of equity. Assume that the capital structure (the market debt-to-equity ratio) observed as of the most recent annual financial statements remains in place forever for the company. Also assume that the market risk premium is 5% and that the marginal tax rate is 21%. Suggested sources of the data: 1. SEC's Edgar database - for financial statements and annual or quarterly report (10-K or 10-Q) 2. Stock returns from CRSP database - to calculate the beta (an Excel file with the data is available on CANVAS. Column G is the date of the end of the observation month, I is monthly returns on Rockwell's stock, L is CRSP value-weighted index, N is S&P 500 index returns). 3. FINRA'S TRACE database - for public bond yields and prices (https://finra-markets.morningstar.com/BondCenter/Default.jsp) 4. U.S. Treasury's web-site - for T-bond rates (https://home.treasury.gov/resource-center/data-chart-center/interest- rates/TextView?type-daily_treasury_yield_curve&field_tdr_date_value_month=202211) 5. Yahoo's finance web-site, NASDAQ.com, or NYSE.com - for the stock price around the date of the most recent financial report. Recipe: a) Calculate the cost of debt using most recent yields from a representative set of Rockwell public bonds. Ensure that the bond was issued by Rockwell Automation, Inc (CUSIP: 773903) b) Calculate the market value of Rockwell debt using book value of debt adjusted by the price to face value multiple of a set of public bonds of Rockwell. c) The marginal tax rate is provided. d) Calculate the market value of equity using number of shares outstanding from the most recent financial report and historical stock price as of that date from NASDAQ, NYSE, or Yahoo. e) Calculate the cost of equity using CAPM. For that, you are provided the market risk premium. Use current yield on the 10-year Treasury bond as the risk-free rate, and calculate the beta of Rockwell's stock using 5 years of monthly stock returns and VW CRSP portfolio as the market portfolio. Data on stock returns are provided in the Excel file using CRSP database. f) Combine it all to calculate Weighted Average Cost of Capital (WACC) for Rockwell.
Expert Answer:
Related Book For
Equity Asset Valuation
ISBN: 978-0470571439
2nd Edition
Authors: Jerald E. Pinto, Elaine Henry, Thomas R. Robinson, John D. Stowe, Abby Cohen
Posted Date:
Students also viewed these finance questions
-
Ann Carter, Chief Financial Officer of Consolidated Electric Company (Con El), must make a recommendation to Con Els board of directors regarding the firms dividend policy. Con El owns two...
-
Assignment Overview This project consists of determining the current weighted average cost of capital for a publicly traded firm. Please read the information below. The Problem As new analysts in the...
-
A problem in Statistics is given to three students A, B, and C whose chances of solving it are 1/4 and 1/5 respectively. Find the probability that the problem will be solved if they all try...
-
Discuss the Sarbanes-Oxley Act in wake of the financial reporting misdeeds of Enron and WorldCom. Compare and contrast the two companies, why they were caught, and how policies have changed for...
-
Why is EBIT generally considered to be independent of financial leverage? Why might EBIT actually be influenced by financial leverage at high debt levels?
-
Etsy is an e-commerce website focusing on handmade or vintage items and unique factory-manufactured products. These items cover a wide range of product types, including jewelry, furniture,...
-
An orifice meter (see Figure 3.2-1) is to be calibrated for the measurement of the flow rate of a stream of liquid acetone. The differential manometer fluid has a specific gravity of 1.10. The...
-
Other than the wind speed, what factor has the most impact on the amount of power generated by a wind turbine? Swept area of rotor Turbine style Terrain Blade material.
-
Complete Tsate's Form 1040-SR, Schedules A, B and D, Form 8949, Form 6252 and Qualified Dividends and Capital Gain Tax Worksheet. Tsate Kongia (birthdate 02/14/1954) is an unmarried high school...
-
Assume that AOL-Time Warner is interested in acquiring the ABC television network from Disney. It has estimated the expected incremental future cash flows from acquiring ABC and desires an...
-
3 3 A ship floating in sea water (density =1020 kg/m displaces 1000m of water. What is the mass of the ship? O 6 1.02x 10 kg 5 5.1x10 kg 6 9.8x 10 kg 5 7.6x10 kg O O
-
2 3 1 point The zero of the Celsius scale corresponds to The boiling point of water The tripple point of water (approximately) Zero absolute pressure No aboslution motion +273.15 K -273.15 K 1 point...
-
An electrostatic air cleaner is a device that removes polluting particulates, thus purifying air. As an example, contaminated air carrying a particulate, with a mass of 3.15 109 kg, will first pass...
-
3 3 A balloon filled with 200 m of helium (density = 0.179 kg/m is rising in air 3 (density = 1.2 kg/m ). how much mass can the balloon left. O 104 kg O 415 kg 204 kg 2000 kg
-
A piece of pollen typically has both a small mass (about 5 ng) and a small amount of charge (about 1 fC). Estimate the electric field that a honeybee needs to create to carry a typical piece of...
-
Given that it is equally likely that the stock will go up by 36.5% or go down by 5.5%. The current price is $30. The future prices for the next 4 years are: What is the expected price of this stock...
-
Solve the relation Exz:Solve therelation ne %3D
-
Suppose an analyst uses an equity index as a comparison asset in valuing a stock. In making a decision to recommend purchase of an individual stock, which price multiple(s) would cause concern about...
-
Based on the third approach (the H - model), the stock is A. Undervalued. B. Fairly valued. C. Overvalued. Assorted Fund, a UK - based globally diversified equity mutual fund, is considering adding...
-
In a research note on the ordinary shares of the Milan Fashion Group (MFG) dated early July 2007 when a recent price was 7.73 and projected annual dividends were 0.05, an analyst stated a target...
-
Which of the following is not a characteristic of common equity? A. It represents an ownership interest in the company. B. Shareholders participate in the decision-making process. C. The company is...
-
Investing the majority of the portfolio on a passive or low active risk basis while a minority of the assets is managed aggressively in smaller portfolios is best described as: A. The coresatellite...
-
All of the following are characteristics of preference shares except: A. They are either callable or putable. B. They generally do not have voting rights. C. They do not share in the operating...
Study smarter with the SolutionInn App