PLEASE enter in CELL FORMAT

same result of adding those cells, except they are expressed as a range in the formula, and the result would be 91,000 6 X 5 Libby Stmt of Cash Flows-JSH - Excel ? - X Sign In 4 4 nts FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Calibri 11 A A A % Paste BIU- A Cells Alignment Number Conditional Format as Cell Formatting Table Styles Styles eBook Clipboard Font A1 V fx Required: Print A D E F G H I J references 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 B provided by operating activities: Depreciation expense Gain on sale of Equipment Changes in current assets and current liabilities: Accounts receivable Prepaid insurance Inventory Accounts payable Wages payable Unearned revenue Interest payable Taxes payable Net cash provided by (used in) operating activities 36 Cash Flows from Investing Activities: Equipment Purchased Equipment Sold Net cash provided by (used in) investing activities 37 38 39 40 41 42 43 44 Cash Flows from Financing Activities: Cash paid for Dividends Issue common stock Repayment of Notes Net cash provided by (used in) financing activities Net increase (decrease) in cash Cash at beginning of the period Cash at end of the period 45 46 47 48 49 50 51 Balance Sheet Sheet1 - + 10% READY Attempt(s) same result of adding those cells, except they are expressed as a range in the formula, and the result would be 91,000 6 X 5 Libby Stmt of Cash Flows-JSH - Excel ? 5 4 nts FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 A A % Paste BIU- A- Alignment Number Cells Conditional Format as Cell Formatting Table Styles Styles eBook Clipboard Font A1 V Required: Print D F G H 1 J "eferences 4 5 a B E Required 2 1) Complete the following calculations by referencing values from the Balance Sheet (found by 3 clicking the Balance Sheet tab at the bottom of this workbook) and values from the notes found at the bottom of the balance sheet. Calculate the book value of the asset sold 6 b. Calculate the historical cost of the asset sold 7c Calculate the related Accumulated Depreciation 8 for the equipment sold 9 10 2) Complete the Statement of Cash Flows (indirect method) shown below by using formulas that reference 11 data from the balance sheet (found by clicking the Balance Sheet tab at the bottom of this workbook). Values pertaining to the notes at the bottom of the balance sheet have been placed in separate cell locations so you can reference these numbers in your calculations. Read the notes at the bottom of the balance sheet 13 carefully. 12 14 15 16 17 18 19 20 21 22 23 24 25 I & S Apparel Industries Statement of Cash Flows For the Year Ended December 31, 2016 Cash Flows from Operating Activities: Net income Adjustments to reconcile net income to net cash provided by operating activities: Depreciation expense Gain on sale of Equipment Changes in current assets and current liabilities: Accounts receivable Prepaid insurance Inventory Accounts payable Wages payable Unearned revenue Interest payable 26 27 28 29 30 31 Tovar nanahal Balance Sheet Sheet1 + 10% READY Attempt(s) same result of adding those cells, except they are expressed as a range in the formula, and the result would be 91,000 6 X 5 Libby Stmt of Cash Flows-JSH - Excel ? - X Sign In 4 4 nts FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW X Calibri 11 A A A % Paste BIU- A Cells Alignment Number Conditional Format as Cell Formatting Table Styles Styles eBook Clipboard Font A1 V fx Required: Print A D E F G H I J references 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 B provided by operating activities: Depreciation expense Gain on sale of Equipment Changes in current assets and current liabilities: Accounts receivable Prepaid insurance Inventory Accounts payable Wages payable Unearned revenue Interest payable Taxes payable Net cash provided by (used in) operating activities 36 Cash Flows from Investing Activities: Equipment Purchased Equipment Sold Net cash provided by (used in) investing activities 37 38 39 40 41 42 43 44 Cash Flows from Financing Activities: Cash paid for Dividends Issue common stock Repayment of Notes Net cash provided by (used in) financing activities Net increase (decrease) in cash Cash at beginning of the period Cash at end of the period 45 46 47 48 49 50 51 Balance Sheet Sheet1 - + 10% READY Attempt(s) same result of adding those cells, except they are expressed as a range in the formula, and the result would be 91,000 6 X 5 Libby Stmt of Cash Flows-JSH - Excel ? 5 4 nts FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In X Calibri 11 A A % Paste BIU- A- Alignment Number Cells Conditional Format as Cell Formatting Table Styles Styles eBook Clipboard Font A1 V Required: Print D F G H 1 J "eferences 4 5 a B E Required 2 1) Complete the following calculations by referencing values from the Balance Sheet (found by 3 clicking the Balance Sheet tab at the bottom of this workbook) and values from the notes found at the bottom of the balance sheet. Calculate the book value of the asset sold 6 b. Calculate the historical cost of the asset sold 7c Calculate the related Accumulated Depreciation 8 for the equipment sold 9 10 2) Complete the Statement of Cash Flows (indirect method) shown below by using formulas that reference 11 data from the balance sheet (found by clicking the Balance Sheet tab at the bottom of this workbook). Values pertaining to the notes at the bottom of the balance sheet have been placed in separate cell locations so you can reference these numbers in your calculations. Read the notes at the bottom of the balance sheet 13 carefully. 12 14 15 16 17 18 19 20 21 22 23 24 25 I & S Apparel Industries Statement of Cash Flows For the Year Ended December 31, 2016 Cash Flows from Operating Activities: Net income Adjustments to reconcile net income to net cash provided by operating activities: Depreciation expense Gain on sale of Equipment Changes in current assets and current liabilities: Accounts receivable Prepaid insurance Inventory Accounts payable Wages payable Unearned revenue Interest payable 26 27 28 29 30 31 Tovar nanahal Balance Sheet Sheet1 + 10% READY Attempt(s)