Financial Statement Analysis

Background:
You are to determine the financial ratios of the company and explain if they support the business strategy or if they indicate something that needs further analysis.

Deliverables:
This is an individual assignment. You will be expected to have someone peer review your work. Submit your Word file with your write up and your Excel file with your calculations by email. Make sure to label your files “Project 1_your name”.

Your Task:

Part 1: Financial Statement Analysis
• Pick a publicly listed company
• Go to https://finance.yahoo.com and search for your company either by name or ticker
• Then select “Financials” to see the Income Statement and Balance Sheet for the last years
• Mark the ANNUAL income statements and balance sheets and copy them into separate sheets in Excel; name the sheets accordingly
• For all four years of annual statements, at a minimum calculate the following ratios in a separate sheet. DO other ratios if it adds to the analysis.
Do all your calculations in Excel! See your notes/the textbook for the formulas.
• Liquidity ratios:
• Current ratio
• Quick ratio
• Leverage ratios:
• Total debt ratio
• Turnover ratios:
• Inventory turnover
• Receivables turnover
• Total asset turnover

• Profitability ratios:
• Profit margin
• Return on assets
• Return on equity
• Provide a brief summary of the company’s key startegies.
• Using the ratios for the most recent year (2018), discuss the financial health of the company. Your discussion should include your conclusions regarding its liquidity, indebtedness, efficiency with which it uses its assets and profitability. Link the ratios back to the business strategy and indicate if the ratios support the strategy or indicate areas of concern.
• Conduct a time-trend analysis and compare each ratio over the four years. Did the liquidity, leverage, asset utilization and profitability improve or deteriorate over time? Discuss your findings and does the tine-trend of the ratios support the strategy or indicate areas of concern.

• Based on your financial statement analysis, do the ratios and time trend look reasonable or do they indicate issues.

Calculate your order
275 words
Total price: $0.00

Top-quality papers guaranteed

54

100% original papers

We sell only unique pieces of writing completed according to your demands.

54

Confidential service

We use security encryption to keep your personal data protected.

54

Money-back guarantee

We can give your money back if something goes wrong with your order.

Enjoy the free features we offer to everyone

  1. Title page

    Get a free title page formatted according to the specifics of your particular style.

  2. Custom formatting

    Request us to use APA, MLA, Harvard, Chicago, or any other style for your essay.

  3. Bibliography page

    Don’t pay extra for a list of references that perfectly fits your academic needs.

  4. 24/7 support assistance

    Ask us a question anytime you need to—we don’t charge extra for supporting you!

Calculate how much your essay costs

Type of paper
Academic level
Deadline
550 words

How to place an order

  • Choose the number of pages, your academic level, and deadline
  • Push the orange button
  • Give instructions for your paper
  • Pay with PayPal or a credit card
  • Track the progress of your order
  • Approve and enjoy your custom paper

Ask experts to write you a cheap essay of excellent quality

Place an order