Question

In: Accounting

Spreadsheet and Statement The following 2016 information is available for Stewart Company: Condensed Income Statement for...

Spreadsheet and Statement

The following 2016 information is available for Stewart Company:

Condensed Income Statement for 2016
Sales $9,000
Cost of goods sold (6,000)
Other expenses (2,000)
Loss on sale of equipment (260)
Gain on sale of land 400
Net income $1,140
Comparative Balance Sheets
December 31,
2015		 December 31,
2016
Cash $700 $1,130
Accounts receivable 450 310
Inventory 350 400
Land 300 500
Equipment 1,600 1,800
Less: Accumulated depreciation (200) (150)
Total Assets $3,200 $3,990
Accounts payable $600 $750
Bonds payable (due 1/1/2018) 1,000 1,000
Common stock, $10 par 900 1,400
Retained earnings 700 840
Total Liabilities and Shareholders' Equity $3,200 $3,990

Partial additional information:

The equipment that was sold for cash had cost $400 and had a book value of $300.

Land that was sold brought a cash price of $530.

Fifty shares of stock were issued at par.

Required:

Making whatever additional assumptions that are necessary,

1. Prepare a spreadsheet to support a 2016 statement of cash flows for Stewart. If an amount is zero, enter "0".

  
Balances Balances Balances Change Worksheet Entries Debit Worksheet Entries Credit

12/31/2015 12/31/2016
  

Entries
Debit   Worksheet
Entries
Credit​

Cash                  
Noncash Accounts:                  
Accounts receivable                  
Inventory                  
Land                  
Equipment                  
Totals                  
Credits                  
Accumulated depreciation                  
Accounts payable                  
Bonds pay. (due 1/1/2021)                  
Common stock, $10 par                  
Retained earnings                  
Totals                  
Cash Flow From Operating Activities                  
Net income                  
Add: Decrease in accounts receivable                  
Add: Loss on sale of equipment                  
Add: Depreciation expense                  
Add: Increase in accounts payable                  
Less: Increase in inventory                  
Less: Gain on sale of land                  
Cash Flows From Investing Activities                  
Proceeds from sale of land                  
Payment for purchase of land                  
Proceeds from sale of equipment                  
Payment for purchase of equipment                  
Cash Flows From Financing Activities                  
Proceeds from issuance of common stock                  
Payment of dividends                  
Net increase in cash                  
Totals               $   $

2. Prepare the statement of cash flows. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments.

STEWART COMPANY
Statement of Cash Flows
For Year Ended December 31, 2016
Operating Activities:
Net income $
Adjustment for noncash income items:
Add: Depreciation expense
Add: Loss on sale of equipment
Less: Gain on sale of land
Adjustments for cash flow effects
from working capital items:
Decrease in accounts receivable
Increase in inventory
Increase in accounts payable
Net cash provided by operating activities $
Investing Activities:
Proceeds from sale of land $
Payment for purchase of land
Proceeds from sale of equipment
Payment for purchase of equipment
Net cash used for investing activities
Financing Activities:
Proceeds from issuance of common stock $
Payment of dividends
Net cash used for financing activities
Net increase in cash $
Cash, January 1, 2016
Cash, December 31, 2016 $

2. Prepare the statement of cash flows. Use the minus sign to indicate cash outflows, a decrease in cash or cash payments.

STEWART COMPANY
Statement of Cash Flows
For Year Ended December 31, 2016
Operating Activities:
Net income $
Adjustment for noncash income items:
Add: Depreciation expense
Add: Loss on sale of equipment
Less: Gain on sale of land
Adjustments for cash flow effects
from working capital items:
Decrease in accounts receivable
Increase in inventory
Increase in accounts payable
Net cash provided by operating activities $
Investing Activities:
Proceeds from sale of land $
Payment for purchase of land
Proceeds from sale of equipment
Payment for purchase of equipment
Net cash used for investing activities
Financing Activities:
Proceeds from issuance of common stock $
Payment of dividends
Net cash used for financing activities
Net increase in cash $
Cash, January 1, 2016
Cash, December 31, 2016

Solutions

Expert Solution

ekkarill92 answered 2 years ago
Next > < Previous

Related Solutions

Ratios (Appendix) Byers Company presents the following condensed income statement for 2016 and condensed December 31,...
Ratios (Appendix) Byers Company presents the following condensed income statement for 2016 and condensed December 31, 2016, balance sheet: Income Statement Sales (net) $267,000 Less:      Cost of goods sold $160,000      Operating expenses 62,000      Interest expense 11,000      Income taxes 10,000      Total expenses (243,000) Net income $24,000 Balance Sheet Cash $10,000 Current liabilities $40,000 Receivables (net) 22,000 Bonds payable, 10% 110,000 Inventory 56,000 Common stock, $10 par 100,000 Long-term investments 30,000 Additional paid-in capital 95,000 Property and equipment (net) 282,000 Retained earnings...
Zumbrunn Company’s income statement contained the following condensed information. ZUMBRUNN COMPANY Income Statement For the Year...
Zumbrunn Company’s income statement contained the following condensed information. ZUMBRUNN COMPANY Income Statement For the Year Ended December 31, 2020 Service revenue $970,400 Operating expenses, excluding depreciation $624,100 Depreciation expense 55,400 Loss on disposal of plant assets 25,200 704,700 Income before income taxes 265,700 Income tax expense 39,100 Net income $226,600 Zumbrunn’s balance sheets contained the comparative data at December 31, shown below. 2020 2019 Accounts receivable $75,200 $59,800 Accounts payable 40,400 28,900 Income taxes payable 13,000 6,400 Accounts payable...
Direct and Indirect Methods Dauve Company reported the following condensed income statement for 2016: Sales $100,000...
Direct and Indirect Methods Dauve Company reported the following condensed income statement for 2016: Sales $100,000 Cost of goods sold (58,000) Gross profit $42,000 Operating expenses: Depreciation expense $8,000 Salaries expense 12,000 (20,000) Income before income taxes $22,000 Income tax expense (6,600) Net income $15,400 During 2016, the following changes occurred in the company's current assets and current liabilities: Increase (Decrease) Cash $3,700 Accounts receivable (5,500) Inventories 8,900 Accounts payable (purchases) (4,600) Salaries payable 2,800 Required: 1. By visual inspection,...
Ratio Analysis Byers Company presents the following condensed income statement for 2019 and condensed December 31,...
Ratio Analysis Byers Company presents the following condensed income statement for 2019 and condensed December 31, 2019, balance sheet: Income Statement Sales (net) $267,000 Less:      Cost of goods sold $160,000      Operating expenses 62,000      Interest expense 11,000      Income taxes 10,000      Total expenses (243,000) Net income $24,000 Balance Sheet Cash $10,000 Current liabilities $40,000 Receivables (net) 22,000 Bonds payable, 10% 110,000 Inventory 56,000 Common stock, $10 par 100,000 Long-term investments 30,000 Additional paid-in capital 95,000 Property and equipment (net) 282,000 Retained earnings...
The following information is available for Ziyana: Statement of Financial Position at 31st December 2016 2015...
The following information is available for Ziyana: Statement of Financial Position at 31st December 2016 2015 Assets Non-current assets Cost/valuation 11000000 8000000 Acc Depn -5600000 -4800000 Carrying amount 5400000 3200000 Current Assets Inventories 3400000 3800000 Receivables 3800000 2900000 Cash at bank 400000 7600000 100000 6800000 Current liabilities Trade payables 3700000 3200000 Tax 700000 -4400000 600000 -3800000 Non-current Liablities 10% Loan notes -3000000 -2000000 5600000 4200000 Equity and liabilities Equity Ordinary share capital 1000000 1000000 Revaluation surplus 1500000 1000000 Retained earnings...
Ratios (Appendix) Miller Company's condensed income statement for 2016 and December 31, 2016, balance sheet follow:...
Ratios (Appendix) Miller Company's condensed income statement for 2016 and December 31, 2016, balance sheet follow: Income Statement Sales (net) $304,400 Cost of goods sold (183,600) Gross profit $120,800 Operating expenses (82,000) Operating income $38,800 Interest expense (7,000) Income before income taxes $31,800 Income taxes (10,000) Net income 21,800 Balance Sheet Cash $8,200 Accounts payable $18,000 Receivables (net) 14,700 Other current liabilities 6,800 Inventory 19,300 Bonds payable, 10% 70,000 Property, plant, and equipment (net) 195,800 Common stock, $10 par 80,500...
Wildhorse Co.’s income statement contained the condensed information below. Wildhorse Co. Income Statement For the Year...
Wildhorse Co.’s income statement contained the condensed information below. Wildhorse Co. Income Statement For the Year Ended December 31, 2022 Service revenue $1,358,000 Operating expenses, excluding depreciation $859,600 Depreciation expense 77,000 Loss on disposal of plant assets 22,400 959,000 Income before income taxes 399,000 Income tax expense 78,400 Net income $320,600 Wildhorse Co.’s balance sheets contained the following comparative data at December 31. 2022 2021 Accounts receivable $98,000 $84,000 Accounts payable 57,400 44,800 Income taxes payable 18,200 9,800 Accounts payable...
Wildhorse Co.’s income statement contained the condensed information below. Wildhorse Co. Income Statement For the Year...
Wildhorse Co.’s income statement contained the condensed information below. Wildhorse Co. Income Statement For the Year Ended December 31, 2017 Service revenue $2,463,800 Operating expenses, excluding depreciation $1,559,560 Depreciation expense 139,700 Loss on disposal of plant assets 40,640 1,739,900 Income before income taxes 723,900 Income tax expense 142,240 Net income $581,660 Wildhorse Co.’s balance sheet contained the comparative data at December 31. 2017 2016 Accounts receivable $177,800 $152,400 Accounts payable 104,140 81,280 Income taxes payable 33,020 17,780 Accounts payable pertain...
The following income statement and balance sheet information are available for two firms, Firm A and...
The following income statement and balance sheet information are available for two firms, Firm A and Firm B. (a) Calculate the amount of dividends Firm A and Firm B paid using the information given. (b) Prepare statement of cash flows for each firm using the indirect method. (c) Analyze the difference in the two firms, Income Statement for Year Ended Decemeber 31,2015                                                    Firm A       Firm B Sales                                       1,000,000       1,000,000 Cost of Goods Sold                     700,000           700,000 Gross Profit                                300,000            300,000...
Teal Company’s income statement for the year ended December 31, 2017, contained the following condensed information....
Teal Company’s income statement for the year ended December 31, 2017, contained the following condensed information. Service revenue $845,000 Operating expenses (excluding depreciation) $620,000 Depreciation expense 61,000 Loss on sale of equipment 26,000 707,000 Income before income taxes 138,000 Income tax expense 41,000 Net income $97,000 Teal’s balance sheet contained the following comparative data at December 31. 2017 2016 Accounts receivable $39,000 $56,000 Accounts payable 39,000 33,000 Income taxes payable 4,100 8,400 (Accounts payable pertains to operating expenses.) Prepare the...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT