978-1337398169 Chapter 13 Excel Part 3

subject Type Homework Help
subject Pages 10
subject Words 1682
subject Authors Carl Warren, Jeff Jones

Unlock document.

This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
page-pf1
Net increase (decrease) in cash
Cash balance, January 1, 20Y6
Cash balance, December 31, 20Y6
Schedule Reconciling Net Income with Cash Flows from Operating Activities:
Net income
Adjustments to reconcile net income to net cash flow from operating activities:
Depreciation expense
Loss on sale of investments
Changes in current operating assets and liabilities:
Net cash flow from operating activities
Computations:
1. Sales
Cash received from customers
2. Cost of goods sold
Cash payments for merchandise
3. Operating expenses other than depreciation
Cash payments for operating expenses
page-pf2
An asterisk (*) will appear to the right of an incorrect entry.
Cash flows from (used for) operating activities:
Cash received from customers 5,960,600$
(2,456,800)
(3,107,400)
(102,800)
Net cash flow from operating activities 293,600$
Cash flows from (used for) investing activities:
Cash received from sale of investments 176,000$
(520,000)
Net income
217,200$
Adjustments to reconcile net income to net cash flow from operating activities:
Depreciation expense 44,000
Loss on sale of investments 64,000
Changes in current operating assets and liabilities:
(19,400)
(28,200)
Score:
ON
Problem 13-4A
Name:
Solution
Section:
Cash paid for purchase of land
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Canace Products Inc.
Statement of Cash Flows
For the Year Ended December 31, 20Y6
Cash payments for merchandise
Cash payments for operating expenses
Cash payments for income taxes
Increase in accounts receivable
Increase in inventories
page-pf3
1. Sales 5,980,000$
(19,400)
Cash received from customers 5,960,600$
2. Cost of goods sold 2,452,000$
28,200
(23,400)
Cash payments for merchandise 2,456,800$
3. Operating expenses other than depreciation 3,100,000$
7,400
Cash payments for operating expenses 3,107,400$
Increase in accounts receivable
Increase in inventories
Increase in accounts payable
Decrease in accrued expenses payable
An asterisk (*) will appear to the right of an incorrect entry.
Cash flows from (used for) operating activities:
Cash received from customers
Net cash flow from operating activities
Cash flows from (used for) investing activities:
Cash received from sale of investments
Net cash flow used for investing activities
Cash flows from (used for) financing activities:
Cash received from sale of common stock
Net cash flow from financing activities
Problem 13-4B
Name:
Section:
Score:
0%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Martinez Inc.
Statement of Cash Flows
For the Year Ended December 31, 20Y4
Net increase (decrease) in cash
Cash balance, January 1, 20Y4
Cash balance, December 31, 20Y4
Schedule Reconciling Net Income with Cash Flows from Operating Activities:
Net income
Adjustments to reconcile net income to net cash flow from operating activities:
Depreciation expense
Gain on sale of investments
Changes in current operating assets and liabilities:
Net cash flow from operating activities
Computations:
1. Sales
Cash received from customers
2. Cost of goods sold
Cash payments for merchandise
3. Operating expenses other than depreciation
Cash payments for operating expenses
page-pf6
An asterisk (*) will appear to the right of an incorrect entry.
Cash flows from (used for) operating activities:
Cash received from customers 4,433,760$
(2,269,200)
(1,356,240)
(299,100)
Net cash flow from operating activities 509,220$
Cash flows from (used for) investing activities:
Cash received from sale of investments 588,000$
(960,000)
(240,000)
Net cash flow used for investing activities (612,000)
Net income
558,960$
Adjustments to reconcile net income to net cash flow from operating activities:
Depreciation expense 113,100
Gain on sale of investments (156,000)
Changes in current operating assets and liabilities:
(78,240)
(30,600)
113,400
Score:
ON
Problem 13-4B
Name:
Solution
Section:
Cash paid for purchase of land
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Martinez Inc.
Statement of Cash Flows
For the Year Ended December 31, 20Y4
Cash payments for merchandise
Cash payments for operating expenses
Cash payments for income taxes
Cash paid for purchase of equipment
Increase in accounts receivable
Increase in inventories
Increase in accounts payable
page-pf7
1. Sales 4,512,000$
(78,240)
Cash received from customers 4,433,760$
2. Cost of goods sold 2,352,000$
30,600
(113,400)
Cash payments for merchandise 2,269,200$
3. Operating expenses other than depreciation 1,344,840$
11,400
Cash payments for operating expenses 1,356,240$
Increase in accounts receivable
Increase in inventories
Increase in accounts payable
Decrease in accrued expenses payable
page-pf8
An asterisk (*) will appear to the right of an incorrect entry.
Cash flows from (used for) operating activities:
Cash received from customers
Net cash flow from operating activities
Cash flows from (used for) investing activities:
Cash received from sale of investments
Net cash flow used for investing activities
Cash flows from (used for) financing activities:
Cash received from sale of common stock
Net cash flow from financing activities
Answers are entered in the cells with gray backgrounds.
Problem 13-5A
Name:
Section:
Score:
0%
Key Code:
[Key code here]
Instructions
Cells with non-gray backgrounds are protected and cannot be edited.
Livers Inc.
Statement of Cash Flows
For the Year Ended December 31, 20Y3
Net increase (decrease) in cash
Cash balance, January 1, 20Y3
Cash balance, December 31, 20Y3
Schedule Reconciling Net Income with Cash Flows from Operating Activities:
Net income
Adjustments to reconcile net income to net cash flow from operating activities:
Depreciation expense
Gain on sale of investments
Changes in current operating assets and liabilities:
Net cash flow from operating activities
Computations:
1. Sales
Cash received from customers
2. Cost of goods sold
Cash payments for merchandise
3. Operating expenses other than depreciation
Cash payments for operating expenses
4. Cash dividends declared
Cash payments for dividends
page-pfb
An asterisk (*) will appear to the right of an incorrect entry.
Cash flows from (used for) operating activities:
Cash received from customers 2,950,000$
(1,380,000)
(955,000)
(125,000)
Net cash flow from operating activities 490,000$
Cash flows from (used for) investing activities:
Cash received from sale of investments 175,000$
(500,000)
Net income
500,000$
Adjustments to reconcile net income to net cash flow from operating activities:
Depreciation expense 100,000
Gain on sale of investments (75,000)
Changes in current operating assets and liabilities:
(50,000)
Livers Inc.
Problem 13-5A
Name:
Solution
Section:
Score:
ON
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Statement of Cash Flows
For the Year Ended December 31, 20Y3
Cash payments for merchandise
Cash payments for operating expenses
Cash payments for income taxes
Cash paid for purchase of land
Increase in accounts receivable
page-pfc
1. Sales 3,000,000$
(50,000)
Cash received from customers 2,950,000$
2. Cost of goods sold 1,400,000$
20,000
(40,000)
Cash payments for merchandise 1,380,000$
3. Operating expenses other than depreciation 950,000$
5,000
Cash payments for operating expenses 955,000$
4. Cash dividends declared 90,000$
(5,000)
Cash payments for dividends 85,000$
Increase in accounts receivable
Increase in inventories
Increase in accounts payable
Decrease in accrued expenses payable
Increase in dividends payable
An asterisk (*) will appear to the right of an incorrect entry.
Cash flows from (used for) operating activities:
Cash received from customers
Net cash flow from operating activities
Cash flows from (used for) investing activities:
Cash received from sale of investments
Net cash flow used for investing activities
Cash flows from (used for) financing activities:
Cash received from sale of common stock
Net cash flow from financing activities
Problem 13-5B
Name:
Section:
Score:
0%
Key Code:
[Key code here]
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Merrick Equipment Co.
Statement of Cash Flows
For the Year Ended December 31, 20Y9
Net increase (decrease) in cash
Cash balance, January 1, 20Y9
Cash balance, December 31, 20Y9
Schedule Reconciling Net Income with Cash Flows from Operating Activities:
Net income
Adjustments to reconcile net income to net cash flow from operating activities:
Depreciation expense
Loss on sale of investments
Changes in current operating assets and liabilities:
Net cash flow from operating activities
Computations:
1. Sales
Cash received from customers
2. Cost of goods sold
Cash payments for merchandise
3. Operating expenses other than depreciation
Cash payments for operating expenses
page-pff
An asterisk (*) will appear to the right of an incorrect entry.
Cash flows from (used for) operating activities:
Cash received from customers 2,004,858$
(1,242,586)
(513,559)
(94,453)
Net cash flow from operating activities 154,260$
Cash flows from (used for) investing activities:
Cash received from sale of investments 91,800$
(295,800)
Net income
141,680$
Adjustments to reconcile net income to net cash flow from operating activities:
Loss on sale of investments 10,200
Changes in current operating assets and liabilities:
(19,040)
(8,670)
11,560
3,740
Score:
ON
Problem 13-5B
Name:
Solution
Section:
Cash paid for purchase of land
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Merrick Equipment Co.
Statement of Cash Flows
For the Year Ended December 31, 20Y9
Cash payments for merchandise
Cash payments for operating expenses
Cash payments for income taxes
Increase in accounts receivable
Increase in inventories
Increase in accounts payable
Increase in accrued expenses payable
page-pf10
1. Sales 2,023,898$
(19,040)
Cash received from customers 2,004,858$
2. Cost of goods sold 1,245,476$
8,670
(11,560)
Cash payments for merchandise 1,242,586$
3. Operating expenses other than depreciation 517,299$
(3,740)
Cash payments for operating expenses 513,559$
Increase in accounts receivable
Increase in inventories
Increase in accounts payable
Increase in accrued expenses payable

Trusted by Thousands of
Students

Here are what students say about us.

Copyright ©2022 All rights reserved. | CoursePaper is not sponsored or endorsed by any college or university.