Select two public corporations in the same industry that are listed on a major s

Select two public corporations in the same industry that are listed on a major stock exchange.
 Go to their latest 10K filing with the SEC, financial statements, and footnotes.
 Provide these components of financial analysis supported by calculations from the financial data.
—————————————–
Here are some examples of competing public corporations:
 The Coca-Cola Company (KO) and PepsiCo. Inc. (PEP)
 The Proctor Gamble Company (PG) and Unilever N.V. (UN)
 General Electric (GE) and The Boeing Company (BA)
 The Walt Disney Company (DIS) and Comcast (CMCSA on the NASDAQ stock exchange)
 Pfizer (PFE) and Johnson & Johnson (JNJ)
———————————————————————————
Part 1 – Financial Analysis – Due Week 4
Use the current financial statements to complete the attached worksheet, to include calculations for the following ratios and your interpretation of these measures. ONLY COMPLETE PART 1 RATIOS of the excel.
1. Liquidity
i. The Current Ratio
ii. The Quick Ratio
iii. Net Working Capital (NWC) as a percent of Sales
2. Asset Management
i. Accounts Receivable Turnover
ii. Average Collection Period (days sales in A/R)
iii. Inventory Turnover
iv. Asset Turnover
3. Solvency
i. Debt/Equity
ii. Times Interest Earned
4. Profitability
i. The Profit Margin
ii. Return on Equity