Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.Find Apple Inc.s 10-K filings that will give you their financial data for the past 5 years. Note: You could find it on Apple, Inc.s

1.Find Apple Inc.s 10-K filings that will give you their financial data for the past 5 years. Note: You could find it on Apple, Inc.s investor relations website: http://investor.apple.com/financials.cfm, or in EDGAR. 2.Create a spreadsheet where you will enter the 5-year data from the report (from page 24 of Apples 2015 10-K report). 3.In your spreadsheet, build a similar set-up with the column in the left showing all the lines, e.g. from Net Sales down to Total Shareholders Equity. 4.Then create columns for the 5 years of historical data (2011) to (2015) you will note that their fiscal year ends in September. 5.Using this year-by-year historical data, calculate your 3, 5, and 10-year forecasts for each of the rows (i.e. Net Sales, etc., down to Total Shareholders Equity). You can choose which forecasting method you want to use, (remember your undergraduate statistics course) and there are refresher of various methods on the Internet. For example, here are some helpful videos and webpages on time-series analysis if you chose that method and need a refresher: a.https://www.youtube.com/watch?v=gHdYEZA50KE b.http://www.cimaglobal.com/Thought-leadership/Newsletters/Insight-e-magazine/Insight-2010/Insight-November-2010/Spreadsheet-skills-trendy-forecasting-in-Excel/ c.http://jcflowers1.iweb.bsu.edu/rlo/trendlines.htm 6.After you have completed your forecast, in a Word document, state the type of forecasting method you chose and why. Then write a brief statement as to why Apples Board of Directors should be confident in these forecasts (for the 3, 5, and 10 years). Remember that hundreds of millions of dollars are at stake. Only one page is necessary for this written statement. PLEASE SEE ATTACHED HISTORICAL DATA INSTEAD FOR APPLE INC.image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

Explain the importance of nonverbal messages.

Answered: 1 week ago

Question

Describe the advantages of effective listening.

Answered: 1 week ago

Question

Prepare an employment application.

Answered: 1 week ago