apple vs samsung Financial Analysis EXCEL

You must then obtain the financials for the most recent three-year period. Based on the company financials:

  1. Prepare a Horizontal Analysis for all 3 financial statements.
  2. Prepare a Vertical Analysis for the Balance Sheet and Income Statement.
  3. Prepare a Ratio Analysis for each of the following:
    1. Current ratio
    2. Acid-test ratio
    3. Receivable turnover
    4. Inventory turnover
    5. Profit margin
    6. Asset turnover
    7. Return on Assets
    8. Return on Common Stockholder’s Equity
    9. EPS (Earnings Per Share)
    10. Debt to total Assets ratio
    11. Times Interest Earned

    The financial statements for the project can be retrieved at the assigned company’s website or at sec.gov. You must use the most recent 2 years for your analysis.

The analysis should include a comparative analysis that is Intracompany (Horizontal & Vertical analysis for 2 years) and Intercompany (by way comparison of Ratios to a Major Competitor for the most recent year). Possible explanations for major differences should be provided. You must use a formula for all numbers that require a calculation (ratio, total, difference, etc.).

The project should be done via Excel and Write a paper describing what you did.

any questions please ask

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now