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: 1. Net income for the year 2013, $66,000. 2. Depreciation on plant assets for the year, $12,700. 3. Sold the long-term investments for $28,000 (assume gain or loss is ordinary). 4. Paid dividends of $25,000. 1 / 2 5. Purchased machinery costing $21,500, paid cash. 6. Purchased machinery and gave a $60,000 long-term note payable. 7. Paid a $40,000 long-term note payable by issuing common stock.

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: 1. Net income for the year 2013, $66,000. 2. Depreciation on plant assets for the year, $12,700. 3. Sold the long-term investments for $28,000 (assume gain or loss is ordinary). 4. Paid dividends of $25,000. 1 / 2 5. Purchased machinery costing $21,500, paid cash. 6. Purchased machinery and gave a $60,000 long-term note payable. 7. Paid a $40,000 long-term note payable by issuing common stock.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 14M

See similar textbooks

Similar questions

Use the following information from Dubuque Company's financial statements to prepare the operating activities section of the statement of cash flows (indirect method) for the year 2018: 2018 Income Statement Balance Sheets Sales Cost of Goods Sold Operating Expenses, other than depreciation expense Depreciation Expense Gain on Sale of Plant Assets $ 299,000 (135,000) (27,000) (17,000) 16,500 136,500 Net Income Dec. 31, 2018 $45,300 1,600 22,500 900 Accounts Receivable Inventory Accounts Payable Accrued Liabilities Accounts Receivable Inventory Accounts Payable Accrued Liabilities Dec. 31, 2017 $43,400 1,800 21,250 1,150 PLEASE NOTE: Use the account and term names exactly, as shown above and the accounts will be listed in the same order as shown in the textbook examples. All dollar amounts will be rounded to whole dollars using "$" and commas as needed (i.e. $12,345) and decreases will be shown with parentheses - $(12,345).
) Provide an accurate, full and complete explanation and implication of the information presented in (mathematical forms) by explaining the significance of the cash flow statement The net income reported on the income statement for the current year was $128,000. Depreciation recorded on store equipment for the year amounted to $21,100. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $51,200 $47,100 Accounts receivable (net) 36,710 34,810 Merchandise inventory 50,120 52,990 Prepaid expenses 5,630 4,470 Accounts payable (merchandise creditors) 47,970 44,560 Wages payable 26,210 29,110
Using the Exhibit below, assume that the depreciation expense on the Income Statement for the year was $38,000. When preparing the Statement of Cash Flow using the indirect method for the current year, which of the following statements would describe the proper presentation of depreciation expense on the Cash flow from operating activities section? EXHIBIT Increase (Decrease) Net Income (loss) $XXX Adjustments to reconcile net income to net cash flow from operating activities: Depreciation of fixed assets XXX Losses on disposal of assets XXX Gains on disposal of assets (XXX) Changes in current operating assets and liabilities:…
Use a spreadsheet and the following financial information from Mineola Companys financial statements to build a template that automatically calculates the net operating cash flow. It should be suitable for use in preparing the operating section of the statement of cash flows (indirect method) for the year 2018.
Use the following information from Dubuque Companys financial statements to prepare the operating activities section of the statement of cash flows (indirect method) for the year 2018.
Using the Exhibit below, assume that the amount of Net Income on the Income Statement for the year was $100,000. When preparing the Statement of Cash Flow using the indirect method for the current year, which of the following statements would describe the proper presentation of net income on the Cash flow from operating activities section? EXHIBIT Increase (Decrease) Net Income (loss) $XXX Adjustments to reconcile net income to net cash flow from operating activities: Depreciation of fixed assets XXX Losses on disposal of assets XXX Gains on disposal of assets (XXX) Changes in current operating assets and liabilities:…
Requirements Calculate the following items for the statement of cash flows: a. Beginning and ending Plant Assets, Net, were $106,000 and $101,000, respectively. Depreciation for the period was $18,000, and purchases of new plant assets were $26,000. Plant assets were sold at a gain of $5,000. What were the cash proceeds of the sale? b. Beginning and ending Retained Earnings were $44,000 and $70,000, respectively. Net income for the period was $46,000, and stock dividends were $6,000. How much were the cash dividends? Requirement a. Beginning and ending Plant Assets, Net, were $106,000 and $101,000, respectively. Depreciation for the period was $18,000, and purchases of new plant assets were $26,000. Plant assets were sold at a gain of $5,000. What were the cash proceeds of the sale? Cash proceeds from the sale were
Use the information provided below to prepare the Cash Flow Statement of Alto Limited for the year ended 31 December 2022. INFORMATION The following amounts were obtained from the Statement of Comprehensive Income for the year ended 31 December 2022 and Statement of Financial Position of Alto Limited as at 31 December 2022 and 31 December 2021: Sales Cost of sales Depreciation Operating profit Interest expense Company tax for the year Property, plant and equipment (carrying value) Long-term investments Inventories Accounts receivable Prepaid expenses Cash and cash equivalents Ordinary share capital (All shares issued at R10 each) Retained earnings Non-current liabilities Accounts payable Accrued expenses Dividends payable Company tax payable 31 Dec 2022 R 11 000 000 6 500 000 750 000 1 650 000 450 000 400 000 6 250 000 350 000 2 150 000 1 700 000 200 000 500 000 3 100 000 3 000 000 3 600 000 1 100 000 100 000 200 000 50 000 31 Dec 2021 R Note: ■ Dividends paid and recommended during…
You are researching Time Manufacturing and have found the following accounting statement of cash flows for the most recent year. You also know that the company paid $98.1 million in current taxes and had an interest expense of $48.1 million. Operations Net income Depreciation TIME MANUFACTURING Statement of Cash Flows (in millions) Deferred taxes Changes in assets and liabilities Accounts receivable Inventories Accounts payable Accrued expenses Other Total cash flow from operations Investing activities Acquisition of fixed assets Sale of fixed assets Total cash flow from investing activities Financing activities Retirement of long-term debt Proceeds from long-term debt sales Dividends Repurchase of stock Proceeds from new stock issue Total cash flow from financing activities Change in cash (on balance sheet) a. Calculate the operating cash flow. b. Calculate the net capital spending. c. Calculate the change in net working capital. d. Calculate the cash flow to creditors. e. Calculate…
using the image attached , please prepare the cash flow statement for the year. Also alongside the given image the following additional infromation should be noted for the account as well : 1. The building was revalued during the year.2. Equipment costing 25,000 for which there a provision for depreciation of 5,500was sold for a profit of 6,000.3. Dividends paid and proposed for the year amounted to 27,000
of Take me to the text Squash Incorporated had net income for 2023 of $382,000. Included on the income statement was a loss on sale of equipment of $4,900, a gain on sale of investments of $16,300, depreciation of $7,300, loss on retirement of debt of $10,600, and interest of $3,200. Calculate the net cash provided (used) by operating activities using the indirect method Assume that the balances of current assets (except cash) and current liabilities remain the same as last year. Do not enter dollar signs or commas in the input boxes. Use the negative sign for a decrease in cash. Net cash provided (used) by operating activities $-385400 Check *
Use the following information from Dubuque Company’s financial statements to prepare the operating activities section of the statement of cash flows (indirect method) for the year 2018: PLEASE NOTE: Use the account and term names exactly as shown above and the accounts will be listed in the same order as shown in the textbook examples. All dollar amounts will be rounded to whole dollars using "$" and commas as needed (i.e. $12,345) and decreases will be shown with parentheses - $(12,345). Operating Activities: Adjustments to Reconcile Net Income to Net Cash Flow from Operating Activities: Changes in Current Assets and Liabilities: Net Cash Flows: Operating Activities