Finanical Statement Analysis

profilealeisj1
Deliverable Length:Word document of 700–1,000 words with attached Excel spreadsheet showing calculations
Details:

Weekly tasks or assignments (Individual or Group Projects) will be due by Monday, and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.

Library Research Assignment

Research a publicly held company of your choice, and access the company's Web page on the Internet to read its most recent annual report. The annual report is typically found in an "Investor Relations" or "Company Information" section within the company's Web site.

Using the company's financial statements, perform a complete 2-year financial statement analysis addressing liquidity, efficiency, debt, profitability, and market measures as well as a common-size income statement and balance sheet along with a practical narrative. This analysis should not only include the calculation of the required ratios, but an assessment of the firm’s health in each area and a summary of the findings with regards to the overall health of the firm. All related findings, conclusions, and recommendations should be supported with sound financial analysis principles and be properly sourced.

  • Liquidity Measures
    • Current ratio [current assets / current liabilities]
    • Quick ratio-acid test [(current assets – inventory) / current liabilities]
    • Net working capital to total assets [net working capital / total assets]
  • Efficiency Measures
    • Collection period [accounts receivable / average daily sales]
    • Inventory turnover [cost of goods sold / ending inventory]
    • Fixed asset turnover [sales / net fixed assets]
  • Debt (Leverage) Measures
    • Debt-to-asset ratio [total liabilities / total assets]
    • Debt-to-equity ratio [total liabilities / total stockholder equity]
    • Times-interest-earned (TIE) ratio [EBIT / interest]
  • Profitability Measures
    • Gross profit margin [gross profit / sales]
    • Operating profit margin [EBIT / sales]
    • Net profit margin [net income / sales]
    • Return on assets (ROA) [net income / total assets]
    • Return on equity (ROE) [net income / total stockholder equity]
  • Market-Based Measures
    • Earnings per share (EPS) [earnings available to common stockholders / common shares outstanding]
    • Price-to-earnings ratio (P/E) [stock price / earnings per share]
    • Market to book [market value of common stock / total stockholder equity]
    • 10 years ago
    • 30
    Answer(3)

    Purchase the answer to view it

    blurred-text
    • attachment
      finanical_statement_analysis1.doc
    • attachment
      excel.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      20140326195817case_study_mcdonalds_corporation.doc
    • attachment
      mcdonalds_financials.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      costco_analysis_aug_lovingmpmmy.xlsx
    • attachment
      costco_financial_analysis_lovingmommy.docx