Identify the numbers needed for filling

Assignment Help Financial Accounting

Reference no: EM131241398

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%.)

Reference no: EM131241398

Questions Cloud

Calculate the initial consumer surplus and producer surplus : Consider the market for Canadian maple syrup. The demand and supply functions for Canadian maplesyrup are given by: Find the initial equilibrium price and quantity of Canadian maple syrup. Calculate the initial consumer surplus (CS) and producer surp..

Market for aluminum rods the demand and supply functions : Suppose that in the market for aluminum rods the demand and supply functions are given by: Find the initial equilibrium price and quantity. Calculate the initial consumer surplus (CS) andproducer surplus (PS). Suppose the government imposes a price f..

How a company generates revenue : Managers decide to increase the number of new accounts by 4.0% within the next quarter - How a company generates revenue from its assets is referred.

Identify the numbers needed for filling : 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.

Consider subway company whose cost function : Consider a subway company whose cost function is given by C(T) - 1000 + T. Due to the government regulation, this company must set the fare per passenger at the marginal cost (MC pricing). Is this pricing efficient? Would this company run the busines..

When is it impossible to avoid agreement protocols : When is an event set π/?-precedent? What is an agreement protocol? Why should we try to avoid agreement protocols in real-time systems? When is it impossible to avoid agreement protocols?

Evaluate the strengths and weaknesses of smiths reasons : How should depreciation be recorded? Do you support Biles or Smith? Evaluate the strengths and weaknesses of Smith's reasons for preferring his method.

What is your expected rate of return : A house up for auction can be worth either $500,000 or $1,000,000 with 50-50 probability. The other bidders know the true value; you do not. If you bid for the house in an auction, what should you bid? If you bid $750,000, what is your expected ra..

User Account

All Pages