In: Accounting
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 Apple's 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 Shareholder's Equity. 4. Then create columns for the 5 years of historical data (2013) to (2017) - 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 Shareholder's Equity). You can choose which forecasting method you want to use. 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 Apple's 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
I would like this answered with time series forecasting. I need to see the Excel sheet complete with the 3, 5, and 10-year forecasts. Why would Apple's Board of Directors be confident in the forecasts provided?