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.
Top-quality papers guaranteed
100% original papers
We sell only unique pieces of writing completed according to your demands.
Confidential service
We use security encryption to keep your personal data protected.
Money-back guarantee
We can give your money back if something goes wrong with your order.
Enjoy the free features we offer to everyone
-
Title page
Get a free title page formatted according to the specifics of your particular style.
-
Custom formatting
Request us to use APA, MLA, Harvard, Chicago, or any other style for your essay.
-
Bibliography page
Don’t pay extra for a list of references that perfectly fits your academic needs.
-
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
What we are popular for
- English 101
- History
- Business Studies
- Management
- Literature
- Composition
- Psychology
- Philosophy
- Marketing
- Economics