Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 Shareholders Equity).
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 Shareholders Equity). Please use Spreadsheet.
Apple Inc. Selected Financial Data Items Years 2015 2014 2013 2012 2011 233,715 182,795 170,910 156,508 108,249 Net Sales 53,394 39,510 37,037 41,733 25,922 Net Income Earnings per share (EPS): Basic 9.28 6.49 5.72 6.38 4.01 9.22 6.45 5.68 6.31 3.95 Diluted 1.98 1.82 1.64 0.38 Cash dividends declared/share Shares used in computing EPS 5,753,421 6,085,572 6,477,320 S 6,543,726 6,469,806 Basic Diluted 5,793,069 6,122,663 6,521,634 6,617,483 6,556,514 Total Cash, Cash equivalents and Marketable securities 205,666 155,239 146,761 121,251 81,570 231,839 207,000 176,064 290,479 Total Assets 116,371 8,499 6,308 Commercial paper 55,963 28,987 Total term debt 16,960 Other long-term obligations 33,427 24,826 S 20,208 16,664 10, 100 171,124 120,292 83,451 57,854 39,756 Total Liabilities 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 108,249 Net Sales 53,394 39,510 37,037 41,733 25,922 Net Income Earnings per share (EPS): Basic 9.28 6.49 5.72 6.38 4.01 9.22 6.45 5.68 6.31 3.95 Diluted 1.98 1.82 1.64 0.38 Cash dividends declared/share Shares used in computing EPS 5,753,421 6,085,572 6,477,320 S 6,543,726 6,469,806 Basic Diluted 5,793,069 6,122,663 6,521,634 6,617,483 6,556,514 Total Cash, Cash equivalents and Marketable securities 205,666 155,239 146,761 121,251 81,570 231,839 207,000 176,064 290,479 Total Assets 116,371 8,499 6,308 Commercial paper 55,963 28,987 Total term debt 16,960 Other long-term obligations 33,427 24,826 S 20,208 16,664 10, 100 171,124 120,292 83,451 57,854 39,756 Total Liabilities Total shareholders' equity 119,355 111,547 123,549 118,210 76,615Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started