Question

In: Accounting

The controller of Neptune Corporation has provided you with the following information: Neptune Corporation Income Statement...


The controller of Neptune Corporation has provided you with the following information:
Neptune Corporation
Income Statement
For the Year Ended December 31, 2018

Sales Revenue $77,500
Cost of Goods Sold 53,500
Gross Profit 24,000
Depreciation expense 16,500
Gain on Sale of Equipment
6,500
Net Income 14,000

Neptune Corporation

Comparative Account Information

Relating to Operations

For the Year Ended December 31

Assets 2018 2017
Cash 29,500 30,000
Accounts Receivable 17,000 12,000
Capital Assets 138,500 123,500
Accumultaed Depreciation (89,000) (83,500)
Total Assets 96,000 82,000
Liabilities AND shareholders Equity
Bonds Payable 24,500 23,000
Dividends Payable 4,000 2,500
Common Shares 15,500 11,000
Retained Earnings 52,000 45,500
Total Liabilities AND Shareholders Equity 96,000 82,000


Additional Information:
During 2018, equipment costing 20,000 was sold for cash.
During 2018, $10,000 bonds payable were issued in exchange for capital assets. There was no amortization of bond discount or premium.
Required
In good form, generate the Statement of Cash Flows for the year ended December 31, 2018, using the indirect method.

Solutions

Expert Solution

Solution:

Neptune Corporation
Statement of Cash Flows
For the year ended 2018
Particulars Details Amount
Cash Flow from Operating Activities:
Net Income $14,000.00
Adjustments to reconcile net income to net cash provided by operations:
Depreciation Expense $16,500.00
Gain on sale of equipment -$6,500.00
Increase in accounts receivables -$5,000.00
Net Cash provided (Used) by operating activities $19,000.00
Cash Flow from Investing Activities:
Purchase of Capital assets ($138,500 - $123,500 + $20,000 - $10,000) -$25,000.00
Sale of equipment ($20,000 - $11,000 + $6,500) $15,500.00
Net Cash Provided (Used) by Investing activities -$9,500.00
Cash Flow from Financing Activities:
Dividend Paid ($2,500 + $7,500 - $4,000) -$6,000.00
Repayment of bonds ($23,000 + $10,000 - $24,500) -$8,500.00
Proceed from issue of common stock $4,500.00
Net Cash Provided (used) in financing activities -$10,000.00
Net Increase / (Decrease) in Cash -$500.00
Cash balance at beginning of year $30,000.00
Cash balance at end of year $29,500.00
Non Cash investing and financing activities:
Issue of bond in exchange of capital assets $10,000.00

Related Solutions

The following information has been provided to you by Watts Corporation: Net Income: 169,000 Increase in...
The following information has been provided to you by Watts Corporation: Net Income: 169,000 Increase in accounts payable: 18,500 Increase in inventory: 17,500 Increase in accounts recievable: 9,700 Increase in bonds payable: 75,000 Depriciation expense: 21,300 Depreciation in income taxes payable: 7,300 What is Watts Corporation's net cash flow from operating activities?
Asplund Corporation has provided the following information:
Asplund Corporation has provided the following information:    Cost per Unit Cost per Period Direct materials $ 6.25   Direct labor $ 2.90   Variable manufacturing overhead $ 1.30   Fixed manufacturing overhead   $ 18,000 Sales commissions $ 1.50   Variable administrative expense $ 0.45   Fixed selling and administrative expense   $ 7,500   Required: a. For financial reporting purposes, what is the total amount of product costs incurred to make 5,000 units? b. For financial reporting purposes,...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct a cash flow statement for the year ended Dec 31, 2008. Note that this company has also paid dividends on the common stock, but you need to find out how much by yourself. Hint: take a look at retained earnings. The company had no preferred stock (50% of exam grade) BALANCE SHEET ASSETS 2007 2008 Cash 45,000 50,000 Marketable Securities 275,000 160,000 Accounts Receivable...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct...
A) You are provided with the balance sheet and income statement of the Neuman Corporation: Construct a cash flow statement for the year ended Dec 31, 2008. Note that this company has also paid dividends on the common stock, but you need to find out how much by yourself. Hint: take a look at retained earnings. The company had no preferred stock (50% of exam grade) BALANCE SHEET ASSETS 2007 2008 Cash 45,000 50,000 Marketable Securities 275,000 160,000 Accounts Receivable...
The following income statement and additional year-end information is provided. SONAD COMPANY Income Statement For Year...
The following income statement and additional year-end information is provided. SONAD COMPANY Income Statement For Year Ended December 31 Sales $ 1,513,000 Cost of goods sold 741,370 Gross profit 771,630 Operating expenses Salaries expense $ 207,281 Depreciation expense 36,312 Rent expense 40,851 Amortization expenses—Patents 4,539 Utilities expense 16,643 305,626 466,004 Gain on sale of equipment 6,052 Net income $ 472,056 Accounts receivable $ 18,700 increase Accounts payable $ 12,525 decrease Inventory 34,225 increase Salaries payable 1,250 decrease Prepare the operating...
r supervisor has provided you with the following draft statement of income: Smoking’ Hot Ltd. Statement...
r supervisor has provided you with the following draft statement of income: Smoking’ Hot Ltd. Statement of Income Year Ended October 31, 2020 Sales $76,445,500 Gain on sale of building 975,000 77,420,500 Expenses    Cost of goods sold 48,542,900    Depreciation 660,100    Interest 93,200    Other operating 313,700    Rent 1,800,000    Salaries and wages 8,452,900 59,862,800 Income before income taxes 17,557,700 Income tax expense 5,267,000 Net income $12,290,700 Your supervisor has asked you to INDICATE whether the statement of income was prepared in the...
The Controller of Carriage House Inc, a Canadian Public Corporation, has prepared the accounting income statement...
The Controller of Carriage House Inc, a Canadian Public Corporation, has prepared the accounting income statement for the year ended April 30, 2019: Carriage House Inc Income Statement For the year ended April 30, 2019 Sales 995,000 Cost of Sales 523,000 Admin Expenses 185,000 (708,000) Operating Income 287,000 Other income and expenses 55,000 342,000 Provision for taxes     (102,000) Net Income 240,000 Other Informations: Included in the calculation of “Administrative expenses”: Interest on late income tax payments 435 Amortization (maximum...
Dingel Corporation has contracted with you to prepare a statement of cash flows. The controller has...
Dingel Corporation has contracted with you to prepare a statement of cash flows. The controller has provided the following information. December 31 2017 2016 Cash $38,500 $13,000 Accounts receivable 12,250 10,000 Inventory 12,000 10,000 Equity investments –0– 3,000 Buildings –0– 29,750 Equipment 40,000 20,000 Copyrights 5,000 5,250      Totals $107,750 $91,000 Allowance for doubtful accounts $3,000 $4,500 Accumulated depreciation—equipment 2,000 4,500 Accumulated depreciation—buildings –0– 6,000 Accounts payable 5,000 4,000 Dividends payable –0– 5,000 Notes payable, short-term (nontrade) 3,000 4,000 Long-term notes...
Homeboy Corporation has provided the following contribution format income statement. All questions concern situations that are...
Homeboy Corporation has provided the following contribution format income statement. All questions concern situations that are within the relevant range. Sales (2,000 units) $120,000 Variable expenses 72,000 Contribution margin 48,000 Fixed expenses 33,600 Net operating income $14,400 Required: If sales decline to 1,900 units, what would be the estimated net operating income? If the selling price increases by $4 per unit and the sales volume decreases by 200 units, what would be the estimated net operating income? What is the...
ABC Corporation has provided the following contribution format income statement. All questions concern situations that are...
ABC Corporation has provided the following contribution format income statement. All questions concern situations that are within the relevant range. Show your calculations Sales (6,000 units) $300,000 Variable expenses 240,000 Contribution margin 60,000 Fixed expenses 58,800 Net operating income $1,200 a. What is the contribution margin ratio? What does it mean? b. If sales increase to 6,040 units, what would be the estimated increase in net operating income? c. If the selling price increases by $4 per unit and the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT