Complete a common-size Balance Sheet for Apple for the last 5 years in the Excel spreadsheets provided.
Fantastic news! We've Found the answer you've been seeking!
Question:
Complete a common-size Balance Sheet for Apple for the last 5 years in the Excel spreadsheets provided. help https://www.sec.gov/edgar/search-and-access apples 10k report
these are ones provided
Transcribed Image Text:
CONSOLIDATED BALANCE SHEETS - USD ($) shares in Thousands, $ in Millions Sep. 30, 2023 Sep. 24, 2022 Sep. 25, 2021 Sep. 26, 2020 Sep. 28, 2019 Current assets: Cash and cash equivalents Marketable securities $ 29,965 31,590 $ 23,646 $ 34,940 $ 38,016 $ 48,844 24,658 27,699 52,927 51,713 Accounts receivable, net 29,508 28,184 26,278 16,120 22,926 Vendor non-trade receivables Inventories Other current assets 31,477 32,748 6,580 4,061 4,106 6,331 4,946 25,228 21,325 22,878 14,695 21,223 14,111 11,264 12,352 Total current assets 143,566 135,405 134,836 143,713 162,819 Non-current assets: Marketable securities 100,544 120,805 127,877 100,887 105,341 Property, plant and equipment, net 43,715 42,117 39,440 36,766 37,378 Other non-current assets 64,758 54,428 48,849 42,522 32,978 Total non-current assets Total assets Current liabilities: Accounts payable Other current liabilities Deferred revenue Commercial paper Term debt Total current liabilities Non-current liabilities: Term debt Other non-current liabilities Total non-current liabilities Total liabilities 209,017 217,350 216,166 180,175 175,697 352,583 352,755 351,002 323,888 338,516 62,611 64,115 54,763 42,296 46,236 58,829 60,845 47,493 42,684 37,720 8,061 7,912 7,612 6,643 5,522 5,985 9,982 6,000 4,996 5,980 9,822 11,128 9,613 8,773 10,260 145,308 153,982 125,481 105,392 105,718 95,281 98,959 109,106 98,667 91,807 49,848 49,142 53,325 54,490 50,503 145,129 148,101 162,431 153,157 142,310 290,437 302,083 287,912 258,549 248,028 Commitments and contingencies Common stock, shares outstanding (in shares) Common stock, shares issued (in shares) 15,550,061 15,550,061 15,943,425 16,426,786,000 16,976,763,000 4,443,236,000 15,943,425 16,426,786,000 16,976,763,000 4,443,236,000 Shareholders' equity: Common stock and additional paid-in capital, $0.00001 par value: 50,400,000 shares authorized; 15,550,061 and 15,943,425 shares issued and outstanding, respectively $ 73,812 $ 64,849 57,365 50,779 45,174 Accumulated deficit (214) Accumulated other comprehensive loss (11,452) Total shareholders' equity 62,146 (3,068) (11,109) 50,672 5,562 14,966 45,898 163 63,090 Total liabilities and shareholders' equity $352,583 $352,755 $ 351,002 (406) 65,339 $323,888 (584) 90,488 $ 338,516 CONSOLIDATED BALANCE SHEETS - USD ($) shares in Thousands, $ in Millions Sep. 30, 2023 Sep. 24, 2022 Sep. 25, 2021 Sep. 26, 2020 Sep. 28, 2019 Current assets: Cash and cash equivalents Marketable securities $ 29,965 31,590 $ 23,646 $ 34,940 $ 38,016 $ 48,844 24,658 27,699 52,927 51,713 Accounts receivable, net 29,508 28,184 26,278 16,120 22,926 Vendor non-trade receivables Inventories Other current assets 31,477 32,748 6,580 4,061 4,106 6,331 4,946 25,228 21,325 22,878 14,695 21,223 14,111 11,264 12,352 Total current assets 143,566 135,405 134,836 143,713 162,819 Non-current assets: Marketable securities 100,544 120,805 127,877 100,887 105,341 Property, plant and equipment, net 43,715 42,117 39,440 36,766 37,378 Other non-current assets 64,758 54,428 48,849 42,522 32,978 Total non-current assets Total assets Current liabilities: Accounts payable Other current liabilities Deferred revenue Commercial paper Term debt Total current liabilities Non-current liabilities: Term debt Other non-current liabilities Total non-current liabilities Total liabilities 209,017 217,350 216,166 180,175 175,697 352,583 352,755 351,002 323,888 338,516 62,611 64,115 54,763 42,296 46,236 58,829 60,845 47,493 42,684 37,720 8,061 7,912 7,612 6,643 5,522 5,985 9,982 6,000 4,996 5,980 9,822 11,128 9,613 8,773 10,260 145,308 153,982 125,481 105,392 105,718 95,281 98,959 109,106 98,667 91,807 49,848 49,142 53,325 54,490 50,503 145,129 148,101 162,431 153,157 142,310 290,437 302,083 287,912 258,549 248,028 Commitments and contingencies Common stock, shares outstanding (in shares) Common stock, shares issued (in shares) 15,550,061 15,550,061 15,943,425 16,426,786,000 16,976,763,000 4,443,236,000 15,943,425 16,426,786,000 16,976,763,000 4,443,236,000 Shareholders' equity: Common stock and additional paid-in capital, $0.00001 par value: 50,400,000 shares authorized; 15,550,061 and 15,943,425 shares issued and outstanding, respectively $ 73,812 $ 64,849 57,365 50,779 45,174 Accumulated deficit (214) Accumulated other comprehensive loss (11,452) Total shareholders' equity 62,146 (3,068) (11,109) 50,672 5,562 14,966 45,898 163 63,090 Total liabilities and shareholders' equity $352,583 $352,755 $ 351,002 (406) 65,339 $323,888 (584) 90,488 $ 338,516
Expert Answer:
Related Book For
Accounting
ISBN: 978-0132690089
9th Canadian Edition volume 2
Authors: Charles T. Horngren, Walter T. Harrison Jr., Jo Ann L. Johnston, Carol A. Meissner, Peter R. Norwood
Posted Date:
Students also viewed these accounting questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
The manager of a $20 million portfolio of domestic stocks with a beta of 1.10 would like to begin diversifying internationally. He would like to sell $5 million of domestic stock and purchase $5...
-
The American League consists of 15 baseball teams. Suppose a sample of 5 teams is to be selected to conduct player interviews. The following table lists the 15 teams and the random numbers assigned...
-
A cable of length Lc supports a beam of length Lb, so that it is horizontal when the weight W is attached at the beam end. The principles of statics can be used to show that the tension force T in...
-
CGI Federal, Inc., is a corporation that provides a number of services to the United States Passport Agency, included the processing of passport application. Passport applicants must submit sensitive...
-
Whitlock, Inc., buys hardware parts from various manufacturers and sells them to retail stores. Management is currently trying to prepare a cash budget for August and has the following information...
-
Create three new users with names and privileges as described below in Oracle database: Show the code you used to make these users and grant them the correct privileges. Name User1 User2 User3...
-
Answer the following questions: 1. Explain the major designs of telescopes and discuss their strengths and weaknesses. 2. Describe the best places to build ground-based telescopes and why astronomers...
-
Implement the following C procedure in RISC-V assembly. Hint: Remember that the stack pointer must remain aligned on a multiple of 16 Int fib(int n) {if n= 0) return 0; Else if (n=1) return 1; Else...
-
Laker Company reported the following January purchases and sales data for its only product. For specific identification, ending inventory consists of 380 units from the January 30 purchase, 5 units...
-
Given the following data for work packages in a PERT/Cost network at week 18: Activity Immediate Budgeted Budgeted Percent Expense Predecessors Time Cost Completed To Date (weeks) (planned) A 12...
-
______________ between mentors and trainees is crucial for honesty and understanding. Group of answer choices Gossiping History Background checks Dialogue
-
4. Consider a manufacturing plant which produces 280,000 units for $350,000 and 560,000 units for $420,000. Each unit can be sold for $3.6 (15 points) a. Find the cost, revenue, and profit functions....
-
5 years ago, Barton Industries issued 25-year non-callable, semiannual bonds with a $1,600 face value and a 8% coupon, semiannual payment ($64 payment every 6 months). The bonds currently sell for...
-
Chris Zulliger was a chef at the Plaza Restaurant in the Snowbird Ski Resort in Utah. The restaurant is located at the base of a mountain. As a chef for the Plaza, Zulliger was instructed by his...
-
Hatteras Corporation reported the following accounts (a partial list): Prepare the shareholders' equity section of the Hatteras balance sheet. $3,000 8,000 2,600 12,000 Common Shares, Retained...
-
The 2014 comparative income statement and the 2014 comparative balance sheet of Eclipse Golf Inc. have just been distributed at a meeting of the company's board of directors. In discussing the...
-
The balance sheet of Collingwood International Inc. at December 31, 2013, presented the following shareholders' equity: Contributed capital Common shares, 2,000,000 shares authorized, 500,000 shares...
-
Management is considering three alternatives to satisfy an urgent need. Each of the alternatives will completely satisfy the need, so no combinations have to be considered. The first costs, operating...
-
Consider the following cash flow profile and assume MARR is 10 percent/year and the finance rate is 4 percent/year. a. Determine the MIRR for this project. b. Is this project economically attractive?...
-
Consider the following cash flow profile and assume MARR is 10 percent/year and the finance rate is 4 percent/ year. a. Determine the MIRR for this project. b. Is this project economically...
Study smarter with the SolutionInn App