FIN Excel Module 1 Design Formatting.xlsx - INCOME STATEMENTS(In millions except per share amounts Year Ended June 30 Revenue Operating expenses Cost of

FIN Excel Module 1 Design Formatting.xlsx - INCOME...

This preview shows page 1 - 6 out of 6 pages.

INCOME STATEMENTS (In millions, except per share amounts) 2011 2010 2009 Revenue $ 69,943 $ 62,484 $ 58,437 Operating expenses: Cost of revenue 15,577 12,395 12,155 Research and development 9,043 8,714 9,010 Sales and marketing 13,940 13,214 12,879 General and administrative 4,222 4,063 4,030 Total operating expenses $ 42,782 $ 38,386 $ 38,074 Operating income $ 27,161 $ 24,098 $ 20,363 Other income (expense) 910 915 -542 Income before income taxes $ 28,071 $ 25,013 $ 19,821 Provision for income taxes 4,921 6,253 5,252 Net income $ 23,150 $ 18,760 $ 14,569 Earnings per share: Basic 2.73 2.13 1.63 Diluted 2.69 2.1 1.62 Weighted average shares outstanding: Basic 8,490 8,813 8,945 Diluted 8,593 8,927 8,996 Cash dividends declared per common share 0.64 0.52 0.52 Year Ended June 30,
Image of page 1

Subscribe to view the full document.

ANCE SHEETS (In millions) 2011 2010 Assets $ $ 5,505 43,162 31,283 52,772 36,788 June 30, Curren t assets: h and cas h equi vale 9,610 m inve stm ents (incl udin g sec uriti es loan ed of $1,1 81 i v a l e n t s , a n d s h o rt
Image of page 2
14,987 13,014 1,372 740 2,467 2,184 3,320 2,950 74,918 55,676 8,162 7,630 10,865 7,754 12,581 12,394 744 1,158 1,434 1,501 s rece ivab le, net of allo wan ce for dou btful acc ount s of $33 3 and Inve ntori es Def erre
Image of page 3

Subscribe to view the full document.

Image of page 4
Image of page 5

Subscribe to view the full document.

Image of page 6

Unformatted text preview: d inco me taxe s Oth er u r r e n t Propert y and equipm ent, net of accum ulated depreci ation of $9,829 and $8,629 Equity and other invest ments Goodw ill Intangi ble assets, net Other long-term assets $ 108,704 $ $ 4,197 $ 4,025 1,000 3,575 3,283 580 1,074 15,722 13,652 1,208 182 3,492 2,931 28,774 26,147 86,113 Liabilit ies and stockh olders’ equity Curren t liabilitie s: Acc ount s pay able Sho rt-ter m debt Acc rue d com pen sati on Inco me taxe s rt-ter m une arn ed reve Sec uriti es lend ing pay able Oth er r r e n t li 11,921 4,939 1,398 1,178 1,456 229 8,072 7,445 51,621 39,938 63,415 62,856 Long-term debt Long-term unearn ed revenu e Deferr ed income taxes Other long-term liabilitie s Commi tments and conting encies Stockh olders’ equity: on stoc k and paid-in capi tal – shar es auth oriz ed 24,0 00; outs tand ing 8,37 6 and (6,332 (16,681 57,083 46,175 $ 108,704 $ 86,113 defi cit, incl udin g acc umu late d othe r com pre hen sive inco me of $1,8 63 ) )...
View Full Document

  • Fall '08
  • Olander

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes