Question

Based on the information provided below, prepare a Statement of Cash Flows. Remember to include all three sections of this statement as well as the necessary reconciliation of cash flows at the bottom of the statement. (It may be helpful to copy the below information and paste it into Excel for easier accessibility when completing the Statement of Cash Flows. Then copy your solution from Excel and paste into the response box below) Balance Sheet Income Statement Year 1 Assets 12/31/41 12/31/40 Sales revenue 7,560 Cash 20.200 0 Cost of goods sold 1,800 Accounts receivable 5.060 0 Gross margin 5760 Inventory 4.2000 Wages Expense 450 PPE 75,000 0 Utilities Expense 2,000 Less Accumulated 875 Depreciation Expense 875 Depreciation Land 2.5000 Operating Income 2,435 Total Assets 106,085 0 Interest Expense 1,875 Earnings before income 560 tax Liabilities 12/31/41 12/31/40 Income tax 196 Accounts Payable 3,400 0 Net Income Wages Payable 250 0 Interest Payable 1.875 0 Taxes Payable 196 0 Total Current Liabilities 5,721 0 Notes Payable 75,0000 Total Liabilities 80,721 0 Equity Common stock 2500 Preferred stock 10,000 0 Additional Paid-in Capital - 4.750 0 CS Additional Paid-in Capital - 10,0000 PS Retained earnings Total Equity 364 25364 0 0 Total Liabilities & Equity 106,085 O Additional Information: a. Jan 1st, issued 500 shares of common stock ($0.50 par value) for $5000. b. Feb 1st, paid $2500 to purchase land. C Feb 28th, issued 100 shares of preferred stock ($100 par value) for $20,000. d. June 30th, paid $75,000 for a building (estimated useful life of 40 years; salvage value = $5,000) by signing a 5 year Note Payable, promising to pay 5% interest at the end of each of those 5 years (i.e. on June 30th of each year).

Answer 1

Statement of Cash Flows - Indirect Approach
	Amount in $	Amount in $
Net income		$                   364
Cash flows from operating activities
Adjustments for reconcile the net income o net cash provided by operating activities
Income statement items not affecting cash
Depreciation Expenses	$                   875
Change in current assets and current liabilities:
Increase in account receivable	$              -5,060
Decrease in inventory	$              -4,200
Increase on account payable	$                3,400
Increase on wages payab;e	$                   250
Increase on Interest payab;e	$                1,875
Increase on Taxes Payable	$                   196
		$              -2,664
Net cash from operating activities		$              -2,300
Cash flows from investing activities
Purchase of PPE	$            -75,000
Purhase of land	$              -2,500
Net cash used in investing activities		$            -77,500
Cash flows from Financing activities
Isseue of common stock	$                5,000
Isseue of PReferred stock	$             20,000
Issue of Notes Payable	$             75,000
Net cash used in financing activities		$          1,00,000
Net increase in cash and cash equivalents		$             20,200
Add :Cash and cash equivalents at beginning of period		$                       -
Cash and cash equivalents at end of period		$             20,200