Deliverable 7 – Analyzing And Summarizing A Company’s Operations


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.


Using the financial statements of International Business Machines Corporation:

  1. 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.

    importantBe sure to search for International Business Machines Corp, and choose the United States entity.
    FAQ for accessing and downloading income statements

  2. 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.
  3. 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:

    1. Current Ratio
    2. Gross Margin
    3. Inventory % of TA
    4. Inventory Turnover
    5. Debt/Equity Ratio
    6. Net Current Assets % TA
    7. Net PPE % TA
    8. Net Profit Margin %
    9. Operating Margin %
    10. R + D % TR
    11. ROA %
    12. ROE %
    13. ROI %
    14. Selling and General Admin % TR
    15. Total Asset Turnover
  4. Using the historical income statement data, prepare a sales (revenue) forecast for the upcoming year including your assumptions, calculations, and rationale.
  5. Using the 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.

Calculate p(0) such that p(y) is normalised.

A PCM transmitter sends out a 12-bit serial digital signal with 5 V corresponding to a 1 and 0 V corresponding to a 0. The signal passes over a transmission….

estimate the probable number of errors if 1600 bits of information are transmitted.

Ten measurement signals are input to a multiplexer so that each one is sampled twice per second. The multiplexed signal is input to a serial digital transmitter incorporating a 10-bit….

Calculate the cost per equivalent unit of material and conversion cost for January

Calculate the cost per equivalent unit of material and conversion cost for January – using the Weighted Average Approach Units Materials Conversion Work in process January 1 2,500 50% 35%….