Reference no: EM131852964
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 MARRIOTT !!
Berkshire Hathaway Corporation
PepsiCo Corporation
Procter and Gamble Corporation
General Electric Corporation
USE MARRIOTT PLEASE
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.
|
What is after-tax accumulation
: In 2016, Nina contributes 10 percent of her $100,000 annual salary to her 401(k) account. She expects to earn a 6 percent before-tax rate of return.
|
|
What are qualities that may help a living organism survive
: What are some qualities that may help a living organism survive? Why do you think these qualities are important?
|
|
What was the income from operations
: If the contribution margin ratio for Ernie Company is 62%, sales were $878,000, and fixed costs were $391,940, what was the income from operations?
|
|
Dam on the feather river at oroville
: A spillway is being designed for a dam on the Feather River at Oroville, California (Prob. 1.7). The problem is to make the most reliable forecasts
|
|
Calculate a companys financial ratios and their comparison
: How to use the financial information and tools learned in the class on a public company, obtain public company SEC reports.
|
|
Describe the differences between the contracts
: HRM 0110 — HR Legislation analyze contract terms and demonstrate your understanding by identifying the implications for an employer based on the terms
|
|
Propose a logical hypothesis test
: (a) Propose a logical hypothesis test, i.e., a logical statistic and a reasonable form for the operating rule.
|
|
Analyze why the article caught your attention
: Analyze why the article caught your attention. Relate the article to your life and to issues that are important to you.
|
|
Discuss about an inappropriate long-term capital investment
: Describe a real or hypothetical situation in which a business made an inappropriate long-term capital investment decision and its apparent underlying causes
|