Find the blue fill only, PLEASE SHOW FORMULAS: (Find Prepaid Expenses too)
USE THESE DATA TO ANSWER
Dec. 29, 2018 Dec. 28, 2019 Dec. 26, 2020 5. Free Cash Flow Calculation Net Income PLUS Interest(1 - Tax Rate) PLUS Depreciation Net Working Capital Calculation (NWC) OP CASH AR INV Prepaid Expenses AP Acc Exp Deferred Revenues or Income NWC (Net Working Capitol) Chg in NWC CAPEX FCFF = NI = Interest(1 - Tax Rate) + Depreciation - Chg in NWC - CAPEX WACC Constant Growth Rate (Estimated) PV of FCFF (Intrinsic Enterprise Value) :- 4.50% Total Debt Excess cash Number of shares outstanding Intrinsic value per share B B Dec. 28, 2019 Dec. 26, 2020 $ 4,194 1,082 7,847 7,659 8,744 1,713 31,239 55,386 3,967 3,276 26,276 10,827 5,553 136,524 $5,865 2,292 15,738 6,782 8,427 5,400 2,745 47,249 56,584 5,152 2,192 26,971 9,026 5,917 153,091 Formula Bar . 1 Consolidated Balance Sheets - USD ($) $ in Millions 2 Current assets: 3 Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents 4 Short-term investments 5 Trading assets 6 Accounts receivable, net of allowance for doubtful accounts 7 Inventories 8 Assets held for sale 9 Other current assets 10 Total current assets 11 Property, plant and equipment, net 12 Equity investments 13 Other long-term investments 14 Goodwill 15 Identified intangible assets, net 16 Other long-term assets 17 Total assets 18 Current liabilities: 19 Short-term debt 20 Accounts payable 21 Accrued compensation and benefits 22 Other accrued liabilities 23 Total current liabilities 24 Debt 25 Contract Liabilities 26 Income taxes payable, non-current 27 Deferred income taxes 28 Other long-term liabilities 29 Commitments and Contingencies (Note 19) 30 Temporary equity 31 Stockholders' equity: 32 Preferred stock, $0.001 par value, 50 shares authorized; none issued Common stock, $0.001 par value, 10,000 shares authorized; 4,062 shares issued and 33 outstanding (4,290 issued and outstanding in 2019) and capital in excess of par value 34 Accumulated other comprehensive income (loss) 35 Retained earnings 36 Total stockholders' equity 37 Total liabilities, temporary equity, and stockholders' equity 38 3,693 4,128 3,853 10,636 22,310 25,308 1,368 4,919 2,044 2,916 2,504 5,581 3,999 12,670 24,754 33,897 1,367 4,578 3,843 3,614 155 0 0 25,261 0 25,556 (1,280) 53,523 77,504 $ 136,524 (751) 56,233 81,038 $ 153,091 A B D 1 12 Months Ended Dec. 28, 2019 2 Dec. 29, 2018 Dec. 26, 2020 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 3 Income Statement [Abstract] 4 Net revenue 5 Cost of sales 6 Gross margin 7 Research and development 8 Marketing, general and administrative 9 Restructuring and other charges 10 Operating expenses 11 Operating income 12 Gains (losses) on equity investments, net 13 Interest and other, net 14 Income before taxes 15 Provision for taxes 16 Net income 17 Earnings per share-basic 18 Earnings per share-diluted 19 Weighted average shares of common stock outstanding: 20 Basic (shares) 21 Diluted (shares) 22 $ 70,848 27,111 43,737 13,543 6,950 (72) 20,421 23,316 (125) 126 23,317 2,264 $ 21,053 $ 4.57 $4.48 $ 71,965 29,825 42,140 13,362 6,350 393 20,105 22,035 1,539 484 24,058 3,010 $ 21,048 $4.77 $4.71 $ 77,867 34,255 43,612 13,556 6,180 198 19,934 23,678 1,904 (504) 25,078 4,179 $ 20,899 $ 4.98 $ 4.94 4,611 4,701 4,417 4,473 4,199 4,232 B D E 12 Months Ended Dec. 26, Dec. 29, 2018 Dec. 28, 2019 2020 $3,433 $ 3,019 $ 4,194 21,053 21,048 20,899 7,520 1,546 1,565 155 (497) 9,204 1,705 1,622 (892) (690) 10,482 1,854 1,757 (1,757) (30) (1,714) (214) 211 (260) 1,367 (1,601) 301 1935) (1,481) 696 91 (782) 885 2,674 12,097 33,145 883 (687) 412 463 (181) 1,620 (331) 14,485 35,384 8,379 29,432 A 1 Consolidated Statements of Cash Flows - USD ($) $ in Millions 2 3 Statement of Cash Flows [Abstract] 4 Cash and cash equivalents, beginning of period 5 Cash flows provided by (used for) operating activities: 6 Net income 7 Adjustments to reconcile net income to net cash provided by operating activities: 8 Depreciation 9 Share-based compensation 10 Amortization of intangibles 11 (Gains) losses on equity investments, net 12 (Gains) losses on divestitures 13 Changes in assets and liabilities: 14 Accounts receivable 15 Inventories 16 Accounts payable 17 Accrued compensation and benefits 18 Customer deposits and prepaid supply agreements 19 Income taxes 20 Other assets and liabilities 21 Total adjustments 22 Net cash provided by operating activities 23 Cash flows provided by used for) investing activities: 24 Additions to property, plant and equipment 25 Additions to held for sale NAND property, plant, and equipment 26 Acquisitions, net of cash acquired 27 Purchases of available-for-sale debt investments 28 Maturities and sales of available-for-sale debt investments 29 Purchases of trading assets 30 Maturities and sales of trading assets 31 Purchases of equity investments 32 Proceeds from Equity Method Investment, Distribution, Return of Capital 33 Proceeds from Divestiture of Businesses 34 Other investing 35 Net cash used for investing activities 36 Cash flows provided by (used for) financing activities: 37 Issuance of term debt, net of issuance costs 38 Repayments of Long-term Debt 39 Proceeds from sales of common stock through employee equity incentive plans 40 Repurchase of common stock 41 Payment of dividends to stockholders 42 Other financing 43 Net cash provided by (used for) financing activities 44 Net increase (decrease) in cash and cash equivalents 45 Cash and cash equivalents, end of period 46 Supplemental disclosures: Acquisition of property, plant and equipment included in accounts payable and accrued 47 liabilities 48 Interest, net of capitalized interest 49 Income taxes, net of refunds 50 (15,181) 0 (190) (3,843) 3,163 (9,503) 12,111 (874) 2,802 548 (272) (11,239) (16,213) (14,259) 0 194 (1,958) (837) (2,268) (6,862) 4,226 6,781 (9,162) (22,377) 7,178 15,377 (522) (720) 2,688 910 911 123 715 1,262 (14,405) (20,796) 423 (3,026) 555 (10,730) (5,541) (288) (18,607) (414) 3,019 3,392 10,247 (2,627) (4,525) 750 897 (13,576) (14,229) (5,576) (5,568) 72 261 (17,565) (12,917) 1,175 1,671 4,194 5,865 2,340 1,761 2,973 448 $ 3,813 469 $ 2,110 594 $ 2,436 Dec. 29, 2018 Dec. 28, 2019 Dec. 26, 2020 5. Free Cash Flow Calculation Net Income PLUS Interest(1 - Tax Rate) PLUS Depreciation Net Working Capital Calculation (NWC) OP CASH AR INV Prepaid Expenses AP Acc Exp Deferred Revenues or Income NWC (Net Working Capitol) Chg in NWC CAPEX FCFF = NI = Interest(1 - Tax Rate) + Depreciation - Chg in NWC - CAPEX WACC Constant Growth Rate (Estimated) PV of FCFF (Intrinsic Enterprise Value) :- 4.50% Total Debt Excess cash Number of shares outstanding Intrinsic value per share B B Dec. 28, 2019 Dec. 26, 2020 $ 4,194 1,082 7,847 7,659 8,744 1,713 31,239 55,386 3,967 3,276 26,276 10,827 5,553 136,524 $5,865 2,292 15,738 6,782 8,427 5,400 2,745 47,249 56,584 5,152 2,192 26,971 9,026 5,917 153,091 Formula Bar . 1 Consolidated Balance Sheets - USD ($) $ in Millions 2 Current assets: 3 Cash, Cash Equivalents, Restricted Cash and Restricted Cash Equivalents 4 Short-term investments 5 Trading assets 6 Accounts receivable, net of allowance for doubtful accounts 7 Inventories 8 Assets held for sale 9 Other current assets 10 Total current assets 11 Property, plant and equipment, net 12 Equity investments 13 Other long-term investments 14 Goodwill 15 Identified intangible assets, net 16 Other long-term assets 17 Total assets 18 Current liabilities: 19 Short-term debt 20 Accounts payable 21 Accrued compensation and benefits 22 Other accrued liabilities 23 Total current liabilities 24 Debt 25 Contract Liabilities 26 Income taxes payable, non-current 27 Deferred income taxes 28 Other long-term liabilities 29 Commitments and Contingencies (Note 19) 30 Temporary equity 31 Stockholders' equity: 32 Preferred stock, $0.001 par value, 50 shares authorized; none issued Common stock, $0.001 par value, 10,000 shares authorized; 4,062 shares issued and 33 outstanding (4,290 issued and outstanding in 2019) and capital in excess of par value 34 Accumulated other comprehensive income (loss) 35 Retained earnings 36 Total stockholders' equity 37 Total liabilities, temporary equity, and stockholders' equity 38 3,693 4,128 3,853 10,636 22,310 25,308 1,368 4,919 2,044 2,916 2,504 5,581 3,999 12,670 24,754 33,897 1,367 4,578 3,843 3,614 155 0 0 25,261 0 25,556 (1,280) 53,523 77,504 $ 136,524 (751) 56,233 81,038 $ 153,091 A B D 1 12 Months Ended Dec. 28, 2019 2 Dec. 29, 2018 Dec. 26, 2020 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 3 Income Statement [Abstract] 4 Net revenue 5 Cost of sales 6 Gross margin 7 Research and development 8 Marketing, general and administrative 9 Restructuring and other charges 10 Operating expenses 11 Operating income 12 Gains (losses) on equity investments, net 13 Interest and other, net 14 Income before taxes 15 Provision for taxes 16 Net income 17 Earnings per share-basic 18 Earnings per share-diluted 19 Weighted average shares of common stock outstanding: 20 Basic (shares) 21 Diluted (shares) 22 $ 70,848 27,111 43,737 13,543 6,950 (72) 20,421 23,316 (125) 126 23,317 2,264 $ 21,053 $ 4.57 $4.48 $ 71,965 29,825 42,140 13,362 6,350 393 20,105 22,035 1,539 484 24,058 3,010 $ 21,048 $4.77 $4.71 $ 77,867 34,255 43,612 13,556 6,180 198 19,934 23,678 1,904 (504) 25,078 4,179 $ 20,899 $ 4.98 $ 4.94 4,611 4,701 4,417 4,473 4,199 4,232 B D E 12 Months Ended Dec. 26, Dec. 29, 2018 Dec. 28, 2019 2020 $3,433 $ 3,019 $ 4,194 21,053 21,048 20,899 7,520 1,546 1,565 155 (497) 9,204 1,705 1,622 (892) (690) 10,482 1,854 1,757 (1,757) (30) (1,714) (214) 211 (260) 1,367 (1,601) 301 1935) (1,481) 696 91 (782) 885 2,674 12,097 33,145 883 (687) 412 463 (181) 1,620 (331) 14,485 35,384 8,379 29,432 A 1 Consolidated Statements of Cash Flows - USD ($) $ in Millions 2 3 Statement of Cash Flows [Abstract] 4 Cash and cash equivalents, beginning of period 5 Cash flows provided by (used for) operating activities: 6 Net income 7 Adjustments to reconcile net income to net cash provided by operating activities: 8 Depreciation 9 Share-based compensation 10 Amortization of intangibles 11 (Gains) losses on equity investments, net 12 (Gains) losses on divestitures 13 Changes in assets and liabilities: 14 Accounts receivable 15 Inventories 16 Accounts payable 17 Accrued compensation and benefits 18 Customer deposits and prepaid supply agreements 19 Income taxes 20 Other assets and liabilities 21 Total adjustments 22 Net cash provided by operating activities 23 Cash flows provided by used for) investing activities: 24 Additions to property, plant and equipment 25 Additions to held for sale NAND property, plant, and equipment 26 Acquisitions, net of cash acquired 27 Purchases of available-for-sale debt investments 28 Maturities and sales of available-for-sale debt investments 29 Purchases of trading assets 30 Maturities and sales of trading assets 31 Purchases of equity investments 32 Proceeds from Equity Method Investment, Distribution, Return of Capital 33 Proceeds from Divestiture of Businesses 34 Other investing 35 Net cash used for investing activities 36 Cash flows provided by (used for) financing activities: 37 Issuance of term debt, net of issuance costs 38 Repayments of Long-term Debt 39 Proceeds from sales of common stock through employee equity incentive plans 40 Repurchase of common stock 41 Payment of dividends to stockholders 42 Other financing 43 Net cash provided by (used for) financing activities 44 Net increase (decrease) in cash and cash equivalents 45 Cash and cash equivalents, end of period 46 Supplemental disclosures: Acquisition of property, plant and equipment included in accounts payable and accrued 47 liabilities 48 Interest, net of capitalized interest 49 Income taxes, net of refunds 50 (15,181) 0 (190) (3,843) 3,163 (9,503) 12,111 (874) 2,802 548 (272) (11,239) (16,213) (14,259) 0 194 (1,958) (837) (2,268) (6,862) 4,226 6,781 (9,162) (22,377) 7,178 15,377 (522) (720) 2,688 910 911 123 715 1,262 (14,405) (20,796) 423 (3,026) 555 (10,730) (5,541) (288) (18,607) (414) 3,019 3,392 10,247 (2,627) (4,525) 750 897 (13,576) (14,229) (5,576) (5,568) 72 261 (17,565) (12,917) 1,175 1,671 4,194 5,865 2,340 1,761 2,973 448 $ 3,813 469 $ 2,110 594 $ 2,436
