Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a series of common sized income statements for all prior years. Show work in excel!!! Income Statements (USD in millions) 2011 2012 2013 2014
Create a series of common sized income statements for all prior years. Show work in excel!!!
| Income Statements | |||||
| (USD in millions) | 2011 | 2012 | 2013 | 2014 | 2015 |
| Revenue | $ 43,218.00 | $ 46,061.00 | $ 48,607.00 | $ 47,142.00 | $ 49,161.00 |
| Cost of revenue | $ (16,682.00) | $ (17,852.00) | $ (19,167.00) | $ (19,373.00) | $ (19,480.00) |
| Gross profit | $ 26,536.00 | $ 28,209.00 | $ 29,440.00 | $ 27,769.00 | $ 29,681.00 |
| Research and development | $ (5,823.00) | $ (5,488.00) | $ (5,942.00) | $ (6,294.00) | $ (6,207.00) |
| Sales, general and administrative | $ (11,720.00) | $ (11,969.00) | $ (11,802.00) | $ (11,437.00) | $ (11,861.00) |
| Restructuring, merger and acquisition | $ (799.00) | $ (304.00) | $ (105.00) | $ (418.00) | $ (484.00) |
| Operating income | $ 8,194.00 | $ 10,448.00 | $ 11,591.00 | $ 9,620.00 | $ 11,129.00 |
| Interest expense | $ (628.00) | $ (596.00) | $ (583.00) | $ (564.00) | $ (566.00) |
| Income before taxes | $ 7,566.00 | $ 9,852.00 | $ 11,008.00 | $ 9,056.00 | $ 10,563.00 |
| Provision for income taxes | $ (1,335.00) | $ (2,118.00) | $ (1,244.00) | $ (1,862.00) | $ (2,220.00) |
| Net income | $ 6,231.00 | $ 7,734.00 | $ 9,764.00 | $ 7,194.00 | $ 8,343.00 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started