You will have three sheets. All numbers after the given sheet must be formulas and may not be hard coded. Sheet 1 name is XXXXX XXXXX XXXXX All of this information below will be in the given: All Sales Are On Credit Fixed Assets Costing $5,000 With A Book Value Of $2,000 Were Sold For $4,000 Three-Year Insurance Policy Was Purchased In 2011 Long-Term Investments Costing $5,000 Were Used To Retire $5,000 Of Bonds Outstanding Other Expenses And Losses Consist Of $1,000 Interest Paid Comparative Balance Sheets For 2011 And 2012 Are As Follows All Accounts Payable is for Inventory All Dividends are declared and paid THOMSEN INC BALANCE SHEET December 31, 2012 2012 2011 Cash $9,000 $8,000 Treasury Bills 4,000 3,000 Accounts Receivable 4,000 5,000 Inventory 1,000 2,000 Prepaid Insurance 2,000 3,000 Long-Term Investment In ABC Co. 17,000 22,000 Fixed Assets 22,000 17,000 Accumulated Depreciation (5,000) (4,000) Total Assets $54,000 $56,000 Accounts Payable $4,000 $7,000 Income Tax Payable 3,000 1,000 Deferred Tax Liability 5,000 3,000 Bonds Payable 5,000 10,000 Common Stock 20,000 20,000 Retained Earnings 17,000 15,000 Total Liabilities and Stockholder's Equity $54,000 $56,000 THOMSEN INC INCOME STATEMENT FOR YEAR ENDED DECEMBER 31, 2012 Net Sales $50,000 Cost Of Goods Sold (20,000) Gross Profit 30,000 Operating Expenses (17,000) Income Form Operations 13,000 Other Revenue And Gains 2,000 Other Expenses And Losses (1,000) Income Before Taxes 14,000 Income Tax Expense $5,000 Current Portion 2,000 Deferred Portion 7,000 Net Income $7,000 Sheets 2 and 3 are to be named Indirect Method and Direct Method. All numbers in this sheet are to be formulas. All dates are to be concatenate formulas. For Indirect Method sheet in good accounting format create a Cash Flows Statement based on the indirect method. For Direct Method sheet in good accounting format create a Cash Flows Statement based on the indirect method.