How to use the financial information and tools learned

Reference no: EM131579375

Assignment

Purpose of Assignment

Students should understand how to use the financial information and tools learned in the class on a public company, obtain public company SEC reports, and use that data to calculate a company's financial ratios and their comparison to industry or competitor standards.

Assignment Steps

Resources: Tutorial help on Excel and Word functions can be found on the MicrosoftOffice website. There are also additional tutorials via the web that offer support for office products.

Select one of the publicly traded corporations listed below and obtain the most current SEC Form 10-K (annual financial report) from the company's web site (Do not use the Annual Report that is sent to shareholders):

• Lowes Corporation
• Kroger Corporation
• Harley Davidson Corporation
• Apple Corporation
• Intel Corporation
• Marriott Corporation
• Berkshire Hathaway Corporation
• PepsiCo Corporation
• Procter and Gamble Corporation
• General Electric Corporation

Calculate and analyze the following ratios for your selected company for the last two years from the SEC Form 10-K:

• Current Ratio
• Inventory Turnover
• Debt Ratio
• Time Interest Earned
• Gross Profit Margin
• Equity Multiplier
• Return on Assets
• Net Profit Margin
• Return on Equity (Use three ratio DuPont method)

Compare and contrast your company's ratios to industry and competitor standard ratios obtained from Yahoo Finance, Morningstar, MotleyFool, Macroaxis or other Internet sources, and provide a detailed answer and analysis as to why your company's ratios are different than the industry/competitor standard.

Prepare your analysis in a minimum of 875 words in Microsoft Word. The use of Microsoft Word tables is encouraged.

Cite the source of the industry/competitor ratio information.

Format your assignment consistent with APA guidelines.

Reference no: EM131579375

Questions Cloud

Create a brief social history : To create a social history document, it should be a collaborative process with the client, in order to make recommendations for actions to resolve the issue.

Draw the graph with the same vertex set and edge set : In the graph G of Figure 6.22, let M1 be the matching {l, 1}, {s, 2}, {t, 4}, {m, 5}, {e, 6}, {b, 9}, {f, 8}, and let M2 be the matching.

Explain the road not taken : Do not use the same poems you used previously for your initial post in weeks three and four.

What will be the net cash flow for year one of project : Your company has spent $240,000 on research to develop a new computer game. What will be the net cash flow for year one of this project?

How to use the financial information and tools learned : Students should understand how to use the financial information and tools learned in the class on a public company and obtain public company SEC reports.

What would be the pre-money and post money valuation : What percentage ownership at times 0 should the investors demand for their $5 million dollar investment? What would be the pre-money and post money valuation?

What documentary are you reviewing : What documentary are you reviewing?Was the topics covered in the film covered in a balanced way? How could it have been covered in a more fair way?

Determine the net effect of this plan on the pretax profits : Determine the net effect of this plan on the pretax profits of Bimbo. Assume there are 365 days per year.

Draw graph for sample job application data : Table shows a second sample of the kinds of applications a school district might get for its positions. Draw a graph as before and use it to help you decide.

User Account

All Pages