Question

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

Answer 1

67 68 Brady & Co. Income Statement For The Years 69 70 2015 2016 71 72 8,430,061 3,000,235 5,429,826 6,526,967 2,763,584 3,763,383 73 74 75 76 77 307,200 1,732,429 199,500 199,506 19,365 Sales Less Cost of Goods sold Gross Profit Operating Expenses Depreciation expense General & Adminstrative expenses Research and Development Expenses Restructuring Charges Selling expenses Total operating expenses Operating Income Other Income (Expenses) Interest Expense Interest Income Income Before Tax Provision for Income Taxes Net Income from continuing Operations 311,236 1,459,695 496,597 255,013 19,952 78 79 80 2,458,000 2,971,826 2,542,493 1,220,890 81 82 83 -201,366 10,126 -241,336 9,563 84 85 -191,240 2,780,586 245,105 2,535,481 -231,773 989,117 201,636 787,481 86 87

88 89 Discontinued operation (Loss) Income from Discontinued Operations ,net of Tax Net Income -28,100 2,507,381 7,453 794,934 90 91 92 3.81 Basic earning per share Diluted 11.48 11.35 93 3.78 94 95 96 97 98 Brady & Co. Statement of Retained Earnings For The Years 2015 2016 2,960,256 2,507,381 794,934 99 5,173,286 100 101 102 103 104 105 106 Retained Earnings ,Beginning Add Net Income Less Dividends Common Preferred Retained Earnings ,Ending -292,351 -2,000 -214,956 -945 579,033 2,213,030 5,173,286 5,752,319

Brady & Co. Balance Sheet As on 2015 2016 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 401,236 20,000 2,943,125 -125,436 163,214 62,596 141,029 751,329 26,800 3,245,967 -124,645 224,561 81,236 170,296 Assets Current Assets Cash and Cash equivalents Short term Investments Accounts Receivable Less Allowance for Doubtful Accounts Inventories Deferred Tax Assets Prepaid Expenses Total Current Assets Long term Investments Investments in Unconsolidated affiliated Companies Property,Plant & Equipment Property,Plant & Equipment Accumulated Depreciation - Property plant & Equipment Property ,Plant & Equipment, Net Intangibles Goodwill and other Intangibles Total Assets 3,605,764 4,375,544 1,235,000 1,456,896 2,943,216 -1,829,634 3,936,726 -1,999,999 1,113,582 1,936,727 3,212,491 9.166.837 3,212,491 10.981.658

1,020,364 456,325 508,643 650,216 126,000 281,364 720,125 246,002 1,079,837 423,689 721,358 450,356 90,746 311,253 849,869 102,563 4,009,039 4,029,671 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 Liabilities and Shareholder's Equity Current Liabilities Accounts Payable Unearned Revenues Accrued Liabilities -Other Accrued Pension -Liabilities Accrued Restructing Charges Accrued Salaries, Wages and Commissions Current Portion of Long term Debt Income Taxes Payable Total Current Liabilities Long term Liabilities Bonds Payable Long term Debt Deferred Tax Liabilities (Long term) Accumulated Post-Employment Benefit Obligation (Long term) Total Long term Liabilities Total Liabilities Shareholder's Equity Common Stock($1par value)authorized900 million shares issued 300 million shares in 2016 284 million in 2015 Preferred Stock ($10 Par Value) authorized 10 million shares issued 90000 shares in 2016.90000 in 2015 224,563 3,202,559 229,000 802,316 249,046 3,702,700 440,263 402,634 4,458,438 8,467,477 4,794,643 8,824,314 300,000 284,000 900 900

155 156 157 158 159 160 161 162 163 164 Additional Paid-in Capital - Common Stock Additional Paid-in Capital - Preferred Stock Retained Earnings Total Paid in Capital and Retained Earnings Accumulated other comprehensive income (Loss) Treasury Stock at Cost total Stockholder's Equity Total Liabilities and Shareholder's Equity 299,304 75 5,173,286 5,773,565 -601,236 -4,472,969 299,304 75 5,752,319 6,336,598 85,000 -4,263,984 699,360 9,166,837 2,157,614 10,981,928