companys operations
The assignment is already started but needs some help in completing.
The Vice President of Finance called you into a meeting to discuss the overall vision and future of your company. He states that he has always admired International Business Machines (IBM) since he studied the company in college. The VP has not followed the company as of late and would like you to prepare an update as to how IBM is doing over last three years and the top line outlook for next year. The VP would like you to use similar techniques that you have used in writing your previous reports.
Instructions
Using the financial statements of International Business Machines Corporation:
- Use Mergent Onlineto download income statement to Excel.
-
Using the line item descriptions from the income statement, create a new tab and identify which expenses (costs) are likely fixed, variable, product, and period costs. - Using Mergent Online, create a ratio analysis report showing International Business Machines Corporation and its largest 4 competitors based on total revenue
- Using the historical income statement data, prepare a sales (revenue) forecast for the upcoming year including your assumptions, calculations, and rationale.
- Using the SEC.gov website, find articles on of International Business Machines Corporation and comment in a Word document on any recent accounting standards or ethical considerations that affect the company.
Rubric:
|
F |
F |
C |
B |
A |
|
0 |
1 |
2 |
3 |
4 |
|
Did not Submit |
No Pass |
Competence |
Proficiency |
Mastery |
|
Not Submitted |
Did not prepare an income statement vertical and horizontal analysis using three years of data. |
Prepared a basic income statement vertical and horizontal analysis using three years of data. |
Prepared a comprehensive income statement vertical and horizontal analysis using three years of data. |
Prepared a detailed income statement vertical and horizontal analysis using three years of data. |
|
Not Submitted |
Did not use the items from the income statement to identify which expenses (costs) are likely fixed, variable, product, and period costs. |
Provided a basic identification of which expenses (costs) are likely fixed, variable, product, and period costs from the income statement. |
Provided a summary of which expenses (costs) are likely fixed, variable, product, and period costs from the income statement. |
Provided a detailed identification of which expenses (costs) are likely fixed, variable, product, and period costs from the income statement. |
|
Not Submitted |
Did not create a ratio analysis report showing International Business Machines Corporation and its largest 4 competitors based on total revenue. |
Created a basic ratio analysis report showing International Business Machines Corporation and its largest 4 competitors based on total revenue. |
Created a summarized ratio analysis report showing International Business Machines Corporation and its largest 4 competitors based on total revenue. |
Created a detailed ratio analysis report showing International Business Machines Corporation and its largest 4 competitors based on total revenue. |
|
Not Submitted |
Did not prepare a sales (revenue) forecast for the upcoming year including assumptions, calculations, and rationale. |
Prepared a basic sales (revenue) forecast for the upcoming year including assumptions, calculations, and rationale. |
Prepared an elaborative sales (revenue) forecast for the upcoming year including assumptions, calculations, and rationale. |
Prepared a detailed sales (revenue) forecast for the upcoming year including assumptions, calculations, and rationale. |
|
Not Submitted |
Did not provide basic comments on recent accounting standards or ethical considerations that affect IBM. |
Provided basic comments on recent accounting standards or ethical considerations that affect IBM. |
Provided elaborate comments on recent accounting standards or ethical considerations that affect IBM. |
Provided very detailed comments on recent accounting standards or ethical considerations that affect IBM. |
