Assignment ContentPurpose of AssignmentThe activity requires students to perform research and analysis on competing companies and the potential implications of international standards. This real-world analysis is key to understanding how a companys profitability, liquidity, and solvency can be useful for all users. Students also learn to analyze financial statements and use managerial tools to make decisions from an investors and creditors standpoint.This is a comprehensive assessment of weeks 1-3. You will utilize your learned skills to develop an analysis of 2 companies.week 3 grading rubric.docAssignment StepsYOU MAY NOT USE STARBUCKS AND DUNKIN DONUTS FOR THIS ASSIGNMENT.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 retrieve 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.Developamaximum500-wordAPA Formatted 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.Includea working link to the four financial statements along with your assignment , clearly indicated.Formatyour assignment consistent with APA guidelinesUSING THE APA TEMPLATE PAPER I PROVIDED.paper template.docSUBMIT your paper and excel spreadsheet.