Calculate net profit margin ratios using financial statement

Reference no: EM131056120

Financial Case

Choose Tyson Foods Inc

For this project, you will be randomly assigned a publicly-traded company. Once given your company, go online to www.sec.gov to find the 12/31/15 and the 12/31/14 financial statements (or closest to those dates if on a different fiscal year). Include a copy of the Balance Sheets and Income Statements for both years in your excel file. Next, calculate the 12/31/15 and 12/31/14 ratios using the financial statements you printed, including all of the following:

• Current ratio
• Quick ratio
• Inventory turnover ratio
• Days sales outstanding (DSO)
• Net profit margin
• Return on total assets (ROA)
• Return on equity (ROE)
• P/E ratio

You must use the Excel spreadsheet template to calculate these ratios. Next, locate the industry averages for these same ratios available through Hoovers. Copy the industry average information into your Excel document, to show the source of your data, and be sure to cite your sources. Using the company's year-over-year results (2015 versus 2014) and a comparison of 12/31/15 results to the industry averages, write a brief report to analyze the company's performance in terms of its liquidity, asset management, and profitability. Finally, in the same report, answer these questions: (1) If you were an investor, would you buy this company's stock? Why or why not? (2) If you were a commercial lender, would you approve a loan for this company? Why or why not? Incorporate the calculated ratios to explain your answers to these questions. Industry averages can be found online; the Hoovers database available in the library is an excellent source for these.

you need to fill all the dark green. In order to complete the assignment you will need industry ratios which you can find online; the best place is Hoover's through the library. Note, not all ratios apply to all idustries! For example, New York Life will not have inventory or inventory turnover. If this applies to one of your ratios just put N/A and explain why you think it doesn't apply to your company.

https://www.sec.gov/edgar/searchedgar/companysearch.html

Attachment:- financial_analysis_project1_4_0.xlsx

Reference no: EM131056120

Questions Cloud

Calculate the temperature at the points : Suppose 57.5 moles of an ideal monatomic gas undergo the series of processes shown in Figure 5. (a) Calculate the temperature at the points A, B, and C. (b) For each process and state whether heat enters or leaves the system. Explain in each case...

Which of the cell types is an immature red blood cells : Which of the following cell types is an immature red blood cell?

Identify the functionality of key code components : Identify the functionality of key code components such as what the functionality of "system.out.println" is along with other code components such as the calendar code and the semicolon.

Social media and feminism : Expand and be more specific on the example (on the hashtag example). What the hashtag is about? And how is the hashtag affected

Calculate net profit margin ratios using financial statement : Next, calculate the 12/31/15 and 12/31/14 ratios using the financial statements you printed, including all of the following:

Discuss it strategy that o-reilly media chose to implement : Discuss the IT strategy that O'Reilly Media chose to implement and whether you believe that it successfully addresses the goals of IT governance and business alignment. Has O'Reilly Media considered all of the stakeholders in this scenario? What c..

Create three classes for the linked list : The input file will be in the following format: one word per line followed by either N or V in parenthesis: apple(N) peach(N) eat(V) .

Thermodynamic data for an unknown inorganic complex : Consider the following thermodynamic data for an unknown inorganic complex at constant pressure. At what temperature does sublimation occur? Please answer in units of°C

Tennatite with a mass : Tennantite is an ore of copper with a formula of Cu12As4S13. How many moles of copper are in tennatite with a mass of 19850 grams?

User Account

All Pages