In excel format...

If more information is needed from the book it can be found here:

https://books.google.com/books?id=X0rW2epSKAMC&printsec=frontcover&dq=accounting+for+managers+pete+m&hl=en&sa=X&ved=0ahUKEwj9ydeinI_WAhUExlQKHZPvBzgQ6AEIKDAA#v=twopage&q&f=false

Problem 1-2 Given the following data from the Coca-Cola Company (amounts in millions of dollars): 2007 $28,857 20984 7,873 Income Statement Revenues Expenses Pretax income Income ax expenses Net income $5,981 Balance Sheets 2006 2,440 27.523 29,963 2007 Cash and cash equivalents All other assets Total asset:s 39,176 Total liabilities Total shareholders' equity Total liabilities and shareholders' equity 21,525 13,043 21744 $29,963 Statement of Cash Flows Cash flows from operating activities Cash flows from investing activities Cash flows from financing activities 2007 7,150 (6,719) 1,222 $1,653 Net increase in cash Required: Determine the following missing 2007 financial statement amounts: 1. Total liabilities and shareholders' equity 2. Total assets 3. Cash and cash equivalents (using 2007 balance sheet data) 4. Cash and cash equivalents (using 2006 cash balance and 2007 statement of cash flows data)