Explain the components of this spreadsheet and findings. Give financial recommendation for forecasting regarding future profits, liabilities, assets, a deficient etc.
4 (in millions) 5 December 31 2011 June 30, 2011 6 7 Assets 10,610 5 9,610 41,126 43,162 51,736 52.772 13,643 1,351 2,169 3,614 72,513 14.987 1,372 2,467 3,320 74,910 8,010 7.550 19,670 2,581 1,919 112,243 8,162 10,565 12,581 744 1,434 108,704 5 8 Current assets: 9 Cash and cash equivalents Short-term investments including securities loaned 10 of $831 and $1,181) Total cash, cash equivalents, and short-term 11 Investments Accounts receivable, net of allowance for doubtful 12 accounts of $321 and $333 13 Inventories 14 Deferred income taxes 15 Other 16 Total current assets Property and equipment, net of accumulated depreciation 17 of $10,546 and 9,99 18 Equity and other investments 19 Goodwill 20 Intangible assets, net 21 other long-term assets 22 Total assets 23 24 Uablities and stockholders' equity 25 Current liabilities: 26 Accounts payable 27 Accrued compensation 28 Income taxes 29 Short-term earned revenue 30 Securities lending payable 31 Other 32 Total current abilities 33 Long term det 34 Long term reamed revenue 35 Deferred income taxes 36 other long term liabilities 37 Total abilities 38 commitments and contingencies 39 Stockholders equity Common stock and paid in capital-shares authorized 40 24,00 outstanding 8,382 and 8,376 Retained earrings (oficit, including accumulated other 41 comprehensive income of $826 and 51,565 42 Total stockholders' equity 43 Totalities and stockholders equity $ 4197 3,884 2,677 921 13,985 849 3,057 25,373 11,932 3,575 $80 15,722 1,200 1,492 28,774 11,921 1,390 1,456 31,072 1,082 8,386 48,122 51.621 63,902 219 54,121 112,243 (6,330) 57,000 10,704 $ 44 4 (in millions) 5 December 31 2011 June 30, 2011 6 7 Assets 10,610 5 9,610 41,126 43,162 51,736 52.772 13,643 1,351 2,169 3,614 72,513 14.987 1,372 2,467 3,320 74,910 8,010 7.550 19,670 2,581 1,919 112,243 8,162 10,565 12,581 744 1,434 108,704 5 8 Current assets: 9 Cash and cash equivalents Short-term investments including securities loaned 10 of $831 and $1,181) Total cash, cash equivalents, and short-term 11 Investments Accounts receivable, net of allowance for doubtful 12 accounts of $321 and $333 13 Inventories 14 Deferred income taxes 15 Other 16 Total current assets Property and equipment, net of accumulated depreciation 17 of $10,546 and 9,99 18 Equity and other investments 19 Goodwill 20 Intangible assets, net 21 other long-term assets 22 Total assets 23 24 Uablities and stockholders' equity 25 Current liabilities: 26 Accounts payable 27 Accrued compensation 28 Income taxes 29 Short-term earned revenue 30 Securities lending payable 31 Other 32 Total current abilities 33 Long term det 34 Long term reamed revenue 35 Deferred income taxes 36 other long term liabilities 37 Total abilities 38 commitments and contingencies 39 Stockholders equity Common stock and paid in capital-shares authorized 40 24,00 outstanding 8,382 and 8,376 Retained earrings (oficit, including accumulated other 41 comprehensive income of $826 and 51,565 42 Total stockholders' equity 43 Totalities and stockholders equity $ 4197 3,884 2,677 921 13,985 849 3,057 25,373 11,932 3,575 $80 15,722 1,200 1,492 28,774 11,921 1,390 1,456 31,072 1,082 8,386 48,122 51.621 63,902 219 54,121 112,243 (6,330) 57,000 10,704 $ 44