f

1 pts Question 1 On the Apple Data sheet, what is the Rvalue on your chart? Use only 3 decimal places in your answer BALANCE SHEETS (In millions) 2010 2011 5,505 31 283 36,788 13,014 740 2 184 2 950 55 676 7.630 7,754 12 394 1.158 1501 86.113 9,610 43.162 52.772 14.987 1,372 2.467 3.320 74,978 8,162 10 865 12 581 744 1434 108,704 Assets Current assets: Cash and cash equivalents Short-term investments (including securities loaned of $1,181 and $62) Total cash cash equivalents, and short-term investments Accounts receivable, net of allowance for doubtful accounts of $333 and $375 Inventories Deferred income taxes Other Total current assets Property and equipment, net of accumulated depreciation of $9,829 and $8,629 Equity and other investments Goodwill Intangible assets, net Other long-term assets Total assets Liabilities and stockholders' equity Current liabilities: Accounts payable Short-term debt Accrued compensation Income taxes Short-term uneamed revenue Securities lending payable Other Total current abilities Long-term debt Long-term uneamed revenue Deferred income taxes Other long-term liabilis Total liabilities Commitments and contingencies Stockholders' equity Common stock and paid-in capital - shares authorized 24,000, outstanding 8,376 and 8,668 Retained deficit, including accumulated other comprehensive income of $1.863 and $1,055 Total stockholders' equity Total liabilities and stockholders equity 4,025 1,000 3 283 1,074 13,652 182 2.931 26, 147 4.939 1.178 229 7445 39.938 4.197 O 3,575 580 15,722 1.208 3.492 28,774 11 921 1.358 1.456 8,072 51.621 62 856 -16,681 45,175 86,113 63.415 6,302 57083 108,704 RET DATE COMNAM TICKER wed 0.019418 0.01049 310X APPLE INCAAPL 28/02/2007 APPLE INCAAPL 0013987 -0.013054 2007 APPLE INCAAPI 0.012909 0.098097 3004/2007 APPLE INCAAPL 0039821 0.074158 31/05/2007 APPLE INCAAPL 0.038932 0214339 2006/2007 APPLE INCAAPL 0014756 0602005 31/01/2007 APPLE INCAAPL 0031756 0.079646 31/08/2007 APPLE INCAAPL 0.011656 0.051002 ODBOR 0108247 28.09.2007 APPLE INCAAPL 31/10/2007 APPLE INCAAPL 0.02533 0.237701 30/11/2007 APPLE INCAAPL -0.049232 0.040695 31/12/2007 APPLE INCAAPL -0.0044190.082035 31.01.2008 APPLE INCAAPL -6662151 031664 29.03/2008 APPLE INCAAPL -0.021653 -0.076389 SUO 2008 APPLE INCAAPL -0.01042 0.147816 30042005 APPLE INCAAPL 0151108 0.212195 300X APPLE INCAAPL. 0.00143 OORSOR2 2006/2008 APPLE INCAAPL. 0.078434 -0.112901 31/07/2008 APPLE INCAAPL -OD133300SOMOS 29/08/2005 APPLE INCAAN 0.010564 0.066562 2009 2008 APPLE INCAAPL -0.09 -0.129558 31/10/2008 APPLE INCAAFL -0.1810 0.051.005 28/11/2008 APPLE INCAAPL -0.084615 -0.136675 31/12/2008 APPLE INCAAPL 0.00219 0.07890 30/01/2009 APPLE INCAAPI. 0.077332 0.05600 27001/2009 APPLE INCAAFL 0.100184 0.00909 31/03/2009 APPLE INCAAPL 0.03 0.177034 3004/2009 APPLE INCAAP 0.109359 0.192013 29/05/2009 APPLE INCAAPE 0.067789 0.079313 06/2009 APPLE INCAAH. -0.00098 0.045745 3L101/2009 APPLE INCAAPL 0081718 0.14716 310 2009 APPLE INCAAPL 0031465 0.0095 30092009 APPLE INCAAFI 5205 101896 *V102009 APPLE INCAAFL 0027909 0.016 30/11/2009 APPLE INCAAPL 0.057099 0.000531 312/2009 APPLE INCAAPL 0.005419 0.05414 2901/2010 APTLE INCAL 0.037098 0.0591 26/02/2010 APPLE INCAAPL 0044775 0.0031 3163/2010 APPLE INCAAPL 006 1637 30/04/2010 APPLE INCAAPL 0.020011 0111021 2805/2010 APPLE INCAAPL -0.079841 -0.016125 2010 APPLE INCAAPL 0.021 020227 OUT 2010 APPLE INCAAPL. 0.071554 0.022741 10/2010 APPLE INCAARL 0042818 0.055005 30/09/2010 APPLE INCAAR 091510167215 29.10.2010.APPLE INCAPL 0.0385520.00 11/2010 APLE INCAAPE 0.005165 0.03379 31/12/2010 ATYLE INCAAPC 0.067152 0.00667 31/01/2011 APYLINCAAPL 0.019157 0.051999 000011 APPLE INCAARL 0.0166 0.0095 2011 AITLE INCLAI 0.003374 00:3314 2002 APPLE INCAAPL O.COM 0004656 31/05/2011 AILE INCAAPL 0.0193 000 2011 APPLE INCAA 2010 2011 APPLE INCAAM 09 041 01632 31/08/2011 APPLE INCAPE 60574710140 2009/2011 APPLE INCAR 068473009121 2011 APPLE INCAAPL 161533 30/11/2011 APPLE INCAARL 306225 0.00373 2013/2011 APPLE INCAAPL 0.0000 000 Instructions Copy Paste Values Paste Link Charts Pivot Data Apple Data Product Name Category ID CategoryName 6 Meat Poultry Alice Mutton 2 Condiments Anisood Syrup 8 Seafood Hoston Crab Meat 4 Dairy Products Camembert Pierrot 8 Seafood Carnarvon Tigers 1 Beverages 1 Beverages Chang 1 Beverages Chartreuse verte 2 Condiments Chef Anton's Cajun Seasoning 2 Condiments Chef Anton's Gumbo Mix 3 Confections Chocolade 1 Beverages Cote de Blaye & Seafood Escargots de Bourgogne 5 Gratis Cereals Filo Mix 4 Dairy Products Flatemysost 4 Dairy Products Gestost 2 Condiments Genen Shouyu 5 Grains Cereals Gnocchi di nonna Alice 4 Dairy Products Gorgonzola Telino 2. Condiments Grandmas Boysenberry Spread & Seafood Gravad lax 1 Beverages Guarina Fantstica 4 Dairy Predicts Gudbrandsdalsost 2 Condiments Gula Malacca 3. Confections Gumor Gummiblichen GrainsCereals Gustafs Knickebrd S Seafood kuru 8 Seafood Inlagd Sie 1 Beverages Ipoh Coffee 8 Seadood Jack's New England Clam Chowder 8 Seafood Kobu 1 Beverages Lakkalikoni 1 Beverages Laughing Lumberjack Lager 7 Produce Longlife Tofu 2 Condiments Louisiana Fery Hot Pepper Sauce 2 Condiments Louisiana Hot Spiced Okra 7 Produce Manjimup Dried Apples 4 Dairy Products Mascarpone Fabioli 3 Confections Madaku 6 MPalty Mishi Kobe Nike 4 Dairy Products Mozarella di Giovanni Seafood Nord-Ost Matjestering 2 Condiments Northwoods Cranberry Sauce 3. Confection NUNC Nal-Noogat-Creme 2 Condiments Original Frankfurter grne Sole 1 leveres Outback Lager 6 Meat Poultry Pite chinois 3 Confections Pavlova 6 Meat Poultry Perth Pasties 4 Dairy Products Queso Cabrales 4 Dairy Products Queso Manchego La Pastor 4 Dairy Products Raclette Coundavat GranCercals Ravioli Angelo 1 Beverages Rru Klosterter Seabood Rod Kaviar 8 Salood Regole sild 7 Produce Route Sauerkraut 1 Beverages Sasquatch Ale Confections Scho Schokolade 3 Confections Scotch Logba Sisene Instructions Sinnen Hokkan Fried Moe Copy Paste Values Pasal Product Sales 14,123.85 1.544.00 9,796.33 22.413.48 14,525.00 5,070.60 5,817.80 2.295.90 5,214.88 917.62 1.282.01 51,569 58 2,913.68 2.058.00 10,433.94 905.00 1.474.82 30,088.40 7,188.49 2.500.00 629.20 1.571.62 14.04180 6,34343 11.225.65 4,023.60 8,720.30 6,397.11 10.03490 4,322.72 941 34 7.883.10 868.00 1,186.00 8,11718 2,100.00 16.024.02 2.668.80 3.060.60 6935.50 12.42738 5.573.62 3.300.00 1.058 40 4.71198 5,663 40 9.114.48 2.180.15 13 X32.13 $310.09 8.335.30 32,769.55 2.156.70 3.670.24 3517.50 3.303.40 13.691 48 2.0/79.00 9.218.00 3.909.00 4,9260 5 Grains/Cereals 3 Confections 3 Confections 2 Condiments 8 Seafood 1 Beverages 3 Confections 3 Confections 6 Meat/Poultry 7 Produce 6 Meat/Poultry 5 Grains/Cereals 7 Produce 3 Confections 2 Condiments 5 Grains/Cereals 3 Confections Singaporean Hokkien Fried Mee Sir Rodney's Marmalade Sir Rodney's Scones Sirop d'rable Spegesild Steeleye Stout Tarte au sucre Teatime Chocolate Biscuits Thringer Rostbratwurst Tofu Tourtire Tunnbrd Uncle Bob's Organic Dried Pears Valkoinen suklaa Vegie-spread Wimmers gute Semmelkndel Zaanse koeken 4,996.60 9,711.90 4,941.00 8,521.50 3,655.32 5,955.30 20,811.32 2,339.99 30,038.43 6,820.38 3,120.36 2,576.70 8,251.80 2,368.44 6,087.69 7,923.47 2,645.75 Instructin 1 pts Question 1 On the Apple Data sheet, what is the Rvalue on your chart? Use only 3 decimal places in your answer BALANCE SHEETS (In millions) 2010 2011 5,505 31 283 36,788 13,014 740 2 184 2 950 55 676 7.630 7,754 12 394 1.158 1501 86.113 9,610 43.162 52.772 14.987 1,372 2.467 3.320 74,978 8,162 10 865 12 581 744 1434 108,704 Assets Current assets: Cash and cash equivalents Short-term investments (including securities loaned of $1,181 and $62) Total cash cash equivalents, and short-term investments Accounts receivable, net of allowance for doubtful accounts of $333 and $375 Inventories Deferred income taxes Other Total current assets Property and equipment, net of accumulated depreciation of $9,829 and $8,629 Equity and other investments Goodwill Intangible assets, net Other long-term assets Total assets Liabilities and stockholders' equity Current liabilities: Accounts payable Short-term debt Accrued compensation Income taxes Short-term uneamed revenue Securities lending payable Other Total current abilities Long-term debt Long-term uneamed revenue Deferred income taxes Other long-term liabilis Total liabilities Commitments and contingencies Stockholders' equity Common stock and paid-in capital - shares authorized 24,000, outstanding 8,376 and 8,668 Retained deficit, including accumulated other comprehensive income of $1.863 and $1,055 Total stockholders' equity Total liabilities and stockholders equity 4,025 1,000 3 283 1,074 13,652 182 2.931 26, 147 4.939 1.178 229 7445 39.938 4.197 O 3,575 580 15,722 1.208 3.492 28,774 11 921 1.358 1.456 8,072 51.621 62 856 -16,681 45,175 86,113 63.415 6,302 57083 108,704 RET DATE COMNAM TICKER wed 0.019418 0.01049 310X APPLE INCAAPL 28/02/2007 APPLE INCAAPL 0013987 -0.013054 2007 APPLE INCAAPI 0.012909 0.098097 3004/2007 APPLE INCAAPL 0039821 0.074158 31/05/2007 APPLE INCAAPL 0.038932 0214339 2006/2007 APPLE INCAAPL 0014756 0602005 31/01/2007 APPLE INCAAPL 0031756 0.079646 31/08/2007 APPLE INCAAPL 0.011656 0.051002 ODBOR 0108247 28.09.2007 APPLE INCAAPL 31/10/2007 APPLE INCAAPL 0.02533 0.237701 30/11/2007 APPLE INCAAPL -0.049232 0.040695 31/12/2007 APPLE INCAAPL -0.0044190.082035 31.01.2008 APPLE INCAAPL -6662151 031664 29.03/2008 APPLE INCAAPL -0.021653 -0.076389 SUO 2008 APPLE INCAAPL -0.01042 0.147816 30042005 APPLE INCAAPL 0151108 0.212195 300X APPLE INCAAPL. 0.00143 OORSOR2 2006/2008 APPLE INCAAPL. 0.078434 -0.112901 31/07/2008 APPLE INCAAPL -OD133300SOMOS 29/08/2005 APPLE INCAAN 0.010564 0.066562 2009 2008 APPLE INCAAPL -0.09 -0.129558 31/10/2008 APPLE INCAAFL -0.1810 0.051.005 28/11/2008 APPLE INCAAPL -0.084615 -0.136675 31/12/2008 APPLE INCAAPL 0.00219 0.07890 30/01/2009 APPLE INCAAPI. 0.077332 0.05600 27001/2009 APPLE INCAAFL 0.100184 0.00909 31/03/2009 APPLE INCAAPL 0.03 0.177034 3004/2009 APPLE INCAAP 0.109359 0.192013 29/05/2009 APPLE INCAAPE 0.067789 0.079313 06/2009 APPLE INCAAH. -0.00098 0.045745 3L101/2009 APPLE INCAAPL 0081718 0.14716 310 2009 APPLE INCAAPL 0031465 0.0095 30092009 APPLE INCAAFI 5205 101896 *V102009 APPLE INCAAFL 0027909 0.016 30/11/2009 APPLE INCAAPL 0.057099 0.000531 312/2009 APPLE INCAAPL 0.005419 0.05414 2901/2010 APTLE INCAL 0.037098 0.0591 26/02/2010 APPLE INCAAPL 0044775 0.0031 3163/2010 APPLE INCAAPL 006 1637 30/04/2010 APPLE INCAAPL 0.020011 0111021 2805/2010 APPLE INCAAPL -0.079841 -0.016125 2010 APPLE INCAAPL 0.021 020227 OUT 2010 APPLE INCAAPL. 0.071554 0.022741 10/2010 APPLE INCAARL 0042818 0.055005 30/09/2010 APPLE INCAAR 091510167215 29.10.2010.APPLE INCAPL 0.0385520.00 11/2010 APLE INCAAPE 0.005165 0.03379 31/12/2010 ATYLE INCAAPC 0.067152 0.00667 31/01/2011 APYLINCAAPL 0.019157 0.051999 000011 APPLE INCAARL 0.0166 0.0095 2011 AITLE INCLAI 0.003374 00:3314 2002 APPLE INCAAPL O.COM 0004656 31/05/2011 AILE INCAAPL 0.0193 000 2011 APPLE INCAA 2010 2011 APPLE INCAAM 09 041 01632 31/08/2011 APPLE INCAPE 60574710140 2009/2011 APPLE INCAR 068473009121 2011 APPLE INCAAPL 161533 30/11/2011 APPLE INCAARL 306225 0.00373 2013/2011 APPLE INCAAPL 0.0000 000 Instructions Copy Paste Values Paste Link Charts Pivot Data Apple Data Product Name Category ID CategoryName 6 Meat Poultry Alice Mutton 2 Condiments Anisood Syrup 8 Seafood Hoston Crab Meat 4 Dairy Products Camembert Pierrot 8 Seafood Carnarvon Tigers 1 Beverages 1 Beverages Chang 1 Beverages Chartreuse verte 2 Condiments Chef Anton's Cajun Seasoning 2 Condiments Chef Anton's Gumbo Mix 3 Confections Chocolade 1 Beverages Cote de Blaye & Seafood Escargots de Bourgogne 5 Gratis Cereals Filo Mix 4 Dairy Products Flatemysost 4 Dairy Products Gestost 2 Condiments Genen Shouyu 5 Grains Cereals Gnocchi di nonna Alice 4 Dairy Products Gorgonzola Telino 2. Condiments Grandmas Boysenberry Spread & Seafood Gravad lax 1 Beverages Guarina Fantstica 4 Dairy Predicts Gudbrandsdalsost 2 Condiments Gula Malacca 3. Confections Gumor Gummiblichen GrainsCereals Gustafs Knickebrd S Seafood kuru 8 Seafood Inlagd Sie 1 Beverages Ipoh Coffee 8 Seadood Jack's New England Clam Chowder 8 Seafood Kobu 1 Beverages Lakkalikoni 1 Beverages Laughing Lumberjack Lager 7 Produce Longlife Tofu 2 Condiments Louisiana Fery Hot Pepper Sauce 2 Condiments Louisiana Hot Spiced Okra 7 Produce Manjimup Dried Apples 4 Dairy Products Mascarpone Fabioli 3 Confections Madaku 6 MPalty Mishi Kobe Nike 4 Dairy Products Mozarella di Giovanni Seafood Nord-Ost Matjestering 2 Condiments Northwoods Cranberry Sauce 3. Confection NUNC Nal-Noogat-Creme 2 Condiments Original Frankfurter grne Sole 1 leveres Outback Lager 6 Meat Poultry Pite chinois 3 Confections Pavlova 6 Meat Poultry Perth Pasties 4 Dairy Products Queso Cabrales 4 Dairy Products Queso Manchego La Pastor 4 Dairy Products Raclette Coundavat GranCercals Ravioli Angelo 1 Beverages Rru Klosterter Seabood Rod Kaviar 8 Salood Regole sild 7 Produce Route Sauerkraut 1 Beverages Sasquatch Ale Confections Scho Schokolade 3 Confections Scotch Logba Sisene Instructions Sinnen Hokkan Fried Moe Copy Paste Values Pasal Product Sales 14,123.85 1.544.00 9,796.33 22.413.48 14,525.00 5,070.60 5,817.80 2.295.90 5,214.88 917.62 1.282.01 51,569 58 2,913.68 2.058.00 10,433.94 905.00 1.474.82 30,088.40 7,188.49 2.500.00 629.20 1.571.62 14.04180 6,34343 11.225.65 4,023.60 8,720.30 6,397.11 10.03490 4,322.72 941 34 7.883.10 868.00 1,186.00 8,11718 2,100.00 16.024.02 2.668.80 3.060.60 6935.50 12.42738 5.573.62 3.300.00 1.058 40 4.71198 5,663 40 9.114.48 2.180.15 13 X32.13 $310.09 8.335.30 32,769.55 2.156.70 3.670.24 3517.50 3.303.40 13.691 48 2.0/79.00 9.218.00 3.909.00 4,9260 5 Grains/Cereals 3 Confections 3 Confections 2 Condiments 8 Seafood 1 Beverages 3 Confections 3 Confections 6 Meat/Poultry 7 Produce 6 Meat/Poultry 5 Grains/Cereals 7 Produce 3 Confections 2 Condiments 5 Grains/Cereals 3 Confections Singaporean Hokkien Fried Mee Sir Rodney's Marmalade Sir Rodney's Scones Sirop d'rable Spegesild Steeleye Stout Tarte au sucre Teatime Chocolate Biscuits Thringer Rostbratwurst Tofu Tourtire Tunnbrd Uncle Bob's Organic Dried Pears Valkoinen suklaa Vegie-spread Wimmers gute Semmelkndel Zaanse koeken 4,996.60 9,711.90 4,941.00 8,521.50 3,655.32 5,955.30 20,811.32 2,339.99 30,038.43 6,820.38 3,120.36 2,576.70 8,251.80 2,368.44 6,087.69 7,923.47 2,645.75 Instructin