Purpose of AssignmentStudents 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 Microsoft?Office?ÿwebsite. There are also additional tutorials via the web that offer support for office products.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 CorporationKroger CorporationHarley Davidson CorporationApple CorporationIntel CorporationMarriott CorporationBerkshire Hathaway CorporationPepsiCo CorporationProcter and Gamble CorporationGeneral Electric CorporationCalculateÿandÿanalyzeÿthe following ratios for your selected company for the last two years from the SEC Form 10-K:úÿÿÿÿÿÿÿÿ Current Ratioúÿÿÿÿÿÿÿÿ Debt Ratioúÿÿÿÿÿÿÿÿ Time Interest Earnedúÿÿÿÿÿÿÿÿ Gross Profit Marginúÿÿÿÿÿÿÿÿ Net Profit Marginúÿÿÿÿÿÿÿÿ Asset Turnoverúÿÿÿÿÿÿÿÿ Return on Assetsúÿÿÿÿÿÿÿÿ Equity Multiplierúÿÿÿÿÿÿÿÿ Return on Equity (Use three ratio DuPont method)All ratios should be calculated using data from the company’s financial statements in the 10-K Report.Specify what year financial data is being used (indicate the dates of the company’s fiscal year).

Leave a Reply

Your email address will not be published.