Please explain if possible.

CHAPTER 2 The Balance Sheet 87 Case 2.2 Applied Materials Comprehensive Analysis Case Using the Financial Statement Analysis Template Each chapter in the textbook contains a continuation of this problem. The objective is to learn how to do a comprehensive financial statement analysis in steps as the content of each chapter is learned. Using the 2013 Applied Materials Form 10-K that can be found at www.pearsonhighered.com/fraser, complete the following requirements: (a) Open the financial statement analysis template that you saved from the Chapter 1 Applied Materials problem and input the data from the Applied - Materials balance sheet. Be sure to read the notes to the financial statements to determine the correct numbers to input on the template. For example, the company has combined asset and liability accounts and property, plant and equipment has been recorded net of accumulated depreciation. See Note 7 to help you reorganize the data for the template. When you have finished input- ting the data, review the balance sheet to make sure there are no red blocks indicating that your numbers do not match the cover sheet information you input from the Chapter 1 problem. Make any necessary corrections before printing out both your input and the common-size balance sheet that the template automatically creates for you. Clipboard Formatting Table Styles Font Alignment Number Styles ash_YrO_BS 1711 4 B C D Clear E Type all entries, DO NOT cut & paste values Review 2013 $ ASSETS Cash and cash equivalents Short-term investments 22 Accounts receivable, net 3 Accounts receivable allowance 4 Inventories, net 5 Current deferred taxes 7 Other current assets 9 Property, plant, and equipment 0 Less: accumulated depreciation 2 Long-term investments 3 Goodwill, net 4 Other intangibles, net -5 Other deferred taxes 7 Other assets 1,711 $ 180 1,633 75 1,413 323 705 2,817 1, 1,005, 3,294 1,103 53 2012 Use a formula format [En+n+n] to add multiple financial statement line items into a single cell 1,392 545 Include 'Marketable securities' if listed separately 1.220 87 IF B/S does not have 'Allowance' amounts, see Notes 1,272 369 673 Use formula format to summarize multiple line items 2,917 If Net PPE on B/S, add Accum. Depr. from Notes 2,007 Enter Accumulated Depreciation as a positive number 1,055 3,518 1,355 Use formula format to summarize multiple line items 51 Use formula format to summarize multiple line items Use formula format to summarize multiple line items $ 582 $ 396 Use formula format to summarize multiple line items 73 74 Use formula format to summarize multiple line items 19 LIABILITIES 51 Accounts payable 2 Short-term debt 33 Current portion of long-term debt 34 Accrued liabilities 35 Income taxes payable B7 Other current liabilities 39 Long-term debt 40 Deferred income taxes payable 41 Other deferred liabilities 43 Other liabilities 45 Minority interest 46 STOCKHOLDERS' EQUITY 47 Preferred stock 48 Common stock par value plus additional paid in canital 1,946 71 1,946 200 566 Use formula format to summarize multiple line items Use formula format to summarize multiple line items Included in Total Liabilities and Stockholder Equity total 6.163 5 875 Include 'Canital in excess of par valtelif lister senarately Ready Accessibility: Investigate Paste Format Painter B I U Merge & Center $ % ) Conditional Format as Cell Formatting Table Styles Insert Delete Clipboard Font E Alignment Number Styles Cells Cash_YrO_BS - : fr 1711 D F G 1,946 71 E Use formula format to summarize multiple line items 1,946 200 Use formula format to summarize multiple line items 656 Use formula format to summarize multiple line items Included in Total Liabilities and Stockholder Equity total 566 A B 37 Other current liabilities 39 Long-term debt 40 Deferred income taxes payable 41 Other deferred liabilities 43 Other liabilities 45 Minority interest 46 STOCKHOLDERS' EQUITY 47 Preferred stock 48 Common stock, par value plus additional paid-in capital 49 Retained earnings (accumulated deficit) 50 Treasury stock 51 Accumulated other comprehensive income (loss) 53 Other stockholders' equity 57 No enterable fields exist below this point 58 59 60 61 62 63 64 65 66 6.163 12,487 (11,524) (38) 5,875 Include 'Capital in excess of par value' if listed separately 12,700 Enter a negative amount to bracket the number (11,279) Enter Treasury Stock as a negative number (61) Enter a negative amount to bracket the number Use formula format to summarize multiple line items CHAPTER 2 The Balance Sheet 87 Case 2.2 Applied Materials Comprehensive Analysis Case Using the Financial Statement Analysis Template Each chapter in the textbook contains a continuation of this problem. The objective is to learn how to do a comprehensive financial statement analysis in steps as the content of each chapter is learned. Using the 2013 Applied Materials Form 10-K that can be found at www.pearsonhighered.com/fraser, complete the following requirements: (a) Open the financial statement analysis template that you saved from the Chapter 1 Applied Materials problem and input the data from the Applied - Materials balance sheet. Be sure to read the notes to the financial statements to determine the correct numbers to input on the template. For example, the company has combined asset and liability accounts and property, plant and equipment has been recorded net of accumulated depreciation. See Note 7 to help you reorganize the data for the template. When you have finished input- ting the data, review the balance sheet to make sure there are no red blocks indicating that your numbers do not match the cover sheet information you input from the Chapter 1 problem. Make any necessary corrections before printing out both your input and the common-size balance sheet that the template automatically creates for you. Clipboard Formatting Table Styles Font Alignment Number Styles ash_YrO_BS 1711 4 B C D Clear E Type all entries, DO NOT cut & paste values Review 2013 $ ASSETS Cash and cash equivalents Short-term investments 22 Accounts receivable, net 3 Accounts receivable allowance 4 Inventories, net 5 Current deferred taxes 7 Other current assets 9 Property, plant, and equipment 0 Less: accumulated depreciation 2 Long-term investments 3 Goodwill, net 4 Other intangibles, net -5 Other deferred taxes 7 Other assets 1,711 $ 180 1,633 75 1,413 323 705 2,817 1, 1,005, 3,294 1,103 53 2012 Use a formula format [En+n+n] to add multiple financial statement line items into a single cell 1,392 545 Include 'Marketable securities' if listed separately 1.220 87 IF B/S does not have 'Allowance' amounts, see Notes 1,272 369 673 Use formula format to summarize multiple line items 2,917 If Net PPE on B/S, add Accum. Depr. from Notes 2,007 Enter Accumulated Depreciation as a positive number 1,055 3,518 1,355 Use formula format to summarize multiple line items 51 Use formula format to summarize multiple line items Use formula format to summarize multiple line items $ 582 $ 396 Use formula format to summarize multiple line items 73 74 Use formula format to summarize multiple line items 19 LIABILITIES 51 Accounts payable 2 Short-term debt 33 Current portion of long-term debt 34 Accrued liabilities 35 Income taxes payable B7 Other current liabilities 39 Long-term debt 40 Deferred income taxes payable 41 Other deferred liabilities 43 Other liabilities 45 Minority interest 46 STOCKHOLDERS' EQUITY 47 Preferred stock 48 Common stock par value plus additional paid in canital 1,946 71 1,946 200 566 Use formula format to summarize multiple line items Use formula format to summarize multiple line items Included in Total Liabilities and Stockholder Equity total 6.163 5 875 Include 'Canital in excess of par valtelif lister senarately Ready Accessibility: Investigate Paste Format Painter B I U Merge & Center $ % ) Conditional Format as Cell Formatting Table Styles Insert Delete Clipboard Font E Alignment Number Styles Cells Cash_YrO_BS - : fr 1711 D F G 1,946 71 E Use formula format to summarize multiple line items 1,946 200 Use formula format to summarize multiple line items 656 Use formula format to summarize multiple line items Included in Total Liabilities and Stockholder Equity total 566 A B 37 Other current liabilities 39 Long-term debt 40 Deferred income taxes payable 41 Other deferred liabilities 43 Other liabilities 45 Minority interest 46 STOCKHOLDERS' EQUITY 47 Preferred stock 48 Common stock, par value plus additional paid-in capital 49 Retained earnings (accumulated deficit) 50 Treasury stock 51 Accumulated other comprehensive income (loss) 53 Other stockholders' equity 57 No enterable fields exist below this point 58 59 60 61 62 63 64 65 66 6.163 12,487 (11,524) (38) 5,875 Include 'Capital in excess of par value' if listed separately 12,700 Enter a negative amount to bracket the number (11,279) Enter Treasury Stock as a negative number (61) Enter a negative amount to bracket the number Use formula format to summarize multiple line items