Statement of Cash Flows Prepared from Consolidation Worksheet
Detecto Corporation purchased 60 percent of Strand Company’s outstanding shares on January 1, 20X1, for $24,000 more than book value. At that date, the fair value of the noncontrolling interest was $16,000 more than 40 percent of the book value of Strand. The full amount of the differential is considered related to patents and is being amortized over an eight-year period. In 20X1, Strand purchased a piece of land for $35,000 and later in the year sold it to Detecto for $45,000. Detecto is still holding the land as an investment. During 20X3, Detecto bonds with a value of $100,000 were exchanged for equipment valued at $100,000.
On January 1, 20X3, Detecto held inventory purchased previously from Strand for $48,000. During 20X3, Detecto purchased an additional $90,000 of goods from Strand and held $54,000 of this inventory on December 31, 20X3. Strand sells merchandise to the parent at cost plus a 20 percent markup. Strand also purchases inventory items from Detecto. On January 1, 20X3, Strand held inventory it had previously purchased from Detecto for $14,000, and on December 31, 20X3, it held goods it purchased from Detecto for $7,000 during 20X3. Strand’s total purchases from Detecto in 20X3 were $22,000. Detecto sells inventory to Strand at cost plus a 40 percent markup. The consolidated balance sheet at December 31, 20X2, contained the following amounts:
| Debit | Credit |
Cash | $ 92,000 |
|
Accounts Receivable | 135,000 |
|
Inventory | 140,000 |
|
Land | 75,000 |
|
Buildings and Equipment | 400,000 |
|
Patents | 30,000 |
|
Accumulated Depreciation |
| $210,000 |
Accounts Payable |
| 114,200 |
Bonds Payable |
| 90,000 |
Noncontrolling Interest |
| 84,800 |
Common Stock |
| 100,000 |
Retained Earnings |
| 273,000 |
Totals | $872,000 | $872,000 |
The consolidation worksheet below was prepared on December 31, 20X3. All eliminating entries and adjustments have been entered properly in the worksheet. Detecto accounts for its investment in Strand using the fully adjusted equity method.
Required
a.Prepare a worksheet for a consolidated statement of cash flows for 20X3 using the indirect method.
b.Prepare a consolidated statement of cash flows for 20X3.
DETECTO CORPORATION AND STRAND COMPANY Consolidation Worksheet December 31, 20X3 | |||||
| Detecto | Strand | Eliminating Entries |
| |
| Corporation | Company | DR | CR | Consolidated |
Income Statement |
|
|
|
|
|
Sales | 400,000 | 200,000 | 90,000 |
| 488,000 |
|
|
| 22,000 |
| (287,000) |
Less: Cost of Goods Sold Less: | (280,000) | (120,000) |
| 8,000 |
|
|
|
|
| 81,000 |
|
|
|
|
| 4,000 |
|
|
|
|
| 20,000 |
|
Less:Depreciation Expense | (25,000) | (15,000) |
|
|
|
|
|
|
|
| (40,000) |
Less: Amortization Expense |
|
| 5,000 |
| (5,000) |
Less: Other Expense | (35,000) | (30,000) |
|
| (65,000) |
Income from Strand Co. | 19,400 |
| 22,400 | 3,000 | 0 |
Consolidated Net Income | 79,400 | 35,000 | 139,400 | 116,000 | 91,000 |
NCI in Net Income of Strand |
|
| 13,600 | 2,000 | (11,600) |
Controlling Interest in Net Income | 79,400 | 35,000 | 153,000 | 118,000 | 79,400 |
Statement of Retained Earnings |
|
|
|
|
|
Beginning Balance | 273,000 | 150,000 | 150,000 |
| 273,000 |
Net Income | 79,400 | 35,000 | 153,000 | 118,000 | 79,400 |
Less: Dividends Declared | (50,000) | (20,000) |
| 20,000 | (50,000) |
Ending Balance | 302,400 | 165,000 | 303,000 | 138,000 | 302,400 |
Balance Sheet |
|
|
|
|
|
Cash | 26,800 | 35,000 |
|
| 61,800 |
Accounts Receivable | 80,000 | 40,000 |
|
| 120,000 |
Inventory | 120,000 | 90,000 |
| 9,000 | 199,000 |
|
|
|
| 2,000 |
|
Patent |
|
| 25,000 |
| 25,000 |
Investment in Subsidiary | 130,600 |
| 6,000 | 130,400 | 0 |
|
|
| 4,800 | 15,000 |
|
|
|
| 4,000 |
|
|
Land | 70,000 | 20,000 |
| 10,000 | 80,000 |
Buildings and Equipment Less: | 340,000 | 200,000 |
| 70,000 | 470,000 |
Accumulated Depreciation | (165,000) | (85,000) | 70,000 |
| (180,000) |
|
|
|
|
| 0 |
Total Assets | 602,400 | 300,000 | 109,800 | 236,400 | 775,800 |
Accounts Payable | 80,000 | 15,000 |
|
| 95,000 |
Bonds Payable | 120,000 | 70,000 |
|
| 190,000 |
Common Stock | 100,000 | 50,000 | 50,000 |
| 100,000 |
Retained Earnings | 302,400 | 165,000 | 303,000 | 138,000 | 302,400 |
NCI in NA of Strand |
|
| 4,000 | 85,600 | 88,400 |
|
|
| 3,200 | 10,000 |
|
Total Liabilities&Equity | 602,400 | 300,000 | 360,200 | 233,600 | 775,800 |
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.