Scenario
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 excel spreadsheet that is attached:
Prepare an income statement vertical and horizontal analysis of International Business Machines Corporation using three years of data. Use Mergent Online to download income statement to Excel.
Be sure to search for International Business Machines Corp, and choose the United States entity.FAQ for accessing and downloading income statements
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
Download the following ratios and peer average into Excel. Format and arrange the data in a professional manner:
Current Ratio
Gross Margin
Inventory % of TA
Inventory Turnover
Debt/Equity Ratio
Net Current Assets % TA
Net PPE % TA
Net Profit Margin %
Operating Margin %
R + D % TR
ROA %
ROE %
ROI %
Selling and General Admin % TR
Total Asset Turnover
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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more