Part VI
Prepare a Cash Flow Statement using the DIRECT Method.
DO NOT use the INDIRECT Method
Not all accounts listed may be used in this example
Net income		$540,000
Cash December 31, 2020	$120,000
Cash December 31 2020	???????
Depreciation Expense	$55,000
Collections from third party	$411,000
Decrease in accounts payable	$105,000
Paid employees		$87,000
Purchased stock		$22,000
Purchased land		$99,000
Paid mortgage		$60,000
Paid car loan		$43,000
Paid for insurance	$11,000
Patient Receivable	$24,000.00

Please show using excel formulas such as =SUMA1+A2