Question

In: Accounting

Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow.

Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow.

LANSING COMPANY
Income Statement
For Year Ended December 31, 2017
Sales revenue $ 148,200
Expenses    
Cost of goods sold   59,000
Depreciation expense   20,500
Salaries expense   35,000
Rent expense   10,700
Insurance expense   5,500
Interest expense   5,300
Utilities expense   4,500
Net income $ 7,700
 

  

LANSING COMPANY
Selected Balance Sheet Accounts
At December 31 2017   2016  
Accounts receivable $ 7,300   $ 9,200  
Inventory   3,680     2,390  
Accounts payable   6,100     8,000  
Salaries payable   1,220     870  
Utilities payable   560     330  
Prepaid insurance   430     620  
Prepaid rent   560     350  
 

Required:
Prepare the cash flows from operating activities section only of the company’s 2017 statement of cash flows using the indirect method. (Amounts to be deducted should be indicated with a minus sign.)

 
 
LANSING COMPANY
Cash Flows from Operating Activities—Indirect Method
For Year Ended December 31, 2017
Cash flows from operating activities:    
     
Adjustments to reconcile net income to net cash provided by operations:
     
     
     
     
     
     
     
     
    0
    $0

Solutions

Expert Solution

Operating Activities of the Cash Flow Statement of Lansing Ltd for the year ended Dec 31, 2017
Particulars Amount
CASH FLOWS FROM OPERATING ACTIVITIES  
Profit before tax $7,700
Adjustments to reconcile profit before tax to cash provided by operating activities  
Depreciation and amortisation expense $20,500
   
OPERATING PROFIT BEFORE WORKING CAPITAL CHANGES $28,200
(Increase) / Decrease in current assets  
Accounts Receivables Decrease $1,900
Inventories (Increase) -$1,290
Prepaid Rent (Increase) -$210
Prepaid Insurance Decrease $190
Increase / (Decrease) in current liabilities  
Accounts Payable (Decrease) -$1,900
Salaries Payable Increase $350
Utilities Payable Increase $230
   
NET CASH GENERATED /(USED) BY OPERATING ACTIVITIES $27,470

 


Related Solutions

Lansing Company’s 2016 income statement and selected balance sheet data (for current assets and current liabilities)...
Lansing Company’s 2016 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2015 and 2016, follow.    LANSING COMPANY Income Statement For Year Ended December 31, 2016 Sales revenue $ 63,000 Expenses Cost of goods sold 19,000 Depreciation expense 5,000 Salaries expense 9,000 Rent expense 2,000 Insurance expense 1,900 Interest expense 1,900 Utilities expense 1,200 Net income $ 23,000 LANSING COMPANY Selected Balance Sheet Accounts At December 31 2016 2015 Accounts receivable $...
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities)...
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow. LANSING COMPANY Income Statement For Year Ended December 31, 2017 Sales revenue $ 124,200 Expenses Cost of goods sold 51,000 Depreciation expense 16,500 Salaries expense 27,000 Rent expense 9,900 Insurance expense 4,700 Interest expense 4,500 Utilities expense 3,700 Net income $ 6,900 LANSING COMPANY Selected Balance Sheet Accounts At December 31 2017 2016 Accounts receivable $ 6,500...
Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current...
Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current and prior years follow. LANSING COMPANY Income Statement For Current Year Ended December 31 Sales revenue $ 148,200 Expenses Cost of goods sold 59,000 Depreciation expense 20,500 Salaries expense 35,000 Rent expense 10,700 Insurance expense 5,500 Interest expense 5,300 Utilities expense 4,500 Net income $ 7,700    LANSING COMPANY Selected Balance Sheet Accounts At December 31 Current Year Prior Year Accounts receivable $ 7,300...
Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current...
Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current and prior years follow. LANSING COMPANY Income Statement For Current Year Ended December 31 Sales revenue $ 115,200 Expenses Cost of goods sold 48,000 Depreciation expense 15,000 Salaries expense 24,000 Rent expense 9,600 Insurance expense 4,400 Interest expense 4,200 Utilities expense 3,400 Net income $ 6,600 LANSING COMPANY Selected Balance Sheet Accounts At December 31 Current Year Prior Year Accounts receivable $ 6,200 $...
Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current...
Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current and prior years follow. LANSING COMPANY Income Statement For Current Year Ended December 31 Sales revenue $ 100,200 Expenses Cost of goods sold 43,000 Depreciation expense 12,500 Salaries expense 19,000 Rent expense 9,100 Insurance expense 3,900 Interest expense 3,700 Utilities expense 2,900 Net income $ 6,100    LANSING COMPANY Selected Balance Sheet Accounts At December 31 Current Year Prior Year Accounts receivable $ 5,700...
Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current...
Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current and prior years follow. LANSING COMPANY Income Statement For Current Year Ended December 31 Sales revenue $ 157,200 Expenses Cost of goods sold 62,000 Depreciation expense 22,000 Salaries expense 38,000 Rent expense 11,000 Insurance expense 5,800 Interest expense 5,600 Utilities expense 4,800 Net income $ 8,000    LANSING COMPANY Selected Balance Sheet Accounts At December 31 Current Year Prior Year Accounts receivable $ 7,600...
Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $   ...
Jafan Retailing, Balance Sheet Statement December 31, 2016 & December 31, 2017 2016 2017 Cash $    235,000 $    400,000 Accounts Receivable        367,200        325,000 Inventory        450,000        500,200 Prepaid Expenses        120,000        160,000 Long-term investment        100,000        300,000 Equiptment (Net)     1,050,000     1,125,000 Total Assets $ 2,322,200 $ 2,810,200 Accounts Payable $    421,000 $    411,000 Salary Payable        134,000        180,000 Interest Payable        110,000        112,000 Bonds Payable        550,000        560,000 Common Shares...
Ratios (Appendix) Miller Company's condensed income statement for 2016 and December 31, 2016, balance sheet follow:...
Ratios (Appendix) Miller Company's condensed income statement for 2016 and December 31, 2016, balance sheet follow: Income Statement Sales (net) $304,400 Cost of goods sold (183,600) Gross profit $120,800 Operating expenses (82,000) Operating income $38,800 Interest expense (7,000) Income before income taxes $31,800 Income taxes (10,000) Net income 21,800 Balance Sheet Cash $8,200 Accounts payable $18,000 Receivables (net) 14,700 Other current liabilities 6,800 Inventory 19,300 Bonds payable, 10% 70,000 Property, plant, and equipment (net) 195,800 Common stock, $10 par 80,500...
Use the following information for the Problems below. Lansing Company’s 2017 income statement and selected balance...
Use the following information for the Problems below. Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow. LANSING COMPANY Income Statement For Year Ended December 31, 2017 Sales revenue $ 148,200 Expenses Cost of goods sold 59,000 Depreciation expense 20,500 Salaries expense 35,000 Rent expense 10,700 Insurance expense 5,500 Interest expense 5,300 Utilities expense 4,500 Net income $ 7,700    LANSING COMPANY Selected Balance Sheet Accounts...
Simon Company’s year-end balance sheets follow. At December 31 2018 2017 2016 Assets Cash $ 31,800...
Simon Company’s year-end balance sheets follow. At December 31 2018 2017 2016 Assets Cash $ 31,800 $ 35,625 $ 37,800 Accounts receivable, net 89,500 62,500 50,200 Merchandise inventory 112,500 82,500 54,000 Prepaid expenses 10,700 9,375 5,000 Plant assets, net 278,500 255,000 230,500 Total assets $ 523,000 $ 445,000 $ 377,500 Liabilities and Equity Accounts payable $ 129,900 $ 75,250 $ 51,250 Long-term notes payable secured by mortgages on plant assets 98,500 101,500 83,500 Common stock, $10 par value 163,500 163,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT