Create a Microsoft ExcelTM worksheet to present the major portions of the firm’s Consolidated Statements of Income. See the sample provided. You are not simply to copy the sample – make your own worksheet and do your own formatting and computations

ssignment: Company Analysis – Writing Assignment 1
You will have time to work on this assignment in class.
Purpose
To analyze a company’s external business communication documents.

Overview
According to the Syllabus, meeting all requirements for an assignment will earn you a grade of B. The B grade indicates expected performance at the graduate level. To achieve a grade of B+ or better, your work should cover all main points of an assignment, demonstrate a clear and concise organized thought process, incorporate various levels of creativity, include additional resources and experiences into the assignment, and contain no noticeable grammatical, typographical, or spelling errors.
A grading rubric, which will be used by your professor, is included with each assignment. Carefully review each rubric to make sure you have addressed all the criteria before submitting your assignment. Most of the rubrics include the following general criteria in addition to the specific criteria for each assignment.
• Integrates established business communication principles.
At the graduate level, you must support your work with established principles in the field. Citations are required.
• Synthesizes relevant information and material to provide evidence of critical thought.
At the graduate level, you must demonstrate that you have the ability to combine various elements to form a coherent whole – not simply stating facts. You also must demonstrate that you have the ability to examine a situation from diverse perspectives before reaching a conclusion.
• Develops ideas with clarity and logic.
At the graduate level, you must demonstrate that you can present your message in a clear and logical manner and not have your message obscured by disorganized facts and information.
In this assignment you will be using a tool called turnitin.com. This tool allows you to check your paper for potential plagiarism before submitting your paper for a grade. Use the results of the originality report to modify your paper as needed before submitting.

Scenario: Your supervisor has asked you to explore a company that your organization is thinking about purchasing. Your job is to begin an initial analysis of the company. You will write a professional email to your supervisor that describes your findings.

Note: This is an individual assignment.
Action Items
1. Review Table 7.1 Tips for Effective Email Messages in your textbook.
2. Review the grading rubric for this assignment.
3. Go to the discussion topic, “Company Assignment”, and see which company your professor has assigned you to analyze for this assignment.
4. Read the two most recent annual reports of the company you have been assigned.
a. Go to the company’s website. Typically, the annual report will be stored on the Investor Relations page of the company’s website.
b. Locate and read the last two annual reports of the company as indicated.
c. Read other reports and press releases posted by the company.
5. Locate the Consolidated Statements of Income (also known as the Income Statement), Balance Sheet and Statement of Cash Flows in the most current annual report. Print them out, or if the firm offers downloadable copies, download them and save to your computer.
Note: You will need the Consolidated Statements of Income for this assignment. Data from the Balance Sheet and Statement of Cash Flows will be used in Write 2: Handout (in-class) .
6. Create a Microsoft ExcelTM worksheet to present the major portions of the firm’s Consolidated Statements of Income. See the sample provided. You are not simply to copy the sample – make your own worksheet and do your own formatting and computations. Format the Excel document to print in landscape view. See the sample for an example of how to set up the reports and the calculations you are to perform.
Note: You will likely note some extra items on the Consolidated Statements of Income – things that you do not know what to do with. Most of these are non-operating expenses or income that should be captured as such, following the sample provided. The items you are most concerned with will be clearly labeled as such