You are required to prepare the following financial statements using Excel. USE EXCEL EFFICIENTLY AND EFFECTIVELY TO COMPLETE THIS PROJECT (cell references, formulas, etc.). (1) Using the data for Brady and Co. provided in the sheet prepare: Balance Sheet - comparative, classified in proper format for fiscal years 2015 and 2016 Income Statement - multiple-step for fiscal years 2015 and 2016. Include earnings per share data. Statement of Retained Earnings for 2016.

2015 2016 Dr Dr Cr 1,020,364 Cr 1,079,837 2,943, 125 3,245,967 508,643 650,216 126,000 281,364 601,236 1,829,634 802,316 299,304 75 125,436 224,563 721,358 450,356 90,476 311,253 85,000 1,999,999 402,634 299,304 75 124,645 249,046 401,236 751,329 300,000 284,000 3,000,235 2,763,584 720,125 849,869 62,596 81,236 229.000 440,263 307,200 292,351 2,000 1,732,429 3,212,491 311,236 214,956 945 1,459,695 3,212,491 246,002 102,563 201,366 241.336 6 7 8 Accounts Payable 9 Accounts Receivable 10 Accrued Liabilities - Other 11 Accrued Pension Liabilities 12 Accrued Restructuring Charges 13 Accrued Salaries, Wages and Commissions 14 Accumulated Other Comprehensive Income (Loss) 15 Accumulated Depreciation - Property, Plant & Equipment 16 Accumulated Post-Employment Benefit Obligation (long-term) 17 Additional Paid-in Capital, Common Stock 18 Additional Paid-in Capital, Preferred Stock 19 Allowance for Doubtful Accounts 20 Bonds Payable 21 Cash and Cash Equivalents 22 Common Stock ($1.00 par value) 23 Cost of Goods Sold 24 Current Portion of Long-term Debt 25 Deferred Tax Assets (current) 26 Deferred Tax Liabilities (long-term) 27 Depreciation Expense 28 Dividends - Common 29 Dividends - Preferred 30 General & Administrative Expenses 31 Goodwill and Other Intangibles 32 Income Taxes Payable 33 Interest Expense 34 Interest Income 35 Investments in unconsolidated affiliated companies 36 Inventories 37 Long-term Debt 38 (Loss) Income from Discontinued Operations, net of tax 39 Preferred Stock ($10 par value) authorized 10 million shares 40 issued 90,000 shares in 2016, 90,000 in 2015 41 Prepaid Expenses 42 Property, Plant and Equipment 43 Provision for income taxes 44 Research and Development Expenses 45 Restructuring Charges 46 Retained Earnings, beginning 47 Sales 48 Selling Expenses 49 Short-term Investments 50 Treasury Stock, at cost 51 Unearned Revenues 52 53 Net Income (loss) 54 55 Weighted average number of common shares: 56 FY 2016: 57 Basic 58 Diluted 59 FY 2015: 60 Basic 61 Diluted 10,126 9,563 1,235,000 163,214 1,456,896 224.561 3,202,559 28,100 3,702,700 7,453 900 900 141.029 2,943,216 245,105 199,500 199,506 170,296 3,936,726 201,636 496,597 255,013 2,960,256 8,430,061 5,173,286 6,526,967 19,365 20,000 4,472,969 19,952 26,800 4,263,984 456,325 22,423,269 423,689 23,335,236 22,423,269 23,335, 236 208,448,076 shares 210,348,076 shares 218,464,140 shares 220.964,140 shares 2015 2016 Dr Dr Cr 1,020,364 Cr 1,079,837 2,943, 125 3,245,967 508,643 650,216 126,000 281,364 601,236 1,829,634 802,316 299,304 75 125,436 224,563 721,358 450,356 90,476 311,253 85,000 1,999,999 402,634 299,304 75 124,645 249,046 401,236 751,329 300,000 284,000 3,000,235 2,763,584 720,125 849,869 62,596 81,236 229.000 440,263 307,200 292,351 2,000 1,732,429 3,212,491 311,236 214,956 945 1,459,695 3,212,491 246,002 102,563 201,366 241.336 6 7 8 Accounts Payable 9 Accounts Receivable 10 Accrued Liabilities - Other 11 Accrued Pension Liabilities 12 Accrued Restructuring Charges 13 Accrued Salaries, Wages and Commissions 14 Accumulated Other Comprehensive Income (Loss) 15 Accumulated Depreciation - Property, Plant & Equipment 16 Accumulated Post-Employment Benefit Obligation (long-term) 17 Additional Paid-in Capital, Common Stock 18 Additional Paid-in Capital, Preferred Stock 19 Allowance for Doubtful Accounts 20 Bonds Payable 21 Cash and Cash Equivalents 22 Common Stock ($1.00 par value) 23 Cost of Goods Sold 24 Current Portion of Long-term Debt 25 Deferred Tax Assets (current) 26 Deferred Tax Liabilities (long-term) 27 Depreciation Expense 28 Dividends - Common 29 Dividends - Preferred 30 General & Administrative Expenses 31 Goodwill and Other Intangibles 32 Income Taxes Payable 33 Interest Expense 34 Interest Income 35 Investments in unconsolidated affiliated companies 36 Inventories 37 Long-term Debt 38 (Loss) Income from Discontinued Operations, net of tax 39 Preferred Stock ($10 par value) authorized 10 million shares 40 issued 90,000 shares in 2016, 90,000 in 2015 41 Prepaid Expenses 42 Property, Plant and Equipment 43 Provision for income taxes 44 Research and Development Expenses 45 Restructuring Charges 46 Retained Earnings, beginning 47 Sales 48 Selling Expenses 49 Short-term Investments 50 Treasury Stock, at cost 51 Unearned Revenues 52 53 Net Income (loss) 54 55 Weighted average number of common shares: 56 FY 2016: 57 Basic 58 Diluted 59 FY 2015: 60 Basic 61 Diluted 10,126 9,563 1,235,000 163,214 1,456,896 224.561 3,202,559 28,100 3,702,700 7,453 900 900 141.029 2,943,216 245,105 199,500 199,506 170,296 3,936,726 201,636 496,597 255,013 2,960,256 8,430,061 5,173,286 6,526,967 19,365 20,000 4,472,969 19,952 26,800 4,263,984 456,325 22,423,269 423,689 23,335,236 22,423,269 23,335, 236 208,448,076 shares 210,348,076 shares 218,464,140 shares 220.964,140 shares