[SOLVED] Signature Assignment
Module 8 Signature Assignment Welcome to the final module of the course! The signature assignment will be in the form of the following: (1) Excel File – For your signature assignment, we will be targeting the Statement of Cash Flows. The preparation of this statement is extremely important as it provides additional resources to management for planning and comprehension of the current period activity. You will be provided an Excel Template which you will use to answer the prompt. (A) Excel File Prompt Statement of Cash Flows Your goal is to prepare a Statement of Cash Flows within the problem noted below. In the Excel Template provided, you will find the Balance Sheet of Marina Comp for December 31, 2013. In addition to the information on the Balance Sheet, we are presented with the following additional data related to current year operations: Net income for the year 2013, $66,000. Depreciation on plant assets for the year, $12,700. Sold the long-term investments for $28,000 (assume gain or loss is ordinary). Paid dividends of $25,000. Powered by TCPDF (www.tcpdf.org) Purchased machinery costing $21,500, paid cash. Purchased machinery and gave a $60,000 long-term note payable. Paid a $40,000 long-term note payable by issuing common stock. Using tab 2 in the Excel Template (2) Cash Flows Statement – prepare a statement of cash flows (using the indirect method) for 2013 for Marina Company. There are a few answers inputted into the Statement to help get you started on the preparation.
