8. Apple 2023 Forecasting Template(1)

xlsx

School

Dartmouth College *

*We aren’t endorsed by this school

Course

211A

Subject

Business

Date

Apr 3, 2024

Type

xlsx

Pages

18

Uploaded by plumeating249

Report
APPLE FORECASTING TEMPLATE Quarter Ended September 30, 2023 INCOME STATEMENT FORECAST Net sales: Products 49,648 Services 21,523 Total net sales 70,551 Cost of sales: Products 32,731 Services 6,437 Total cost of sales 38,965 Gross margin 31,587 Operating expenses: Research and development 7,427 Selling, general and administrative 5,753 Total operating expenses 13,176 Operating income 18,677 Other income/(expense), net 1,097 Income before provision for income taxes 18,208 Provision for income taxes 1,927 Net income 23,402 Earnings per share: Basic 1.05 Diluted 1.04 Shares used in computing earnings per share: Basic 15,608,582 Diluted 15,703,319
Cash dividends declared per share 0.25 BALANCE SHEET ASSETS: Current assets: Cash and cash equivalents 32,690 Marketable securities 37,231 Accounts receivable, net 21,307 Inventories 7,222 Vendor non-trade receivables 21,467 Other current assets 13,620 Total current assets 133,246 Non-current assets: Marketable securities 98,032 Property, plant and equipment, net 43,703 Other non-current assets 64,154 Total non-current assets 205,726 Total assets 337,941 LIABILITIES AND SHAREHOLDERS' EQUITY: Current liabilities: Accounts payable 50,781 Other current liabilities 61,477 Deferred revenue 8,185 Commercial paper 7,988 Term debt 4,923 Total current liabilities 130,050 Non-current liabilities: Term debt 99,112 Other non-current liabilities 50,599
Total non-current liabilities 149,675 Total liabilities 279,610 Commitments and contingencies n/a Shareholders' equity: Common stock and additional paid-in capital 71,783 Retained earnings 457 Accumulated other comprehensive income/(loss) (11,856) Total shareholders' equity 58,447 Total liabilities and shareholders' equity 337,941 STATEMENT OF CASH FLOWS Cash, cash equivalents and restricted cash, beginning balances 5,550 Operating activities: Net income 22,493 Adjustments to reconcile net income to cash generated by operating activities: Depreciation and amortization 3,004 Share-based compensation expense 2,678 Deferred income tax benefit n/a Other (350) Changes in operating assets and liabilities: Accounts receivable, net 1,341 Inventories (576) Vendor non-trade receivables 2,584 Other current and non-current assets (1,284) Accounts payable (3,017) Deferred revenue 8,185 Other current and non-current liabilities 1,128 Cash generated by operating activities 28,100
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Investing activities: Purchases of marketable securities (8,716) Proceeds from maturities of marketable securities 10,070 Proceeds from sales of marketable securities 1,836 Payments for acquisition of property, plant and equipment (2,565) Payments made in connection with business acquisitions, net n/a Other (510) Cash generated by/(used in) investing activities 437 Financing activities: Payments for taxes related to net share settlement of equity aw (2,130) Payments for dividends and dividend equivalents (3,803) Repurchases of common stock (18,188) Proceeds from issuance of term debt, net (14,972) Repayments of term debt (4,094) Proceeds from/(Repayments of) commercial paper, net (995) Other (126) Cash used in financing activities (26,404) Increase/(Decrease) in cash, cash equivalents and restricted ca 22,506 Cash, cash equivalents and restricted cash, ending balances 7,322
EXPLANATION oppenheimeb of a rosenblatt Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 $6.05 Projected using percentage change from Q2 to Q3 of 2023 1.39 $1.41 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023
Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 10q line item is blank Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 10q only has information on income tax benefit related to share based compensation expense Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 found in 10q Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023
Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 not found in 10q Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023 Projected using percentage change from Q2 to Q3 of 2023
12 Months Ended Sep. 24, 2022 Sep. 25, 2021 Sep. 26, 2020 Net sales $ 394,328 $ 365,817 $ 274,515 Cost of sales 223,546 212,981 169,559 Gross margin 170,782 152,836 104,956 Operating expenses: Research and development 26,251 21,914 18,752 Selling, general and administrative 25,094 21,973 19,916 Total operating expenses 51,345 43,887 38,668 Operating income 119,437 108,949 66,288 Other income/(expense), net (334) 258 803 Income before provision for income taxes 119,103 109,207 67,091 Provision for income taxes 19,300 14,527 9,680 Net income $ 99,803 $ 94,680 $ 57,411 Earnings per share: Basic (in dollars per share) $ 6.15 $ 5.67 $ 3.31 Diluted (in dollars per share) $ 6.11 $ 5.61 $ 3.28 Shares used in computing earnings per share: Basic (in shares) 16,215,963 16,701,272 17,352,119 Diluted (in shares) 16,325,819 16,864,919 17,528,214 Products Net sales $ 316,199 $ 297,392 $ 220,747 Cost of sales 201,471 192,266 151,286 Services Net sales 78,129 68,425 53,768 Cost of sales $ 22,075 $ 20,715 $ 18,273 Dividends and dividend equivalents declared per share CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) shares in Thousands, $ in Millions
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Three Month Ended Jul. 01, 2023 Apr. 01, 2023 81,797 94,836 45,384 52,860 36,413 41,976 7,442 7,457 5,973 6,201 13,415 13,658 22,998 28,318 (265) 64 22,733 28,382 2,852 4,222 19,881 24,160 1.27 1.53 1.26 1.52 15,697,614 15,787,154 15,775,021 15,847,050 60,584 73,929 39,136 46,795 21,213 20,907 6,248 6,065 0.24 0.23
e Sep. 24, 2022 Sep. 25, 2021 Current assets: Cash and cash equivalents $ 23,646 $ 34,940 Marketable securities 24,658 27,699 Accounts receivable, net 28,184 26,278 Inventories 4,946 6,580 Vendor non-trade receivables 32,748 25,228 Other current assets 21,223 14,111 Total current assets 135,405 134,836 Non-current assets: Marketable securities 120,805 127,877 Property, plant and equipment, net 42,117 39,440 Other non-current assets 54,428 48,849 Total non-current assets 217,350 216,166 Total assets 352,755 351,002 Current liabilities: Accounts payable 64,115 54,763 Other current liabilities 60,845 47,493 Deferred revenue 7,912 7,612 Commercial paper 9,982 6,000 Term debt 11,128 9,613 Total current liabilities 153,982 125,481 Non-current liabilities: Term debt 98,959 109,106 Other non-current liabilities 49,142 53,325 Total non-current liabilities 148,101 162,431 Total liabilities 302,083 287,912 Commitments and contingencies Shareholders’ equity: 64,849 57,365 Retained earnings/(Accumulated deficit) (3,068) 5,562 Accumulated other comprehensive income/(loss) (11,109) 163 Common stock and additional paid-in capital, $0.00001 par value: 50,400,000 shares authorized; 15,943,425 and 16,426,786 shares issued and outstanding, respectively
Total shareholders’ equity 50,672 63,090 Total liabilities and shareholders’ equity $ 352,755 $ 351,002
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Three Month Ended Jul. 01, 2023 28,408 24,687 $ 23,646 $ 27,502 34,074 31,185 24,658 20,729 19,549 17,936 28,184 21,803 7,351 7,482 4,946 5,433 19,637 17,963 32,748 20,439 13,640 13,660 21,223 16,386 122,659 112,913 135,405 112,292 104,061 110,461 120,805 131,077 43,550 43,398 42,117 40,335 64,768 65,388 54,428 52,605 212,379 219,247 217,350 224,017 335,038 332,160 352,755 336,309 46,699 42,945 64,115 48,343 58,897 56,425 60,845 48,811 8,158 8,131 7,912 7,728 3,993 1,996 9,982 10,982 7,216 10,578 11,128 14,009 124,963 120,075 153,982 129,873 98,071 97,041 98,959 94,700 51,730 52,886 49,142 53,629 149,801 149,927 148,101 148,329 274,764 270,002 302,083 278,202 70,667 69,568 64,849 62,115 1,408 4,336 (3,068) 5,289 (11,801) (11,746) (12,912) (11,109) (9,297) Dec. 31,2022 Sep. 24, 2022 Jun. 25, 2022 Apr. 01, 2023 $ 20,535 30,820 23,752 6,820 30,428 16,422 128,777 114,095 42,951 60,924 217,970 346,747 57,918 59,893 7,992 1,743 9,740 137,286 99,627 53,107 152,734 290,020 66,399 3,240
60,274 62,158 50,672 58,107 335,038 332,160 $ 352,755 $ 336,309 56,727 $ 346,747
12 Months Ended 3 month Sep. 24, 2022 Sep. 25, 2021 Sep. 26, 2020 Jul. 01, 2023 Statement of Cash Flows [Abstract] Cash, cash equivalents and restricted cash, beginning balances $ 35,929 $ 39,789 $ 50,224 8,326 Operating activities: Net income 99,803 94,680 57,411 24,680 Depreciation and amortization 11,104 11,284 11,056 2,955 Share-based compensation expense 9,038 7,906 6,829 2,736 Deferred income tax expense/(benefit) 895 (4,774) (215) Other 111 (147) (97) (550) Changes in operating assets and liabilities: Accounts receivable, net (1,823) (10,125) 6,917 2,536 Inventories 1,484 (2,642) (127) (857) Vendor non-trade receivables (7,520) (3,903) 1,553 4,370 Other current and non-current assets (6,499) (8,042) (9,588) (1,621) Accounts payable 9,448 12,326 (4,062) (5,597) Deferred revenue 478 1,676 2,081 Other current and non-current liabilities 5,632 5,799 8,916 995 Cash generated by operating activities 122,151 104,038 80,674 29,648 Investing activities: Purchases of marketable securities (76,923) (109,558) (114,938) (6,985) Proceeds from maturities of marketable securities 29,917 59,023 69,918 9,286 Proceeds from sales of marketable securities 37,446 47,460 50,473 1,320 Payments for acquisition of property, plant and equipment (10,708) (11,085) (7,309) (2,932) Payments made in connection with business acquisitions, net (306) (33) (1,524) Other (1,780) (352) (909) (251) Cash used in investing activities (22,354) (14,545) (4,289) 437 Financing activities: (6,223) (6,556) (3,634) (1,706) Payments for dividends and dividend equivalents (14,841) (14,467) (14,081) (3,756) Repurchases of common stock (89,402) (85,971) (72,358) (18,849) CONSOLIDATED STATEMENTS OF CASH FLOWS - USD ($) $ in Millions Adjustments to reconcile net income to cash generated by operating activities: Payments for taxes related to net share settlement of equity awards
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Proceeds from issuance of term debt, net 5,465 20,393 16,091 5,228 Repayments of term debt (9,543) (8,750) (12,629) (3,717) Proceeds from/(Repayments of) commercial paper, net 3,955 1,022 (963) (1,990) Other (160) 976 754 (169) Cash used in financing activities (110,749) (93,353) (86,820) (28,445) Decrease in cash, cash equivalents and restricted cash (10,952) (3,860) (10,435) 4,921 Cash, cash equivalents and restricted cash, ending balances 24,977 35,929 39,789 9,966 Supplemental cash flow disclosure: Cash paid for income taxes, net 19,573 25,385 9,501 2,340 Cash paid for interest $ 2,865 $ 2,687 $ 3,002 863
hs ended Apr. 01, 2023 12,489 27,079 2,907 2,796 (866) 4,798 (1,274) 7,393 (2,046) (10,382) 879 31,283 (5,599) 8,562 949 (3,352) (124) 437 (1,367) (3,709) (19,535)
(1,826) (3,375) (3,980) (228) (30,644) 1,076 13,565 2,447 937
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help