Question

Construct the 2020 Projected Cash Flow Statement

Apple Inc Income Statement 5 πιιΙσπ 2030 $ 233,715 (128 832) (11,257) 93026 2019 $215.639 (120.371) (10.505) 54.253 217,795 (119,787) 10.30 87,118 ProProj 2021 2022 219.373 222,173 (120.985) (122.195) (10.999) (11.109) 87,989 169 Cost of sales Depreciation Gross margin Operating expenses! Research and development Selling general and administrative Total operating expenses Operating income Other Income expense), net Income before provision for Income taxes Provision for income taxes Net Income 18.057) (14,329) 022.96 71.230 1.285 72.515 (19,121) $ 53,394 11,109) (15,552) 25.561) (10.045) (14,194) (24,239) 60024 1345 51 372 (15.685) $ 45,587 (10,290 (15,246) (26,135) 60,983 1343 (10,999) (15,398) 26,397) 61.593 1.348 62,941 (16,365) 62.331 1,348 63.556 (16,525) (16,206) Selected Other Items: Dividends Interest Expense (embedded in Other Income/Expense above) 11.561 12.150 12 150 1,456 12,150 1.456 12,150 1.456 1.456 Prej Proj Prej Hist 2018 Hist 2019 2020 2021 2022 $ 21,120 20,481 16 349 2.349 13,494 15,085 89 378 164055 22,471 5.116 3.893 5,422 290,345 $ 20,484 45.571 15.754 2.132 13.545 8.283 106.869 170, 430 27,010 20.434 20 ARE 45.671 46.671 15,246 15.398 2.396 2420 13.545 13.545 8.283 8 .283 106.624 106.801 170,430 170,430 32,200 35,600 5.414 5.414 3.206 3.206 8,7578 ,757 326,631 330,208 20,484 45,671 15.552 2,444 13 545 8.283 106.979 170.430 37,100 5,414 3.206 5.414 3,205 8.757 321,686 8.757 331,886 Apple Inc Balance Sheet $ millions Current assets: Excess Cash (Projected Years Only) Cash and cash equivalents Short-term marketable securities Accounts receivable, less allowances of $53 and $63, respectively Inventories Vendor non-trade receivables Other current assets Total current assets Long-term marketable securities Property, plant and equipment, net Goodwill Acquired intangible assets, net Other non-current assets Total assets Current liabilities: Additional Borrowings (Projected Only) Accounts payable Accrued expenses Deferred revenue Commercial paper Current portion of long-term debt Total current liabilities Deferred revenue, non-current Long-term debt Other non-current liabilities Total liabilities Commitments and contingencies Shareholders' equity: Common stock and additional paid-in capital Retained earnings Accumulated other comprehensive Income/(loss) Total shareholders' equity Total liabilities and shareholders' equity 37,134 22,027 8,080 37,831 22,027 8,080 35,490 25,181 8,940 8,499 2,500 80,610 3.624 53,329 33,427 170,990 37,294 22.027 8,080 8,105 3.500 79,006 2,930 75,427 36,074 193,437 3.500 70,741 2.930 71,927 36,074 181,672 37,505 22,027 8,080 0 3.500 71.112 2.930 68.427 36,074 178,543 3.500 71.488 2.930 64,927 35,074 175,419 27,416 92,284 (345) 119,355 290,345 31,251 96,364 634 128,249 321,686 31,251 130,339 634 162,224 343,896 31,251 161,339 634 193,224 371,767 31,251 186,339 634 218,224 393,643

Answer 1

projected cash Year 2020 flow statement for the net sales Less: Cost of sales Research and development Selling general and administrative doner income Dividend Add: Decrease in Accounts Receivable In creere in inventories Increase in PPE (net) Decrease in Accounts flayable commercial paper Decrease in cone term debt. 217795. (119787) (10850) (15245) 1348 (1215o) 508 (264) (4990) (160) (8105) (3500) 98559 Scatted with CamScanner