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

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. These are the companis from mod 3:

Apple

Google

Avon Products Inc.

L’Oréal SA

Mattel Inc.

Criteria

Points

Calculates all required ratios for each firm

50Summarizes ratio analysis results for each firm

Summarizes ratio analysis results for each firm

20

Provides a brief analysis on the financial health of each firm

30

Grammar, APA, organization and minimum page requirement

10

Total

100

Place a similar order with us or any form of academic custom essays related subject and it will be delivered within its deadline. All assignments are written from scratch based on the instructions which you will provide to ensure it is original and not plagiarized. Kindly use the calculator below to get your order cost; Do not hesitate to contact our support staff if you need any clarifications.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total:

Whatever level of paper you need – college, university, research paper, term paper or just a high school paper, you can safely place an order.