Using this year-by-year historical data, calculate 3, 5, and 10-year forecasts for each of the rows (i.e. Net Sales, etc., down to Total Shareholder’s Equity). Please use Spreadsheet.

 

Transcribed Image Text:

Apple Inc. Selected Financial Data Items Years 2015 2014 2013 2012 2011 233,715 $ 182,795 $ 170,910 $ 156,508 $ Net Sales Net Income Earnings per share (EPS): 108,249 53,394 $ 39,510 $ 37,037 $ 41,733 $ 25,922 $ 6.49 $ 9.28 $ 9.22 $ Basic 5.72 $ 6.38 $ 4.01 Diluted 6.45 $ 5.68 $ 6.31 $ 3.95 Cash dividends declared/share $ 1.98 $ 1.82 $ 1.64 $ 0.38 $ | Shares used in computing EPS $ 5,753,421 $ 6,085,572 $ 6,477,320 $ $ 5,793,069 $ 6,122,663 $ 6,521,634 $ 6,543,726 $ 6,617,483 $ Basic 6,469,806 Diluted 6,556,514 Total Cash, Cash equivalents : and Marketable securities |Total Assets i Commercial paper i Total term debt Other long-term obligations | Total Liabilities $ 205,666 $ 290,479 $ 155,239 $ 146,761 $ 121,251 $ 81,570 231,839 $ 207,000 $ 176,064 $ 116,371 8,499 $ 55,963 $ $ 6,308 $ $ $ 28,987 $ 24,826 $ 16,960 $ 20,208 $ 83,451 $ $ 16,664 $ 57,854 $ 33,427 $ 10,100 171,124 $ 120,292 $ 39,756 Total shareholders' equity $ 119,355 $ 111,547 $ 123,549 $ 118,210 $ 76,615 Apple Inc. Selected Financial Data Items Years 2015 2014 2013 2012 2011 233,715 $ 182,795 $ 170,910 $ 156,508 $ Net Sales Net Income Earnings per share (EPS): 108,249 53,394 $ 39,510 $ 37,037 $ 41,733 $ 25,922 $ 6.49 $ 9.28 $ 9.22 $ Basic 5.72 $ 6.38 $ 4.01 Diluted 6.45 $ 5.68 $ 6.31 $ 3.95 Cash dividends declared/share $ 1.98 $ 1.82 $ 1.64 $ 0.38 $ | Shares used in computing EPS $ 5,753,421 $ 6,085,572 $ 6,477,320 $ $ 5,793,069 $ 6,122,663 $ 6,521,634 $ 6,543,726 $ 6,617,483 $ Basic 6,469,806 Diluted 6,556,514 Total Cash, Cash equivalents : and Marketable securities |Total Assets i Commercial paper i Total term debt Other long-term obligations | Total Liabilities $ 205,666 $ 290,479 $ 155,239 $ 146,761 $ 121,251 $ 81,570 231,839 $ 207,000 $ 176,064 $ 116,371 8,499 $ 55,963 $ $ 6,308 $ $ $ 28,987 $ 24,826 $ 16,960 $ 20,208 $ 83,451 $ $ 16,664 $ 57,854 $ 33,427 $ 10,100 171,124 $ 120,292 $ 39,756 Total shareholders' equity $ 119,355 $ 111,547 $ 123,549 $ 118,210 $ 76,615

Answer rating: 100% (QA)

Answer In the above table the following are observations 1 Net sales are increasing by 21590 in the ... View the full answer