Review balance sheet and income statement in given company

Assignment Help Corporate Finance
Reference no: EM131442207

Assignemnt: Financial Ratio Analysis

Select a Fortune 500 Company from one of the following industries:

• Pharmaceutical
• Energy
• Retail
• Automotive
• Computer Hardware

Review the balance sheet and income statement in the company's 2015 Annual Report.

Calculate the following ratios using Microsoft Excel:

• Current Ratio
• Quick Ratio
• Debt Equity Ratio
• Inventory Turnover Ratio
• Receivables Turnover Ratio
• Total Assets Turnover Ratio
• Profit Margin (Net Margin) Ratio
• Return on Assets Ratio

Analyze in 1,050 words why each ratio is important for financial decision making.

Submit your analysis as well as your calculations.

Attachment:- Assignmt.xlsx

Reference no: EM131442207

Questions Cloud

Existence of a large underground economy : What social, political, and economic conditions might signal the existence of a large underground economy, and why should managers pay heed to such signals?
Analyze country risk assessments : Analyze country risk assessments. Why international companies perform country risk assessment?
What is the problem that needs fixing : An abstract is a concise summary of a larger project (a thesis, research report, performance, service project, etc.) that concisely describes the content and scope of the project and identifies the project's objective, its methodology and its find..
Indicators of nutrient deficiencies : Indicators of nutrient deficiencies.· Obesity rates or percentages: Compare to CDC statistics.· Affordability of food/available discounts or food programs and usage (e.g., WIC, food boxes, soup kitchens, meals-on-wheels, food sta..
Review balance sheet and income statement in given company : Review the balance sheet and income statement in the company's 2015 Annual Report. Calculate the following ratios using Microsoft Excel: Current Ratio and Quick Ratio.
Ideal capital structure : Do you feel they have chosen an ideal capital structure? What would you do to improve their structure if you could be CEO for a day?
Which assets are likely to decrease in value : The adoption of a consumption tax would have a significant effect on the market value of certain assets. Which assets are likely to decrease in value? Which to increase in value? Should the government do anything to compensate the losers or to tax..
Internet to be a useful tool for perpetrating crimes : Share your thoughts about people who have found the Internet to be a useful tool for perpetrating crimes, conducting terrorism, and even waging war. Link theories and statistics to your ideas and opinions when explaining how situations should be h..
Employee rights case study : Read the case study "Employee Rights Case Study" located in the unit Reading. Would firing Allen Lopez violate his civil rights? Explain why or why not using ethical reasoning and theory.

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd