Purchase Solution

Tyson Foods Inc. correlation of stock price financial ratios

Not what you're looking for?

Company: Tyson Foods Inc. - Stock symbol (TSN)

Deliver a 400 to 500 word one page memo on your analysis.

Is there a contemporaneous relationship between current company information and stock price? (That is, is the information reflected in the stock price?)

What happens to the ratio over the last years (2009-2012)? What happens to stock price over the last years?

Interpret the sign ("+" or "-") of the correlation.

List the the correlation from highest to lowest in absolute value.

Do the high correlations make financial sense?

With the attachment, trying to identifying 3 areas close to the number 1 and speak about the effects on those respective areas in a way to provide intelligent responses to the above questions.

Any guidance, suggestions, and assistance would be appreciated to help get started. When you review the ratios, will you suggest where I should focus my attention?

Solution Summary

Your discussion is 454 words and gives ideas about why the correlations are either not strong or are negative. The spreadsheet show the correlations sorted by absolute value.

Solution Preview

The correlation of Tyson ratios to stock prices during the period 2009-2012 show some strange patterns. For instance, there are five ratios that are strongly related (correlation above .7) but are negatively correlated with stock price. That is, as stock price goes up, the ratios go down. Yes, that's right. Return on equity, return on assets, days in receivables, net profit margin and interest coverage all declined of this three year period but the stock price climbed over this period. Only receivables turnover was positively correlated (with a strong relationship over .7) during this three year period.

Sorting the absolute value of the correlations (see excel tab sorted), shows that the measures that seem to move most in relation to price (strong ...

Solution provided by:
Education
• BSc, University of Virginia
• MSc, University of Virginia
• PhD, Georgia State University
Recent Feedback
• "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
• "Thank, this is more clear to me now."
• "Awesome job! "
• "ty"
• "Great Analysis, thank you so much"

Free BrainMass Quizzes

Importance of Critical Thinking

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media