FIN Excel Module 3 Practice.xlsx - Fill Across Columns Jan Feb Mar Apr May Jun Jul Aug Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Lesson 1 Lesson 2

FIN Excel Module 3 Practice.xlsx - Fill Across Columns Jan...

This preview shows page 1 - 4 out of 13 pages.

Fill Across Columns Jan Feb Mar Apr May Jun Jul Aug Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Lesson 1 Lesson 2 Lesson 3 Lesson 4 Lesson 5 Lesson 6 Lesson 7 Lesson 8 Sequental Numbers 1 2 3 4 10 20 30 40 50 60 70 80 Fill Down Rows January February March April May June July August September October November December
Image of page 1

Subscribe to view the full document.

Sep Oct Nov Dec Lesson 9 Lesson 10 Lesson 11 Lesson 12 Lesson 13 Lesson 14 Lesson 15 90 100
Image of page 2
INCOME STATEMENTS (In millions, except per share amounts) 2011 2010 2009 2008 2007 Revenue 69,943 62,484 58,437 60,420 51,122 Operating expenses: Cost of revenue 15,577 12,395 12,155 11,598 10,693 Research and development 9,043 8,714 9,010 8,164 7,121 Sales and marketing 13,940 13,214 12,879 13,039 11,455 General and administrative 4,222 4,063 4,030 5,127 3,329 Total operating expenses 42,782 38,386 38,074 37,928 32,598 Operating income 27,161 24,098 20,363 22,492 18,524 Other income (expense) 910 915 -542 1,322 1,577 Income before income taxes 28,071 25,013 19,821 23,814 20,101 Provision for income taxes 4,921 6,253 5,252 6,133 6,036 Net income 23,150 18,760 14,569 17,681 14,065 Earnings per share: Basic 2.73 2.13 1.63 1.9 1.44 Diluted 2.69 2.1 1.62 1.87 1.42 Weighted average shares outstanding: Basic 8,490 8,813 8,945 9,328 9,742 Diluted 8,593 8,927 8,996 9,470 9,886 Cash dividends declared per common share 0.64 0.52 0.52 0.44 0.4
Image of page 3

Subscribe to view the full document.

Image of page 4
  • 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