Ratio analysis

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.