Find the correlation between the two stocks and interpret

Assignment Help Financial Management

Reference no: EM132065813

Select two companies in two different industries and do the following: Disney and Bristol-Myers Squibb

Determine key macroeconomic factors impacting each firm.

List and describe the major competitors to the selected company.

Evaluate each firm using Porter’s 5 determinants of competition.

Compute and interpret the financial ratios described below for a five-year period.

Look at the trend in the ratios to determine if they are deteriorating or improving and compare them against peers or the industry:

Current and quick ratios and net working capital

Inventory turnover, fixed assets turnover and total assets turnover

Debt ratio and TIE.

Gross profit margin and net profit margin and operating margin

ROE and ROA

Price/ Earnings and Market/Book

Du Pont Analysis

Free Cash Flow

EVA and MVA

Find beta, R squared, alpha and the residual standard deviation for each firm using Excel. Interpret the results and recommend which firm should be added to a well diversified portfolio. Use 60 months of return data for the calculations.

Find the correlation between the two stocks and interpret.

Estimate the required return for each stock (SML).

Estimate the sustainable growth rate (g) for each stock. Find it for 3 years and take an average.

Estimate the 5 and 10-year historic growth rate in earnings. Compare to sustainable growth method.

Estimate the intrinsic value (price) of the two stocks using the 1) dividend discount model (DDM) approach or the 2) P/E multiplier approach. Make a buy or sell recommendation.

Evaluate stock using value criteria of dividend yield and price to book.

For Disney and Bristol-Myers Squibb

I completed most of the ratios but missing the WACC, capital invested, EVA and MVA for Bristol-Myers Squibb

Need what is in bold completed we used data from 2013, 2014, 2015, 2016 and 2017.

Reference no: EM132065813

Questions Cloud

Your company to evaluate the proposed acquisition : You have been asked by the president of your company to evaluate the proposed acquisition of a new special-purpose truck for $150,000.

Discuss about the monetary policy simulation game : Your assignment is to take part in a monetary policy simulation game. (You will be graded on participation and your response to questions.

Earnings reinvested in firm are represented on balance sheet : Earnings reinvested in the firm are represented on a balance sheet by:

How to become a double-major : For our next essay this term, I want you to write a directive process analysis essay describing how to do something related to education.

Find the correlation between the two stocks and interpret : Find the correlation between the two stocks and interpret.

Develop your own interpretation based on that experience : This assignment is a "think piece," which is an essay that requires you to interact with a subject and develop your own interpretation based on that experience.

How do the people in the photo look : Photographs may very well be our favorite form of media, and have been almost since the first forms of photography appeared in the 1830's.

What is the general status of women : What is the general status of women in your country of research? Include socio-cultural factors (education; violence; religion; etc.).

Are there any limits to biological change : Are there any limits to biological change? If so, at what point are those limitations reached? How does one know when those limitations have been reached?

User Account

All Pages