Statement of Cash Flows for DuLang Industries Worksheet

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.

—————————————————————————————————————————-

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>