solved Excel #3 is a formative assessment designed to help you

Excel #3 is a formative assessment designed to help you prepare a Statement of Cash Flows.
You will be using the data provided in the ExcelProblem_3_DuLang_Template.xlsx worksheet.  Feel free to use the existing worksheet to complete your problem.  If you can’t access the worksheet there is a pdf of the worksheet below.
Requirements:
You are to complete, in good form, a Statement of Cash Flows for DuLang Industries for the Year Ended December 31, 2019, using Excel.
Good form means the statement must use proper headings, titles, and dates. Underlines, dollar signs, and double underlines where appropriate, please.
Use Excel to do the math for you. When you can use either cell references or formulas.  Typing in numbers when you are able to use cell references or formulas will result in a loss of points.
In the worksheet, I have added a “Difference Column” which serves as a starting point for your assignment. 
If you haven’t yet accessed the Statement of Cash Flows Step by Step check it out, it will help enormously in the preparation for this statement.
Statement of Cash Flows Step by Step
Statement of Cash Flows
The five steps used to prepare the statement of cash flows by the indirect method are:

Step 1: Complete the cash flows from operating activities section using net income and adjusting for increases or decreases in current assets (other than cash) and current liabilities. Also, adjust for gains or losses on long-term assets and non-cash expenses such as depreciation expense.
Step 2: Complete the cash flows from investing activities section by reviewing the long-term assets section of the balance sheet.
Step 3: Complete the cash flows from financing activities section by reviewing the long-term liabilities and equity sections of the balance sheet.
Step 4: Compute the net increase or decrease in cash during the year. The change in cash is the key reconciling figure for the statement of cash flows and must match the change in cash reported on the comparative balance sheet.
Step 5: Prepare a separate schedule reporting any non-cash investing and financing activities.

—————————————————————————————————————————-
+- Cash Flows from Operating Activities
+/-Net income or net loss
Adjustments to reconcile net income to net cash provided by operating activities
+ Depreciation/amortization
+/- Gains/losses on sales of long term assets
+/- Increases/Decreases in current assets other than cash
+/- Increases/Decreases in current liabilities
= Net cash provided by (used for) operating activities
+/- Cash Flows from Investing activities
+Cash received from sales of long term assets
-Acquisitions of long term assets
=Net cash provided by (used for) investing activities
+/- Cash flows from Financing activities
+Cash receipts from sale of stock
+/- Cash receipts from sale or cash paid purchase of treasury stock
+Cash receipts from issuance of bonds or notes payable
-Cash payments to retire bonds payable or pay notes payable
-Cash payments of dividends
=Net cash provided by (used for) financing activities
=Net increase (decrease) in cash (total all three activities)
——————————————————————————————————————-
An increase in a current asset other than cash causes a decrease in cash.
A decrease in a current asset other than cash causes an increase in cash.
An increase in a current liability causes an increase in cash.
A decrease in a current liability causes a decrease in cash.