Question
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
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 Exceland Word functions can be found on the MicrosoftOfficewebsite. There are also additional tutorials via the web that offer support for office products.
Selectone 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
Calculateandanalyzethe 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)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started