You are required to prepare the following financial statements using Excel. USE EXCEL EFFICIENTLY AND EFFECTIVELY TO COMPLETE THIS PROJECT (cell references, formulas, etc.).

File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments + X I = n - A A ab Wrap Text General AY Arial 10 BIUS AutoSum Film Clear Paste A Merge Center $ -% -3 LI Conditional Format as Cell Formatting Table Styles Styles Insert Delete Format Ideas Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas A3 fix You are required to prepare the following financial statements using Excel A B H J K L M N 0 P Q 1 D E F G Financial Statements Project VOWNL You are required to prepare the following financial statements using Excel. 4 USE EXCEL EFFICIENTLY AND EFFECTIVELY TO COMPLETE THIS PROJECT (cell references, formulas, etc.). 6 (1) Using the data for Brady and Co. provided in the sheet labeled "Trial Balance" prepare: 7 A Balance Sheet - comparative, classified in proper format for fiscal years 2015 and 2016 8 B Income Statement - multiple-step for fiscal years 2015 and 2016. Include carnings per share data. 9 Statement of Retained Earnings for 2016. 10 Use separate sheets, appropriately named, for each financial statement. 11 12 D List 5 notes that would be required if you were also preparing the notes to these financial statements. 42 13 Do not prepare the notes, just briefly list the accounts, etc. for which GAAP would require disclosure 14 based on Spring's financial statements. 15 16 17 (2) Using the data for Gronk, Inc. provided in the sheet labeled "Cash Flows" prepare: 18 A Statement of Cash Flows for fiscal year 2016 in proper format. 19 Use a separate sheet, appropriately named, for the Statement of Cash Flows. 20 21 (3) Place your name in cell A1 of the first sheet you create and on all sheets to be printed out. 22 23 FILENAME: 24 Name your file FSlastname. For example, my file would be named: FSCasello_Bouges 25 26 (4) Neatness counts. Make sure the pages break in appropriate places for printing. For instance, make sure the entire 27 balance sheet prints out on one page. Look at the annual report of your favorite company for help with 28 appropriate formatting, subtotalling, underlining, grouping, etc. 29 .-.---.---------- Instructions CashFlows TrialBal File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Autosum n X LG - 12 Arial ~ A A === TTY 29 Wrap Text Custom 4 Fill Paste Av Insert Delete Format BI U $ % 8-9 Ideas Merge & Center Clear Conditional Format as Cell Formatting Teble Styles Styles Sort & Find & Filter Select Clipboard Font Alignment Number Editing Ideas C42 X 141029 A F H 1 J K L M N P a 1 2 C Brady and Co. List of Accounts from General Ledger in Alphabetical Order December 31, 2016 (thousands of dollars) 3 4 5 B 2015 2016 7 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 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 18 Accumulated Post-Employment Benefit Obligation (long-term) 17 Additional Paid-in Capital, Common Slock 18 Additional Paid-in Capital, Preferred Slock 19 Allowance for Doubtful Accounts 20 Bonds Payable 21 Cash and Cash Equivalents 22 Common Stock ($1.00 par value) authorized 900 million shares 23 issued 300 million shares in 2016,284 million in 2015 24 Cost of Goods Sold zs Current Portion of Long term Debt ze Deferred Tax Assets (current) 27 Deferred Tax Liabilities (long-term) 28 Depreciation Expense z9 Dividends - Common 30 Dividends - Preferred 31 General & Administrative Expenses 32 Goodwill and Other Intangibles 23 Income Taxes Payable 24 Interest Expense 26 Interest Income 26 Investments in unconsolidated affiliated companies 37 Inventories 22 Long-term Debt Instructions CashFlows TrialBal + 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 3212, 491 246 002 102 563 201,366 241,336 10.126 9.563 1,235,000 163,214 1.456.896 224,561 3,202.559 3,702, 700 HA MTT File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments X V AutoSum Arial - 12 = - A A ah Wrap Text Custom / TIX 49 4 Paste BTU Av $ - %689 Insert Delete Format Merge & Center Ideas Clear Conditional Format as Cel Formatting Table Styles Styles Sort & Find & Filter Select Criting Clipboard Font Alignment 1 Number Cells Ideas C42 141029 D E F H J L M N P 7.453 900 900 170,296 3.936,726 201,636 496,597 255,013 2.960.256 8,430.061 5,173.286 6,528.967 B 29 (Loss) Income from Discontinued Operations, net of tax 28.100 40 Preferred Stock ($10 par value) authorized 10 million shares 41 issued 90,000 shares in 2016. 90,000 in 2015 42 Prepaid Expenses 141,029 43 Property, Plant and Equipment 2,943,216 44 Provision for income taxes 245, 105 15 Research and Development Expenses 199,500 18 Restructuring Charges 199,506 47 Retained Earnings, beginning 48 Sales 49 Selling Expenses 19,385 50 Short-term Investments 20,000 51 Treasury Stock, at cost - 117.156,719 shares in 2016 4,472,989 52 and 108,822,953 sharos in 2015 53 Uneamed Revenues 54 22,423,269 56 Net Income (loss) 556 557 Weighted average number of common shares 58 FY 2016: 59 Basic 208 448,076 shares Bo Diluted 210.348,076 shares 81 FY 2015: 82 Basic 218,464,140 shares 83 Diluted 220,964, 140 shares 19,952 26,800 4.263,984 456,325 22,423.269 23.335,236 423,689 23,335 236 Ba 67 68 69 70 71 72 73 74 75 76 77 78 Instructions CashFlows TrialBal (+) File Draw Page Layout Formulas Data Review View Help Share Comments Home Insert X Arial LI BTU Autosum - 12 = ~ A A a Wrap Text General / TIX 49 3 Paste A. $ -% 888 Insert Delete Format Es Merge & Center Ideas Clear Conditional Formates Cel Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number 5 Cells Ideas A1 fi Gronk, Inc G H 7 L A B 1 Gronk, Inc 2 List of Items for Statement of Cash Flows Statement 3 December 31, 2016 4 (thousands of dollars) 5 6 Cash and Cash Equivalents, January 1, 2016 66.200 7 Cash and Cash Equivalents, December 31, 2016 8 increase in accrued expenses 2.300 9 decrease in prepaid expenses 960 10 increase in inventories 21,350 11 decrease in income taxes payable 3,500 12 increase in accounts payable 6.840 13 gain on sale of investment 11,000 14 increase in accounts receivable 20.000 15 gain on sale of land 20.500 16 dividend payments 33,000 17 depreciation expense 39,990 18 payments for purchase of investments 40,500 19 payments for purchase of equipment 56,200 20 payments for ppuchase of land 62,500 21 proceeds from sale of land 85,000 22 proceeds from the issuance of stock 81.000 23 proceeds from sale of investments 100.500 24 net income 120.000 25 payments made to retire bonds payable 150,000 26 proceeds from the issueance of a mortgage 175,000 27 payments for purchase of building 187.500 28 29 30 31 Instructions Cash Flows TrialBal + Ready --- Add-ins loaded successfully 110%