Question

Create a Spreadsheet for Statement of Cash Flows for the below

ATTLEBORO GROUP, INC. Income Statement Year Ended December 31, 2018 $441,000 205,400 235,600 $ 76,300 15,300 49,600 Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Salaries Expense Depreciation Expense Other Operating Expenses Total Operating Expenses Operating Income Other Income and (Expenses): Interest Revenue Interest Expense Total Other Income and (Expenses) Net Income Before Income Taxes Income Tax Expense Net Income 141,200 94,400 11,500 (24,400) (12,900) 81,500 16,200 $ 65,300

Answer 1

Please find indirect cash flow attached

Particulars	Amount
Cash flows from operating activities :
Net income	65,300
Depreciation	15,300
Accounts receivable	1,700
Inventory	(3,500)
Accounts payable	(1,500)
Accrued liabilities	1,300
Net cash provided by operating activities	78,600
Cash flows from investing activities:
Purchase of land	(25,400)
Purchase of plant asset	(22,000)
Net cash used for investing activities	(47,400)
Cash flows from financing activities:
Proceeds from issuance of equity shares	8,500
Payment of dividend	(28,200)
Repayment of notes payable	(13,000)
Net cash used for financing activities	(32,700)
Net increase in cash	(1,500)
Cash at beginning of year	15,500
Cash at end of year	14,000