Assignment Steps

Selecttwo competing companies, that areUS publicly traded,and locate annual reports for these two companies by going DIRECTLYTO THE COMPANY WEBSITES TO DOWNLOAD THE ANNUAL REPORT OR 10-K. DO NOT USE SUMMARY SITES.

Researchthe two companies on the Internet and download the Annual Reports with the Income Statement, Statement of Shareholders' Equity, Balance Sheet, and Statement of Cash Flows.

IN EXCEL:

• Make a 5-year trend analysis for each company. Here is an example.
• Net sales.
• Net income.

• Compute forthe two most recent yearsthe:
• Debt to assets ratio.

• Compute fortwo most recent yearsthe:
• Profit margin.
• Asset turnover.
• Return on assets.

Developa Paper in a word documentand include the following:

• If you were a creditor, which company would you be more likely to lend money to? Why?
• Which company would you recommend as an investment?Why?
• At which company would you prefer a management position ?Why?
• Each of the above should be supported by the numbers you calculated in your excel spreadsheet .

Showyour work inExcel.All computations must be in excel cells and not typed in.

Completecalculations/computations usingExcel. Submit a separate spreadsheet-DO NOT embed it in your paper. I need to see your calculations. DO NOT just type numbers in- you need to set up formulas in excel. See the week 1 tutorial.

Includethe four financial statements along with your assignment or a working link, clearly indicated.