Prepare a Cash Flow Statement using the Indirect Method.
DO NOT use the DIRECT Method
Not all accounts listed may be used in this example
Net income		$1,500,000
Cash December 31, 2018	$750,000
Cash December 31 2019	???????
Depreciation Expense	$20,000
Increase in inventory	$15,000
Decrease in accounts payable	$32,000
Increase in Prepaid insurance	$31,000
Purchased stock		$22,000
Purchased land		$99,000
Paid mortgage		$60,000
Paid car loan		$43,000
Increase in wages payable	$11,000
Patient Receivable	$24,000.00

Show using excel formulas such as =SUMA2-A1