I blanked sheet is to be created with the data provided.

the information needed is at the top 1, 1a, 2, 3, 4

Normal Bad Good Neutra 9 Check Cell Conditional Format Formatting as Table Explanatory T... Input Linked G M + Prepare: 1 Balance Sheet - comparative in proper format for fiscal years 2015 and 2016 ta Include earnings per share data. 2 Income Statement - comparative in proper format for fiscal years 2015 and 2016 (use page 161 exhibit 4. Modified USALI Income Statement 3 Statement of Retained Earnings for 2016 4 List 5 notes that would be required if you were also preparing the notes to these financial statements. 37 58 56 76 53 00 99 34 75 45 46 00 59 53 3 62 0 xfx Prepare: 3 Sandy's Candy Company List of Accounts from General Ledger in Alphabetical Order December 31, 2016 thousands of dollars) Preg 3 2015 2016 Detail Credit Debit Credit 1.079,837 2043.125 9,26,907 1 50R 843 650 216 1126.000 281264 4 801 230 721.358 450.358 30.478 311 253 85.000 1.999,999 402,634 299,304 75 124.845 240040 190 802.370 299.00 75 125,00 224,563 7 3 401230 51,328 300.000 2014 000 3.600,235 2.763564 720, 125 849.869 62,590 81.236 229.000 440,263 Accounts on phabetical Orden Accounts Payable Accounts Recovat Accrued Liabacus Cher Accred Persons Accrued Restructuring Changes Accrued Wages and Commissions Accumulated the Comprehensive Income Loss Accumulated Depreciation Property tomont Accued Post-Employment Benelt Oblaston korg term Aditional Paid in Captal Common Stock Additional Paid in Capital Preferred Stock Allowance for both Accounts Bonds Payable Cash and Cath EU Common Stock $1.00 par. authored 600 milion shares issued 300 million shares in 2016,284 milion in 2015 Cost of Good 300 Current Portion of Low-torm Debt Deferred Tax Asses (current) Deferred Tax Llongterm) Depreciation Expense Dividends. Common Ononds Preferred General Administrativo Expenses Goods and other intangibles Income Taxos Payable Interest Expense Interest income Investments unconsolidated thated companies verbros Long-term Dubit (LOBB) Income from Discoelonged Operations, nel oftex Preferred Stock$10 par value), morired 10 million Share ved 90 000 shares in 2016. 90,000 in 2015 Prepaid Expand Property. Plent and Equipment Provision for income taxes Research and Development Expenses Restructurng Charges Retained Earnings beginning Sala Sang Expenses Short-term Investments Treasury Stock arcoal 117/156.719 shares in 2016 and 108.872,953 shares in 2015 Uneamed Revenues Total 307 200 1282351 12.000 1,732,420 3.212.491 311,238 214,956 945 1,469095 3.212.401 240.002 100,563 20130 241.336 10,126 9,563 1235.000 163,214 1.456.890 22461 3.202,550 3 1 2.100 3,702,700 7453 100 900 16 ET 141.029 203.216 245 106 199,500 199,506 170296 3.938,728 201638 4917 256013 50 2 2.960 256 8430.061 5.173.286 6,526,967 19,365 20,000 19.962 26.500 4.263,384 450,335 22.423.26 423,689 23,335 236 22.423,269 23.335, 236 3 Diwwe 32 Wested Average number of common shares FY 2016 Basle Dan 5t 5 208,448 016 shares 210,348,076 share FY 2015 Basle Duod 218,454,140 shares 220,964,140 shares ro 71