Compute the quick ratio using the balance sheet

Assignment Help Corporate Finance
Reference no: EM131036998

Ratio Analysis Assignment

Choose a public company for which financial data are available. Avoid service companies such as AT&T, Sprint, Verizon, etc. Each student works with a different company.Use the most recent period data available for the computations. You need to get your company selection authorized by me.

1. In your own words, write a brief (one paragraph) description of the company. Copying from the company's reports is not acceptable.

2. Collect data on the company's balance sheet and income statement for the latest year. Copy them on an Excel file. This is required. Attach relevant pages from the company book/website with your submission.

3. Using MS Excel, compute (not just report from a source) the following ratios using the balance sheet and income statement data you collected

1. Quick ratio
2. Inventory turnover
3. Debt ratio
4. Net profit margin
5. Return on Investment (or assets)
6. Return on equity
7. P/E ratio

4. Compute ROI and ROE using Du Pont Analysis (not using the definition).

NOTE: Use Ms Excel for both the report (#1) and the computationsand submit via e-Courses. Make one worksheet (or tab) for the report (#1 above) and another one for the computations. The computations should be verifiable by pointing the cursor to the cell where the result is recorded. Report data sources at the end and cite all references used.

Submission in MS Word or any other software will not be accepted

Resources:

1. Company website
2. www.finance.yahoo.com
3. www.hoovers.com
4. www.moneycentral.msn.com
5. Google.

Reference no: EM131036998

Questions Cloud

Evolving in healthcare operations management : What are some of the key trends that are evolving in healthcare operations management? How are systems and technology streamlining the operations within the departments that are support services? How is healthcare reform impacting the operations m..
What is the cost of the stock in the riskless portfolio : What is the cost of the stock in the riskless portfolio? What is the present value in the riskless portfolio? What is the value of the firm's call option? What assumptions in this analysis might not hold in the real world?
Problem regarding the economic profit : At the end of the first year of operating her new business, Mary's accountant reported an accounting profit of $150,000. What was Mary's economic profit?
Discuss the implications of accepting the def corp : Using the other concepts, theories and other materials covered in this class discuss the implications of accepting the DEF Corp. part-time offer. You need not have any knowledge of employment law, trade secret law or intellectual property law gene..
Compute the quick ratio using the balance sheet : Compute the following ratios using the balance sheet and income statement data you collected- Quick ratio, Inventory turnover, Debt ratio, Net profit margin, Return on Investment (or assets), P/E ratio and Return on equity.
Not all companies are viewed as equal : In the land of free trade, the public does not view all industries as equal. Do you believe that is ethical? Do you believe that some industries are unfairly targeted? Should it be consumers' choice to partake in products that are not healthy for ..
Discuss one weakness and one strength of the study : What is the research problem and purpose of the study? What were the research methods used? Explain what "double-blinded" means in regards to the study.
Problem regarding the emotional intelligence : Recommend a strategy that the organization could undertake in order to improve the social skills of leaders within the organization and thereby positively influence their emotional intelligence. Support your recommendation with specific examples t..
True capacity to measure performance : Which units of government have developed the true capacity to measure performance? By what means do they achieve this goal? What new systems, tools, or techniques are required to measure performance effectively?

Reviews

Write a Review

 

Corporate Finance Questions & Answers

  Prepare an analysis that shows whether

Cobe Company has already manufactured 28,000 units of Product A at a cost of $ 28 per unit.

  Preparing an analysis of the market

Create your portfolio. First, set out your investment objectives and decide how much risk you are willing to take. You may invest for yourself or for an imaginary client.

  Q1 what are your cash flows on 6152010 and 12152010 are

q1. what are your cash flows on 6152010 and 12152010? are there any other cash flows? remember to indicate the

  What is the total cost to the firms original investors

What is the total cost to the firm's original investors due to market imperfections from the IPO - What will the value of the whole firm be after this investment (the post-money valuation)?

  Financial scandal

If a financial institution is caught up in a financial scandal, would one expect its value to fall by more or less than the amount of any fines and settlement payments?

  Compare typical compensation and incentive arrangements

Compare typical compensation and incentive arrangements for (a) top management, for example, the CEO or CFO, and (b) plant or division managers. What are the chief differences?

  Great lake clinic has been asked to provide exclusive

great lake clinic has been asked to provide exclusive healthcare services for next years world exposition. although

  What is the size of the industry

what is the size of the industry and how is the industry segmented - what is the industry's projected growth and profitability?

  1mark sexton and todd story the owners of samps air have

1mark sexton and todd story the owners of samps air have decided to expand their operations. they instructed their

  Describe alternative measures of a firms overall performance

Describe some alternative measures of a firm's overall performance. What are their advantages and disadvantages? In each case discuss what benchmarks you might use to judge whether performance is satisfactory.

  Valuation of inventory

Accounts officers at Xerox Company found that significant errors have been made in the evaluation of inventory & are worried that it might have important impact on net income and EPS.

  What type of chart is this

What type of price information does it show, what is the prevailing trend and what does the blue line represent

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