USE EXCEL EFFICIENTLY AND EFFECTIVELY FOR THIS PROJECT (cell references, formulas, etc.)

(1) Using the data for Brady and Co. provided in the sheet labeled "Trial Balance" 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.

*Use separate sheets, appropriately named, for each financial statement.

*List 5 notes that would be required if you were also preparing the notes to these financial statements. Do not prepare the notes, just briefly list the accounts, etc. for which GAAP would require disclosure based on Spring's financial statements.

(2)Using the data for Gronk, Inc. provided in the sheet labeled "Cash Flows" prepare:

-Statement of Cash Flows for fiscal year 2016 in proper format.

*Use a separate sheet, appropriately named, for the Statement of Cash Flows.

Financial Statements Project 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 labeled "Trial Balance" 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. Use separate sheets, appropriately named, for each financial statement. List 5 notes that would be required if you were also preparing the notes to these financial statements. Do not prepare the notes, just briefly list the accounts, etc. for which GAAP would require disclosure based on Spring's financial statements. (2) Using the data for Gronk, Inc. provided in the sheet labeled "Cash Flows" prepare: Statement of Cash Flows for fiscal year 2016 in proper format. Use a separate sheet, appropriately named, for the Statement of Cash Flows. (3) Place your name in cell A1 of the first sheet you create and on all sheets to be printed out. FILENAME: Name your file FSlastname. For example, my file would be named: FSCasello_Bouges (4) Neatness counts. Make sure the pages break in appropriate places for printing. For instance, make sure the entire balance sheet prints out on one page. Look at the annual report of your favorite company for help with appropriate formatting, subtotalling, underlining, grouping, etc. THIS IS A PROJECT TO BE COMPLETED TOTALLY BY EACH STUDENT. DO NOT POST QUESTIONS TO THE DISCUSSION BOARD. STUDENTS ARE TO RESEARCH ANY QUESTIONS ON THEIR OWN OR ASK ME THROUGH MAIL IN BLACKBOARD. rences, formulas, etc.). er share data. ncial statements. quire disclosure asello_Bouges or instance, make sure the entire mpany for help with Brady and Co. List of Accounts from General Ledger in Alphabetical Order December 31, 2016 (thousands of dollars) 2015 Dr Accounts Payable Accounts Receivable Accrued Liabilities - Other Accrued Pension Liabilities Accrued Restructuring Charges Accrued Salaries, Wages and Commissions Accumulated Other Comprehensive Income (Loss) Accumulated Depreciation - Property, Plant & Equipment Accumulated Post-Employment Benefit Obligation (long-term) Additional Paid-in Capital, Common Stock Additional Paid-in Capital, Preferred Stock Allowance for Doubtful Accounts Bonds Payable Cash and Cash Equivalents Common Stock ($.10 par value) authorized 900 million shares issued 300 million shares in 2013, 284 million in 2012 Cost of Goods Sold Current Portion of Long-term Debt Deferred Tax Assets (current) Deferred Tax Liabilities (long-term) Depreciation Expense Dividends - Common Dividends - Preferred General & Administrative Expenses Goodwill and Other Intangibles Income Taxes Payable Interest Expense Interest Income Investments in unconsolidated affiliated companies Inventories Long-term Debt (Loss) Income from Discontinued Operations, net of tax Preferred Stock ($10 par value) authorized 10 million shares issued 90,000 shares in 2013, 90,000 in 2012 Prepaid Expenses Property, Plant and Equipment Provision for income taxes Research and Development Expenses Restructuring Charges Retained Earnings, beginning Sales Selling Expenses Short-term Investments Treasury Stock, at cost - 117,156,719 shares in 2016 and 108,822,953 shares in 2015 Unearned Revenues 2,943,125 Dr 721,358 450,356 90,476 311,253 85,000 1,999,999 402,634 299,304 75 124,635 249,046 601,236 1,829,634 802,316 299,304 75 125,436 224,563 401,236 789,657 300,000 3,000,235 284,000 2,763,584 720,125 62,596 849,869 81,236 229,000 307,200 292,351 2,000 1,732,429 3,212,491 440,263 311,236 214,956 945 1,459,695 ### 246,002 201,366 102,563 241,336 10,126 1,235,000 163,214 9,563 1,456,896 201,236 3,202,559 3,702,636 6,453 900 28,100 900 141,029 2,943,216 245,105 199,500 199,506 155,636 3,936,726 201,636 496,597 255,013 2,960,256 8,430,061 19,365 20,000 4,472,969 Net Income (loss) 208,448,076 shares 210,348,076 shares 218,464,140 shares 220,964,140 shares Cr 1,079,837 3,245,967 508,643 650,216 126,000 281,364 22,423,269 Weighted average number of common shares: FY 2016: Basic Diluted FY 2015: Basic Diluted 2016 Cr 1,020,364 5,173,286 6,526,967 19,652 25,683 4,263,984 456,325 22,423,269 23,334,162 423,689 23,334,162 Gronk, Inc List of Items for Statement of Cash Flows Statement 31-Dec-16 (thousands of dollars) Cash and Cash Equivalents, January 1, 2016 Cash and Cash Equivalents, December 31, 2016 increase in accrued expenses decrease in prepaid expenses increase in inventories decrease in income taxes payable increase in accounts payable gain on sale of investment increase in accounts receivable gain on sale of land dividend payments depreciation expense payments for purchase of investments payments for purchase of equipment payments for ppuchase of land proceeds from sale of land proceeds from the issuance of stock proceeds from sale of investments net income payments made to retire bonds payable proceeds from the issueance of a mortgage payments for purchase of building 66,200 57,870 500 960 21,350 3,500 6,840 11,000 19,380 20,500 32,840 39,990 40,500 56,200 62,500 80,750 81,000 100,500 111,400 150,000 175,000 187,500