Question

In: Accounting

Exercise 11-47 Preparing the Statement of Cash Flows The comparative balance sheets for Beckwith Products Company...

Exercise 11-47
Preparing the Statement of Cash Flows

The comparative balance sheets for Beckwith Products Company are presented below.

2019 2018
Assets:
    Cash $ 36,950 $ 25,000
    Accounts receivable 75,100 78,000
    Inventory 45,300 36,000
    Property, plant, and equipment 256,400 153,000
    Accumulated depreciation 38,650 20,000
Total assets $375,100 $272,000
Liabilities and Equity:
    Accounts payable $13,100 $11,000
    Interest payable 11,500 8,000
    Wages payable 8,100 9,000
    Notes payable 105,000 90,000
    Common stock 100,000 50,000
    Retained earnings 137,400 104,000
Total liabilities and equity $375,100 $272,000

Additional Information:

  1. Net income for 2019 was $58,400.
  2. Cash dividends of $25,000 were declared and paid during 2019.
  3. During 2019, Beckwith issued $50,000 of notes payable and repaid $35,000 principal relating to notes payable.
  4. Common stock was issued for $50,000 cash.
  5. Depreciation expense was $18,650, and there were no disposals of equipment.

Required:

1. Prepare a statement of cash flows (indirect method) for Beckwith Products for 2019. Use a minus sign to indicate any decreases in cash or cash outflows.

Beckwith Products Company
Statement of Cash Flows
For the Year Ended December 31, 2019
Cash flows from operating activities:
Net income $fill in the blank e34b3e0bafd0fdb_2
Adjustments to reconcile net income to net cash flow from operating activities:
Depreciation expense $fill in the blank e34b3e0bafd0fdb_4
Decrease in accounts receivable fill in the blank e34b3e0bafd0fdb_6
Increase in inventory fill in the blank e34b3e0bafd0fdb_8
Increase in accounts payable fill in the blank e34b3e0bafd0fdb_10
Increase in interest payable fill in the blank e34b3e0bafd0fdb_12
Decrease in wages payable fill in the blank e34b3e0bafd0fdb_14 fill in the blank e34b3e0bafd0fdb_15
Net cash provided by operating activities $fill in the blank e34b3e0bafd0fdb_16
Cash flows from investing activities:
Equipment purchase $fill in the blank e34b3e0bafd0fdb_18
Net cash used for investing activities fill in the blank e34b3e0bafd0fdb_19
Cash flows from financing activities:
Cash received from issuance of notes $fill in the blank e34b3e0bafd0fdb_21
Repayment of long-term liabilities fill in the blank e34b3e0bafd0fdb_23
Cash received from stock issue fill in the blank e34b3e0bafd0fdb_25
Payment of dividends fill in the blank e34b3e0bafd0fdb_27
Net cash provided by financing activities fill in the blank e34b3e0bafd0fdb_28
Net increase (decrease) in cash $fill in the blank e34b3e0bafd0fdb_30
Cash, 1/1/2019 fill in the blank e34b3e0bafd0fdb_31
Cash, 12/31/2019 $fill in the blank e34b3e0bafd0fdb_32

Feedback

1. Use proper form with company name, statement title, and date. Complete three sections for cash flows; operating, investing and financing.
For operating activities, start with net income and consider any noncash items as well as gains or losses. Next, analyze the changes in the balance sheet accounts to determine their effect on cash. (Remember to restate the fundamental accounting equation in terms of changes, separate the cash and noncash assets, and isolate the change in cash.)
Finally, total to determine the net cash flow for operating assets.
For investing activities, analyze the balance sheet changes and additional information for items that may be classified as an investing activity. Make T-accounts for any changes and determine if there was an associated inflow or outflow of cash for each account affected.
For financing activities, analyze the balance sheet changes and additional information for items that may be classified as a financing activity. Make T-accounts for any changes and determine if there was an associated inflow or outflow of cash for each account affected.

2. Compute the following cash-based performance measures:

  1. Free cash flow
  2. Cash flow adequacy (Note: Assume that the average amount of debt maturing over the next 5 years is $85,000.)

Round ratio to two decimal places. Enter negative values as negative numbers.

Free cash flow $
Adequacy ratio


Solutions

Expert Solution


Related Solutions

Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company's income statement and comparative balance sheets...
Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company's income statement and comparative balance sheets follow. RAINBOW COMPANY Income Statement For Year Ended December 31, 2016 Sales $1,500,000 Dividend Income 30,000 Total Revenue 1,530,000 Cost of Goods Sold $880,000 Wages and Other Operating Expenses 260,000 Depreciation Expense 78,000 Patent Amortization Expense 14,000 Interest Expense 26,000 Income Tax Expense 88,000 Loss on Sale of Equipment 10,000 Gain on Sale of Investments (6,000) 1,350,000 Net Income $180,000 RAINBOW COMPANY Balance Sheets...
Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company's income statement and comparative balance sheets...
Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company's income statement and comparative balance sheets follow. RAINBOW COMPANY Income Statement For Year Ended December 31, 2016 Sales $1,500,000 Dividend Income 30,000 Total Revenue 1,530,000 Cost of Goods Sold $880,000 Wages and Other Operating Expenses 260,000 Depreciation Expense 78,000 Patent Amortization Expense 14,000 Interest Expense 26,000 Income Tax Expense 88,000 Loss on Sale of Equipment 10,000 Gain on Sale of Investments (6,000) 1,350,000 Net Income $180,000 RAINBOW COMPANY Balance Sheets...
Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company’s income statement and comparative balance sheets...
Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company’s income statement and comparative balance sheets follow. RAINBOW COMPANY Income Statement For Year Ended December 31, 2016 Sales $750,000 Dividend Income 15,000 Total Revenue 765,000 Cost of Goods Sold $440,000 Wages and Other Operating Expenses 130,000 Depreciation Expense 39,000 Patent Amortization Expense 7,000 Interest Expense 13,000 Income Tax Expense 44,000 Loss on Sale of Equipment 5,000 Gain on Sale of Investments (3,000) 675,000 Net Income $90,000 RAINBOW COMPANY Balance Sheets...
Preparing a Statement of Cash Flows (Direct Method) Rainbow Company's income statement and comparative balance sheets...
Preparing a Statement of Cash Flows (Direct Method) Rainbow Company's income statement and comparative balance sheets follow. RAINBOW COMPANY Income Statement For Year Ended December 31, 2016 Sales $3,375,000 Dividend Income 67,500 Total Revenue 3,442,500 Cost of Goods Sold $1,980,000 Wages and Other Operating Expenses 585,000 Depreciation Expense 175,500 Patent Amortization Expense 31,500 Interest Expense 58,500 Income Tax Expense 198,000 Loss on Sale of Equipment 22,500 Gain on Sale of Investments (13,500) 3,037,500 Net Income $405,000 RAINBOW COMPANY Balance Sheets...
Preparing a Statement of Cash Flows (Direct Method) Rainbow Company's income statement and comparative balance sheets...
Preparing a Statement of Cash Flows (Direct Method) Rainbow Company's income statement and comparative balance sheets follow. RAINBOW COMPANY Income Statement For Year Ended December 31, 2016 Sales $1,125,000 Dividend Income 22,500 Total Revenue 1,147,500 Cost of Goods Sold $660,000 Wages and Other Operating Expenses 195,000 Depreciation Expense 58,500 Patent Amortization Expense 10,500 Interest Expense 19,500 Income Tax Expense 66,000 Loss on Sale of Equipment 7,500 Gain on Sale of Investments (4,500) 1,012,500 Net Income $135,000 RAINBOW COMPANY Balance Sheets...
Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company's income statement and comparative balance sheets...
Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company's income statement and comparative balance sheets follow. RAINBOW COMPANY Income Statement For Year Ended December 31, 2016 Sales $3,375,000 Dividend Income 67,500 Total Revenue 3,442,500 Cost of Goods Sold $1,980,000 Wages and Other Operating Expenses 585,000 Depreciation Expense 175,500 Patent Amortization Expense 31,500 Interest Expense 58,500 Income Tax Expense 198,000 Loss on Sale of Equipment 22,500 Gain on Sale of Investments (13,500) 3,037,500 Net Income $405,000 RAINBOW COMPANY Balance Sheets...
Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company’s income statement and comparative balance sheets...
Preparing a Statement of Cash Flows (Indirect Method) Rainbow Company’s income statement and comparative balance sheets follow. RAINBOW COMPANY Income Statement For Year Ended December 31, 2016 Sales $750,000 Dividend Income 15,000 Total Revenue 765,000 Cost of Goods Sold $440,000 Wages and Other Operating Expenses 130,000 Depreciation Expense 39,000 Patent Amortization Expense 7,000 Interest Expense 13,000 Income Tax Expense 44,000 Loss on Sale of Equipment 5,000 Gain on Sale of Investments (3,000) 675,000 Net Income $90,000 RAINBOW COMPANY Balance Sheets...
Exercise 12-12 Indirect: Preparing statement of cash flows LO P2, P3 MONTGOMERY INC. Comparative Balance Sheets...
Exercise 12-12 Indirect: Preparing statement of cash flows LO P2, P3 MONTGOMERY INC. Comparative Balance Sheets December 31 Current Year Prior Year Assets Cash $ 30,400 $ 30,550 Accounts receivable, net 10,050 12,150 Inventory 90,100 70,150 Total current assets 130,550 112,850 Equipment 49,900 41,500 Accum. depreciation—Equipment (22,500 ) (15,300 ) Total assets $ 157,950 $ 139,050 Liabilities and Equity Accounts payable $ 23,900 $ 25,400 Salaries payable 500 600 Total current liabilities 24,400 26,000 Equity Common stock, no par value...
Exercise 16-12 Indirect: Preparing statement of cash flows LO P2, P3 MONTGOMERY INC. Comparative Balance Sheets...
Exercise 16-12 Indirect: Preparing statement of cash flows LO P2, P3 MONTGOMERY INC. Comparative Balance Sheets December 31 Current Year Prior Year Assets Cash $ 53,800 $ 53,900 Accounts receivable, net 13,400 16,400 Inventory 120,100 94,800 Total current assets 187,300 165,100 Equipment 66,500 56,100 Accum. depreciation—Equipment (30,100 ) (20,700 ) Total assets $ 223,700 $ 200,500 Liabilities and Equity Accounts payable $ 32,000 $ 34,400 Salaries payable 600 800 Total current liabilities 32,600 35,200 Equity Common stock, no par value...
E12-13 Preparing and Evaluating a Statement of Cash Flows (Indirect Method) from Comparative Balance Sheets and...
E12-13 Preparing and Evaluating a Statement of Cash Flows (Indirect Method) from Comparative Balance Sheets and Income Statements [LO 12-1, LO 12-2, LO 12-3, LO 12-4, LO 12-5] Consultex, Inc. was founded in 2012 as a small financial consulting business. The company had done reasonably well in 2012–2014 but started noticing its cash dwindle early in 2015. In January 2015, Consultex had paid $14,500 to purchase land and repaid $3,000 principal on an existing promissory note. In March, the company...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT