In: Accounting
Requirements: Create Baylor's 2023 Cash Flow Statement using the INDIRECT METHOD
Baylor Company's 2023 income statement and comparative balance sheets at December 31, 2022 and 2023 are shown below.
|
Baylor |
|
|
Income Statement |
|
|
2023 |
|
|
Sales |
750,000 |
|
Dividend Income |
15,000 |
|
Gain on Sale of Investments |
10,000 |
|
Total Revenue |
775,000 |
|
Cost of Goods Sold |
440,000 |
|
Wages and Other Operating Expenses |
130,000 |
|
Depreciation Expense |
38,000 |
|
Patent Amortization Expense |
8,000 |
|
Interest Expense |
12,000 |
|
Income Tax Expense |
44,000 |
|
Loss of Sale of Equipment |
5,000 |
|
Total Expenses |
677,000 |
|
Net Income |
98,000 |
|
Baylor |
||
|
Balance Sheet |
||
|
2023 |
2022 |
|
|
Assets |
||
|
Cash |
21,000 |
24,000 |
|
Accounts Receivable |
40,000 |
31,000 |
|
Inventory |
97,000 |
77,000 |
|
Prepaid Expenses |
10,000 |
7,000 |
|
Long-term Investments |
30,000 |
80,000 |
|
Land |
190,000 |
100,000 |
|
Buildings |
445,000 |
350,000 |
|
Accumulated Depr - Buildings |
(91,000) |
(75,000) |
|
Equipment |
179,000 |
225,000 |
|
Accumulated Depr - Equipment |
(41,000) |
(46,000) |
|
Patents |
72,000 |
42,000 |
|
Accumulated Amortization |
(18,000) |
(10,000) |
|
Total Assets |
934,000 |
805,000 |
|
Liabilities & Equity |
||
|
Accounts Payable |
25,000 |
16,000 |
|
Interest Payable |
6,000 |
5,000 |
|
Income Taxes Payable |
8,000 |
10,000 |
|
Bonds Payable |
150,000 |
125,000 |
|
Preferred Stock |
100,000 |
70,000 |
|
Common Stock |
540,000 |
524,000 |
|
Retained Earnings |
105,000 |
55,000 |
|
Total Liabilities & Equity |
934,000 |
805,000 |
During 2023, the following transactions occurred:
1. Purchased land for cash
2. Sold long-term investments costing $50,000 at a $10,000 gain.
3. Paid $95,000 to make improvements to buildings.
4. Sold equipment for $14,000 cash that originally cost $46,000 and had $27,000 accumulated depreciation.
5. Issues bonds payable for cash.
6. Acquired a patent with a fair value of $30,000 by issuing preferred stock.
7. Declared and paid a $48,000 cash dividend.
8. Recorded depreciation of $16,000 on buildings and $22,000 on equipment.
9. Issued $16,000 of common stock.
Include all calculations please!
Answer-
| BAYLOR COMPANY | ||
| STATEMENT OF CASH FLOWS (USING INDIRECT METHOD) | ||
| FOR THE YEAR ENDED 31 DECEMBER,2023 | ||
| Particulars | Amount | |
| $ | ||
| Cash flow from operating activities | ||
| Net Income | 98000 | |
| Adjustments to reconcile net income to net cash provided by operating activities | ||
| Adjustment for non cash effects | ||
| Depreciation | 38000 | |
| Gain on sale of long-term investments | -10000 | |
| Loss on sale of equipment | 5000 | |
| Patent amortization expense | 8000 | |
| Change in operating assets & liabilities | ||
| Increase in accounts receivable | -9000 | |
| Increase in inventory | -20000 | |
| Increase in prepaid expenses | -3000 | |
| Increase in accounts payable | 9000 | |
| Increase in interest payable | 1000 | |
| Decrease in income tax payable | -2000 | |
| Net cash flow from operating activities (a) | 115000 | |
| Cash Flow from Investing activities | ||
| Long-term investments sold | 60000 | |
| Land purchased | -90000 | |
| Cash paid for building improvments | -95000 | |
| Old equipment sold | 14000 | |
| Net cash Flow from Investing activities (b) | -111000 | |
| Cash Flow from Financing activities | ||
| Bonds payable issued | 25000 | |
| Common stock issued | 16000 | |
| Cash dividends paid | -48000 | |
| Net cash Flow from Financing activities (c) | -7000 | |
| Net Change in cash c=a+b+c | -3000 | |
| Beginning cash balance | 24000 | |
| Closing cash balance | 21000 | |
| Schedule of non cash investing & financing activities | ||
| Issuance of preferred stock for patent | $30000 |