Question 5 (20 marks)
The comparative Balance Sheets and the Income statement for the Marine Corporation are as follow:
Marine Corporation |
|
Sales |
$ 5,500,000 |
Less: Cost of Goods Sold |
4,100,000 |
Gross Profit |
1,400,000 |
Less: Selling, General & Administrative Expenses |
230,000 |
Operating profit |
1,170,000 |
Less: Depreciation Expense |
160,000 |
Earnings Before Interest and Taxes |
1,010,000 |
Less: Interest Expense |
140,000 |
Earnings Before Taxes |
870,000 |
Less: Taxes (50%) |
435,000 |
Net Income |
$ 435,000 |
Marine Corporation |
Balance Sheet |
|
Assets |
2018 |
2019 |
Cash |
$35,000 |
$40,000 |
Marketable Securities |
185,000 |
170,000 |
Accounts Receivable |
220,000 |
240,000 |
Inventories |
240,000 |
275,000 |
Investments |
75,000 |
50,000 |
Total current assets |
$755,000 |
$775,000 |
Plant and Equipment |
1,100,000 |
1,450,000 |
Less Accumulated Amortization |
420,000 |
550,000 |
Net plant and Equipment |
$680,000 |
$900,000 |
Total Assets |
1,435,000 |
1,675,000 |
LIABILITIES AND SHAREHOLDERS’ EQUITY |
||
Accounts payable |
$75,000 |
$95,000 |
Notes payable |
70,000 |
30,000 |
Accrued Expenses |
25,000 |
5,000 |
Income Taxes Payable |
4,000 |
8,000 |
Bonds Payable (2016) |
700,000 |
850,000 |
Common Stock (100,000 shares) |
200,000 |
200,000 |
Retained Earnings |
361,000 |
487,000 |
Total Liabilities’ and Shareholders’ Equity |
$1,435,000 |
$1,675,000 |
Required:
Prepare a Statement of Cash Flows for the year ended December 31, 2019 using the Indirect Method showing the operating, investing and financial cashflows up to the net change in cash.
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Workings- Indirect Method | |
Decrease in Marketable Securities | Amount $ |
Closing Balance | 170,000.00 |
Less: Opening Balance | 185,000.00 |
Decrease in Marketable Securities | (15,000.00) |
Increase in Accounts Receivable | |
Closing Balance | 240,000.00 |
Less: Opening Balance | 220,000.00 |
Increase in Accounts Receivable | 20,000.00 |
Increase in Inventory | |
Closing Balance | 275,000.00 |
Less: Opening Balance | 240,000.00 |
Increase in Inventory | 35,000.00 |
Decrease in Investments | |
Closing Balance | 50,000.00 |
Less: Opening Balance | 75,000.00 |
Decrease in Investments | (25,000.00) |
Increase in Accounts Payable | |
Closing Balance | 95,000.00 |
Less: Opening Balance | 75,000.00 |
Increase in Accounts Payable | 20,000.00 |
Decrease in Accrued Expenses | |
Closing Balance | 5,000.00 |
Less: Opening Balance | 25,000.00 |
Decrease in Accrued Expenses | (20,000.00) |
Increase in Income Taxes Payable | |
Closing Balance | 8,000.00 |
Less: Opening Balance | 4,000.00 |
Increase in Income Taxes Payable | 4,000.00 |
Decrease in Notes payable | |
Closing Balance | 30,000.00 |
Less: Opening Balance | 70,000.00 |
Decrease in Notes payable | (40,000.00) |
Plant and Equipment purchased | |
Closing Balance | 1,450,000.00 |
Less: Opening Balance | 1,100,000.00 |
Plant and Equipment purchased | 350,000.00 |
Bonds Payable Issued | |
Closing Balance | 850,000.00 |
Less: Opening Balance | 700,000.00 |
Bonds Payable Issued | 150,000.00 |
Dividends paid | |
Opening Balance- Retained Earnings | 361,000.00 |
Add: Net Income | 435,000.00 |
Less: Closing Balance- Retained Earnings | 487,000.00 |
Dividends paid | 309,000.00 |
Marine | ||
Cashflow statement | Amount $ | Amount $ |
Particulars | ||
Net Income | 435,000.00 | |
Adjustment to reconcile Net Income to Net Cash | ||
Add: | ||
Depreciation Expense | 130,000.00 | |
Cash flow from Operations | 565,000.00 | |
Changes in Current Assets/Current Liabilities | ||
Decrease in Marketable Securities | 15,000.00 | |
Increase in Accounts Receivable | (20,000.00) | |
Increase in Inventory | (35,000.00) | |
Decrease in Investments | 25,000.00 | |
Increase in Accounts Payable | 20,000.00 | |
Decrease in Notes payable | (40,000.00) | |
Decrease in Accrued Expenses | (20,000.00) | |
Increase in Income Taxes Payable | 4,000.00 | (51,000.00) |
Net cash provided by operating activities | 514,000.00 | |
Cash flow from investing activities | ||
Plant and Equipment purchased | (350,000.00) | |
Net cash use for investing activities | (350,000.00) | |
Cash flow from financing activities | ||
Bonds Payable Issued | 150,000.00 | |
Dividends paid | (309,000.00) | |
Net cash used for financing activities | (159,000.00) | |
Net Increase/(Decrease) in cash | 5,000.00 | |
Cash Balance, beginning | 35,000.00 | |
Cash Balance, ending | 40,000.00 |
Question 5 (20 marks) The comparative Balance Sheets and the Income statement for the Marine Corporation...
Question 5 (20 marks) The comparative Balance Sheets and the Income statement for the Marine Corporation are as follow Marine Corporation Income Statement For the Year Ended December 31, 2019 Sales Less: Cost of Goods Sold Gross Profit Less: Selling, General & Administrative Expenses Operating profit $4,500,000 3,200,000 1,300,000 260,000 1,040,000 150,000 890,000 90,000 800,000 400,000 $ 400,000 Less: Depreciation Expense Earnings Before Interest and Taxes Less: Interest Expense Earings Before Taxes Less: Taxes (50%) Net Income Marine Corporation Assets...
Question 5 (20 marks) The comparative Balance Sheets and the Income statement for the Marine Corporation are as follow: Marine Corporation Income Statement For the Year Ended December 31, 2019 Sales s 2.500.000 Less: Cost of Goods Sold 1.220,000 Gross Profit 1,280,000 Less: Selling, General & Administrative Expenses 210,000 Operating profit 1.070,000 Less: Depreciation Expense 110,000 Earnings Before Interest and Taxes 960,000 Less: Interest Expense 54.000 Earnings Before Taxes 906,000 Less: Taxes (50%) 453,000 Net Income S 453,000 Marine Corporation...
full answer Question 5 (20 marks) The comparative Balance Sheets and the Income statement for the Marine Corporation are as follow: Marine Corporation Income Statement For the Year Ended December 31, 2019 Sales $ 4.500.000 Less: Cost of Goods Sold 3,200.000 Gross Profit 1.300.000 Less: Selling. General & Administrative Expenses 260.000 Operating profit 1.040.000 Less: Depreciation Expense 150.000 Earnings Before Interest and Taxes 890,000 Less: Interest Expense 90,000 Earnings Before Taxes 800,000 Less: Taxes (50%) 400,000 Net Income $ 400.000...
Question 5 (20 marks) The comparative Balance Sheets and the Income statement for the Marine Corporation are as follow Marine Corporation Assets Cash Marketable Securities Accounts Receivable Inventories Investments Total current assets Plant and Equipment Less Accumulated Amortization Net plant and Equipment Total Assets Balance Sheet 2018 $45,000 175,000 240,000 230,000 70,000 $760,000 1,300,000 450,000 2019 $50,000 160,000 220,000 275,000 55,000 $760,000 1,550,000 600,000 $850,000 1,610,000 $950,000 1,710,000 LIABILITIES AND SHAREHOLDERS' EQUITY Accounts payable $110,000 Notes payable 65,000 Accrued Expenses...
Question 4 (20 marks) The comparative Balance Sheets and the Income statement for the Marine Corporation are as follow: Marine Corporation Balance Sheet Assets 2019 2020 Cash $45,000 $50,000 Marketable Securities 175.000 160,000 Accounts Receivable 240,000 220,000 inventories 230,000 275,000 Investments 70,000 55.000 Total current assets $760,000 $760,000 Plant and Equipment 1,300,000 1,550,000 Less Accumulated Amortization 450,000 600,000 Net plant and Equipment S850,000 $950,000 Total Assets 1.610,000 1.710,000 LIABILITIES AND SHAREHOLDERS' EQUITY Accounts payable S110,000 $85.000 Notes payable 65.000 10.000...
The comparative Balance Sheets and the Income statement for the Marine Corporation are as follow: Marine Corporation Assets Cash Marketable Securities Accounts Receivable Inventories Investments Total current assets Plant and Equipment Less Accumulated Amortization Net plant and Equipment Total Assets Balance Sheet 2019 $45,000 175,000 240,000 230,000 70,000 $760,000 1300000 450,000 $850,000 1610000 LIABILITIES AND SHAREHOLDERS' EQUITY $110,000 65,000 30,000 5,000 400 000 2020 $50,000 160,000 275,000 55,000 $760,000 1550000 $950,000 1710000 Accounts payable Notes payable Accrued Expenses Income Taxes...
Below are the income statement and comparative balance sheet of Doone Corporation for year ending Dec 31, 2019 is given below. All amounts in Canadian dollars. Required: Prepare the cashflow statement, clearly including operating, financing and investing activities up to the net change in cash using the Indirect method as of Dec 31, 2019. Doone Corporation Income Statement For the Year ended Dec 31, 2019 Sales Revenue 950,000 Less: Cost of Goods Sold 520,000 Gross Profit 430,000 Less: Selling,...
Below are the income statement and comparative balance sheet of Doone Corporation for year ending Dec 31, 2019 is given below. All amounts in Canadian dollars. Required: Prepare the cashflow statement, clearly including operating, financing and investing activities up to the net change in cash using the Indirect method as of Dec 31, 2019. Doone Corporation Income Statement For the Year ended Dec 31, 2019 Sales Revenue 670,000 Less: Cost of Goods Sold 340,000 Gross Profit 330,000 Less: Selling, General...
Below are the income statement and comparative balance sheet of Doone Corporation for year ending Dec 31, 2019 is given below. All amounts in Canadian dollars. Required: Prepare the cashflow statement, clearly including operating, financing and investing activities up to the net change in cash using the Indirect method as of Dec 31, 2019. Doone Corporation Income Statement For the Year ended Dec 31, 2019 Sales Revenue 670,000 Less: Cost of Goods Sold 340.000 Gross Profit 330,000 Less: Selling, General...
Below are the income statement and comparative balance sheet of Doone Corporation for year ending Dec 31, 2019 is given below. All amounts in Canadian dollars. Required: Prepare the cashflow statement, clearly including operating, financing and investing activities up to the net change in cash using the Indirect method as of Dec 31, 2019. Doone Corporation Income Statement For the Year ended Dec 31, 2019 Sales Revenue 780,000 Less: Cost of Goods Sold 360,000 Gross Profit 420,000 Less: Selling,...