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 in good form.
	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 Brady'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.

Gronk, Inc List of Items for Statement of Cash Flows Statement December 31, 2016 (thousands of dollars) 66,200 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 2,300 960 21,350 3,500 6,840 11,000 20,000 20,500 33,000 39,990 40,500 56,200 62,500 85,000 81,000 100,500 120,000 150,000 175,000 187,500 Gronk, Inc List of Items for Statement of Cash Flows Statement December 31, 2016 (thousands of dollars) 66,200 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 2,300 960 21,350 3,500 6,840 11,000 20,000 20,500 33,000 39,990 40,500 56,200 62,500 85,000 81,000 100,500 120,000 150,000 175,000 187,500