Construct Pro forma balance sheets and statements of cash flow for the next 5 years
BALANCE SHEET (USD in millions) Year End 2017 Assets Current assets Liabilities Current liabilities Short-term debt $ 3,897.00 Non-current liabilities Cash and cash equivalents $ 6,877.00 Short-term investments $ 53,539.00 Total current assets $ 60,416.00 Long-term debt $ 21,457.00 $ 25,354.00 Total liabilities Non-current assets Gross property, plant and equipment $ 12,427.00 Accumulated Depreciation $ 19,095.00) Total non-current assets $ 3,332.00 Stockholders' equity Common stock Retained earnings Total stockholders' equity $ 22,340.00 $ 16,054.00 $ 38,394.00 Total assets $ 63,748.00 Total liabilities and stockholders' equity $63,748.00 Income Statements (USD in millions) Revenue Cost of revenue Gross profit Research and development Sales, General and administrative Restructuring, merger and acquisition Operating income Interest Expense Income before taxes Provision for income taxes Net income 2013 2014 2015 2016 2017 $ 43,218.00 $ 46,061.00 $ 48,607.00 $ 47,142.00 $ 49,161.00 $(16,682.00) $(17,852.00) $(19,167.00) $(19,373.00) $(19,480.00) $ 26,536.00 $ 28,209.00 $ 29,440.00 $ 27,769.00 $ 29,681.00 $ (5,823.00) $ (5,488.00) $ (5,942.00) $ (6,294.00) $ (6,207.00) $(11,720.00) $(11,969.00) $(11,802.00) $(11,437.00) $(11,861.00) $ 1799.00) $ (304.00) $ (105.00) $ (418.00) $ (484.00) $ 8,194.00 $ 10,448.00 $ 11,591.00 $ 9,620.00 $ 11,129.00 $ (628.00) $ (596.00) $ (583.00) $ (564.00) $ (566.00) $ 7,566.00 $ 9,852.00 $ 11,008.00 $ 9,056.00 $ 10,563.00 $ (1,335.00) $ (2,118.00) $ (1,244.00) $ (1,862.00) $ (2,220.00) $ 6,231.00 $ 7,734.00 $9,764.00 $ 7,194.00 $ 8,343.00 BALANCE SHEET (USD in millions) Year End 2017 Assets Current assets Liabilities Current liabilities Short-term debt $ 3,897.00 Non-current liabilities Cash and cash equivalents $ 6,877.00 Short-term investments $ 53,539.00 Total current assets $ 60,416.00 Long-term debt $ 21,457.00 $ 25,354.00 Total liabilities Non-current assets Gross property, plant and equipment $ 12,427.00 Accumulated Depreciation $ 19,095.00) Total non-current assets $ 3,332.00 Stockholders' equity Common stock Retained earnings Total stockholders' equity $ 22,340.00 $ 16,054.00 $ 38,394.00 Total assets $ 63,748.00 Total liabilities and stockholders' equity $63,748.00 Income Statements (USD in millions) Revenue Cost of revenue Gross profit Research and development Sales, General and administrative Restructuring, merger and acquisition Operating income Interest Expense Income before taxes Provision for income taxes Net income 2013 2014 2015 2016 2017 $ 43,218.00 $ 46,061.00 $ 48,607.00 $ 47,142.00 $ 49,161.00 $(16,682.00) $(17,852.00) $(19,167.00) $(19,373.00) $(19,480.00) $ 26,536.00 $ 28,209.00 $ 29,440.00 $ 27,769.00 $ 29,681.00 $ (5,823.00) $ (5,488.00) $ (5,942.00) $ (6,294.00) $ (6,207.00) $(11,720.00) $(11,969.00) $(11,802.00) $(11,437.00) $(11,861.00) $ 1799.00) $ (304.00) $ (105.00) $ (418.00) $ (484.00) $ 8,194.00 $ 10,448.00 $ 11,591.00 $ 9,620.00 $ 11,129.00 $ (628.00) $ (596.00) $ (583.00) $ (564.00) $ (566.00) $ 7,566.00 $ 9,852.00 $ 11,008.00 $ 9,056.00 $ 10,563.00 $ (1,335.00) $ (2,118.00) $ (1,244.00) $ (1,862.00) $ (2,220.00) $ 6,231.00 $ 7,734.00 $9,764.00 $ 7,194.00 $ 8,343.00
