Question

Income Statement Statement of Cash Flows 100,000.00 S35,000.00 2018 $110.000.00 SES 3 Cost of Goods Gross Profit S71 $17.135.55 $20,000.00 -$5,000.00 $1,000.00 $5,000.00 $26.135.55 3 565,000.00 $15,000.00 $20,000.00 $30,000.00 $4,000.00 526,000.00 $10,400.00 $15,600.00 S6, 240.00 59,360.00 Interest Accounts Payable Cash Flow From Operations 1 Net Income 2 Dividend 3 Addition to Retained Earnings 5174135.55 S6,854.22 $10,281.33 Cash from Investing -Increase in Gross PPE Cash Flow from Investin $75,000.00 525,000.00 2017 2018 5 Balance Sheet 6 Assets 2 cash 8 Acc Receive - Inventory Cash from Fin inancing -Dividends ein Notes Payable $6.954 221 $0.00 in long-term Debt Common Equity $3,000.00 $20,000.00 $10,000.00 $33,000.00 $500,000.00 $100,000.00 $400,000.00 5433,000.00 $3,300.00 $25,000.00 $11,000.00 $36,300,00 $575,000.00 $120,000.00 $455,000.00 $491,300.00 HOW $52182289 Gross PPE 2 Accumulated Depre 3 Net PPE 2017 Cash and Equivalents chance in Chand Equival 2018 cash and Equivalents $3,000.00 $4.003.44 Total As S7.008.44 6 Llabilities and Equity 7 Accounts Payable 8 Notes Payables 9 Current abilities 0 Long Term Debt Total abilities 2 Shareholder Equity $20,000.00 $25,000.00 $15,000.00 $15,000.00 $35,000.00||||$37,000.00 $100,000.00 $146.018 $135.000.00 $298,000.00 5308 34 Totabilities and Equity $430,000.00 $491,300.00 SOLUTION1.3

the total didnt add right on the excel. so im thinking im typing the formula. so whats the formula to find the cash flows from operations and financing?

Answer 1

		2018
Net income		$                   17,135.55
+Depreciation		$                   20,000.00
-increase in accounts receivable		$                    -5,000.00
-increase in accounts payable		$                    -1,000.00
+increase in account payable		$                      5,000.00
Cash flow from operations	=17135.55 + 20000 - 5000 - 1000 + 5000	$                   36,135.55
Cash from investing
-increase in Gross PP&E		$                  -75,000.00
Cash flow from investing	-75000	$                  -75,000.00
-Dividend		$                    -6,854.22
+ increase in notes payable		$                                   -
+ increase in long term debt		$                   46,018.67
+ increase in Common equity		$                                   -
Cash flow from financing	= - 6854.22 + 0 + 46018.67 + 0	$                   39,164.45
2017 cash and equivalents		$                      3,000.00
Change in cash and equivalents	= 36135.55 - 75000 + 39164.45	$                         300.00
2018 cash and equivalents		$                      3,300.00
You gave incorrect signs to increase in accounts receivables and to dividend received hence you answer was not matching.