Finance Hw

NOTE: Read the given details carefully. I need a Word document of 700 words with attached Excel spreadsheet showing calculations. Must include recent information. Must be 100% original work. No previously USED work is acceptable. Must include 3-4 references all formatted in APA.

Company Name: McDonalds

Helping web link:


Assignment Instructions:

1.     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.

2.     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.

3.     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.

4.     All related findings, conclusions, and recommendations should be supported with sound financial analysis principles and be properly sourced.

·         Liquidity Measures

o    Current ratio [current assets / current liabilities]

o    Quick ratio-acid test [(current assets – inventory) / current liabilities]

o    Net working capital to total assets [net working capital / total assets]

·         Efficiency Measures

o    Collection period [accounts receivable / average daily sales]

o    Inventory turnover [cost of goods sold / ending inventory]

o    Fixed asset turnover [sales / net fixed assets]

·         Debt (Leverage) Measures

o    Debt-to-asset ratio [total liabilities / total assets]

o    Debt-to-equity ratio [total liabilities / total stockholder equity]

o    Times-interest-earned (TIE) ratio [EBIT / interest]

·         Profitability Measures

o    Gross profit margin [gross profit / sales]

o    Operating profit margin [EBIT / sales]

o    Net profit margin [net income / sales]

o    Return on assets (ROA) [net income / total assets]

o    Return on equity (ROE) [net income / total stockholder equity]

·         Market-Based Measures

o    Earnings per share (EPS) [earnings available to common stockholders / common shares outstanding]

o    Price-to-earnings ratio (P/E) [stock price / earnings per share]

o    Market to book [market value of common stock / total stockholder equity]



Don't hesitate - Save time and Excel

Are you overwhelmed by an intense schedule and facing difficulties completing this assignment? We at GrandHomework know how to assist students in the most effective and cheap way possible. To be sure of this, place an order and enjoy the best grades that you deserve!

Post Homework