Calculated Cash Flow Summery for Infow and Outflow

I) Create a Cash Flow Summary for Applied Xlaterials' Statement of Cash Flows, Note that AMAT's statement has a lot more stuff in it than the Exhibit. Thats 0k, that s how the works. We want all the cash inflows on top and all the cash outflows on the no matter what their name Cash from Operations is a single line in the Summary sheet. You don't need to do anything with all the various lines in the Operating section here. There are a combinations I 'Nant you to make. Leaving them out m their gross form gives an unrealistic impression of how AMAT is getting"using cash: AMAT rolls investments over as they come due, so they're not really receiving cash from sales and using cash on purchases in the traditional sense. Please combine the Proceeds from Sales and Matunties oflnvestments with Purchases oflnvestment into a single Ime item, "Net Purchases of Investments." This belongs the cash outflow section and will show %hether they have decided to increase their Investment portfolio through additional purchases or decrease their portfolio by selling investments off Please alO combine the tua Commercial Paper item into a single line. F or puposes ofthis worksheet, they dldnt get cash' through commercial paper and then 'use cash' paving it off. It was iut a wash. The Tax Withholding papnent and Lease paynaents need to go on the statement, but feel free to ignore them from an analysis standpoint Thevre both niche and immaterial. Cash flows operatiru activities: required to to cash provided by operating and Severance end related charges Deferred in Sh rebased corn on in of nts kC&untS receivable Other current end assets kcmants payable liabiliti" Income taxes Other liabilities Ch by ope rating mtivities ftw Capital H*nditures Cuh D' id for acquisitions. net Of ash acauired f m and of m. rd o s e s of Cash in imtine Ktivities fim fr fii.w from commercial paper Re of Common Stock repurchases withholding ted equity ds Payments of dividends to stockholders of princ in fimg (decrease) in cash, cash and restricted ash equwalents md teeming of period Cash. cash eau i valents and restricted cash eauivalents end of Deriod _1E) d issuances 24 903 207 (138) (107) (20) 8,700 (1,100) (25 ) 1,268 (I.S3S) (900) (2.189) (179) (975) (3,032) 4.133 2,100 0.233 6.625 (223) (1.109) (1.590) (16) 390 1.039 (541) 5.3gg (787) (441) 1.363 (6.103) (266) (873) (7.043) aool) 5.101 2.100 s.geg (1,989) (405) (602) 396 5,442 1,471 (2007) (1,216) (3.750) (173) (838) (4,591) (365) 5,466 5.101