Question

In: Accounting

1. Find Apple Inc.'s 10-K filings that will give you their financial data for the past...

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

Solutions

Expert Solution

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.


Related Solutions

1. Find Apple Inc.'s 10-K filings that will give you their financial data for the past...
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...
1. Find Apple Inc.'s 10-K filings that will give you their financial data for the past...
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...
1. Find Apple Inc.'s 10-K filings that will give you their financial data for the past...
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...
Calculate the required financial ratios related to Apple Inc.; this will be based on the past...
Calculate the required financial ratios related to Apple Inc.; this will be based on the past three years Apple's balance sheets and income statements. Choose one or two ratios from each of the groups: liquidity, asset management, debt management, profitability, and market value over three years. Develop a trend on how the company is doing based on your ratio analyses. Submit a few sentences of what the three years of ratios mean
Form 10-K for Apple which covered Item 1: Business. (1) You are to prepare a balanced...
Form 10-K for Apple which covered Item 1: Business. (1) You are to prepare a balanced score card using the information provided in the excerpt. You are not required to do any additional research. Since your company is large, you should prepare a balanced scorecard for the manager of a retail Apple Store. This Annual Report on Form 10-K (“Form 10-K”) contains forward-looking statements, within the meaning of the Private Securities Litigation Reform Act of 1995, that involve risks and...
Business Strategic Management: Strategic Audit Apple Inc.'s Internal Environment: Can you summarize Apple Inc.'s, A. Marketing,...
Business Strategic Management: Strategic Audit Apple Inc.'s Internal Environment: Can you summarize Apple Inc.'s, A. Marketing, B. Finance, C. Research & Development, D. Operations & Logistics, E. Human Resources, F. Information Technology, and a short summary of internal factors for Apple ? (A large response would be nice !!)
Give a feedback A company that operates internationally is Apple inc. Apple Inc is an American...
Give a feedback A company that operates internationally is Apple inc. Apple Inc is an American multinational technology company. Based on the article ‘’Apple Globalization and Global Strategic Planning Assignment’’, the author stated that Apple Inc uses differentiation strategy as its major international strategy to deliver high customer value through its innovation brands in their overseas market. With the help of this strategy, the organization has developed a strong market that is share in overseas market. Throughout the years, Apple...
Companies disclose various risks in their 10-K filings. Regulators encourage companies to make these types of...
Companies disclose various risks in their 10-K filings. Regulators encourage companies to make these types of disclosures so that investors can estimate the uncertainties inherent in the organization. (1) Select a company in the pharmaceutical industry. (2) Obtain its recent 10-K filings, and (3) Identify the risks the company included in its filing. Auditors need to be aware of these fisks, as they could have misstatement implications for multiple financial statement accounts.
Analyze 10-K filings (the most recent) for PepsiCo and for Coca-Cola. Answer the following questions. A....
Analyze 10-K filings (the most recent) for PepsiCo and for Coca-Cola. Answer the following questions. A. Which inventory method does each company use? B. How do they account for their Accounts Receivables? C. How do they value their inventory? D. How do they account for and value their PPE? E. Was there any significant changes in PPE for both companies? F. How much working capital did each company have?
Refer to the most recent 10-K for Apple Inc What is the annual cash dividend yield...
Refer to the most recent 10-K for Apple Inc What is the annual cash dividend yield of the common stock for Apple Inc? https://www.sec.gov/Archives/edgar/data/320193/000032019318000145/a10-k20189292018.htm
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT