Question

CONSTRUCT SOURCES AND USES OF FUNDS STATEMENT - HOME DEPOT

Beginning Cash 2,538 HOME DEPOT Income Statement Revenue Cost of Revenue Gross Profit Operating expenses Depreciation expense Earnings Before Interest & Tax Non-operating Inc(Expn) Interest Earnings Before Tax Income Tax Expense Net Income CY 2017 100,904 66,548 34,356 17,613 2,062 14,681 74 Cash Flow - Operating Activities Net Income Depreciation Change in: Accts Receivable Inventory Other Curr Assets Accts Payable Other Curr Liabs Subtotal - CF Operating 1,057 13,698 5,068 8,630 Balance Sheet Cash & Short Term Invest Accounts Receivable Inventory Other Current Assets Current Assets Net Property, Plant & Equipment Other Non-Current Assets Total Assets 12/31/2017 12/31/2016 3,595 2,538 1,952 2,029 12,748 12,549 638 608 18,933 17,724 22,075 21,914 3,521 3,328 44,529 42,966 Cash Flow - Investing Activities Change in: Gross Prop,Plnt,Equip Other Non-Curr Assets Subtotal - CF Investing Accounts Payable Short-Term Debt Other Current Liabilities Current Liabilities Long-Term Debt Other L/T Liabilities Total Liabilities 7,244 2,761 6,189 16,194 24,267 2,614 43,075 7,000 1,252 5,881 14,133 22,349 2,151 38,633 Cash Flow - Financing Activities Dividends to Shareholders Changes in: Short-Term Debt Long-Term Debt Other L/T Liabilities Common Stock/PIC Treasury Stock Other Equity Subtotal - CF Financing Common Stock & Paid-In Capital Retained Earnings Treasury Stock Other Equity Shareholders Equity 10,281 39,935 -48,196 -566 1,454 9,875 35,519 -40,194 -867 4,333 Ending Cash 2538 Note: this should match the cash balance as of 12/31/2017 Total Liabilities & Equity 44,529 42,966

Answer 1

Beginning cash		2,538
Cash flow - Operating activities
Net income	8,630
Depreciation	2,062
Change in :
Account receivable	77
Inventory	-199
Other current assets	-30
Accounts payable	244
Other current liabilities	308
Cash flow from operating activities		11,092
Cash flow - Investing activities :
Change in :
Gross profit, plant, equipment	-2,223
Other non current assets	-193
Cash flow from investing activities		-2,416
Cash flow - financing activities:
Dividends to shareholders	-4,214
Change in :
Short term debt	1,509
Long term debt	1,918
Other long term liabilities	463
Common stock/PIC	406
Treasury stock	-8,002
Other equity	301
Cash flow from financing activities		-7,619
Ending cash balance		$3,595

Dividend paid = Retained earnings, beginning + Net income - Retained earnings , ending

= 35,519 + 8,630 - 39,935

= $4,214

kindly give a positive rating if you are satisfied with the solution. do comment if you have any query, Thanks.