Financial Accounting Homework
Compaies list-
Banking: Goldman Sachs, Chase
Industrial: Caterpillar, Exxon
Technology: Apple, IBM
Create a single Excel file with 3 Sheets, one for each pair of companies and their 3 years of data for easier comparison;
Find the Financial Statements for years 13, 14, 15 for all 6 companies;
Identify the numbers needed for filling in the pre-formatted Excel spreadsheet "Ratio-Analysis-Spreadsheet" and "run" the numbers to obtain the ratios.
(The best and first resource for the company financial statements are their home pages. Look at the caterpillar home page and find the "10K" yearly financial report; in that report you will for example find that Income form Sales (of products) and Revenue (from maintenance) was $47b; you will also find that their profit was "only" $2.5b; when you plug those numbers into the equation for the ratio "Gross Profit Margin", you will get something like 4%.)