1. Find Apple Inc.\'s 10-K filings that will give you their financial data for t
ID: 2611383 • Letter: 1
Question
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,549Explanation / Answer
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.
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.28Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.