RWP #7 – Statement of Cash Flows

THIS IS YOUR SEVENTH REAL WORLD ASSIGNMENT. USING THE APPLE & ALPHABET FY 2023 10-KS THAT YOU USED FOR PREVIOUS RWPS, ANSWER THE FOLLOWING QUESTIONS:NOTE: Some answers are numerical, fill-in the blanks. Please adjust all answers for the units (e.g., 11 million or 11,000 thousand should be entered as 11,000,000), if required.Refer to the most recent 10-Ks (Year Ended in 2023) for Apple Inc. and Alphabet Inc.

NOTE: Some answers are numerical, fill-in the blanks. Please adjust all answers for the units, and include the ‘,’ separators (e.g., 11 million or 11,000 thousand should be entered as 11,000,000), if required.

Instructions for navigating the SEC website.

https://www.sec.gov/

1 – The SEC uses a database called EDGAR to store company data (Electronic Data Gathering, Analysis, and Retrieval system). To use this database, click on “COMPANY FILINGS” on the upper right corner of the website (below the search box).

2 – Search initially by the company name “Apple Inc” and “Alphabet Inc”. Do not include the “.” in the search. Some companies may not use the “.” in their name, and you will not be able to find them (i.e., Apple Inc).

3 – If you search only by the first part of the name (“Apple” or “Alphabet”) you will get a number of different filings. You should double check the CIK (Central Index Key) before you pull the incorrect filing. The CIK for Apple is 0000320193. The CIK for Alphabet is 0001652044. You can also search by CIK, but since most people don’t know the CIK off hand, you should first attempt to use the name.

4 – The filing date and the year ended are not the same! The filing date will be 1-3 months after the year end.

Question 1: Refer to the “Consolidated Statements of Cash Flows” for Apple Inc.

What amount did Apple report as its “Cash generated by operating activities” for Fiscal Year End Sept 30, 2023 (do not include dollar signs in your answer)?

Question 2: Refer to the “Consolidated Statements of Cash Flows” for Apple Inc.

Which adjustment/change in operating assets/liabilities had the largest decrease to Net Income in Apple’s “Operating activities” for Fiscal Year End Sept 30, 2023?

A. Other current and non-current assets

B. Depreciation and amortization

C. Share-based compensation expense

D. Accounts payable

E. Accounts receivable, net

Question 3: Refer to the “Consolidated Statements of Cash Flows” for Apple Inc.

What amount did Apple report as its “Cash generated/(used in) investing activities” for Fiscal Year End Sept 30, 2023 (do not include dollar signs in your answer)?

Question 4: Refer to the “Consolidated Statements of Cash Flows” for Apple Inc.

What activity had the biggest effect (either positive or negative) on Apple’s “Financing activities” for Fiscal Year End Sept 30, 2023?

A. Repurchases of common stock

B. Payments for dividends and dividend equivalents

C. Repayments of term debt

D. Proceeds from issuance of term debt, net

Question 5: Refer to the “Consolidated Statements of Cash Flows” for Apple Inc.

How much cash was paid for income taxes for Fiscal Year End Sept 30, 2023 (this is reported under “Supplemental cash flow disclosure”)?

Question 6: Refer to the “Consolidated Statements of Cash Flows” for Alphabet Inc.

What amount did Alphabet report as its “Net cash provided by operating activities” for Fiscal Year End December 31, 2023 (do not include dollar signs in your answer)?

Question 7: Refer to the “Consolidated Statements of Cash Flows” for Alphabet Inc.

Which adjustment/change in operating assets/liabilities had the largest decrease to Net Income in Alphabet’s “Operating activities” for Fiscal Year End December 31, 2023?

A. Deferred income taxes

B. Stock-based compensation expense

C. Depreciation and impairment of property and equipment

D. Accounts payableE. Accounts receivable, net

Question 8: Refer to the “Consolidated Statements of Cash Flows” for Alphabet Inc.

What amount did Alphabet report as its “Net cash used in investing activities” for Fiscal Year End December 31, 2023 (do not include dollar signs in your answer)?

Question 9: Refer to the “Consolidated Statements of Cash Flows” for Alphabet Inc.

What activity had the biggest effect (either positive or negative) on Alphabet’s “Financing activities” for Fiscal Year End December 31, 2023?

A. Repurchases of stock

B. Net payments related to stock-based award activities

C. Repayments of debt

D. Proceeds from sale of interest in consolidated entities, net

E. Proceeds from issuance of debt, net of costs

Questions 10: Refer to the “Consolidated Statements of Cash Flows” for Alphabet Inc.

How much cash was paid for income taxes (net of refunds) for Fiscal Year End December 31, 2023 (this information is provided under the “Supplemental disclosures of cash flow information” heading)?