Module3 - This workbook contains some new data for you to...

Info icon This preview shows pages 1–4. Sign up to view the full content.

This workbook contains some new data for you to practice what you learned in module 3. Copy Sheet This sheet contains data that you will copy. Paste Values Paste the data from the copy sheet using the Paste Values command. Adjust the column widths to fully display the data. Paste Link Paste the data from the copy sheet using the Paste Link command. Clean up the worksheet to remove any formulas that reference blank cells. Adjust the column widths to fully display the data. Charts Create two meaningful charts from the data displayed on the charts sheet. Make sure the chart is of an appropriate type for the data you selected. Add a meaningful chart title. Place the charts next to the data at the top of the worksheet. Pivot Data Create a meaningful Pivot table from the data in the Pivot Data worksheet. Use the filter to reduce the amount of information displayed in the Pivot table. Create a meaningful Pivot chart from the data. If you can't make a recommendation or decision from the Pivot table information you need to try again. Apple Data Create a xy spatter chart from the data on the Apple sheet. Add a trend line and calculate Beta and Slope for the data.
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

BALANCE SHEETS (In millions) 2010 2011 Assets Current assets: Cash and cash equivalents 5,505 9,610 Short-term investments (including securities loaned of $1,181 and $62) 31,283 43,162 Total cash, cash equivalents, and short-term investments 36,788 52,772 Accounts receivable, net of allowance for doubtful accounts of $333 and $375 13,014 14,987 Inventories 740 1,372 Deferred income taxes 2,184 2,467 Other 2,950 3,320 Total current assets 55,676 74,918 Property and equipment, net of accumulated depreciation of $9,829 and $8,629 7,630 8,162 Equity and other investments 7,754 10,865 Goodwill 12,394 12,581 Intangible assets, net 1,158 744 Other long-term assets 1,501 1,434 Total assets 86,113 108,704 Liabilities and stockholders’ equity Current liabilities: Accounts payable 4,025 4,197 Short-term debt 1,000 0 Accrued compensation 3,283 3,575 Income taxes 1,074 580 Short-term unearned revenue 13,652 15,722 Securities lending payable 182 1,208 Other 2,931 3,492 Total current liabilities 26,147 28,774 Long-term debt 4,939 11,921 Long-term unearned revenue 1,178 1,398 Deferred income taxes 229 1,456 Other long-term liabilities 7,445 8,072 Total liabilities 39,938 51,621 Commitments and contingencies Stockholders’ equity: Common stock and paid-in capital – shares authorized 24,000; outstanding 8,376 and 8,668 62,856 63,415 Retained deficit, including accumulated other comprehensive income of $1,863 and $1,055 -16,681 -6,332 Total stockholders’ equity 46,175 57,083 Total liabilities and stockholders’ equity 86,113 108,704
Image of page 2
BALANCE SHEETS (In millions) 2010 2011 Assets Current assets: Cash and cash equivalents 5505 9610 Short-term investments (including securities loaned of $1,181 and $62) 31283 43162 Total cash, cash equivalents, and short-term investments 36788 52772 Accounts receivable, net of allowance for doubtful accounts of $333 and $375 13014 14987
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 4
This is the end of the preview. Sign up to access the rest of the document.
  • Fall '08
  • Olander
  • Balance Sheet, Generally Accepted Accounting Principles, deferred income taxes

{[ snackBarMessage ]}

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