Ford & Microsoft

profilemarons2

Course Project - Ratio Analysis

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.

Required

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.

Submit your completed assignment to the drop box below. Please check the Course Calendar for specific due dates.

Save your assignment as either a Microsoft Word or Excel document. If you're using both Word and Excel, attach both documents to the drop box. (Mac users, please remember to append the ".doc" or ".xlsx" extension to the filename.) The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date. An example is shown below:

Jstudent_exampleproblem_101504

Need Help? Click here for complete drop box instructions.

    • 9 years ago
    • 5
    Answer(2)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      ford__microsofty.xls

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      ford_and_microsoft.doc
    Bids(1)
    other Questions(10)