Module3Assessment.xlsx

# Module3Assessment.xlsx - This workbook contains some new...

• 17

This preview shows pages 1–5. 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 a 2D Clustered bar chart of the Assets for 2010 and 2011. Create a 3D Clustered column chart of the Liabilities for 2010 and 2011. Add chart titles (Assets and Liabilities, respectively) and include legends for 2010 and 2011. Place the charts next to the data at the top of the worksheet. Pivot Data Insert a pivot table and pivot chart showing the total sales by category name. Change the pivot table headers to Category and Total Sales. Format the Total Sales as Currency. Make your pivot chart title "Total Sales by Category" and have no legend. 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.

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

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

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

BALANCE SHEETS (In millions) 2010 Assets Current assets: Cash and cash equivalents 5,505 Short-term investments (including securities loaned of \$1,181 and \$62) 31,283 Total cash, cash equivalents, and short-term investments 36,788 Accounts receivable, net of allowance for doubtful accounts of \$333 and \$375 13,014
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

{[ snackBarMessage ]}

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