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...

• Homework Help
• 13

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

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
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

Subscribe to view the full document.

• Fall '08
• Olander

What students are saying

• 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.

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

• 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.

Dana University of Pennsylvania ‘17, Course Hero Intern

• 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.

Jill Tulane University ‘16, Course Hero Intern