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