In: Accounting
1. Find Apple Inc.'s 10-K filings that will give you their financial data for the past 5 years. Note: you can find it on Apple, Inc's investor relations' website: http://investor.apple.com/financials.cfm. 2. Create a spreadsheet where you will enter the 5-year data from the report (from page 24 of Apple's 2017 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 - 2017) - 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). Use time-series forecasting. 6. After completing the forecast, state the reason time-series is a good choice for forecasting this. Write a brief statement as to why Apple's Board of Directors should be confident in these forecasts (for 3, 5, and 10 years). I have submitted this question before but it has been answered with the wrong years and without an excel spreadsheet. Can anyone give the answer for years 2013-2017 along with the explanation of why to use time-series forecasting and why Apple should be confident in the forecasts? The information from the 10-K:
The information set forth below for the 5 yrs ended Sept 30, 2017, is not necessarily indicative of results of future operations and should be read in conjunction with Part II, Item 7, "Management's Discussion and Analysis of Financial Condition and Results of Operations" and the consolidated financial statements and related notes thereto included in Part II, Item 8 of this Fork 10-K to fully understand factors that may affect the comparability of the information presented below (in millions, except number of shares, which are reflected in thousands, and per share amounts).
2017 | 2016 | 2015 | 2014 | 2013 | |
Net Sales | $229,234 | $215,639 | $233,715 | $182,795 | $170,910 |
Net Income | $48,351 | $45,687 | $53,394 | $39,510 | $37,037 |
Earnings Per Share | |||||
Basic | $9.27 | $8.35 | $9.28 | $6.49 | $5.72 |
Diluted | $9.21 | $8.31 | $9.22 | $6.45 | $5.68 |
Cash dividends declared/share: | $2.40 | $2.18 | $1.98 | $1.82 | $1.64 |
Basic | 5,217,242 | 5,470,820 | 5,753,421 | 6,085,572 | 6,477,320 |
Diluted | 5,251,692 | 5,500,281 | 5,793,069 | 6,122,663 | 6,521,634 |
Total cash, cash equivalents & marketable securities | $268,895 | $237,585 | $205,666 | $155,239 | $146,761 |
Total assets | $375,319 | $321,686 | $290,345 | $231,839 | $207,000 |
Commercial paper | $11,977 | $8,105 | $8,499 | $6,308 | ---- |
Total term debt | $103,703 | $78,927 | $55,829 | $28,987 | $16,960 |
Other long-term obligations | $40,415 | $36,074 | $33,427 | $24,826 | $20,208 |
Total liabilities | $241,272 | $193,437 | $170,990 | $120,292 | $83,451 |
Total shareholders' equity | $134,047 | $128,249 | $119,355 | $111,547 | $123,549 |
Forecast | ||||||||||
2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | |
net sales | $ 284,647.47 | $ 347,482.29 | $ 424,187.65 | $ 517,825.43 | $ 632,133.37 | $ 771,674.35 | $ 942,018.45 | $ 1,149,965.35 | $ 1,403,815.72 | $ 1,713,702.57 |
Net income | $ 54,669.51 | $ 55,975.50 | $ 57,312.68 | $ 58,681.80 | $ 60,083.64 | $ 61,518.96 | $ 62,988.56 | $ 64,493.28 | $ 66,033.94 | $ 67,611.41 |
Earnings per share | ||||||||||
Basic | $ 11.72 | $ 14.80 | $ 18.70 | $ 23.62 | $ 29.83 | $ 37.67 | $ 47.58 | $ 60.09 | $ 75.90 | $ 95.86 |
Dilluted | $ 11.67 | $ 14.77 | $ 18.69 | $ 23.66 | $ 29.94 | $ 37.90 | $ 47.97 | $ 60.71 | $ 76.84 | $ 97.25 |
Cash Dividends declared per share | $ 3.72 | $ 6.99 | $ 13.12 | $ 24.65 | $ 46.30 | $ 86.96 | $ 163.35 | $ 306.83 | $ 576.35 | $ 1,082.59 |
Shares used in computing earnings per share | ||||||||||
Basic | $ 5,589,761.07 | $ 5,430,756.56 | $ 5,276,275.03 | $ 5,126,187.84 | $ 4,980,369.98 | $ 4,838,700.01 | $ 4,701,059.93 | $ 4,567,335.12 | $ 4,437,414.20 | $ 4,311,188.97 |
Dilluted | $ 5,618,996.61 | $ 5,450,154.81 | $ 5,286,386.44 | $ 5,127,539.05 | $ 4,973,464.76 | $ 4,824,020.15 | $ 4,679,066.12 | $ 4,538,467.72 | $ 4,402,094.08 | $ 4,269,818.24 |
Total Cash, cash equivalents and marketable securties | $ 261,167.93 | $ 331,647.86 | $ 421,147.82 | $ 534,800.62 | $ 679,124.28 | $ 862,395.75 | $ 1,095,125.66 | $ 1,390,661.10 | $ 1,765,951.04 | $ 2,242,518.37 |
Total assets | $ 367,569.07 | $ 465,118.04 | $ 588,555.48 | $ 744,751.91 | $ 942,401.24 | $ 1,192,504.62 | $ 1,508,982.81 | $ 1,909,450.98 | $ 2,416,199.19 | $ 3,057,433.05 |
Commercial Paper | $ 9,237.00 | $ 10,039.09 | $ 10,910.83 | $ 11,858.26 | $ 12,887.96 | $ 14,007.08 | $ 15,223.37 | $ 16,545.28 | $ 17,981.98 | $ 19,543.43 |
Total term debt | $ 58,308.35 | $ 61,046.52 | $ 63,913.28 | $ 66,914.66 | $ 70,056.98 | $ 73,346.87 | $ 76,791.25 | $ 80,397.38 | $ 84,172.85 | $ 88,125.63 |
Other long-term obligation | $ 45,440.24 | $ 61,770.89 | $ 83,970.58 | $ 114,148.55 | $ 155,172.10 | $ 210,939.00 | $ 286,747.82 | $ 389,801.38 | $ 529,891.09 | $ 720,327.28 |
Here use this table take previous figures and take percentage increase or decrease based upon the scenario computing previous and take an average the percentage obtained has to be multiplied this exercise needs to be done I have completed till long term obligation as we assume that apple is growing company and it will continue to develope the products as based upon the previous five year financials, until company face problems from the internal enviroment or the external enviroment by the goverment or public at large.