Course Project - Ratio Analysis

Aug 29th, 2014
Business & Finance
Price: $10 USD

Question description


Company Selection and Stock Watch.xlsx

This assignment is the third part of the course project. In this assignment, you will utilize the two stocks within the same industry that were selected in Module 03.


For the two firms, locate and download their latest annual report. Annual reports are typically found within the 'Investor Relations' section of a firm's website.

Utilizing the data from each of the firm's annual reports, calculate the following ratios:

  • Liquidity Ratios - Current Ratio and Quick Ratio
  • Activity Ratios - Inventory Turnover, Receivables Turnover, Days Sales Outstanding, Fixed Asset Turnover, and Total Asset Turnover
  • Profitability Ratios - Gross Profit Margin, Operating Profit Margin, Net Profit Margin, Return on Assets, and Return on Equity
  • Leverage Ratios - Debt/Net Worth and Debt Ratio
  • Coverage Ratios - Times-Interest-Earned

You may utilize a Microsoft Excel document to calculate the ratios for each firm.

After calculating the ratios for each of the firms, present the results and provide a brief analysis on the financial health of each firm.

Your assignment should be a minimum of 3 written pages in addition to the ratio calculations and utilize APA formatting. In-text citations and a reference page should also be included.

Tutor Answer

(Top Tutor) Daniel C.
School: New York University

Studypool has helped 1,244,100 students

Review from our student for this Answer

Sep 17th, 2014
"Goes above and beyond expectations !"
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1821 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors