Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

The individual financial statements for Gibson Company and Keller Company for th

ID: 2341914 • Letter: T

Question

The individual financial statements for Gibson Company and Keller Company for the year ending December 31, 2018, follow. Gibson acquired a 60 percent interest in Keller on January 1, 2017, in exchange for various considerations totaling $780,000. At the acquisition date, the fair value of the noncontrolling interest was $520,000 and Keller’s book value was $1,040,000. Keller had developed internally a customer list that was not recorded on its books but had an acquisition-date fair value of $260,000. This intangible asset is being amortized over 20 years.

Gibson sold Keller land with a book value of $80,000 on January 2, 2017, for $170,000. Keller still holds this land at the end of the current year.

Keller regularly transfers inventory to Gibson. In 2017, it shipped inventory costing $217,000 to Gibson at a price of $310,000. During 2018, intra-entity shipments totaled $360,000, although the original cost to Keller was only $234,000. In each of these years, 20 percent of the merchandise was not resold to outside parties until the period following the transfer. Gibson owes Keller $40,000 at the end of 2018.

Gibson Company

Keller Company

Sales

$

(960,000

)

$

(660,000

)

Cost of goods sold

660,000

460,000

Operating expenses

150,000

35,000

Equity in earnings of Keller

(99,000

)

0

Net income

$

(249,000

)

$

(165,000

)

Retained earnings, 1/1/18

$

(1,276,000

)

$

(700,000

)

Net income (above)

(249,000

)

(165,000

)

Dividends declared

150,000

50,000

Retained earnings, 12/31/18

$

(1,375,000

)

$

(815,000

)

Cash

$

185,000

$

70,000

Accounts receivable

388,000

570,000

Inventory

550,000

480,000

Investment in Keller

981,000

0

Land

130,000

550,000

Buildings and equipment (net)

512,000

460,000

Total assets

$

2,746,000

$

2,130,000

Liabilities

$

(621,000

)

$

(755,000

)

Common stock

(750,000

)

(480,000

)

Additional paid-in capital

0

(80,000

)

Retained earnings, 12/31/18

(1,375,000

)

(815,000

)

Total liabilities and equities

$

(2,746,000

)

$

(2,130,000

)

(Note: Parentheses indicate a credit balance.)

Prepare a worksheet to consolidate the separate 2018 financial statements for Gibson and Keller.

How would the consolidation entries in requirement (a) have differed if Gibson had sold a building with a $140,000 book value (cost of $300,000) to Keller for $260,000 instead of land, as the problem reports? Assume that the building had a 10-year remaining life at the date of transfer.

Gibson Company

Keller Company

Sales

$

(960,000

)

$

(660,000

)

Cost of goods sold

660,000

460,000

Operating expenses

150,000

35,000

Equity in earnings of Keller

(99,000

)

0

Net income

$

(249,000

)

$

(165,000

)

Retained earnings, 1/1/18

$

(1,276,000

)

$

(700,000

)

Net income (above)

(249,000

)

(165,000

)

Dividends declared

150,000

50,000

Retained earnings, 12/31/18

$

(1,375,000

)

$

(815,000

)

Cash

$

185,000

$

70,000

Accounts receivable

388,000

570,000

Inventory

550,000

480,000

Investment in Keller

981,000

0

Land

130,000

550,000

Buildings and equipment (net)

512,000

460,000

Total assets

$

2,746,000

$

2,130,000

Liabilities

$

(621,000

)

$

(755,000

)

Common stock

(750,000

)

(480,000

)

Additional paid-in capital

0

(80,000

)

Retained earnings, 12/31/18

(1,375,000

)

(815,000

)

Total liabilities and equities

$

(2,746,000

)

$

(2,130,000

)

Required Required B Prepare a worksheet to consolidate the separate 2018 financial statements for Gibson and Keller. (Do not round intermediate calculations. For accounts where multiple consolidation entries are required, combine all debit entries into one amount and enter this amount in the debit column of the worksheet. Similarly, combine all credit entries into one amount and enter this amount in the credit column of the worksheet. Amounts in the Debit and Credit columns should be entered as positive. Negative amounts for the Noncontrolling Interest and Consolidated Totals columns should be entered with a minus sign.) GIBSON AND Consolidation Worksheet For the Year Ending December 31, 2018 Consolidation Entries Gibson 5 (0,000)880,000) 480,000 35,000 Cost of goods sold 880,000 150,000 (39,000) Equity in earnings of Keller Separate company Consolidated net income net income S (249,000) (185,000) To noncontrolling interest To Gibson Company 1/1-Gibson (1,278,000) (700,000) (249,000(185.000) Net income Dividends declared 50,000 5 (1,375,000) (815,000) 5 185,000 70,000 570,000 480,000 150,000 earnings, 12/31 Accounts receivable nventory Investment in Keller 388,000 550,000 981,000 130,000 512,000 550,000 480,000 Buildings and equipment (net) Customer list Total assets 5 2,748,000 2,130,000 5 (821,000)(755,000) Common stock 750,000(480,000 Additional paid-in capital (80,000) (1,375,000)815,000) earnings, 12/31 NCI in Keller, 1/1 NCI in Keller, 12/31 Total liabilities and equity 5 (2,748,000) (2,130,000) 0S

Explanation / Answer

We start off with this problem by looking at the acquisition information. Gibson purchases 60% of Keller. The 60% represents 570,000 in dollar value. The non-controlling interest (the other 40%) has a fair value of 380,000. So, total fair market value of Keller is 950,000 (570,000 + 380,000). The book value of Keller is 850,000, thus the fair value over book value is 100,000. However, they tell us that there is a customer list worth 100,000 that was not included on the books. So if we assume that this would have been on the books, then the adjusted fair value over book value would be zero. The customer list is amortized over 20 years. Therefore, 100,000 divided by 20 comes out to 5,000 per year.

The next section of the worksheet gets into the consolidation entries and most of them will be similar to those in problem 32. The first one that we look at is the land transaction. Gibson sold Keller some land with a book value of 60,000 for 100,000, which Keller still holds. So Gibson would have recorded that 40,000 difference as a gain, which needs to be eliminated.   We reduce retained earnings through a debit to remove the gain, and we also reduce the value of the land by 40,000 to bring it back down to the 60,000 value.

Entry TL

Debit: Retained Earnings                                   40,000

Credit:          Land                                                                    40,000

On Problem 32 we made adjustments for gross profits from the transfer of inventory. We will do that again in this problem. First, we are going to determine how much was deferred in 2012 that we will now recognize in 2013. In the third paragraph they give us the information we need. In 2012, Keller transferred inventory that cost 100,000 for a price of 150,000. So the gross profit rate that we are going to use for 2012 is 33.3% (50,000 gross profit divided by sale price of 150,000). The also tell us that 20% of the merchandise was not resold to outside parties. So in 2012, Gibson purchased 150,000 and retained 20% of that, which is 30,000. We then apply the gross profit rate of 33.3% to that 30,000 to show how much gross profit (it comes out to 10,000) that was deferred in 2012 that we can now recognize in 2012. The entry will be a debit to retained earnings and a credit to cost of goods sold.

Entry *G

Debit: Retained Earnings               10,000      ç 30,000 X 33.3%

Credit:              COGS                                  10,000

We can also calculate the deferred gross profit for 2013. The price of the inventory for 2013 that was transferred to Gibson was 200,000 at a cost of 140,000. Therefore, the gross profit rate is 30% (60,000 gross profits divided by 200,000 sales price). If we take 20% of that sales price of 200,000, we come up with 40,000 that remain unsold to outside parties.   We then take that 30% gross profit rate times the 40,000, and determine that 12,000 needs to be deferred. The deferral of the gross profit is reflected by debiting cost of goods sold and crediting inventory for the 12,000

Entry G

Debit:   COGS                                         12,000

Credit:        Inventory                                                  12,000

We now have to reflect the adjusted amounts of the parents beginning retained earnings. This is determined from the sum of the adjusted amortization of the customer list and the parent’s ownership percentage of the subsidiary’s beginning retained earnings. We determined the amortization to be 5,000 per year. The sub’s beginning retained earnings is 10,000 based on the calculation derived in Entry *G. So, we take the 10,000 plus the 5,000 to get 15,000 and then take 60% of that, which comes out to 9,000.

Entry *C

Debit: Retained Earnings, 1/1/13                              9,000

Credit:       Investment in Keller                                                      9,000

Just like in problem 32, we have to make an elimination entry for the stockholders equity accounts of the subsidiary company. Keller has common stock of 320,000, additional paid in capital of 90,000 and a beginning retained earnings of 610,000 (620,000 adjusted for the 10,000). Again, we have to use the beginning retained earnings because the ending retained earnings factors in net income and dividends, which we will make individual eliminations.    These equity accounts are against the investment in sub, but only based on the 60% ownership interest.

Entry S

Debit: Common Stock                                                 320,000

Debit: APIC                                                                      90,000

Debit: Retained Earnings, 1/1/13                             610,000     (not 620,000 because we already debit 10,000)

Credit: Investment in Keller                                                              612,000 (sum of debits times 60%)

Credit: Non-Controlling Interest                                                      408,000 (sum of debits times 40%)

We need to show on the books the value of the customer list at the beginning of 2013. Since the acquisition was at the beginning of 2012, there should have been a 5,000 amortization recognized in 2012. So, the true value of the customer list at the beginning of 2013 is 95,000 (100,000 less 5,000). This elimination is a debit to the customer list and a credit to investment in Keller for 60% and a credit to non-controlling interest for the other 40%.

Entry A

Debit: Customer List                                     95,000

Credit:      Investment in Keller                                                57,000 ç 95,000 times 60%

Credit:      Non-Controlling Interest                                        38,000   ç 95,000 times 40%

Now that we recorded the value as of beginning of 2013, we can recognize the 5,000 amortization for 2013.

Entry E

Debit:   Amortization Expense                     5,000

Credit:       Customer List                                                       5,000   

Just like in problem 32, we have to do an elimination entry for the income that Gibson shows from Keller. Gibson’s income statement shows 84,000 in income from Keller.

Entry I

Debit: Income of Keller                                   84,000

Credit:       Investment in Keller                                                84,000

   

Keller paid 60,000 in dividends of which 60% went to Gibson. Those have to be eliminated. The remaining 40% went to the non-controlling interest.

Entry D

Debit: Investment in Keller                            36,000    ç 60,000 dividend times 60%

Credit:        Dividends Paid                                               36,000

The last sentence of the third paragraph indicates that Gibson owes Keller 40,000. This would show up as an Accounts Receivable to Keller and a liability to Gibson. So, we have to eliminate that transaction.

Entry P

Debit:   Liabilities                                   40,000

Credit:       Accounts Receivable                            40,000

We have not yet eliminated the revenue line item for the 200,000 in sales to Gibson. We have made adjustments for the gross profit in entry G and *G though.

Entry TI

Debit: Sales                                    200,000

Credit:     COGS                                                  200,000

The last piece of information that we would want to know before completing the worksheet is the adjusted net income for 2013 that the non-controlling interest takes ownership. This is similar to what we did in part A of problem 32.

Keller Company Net Income                                       140,000

Adjustment for Amortization                                    (5,000)

2012 gross Profit recognized                                     10,000

2013 gross profit deferred                                        (12,000)

Adjusted net income 2013                                        133,000

Non-controlling interest                                             53,200   (133,000 times 40%)

This 53,200 will be shown on the worksheet as consolidated net income to non-controlling interest.

GIBSON AND KELLER Consolidation Worksheet Year Ending December 31, 2018 Accounts Gibson Keller Consolidation Entries Noncontrolling Consolidated Debit Credit Interest Totals Sales          (800,000)          (500,000) (TI)   200,000       (1,100,000) Cost of goods sold           500,000           300,000 (G)     12,000 (*G)   10,000           602,000 (TI) 200,000 Operating expenses           100,000             60,000 (E)       5,000           165,000 Income of Keller           (84,000) -0- (I)      84,000 -0- Separate company net income          (284,000)          (140,000) Consolidated net income          (333,000) To noncontrolling interest              (53,200)            53,200 To parent       (279,800) RE, 1/1/10—Gibson       (1,116,000) (*TL)   40,000       (1,067,000) (*C)      9,000 RE, 1/1/10—Keller          (620,000) (*G)    10,000 (S)    610,000 Net income (above)          (284,000)          (140,000)          (279,800) Dividends           115,000             60,000 (D)     36,000               24,000           115,000 Retained earnings, 12/31/10       (1,285,000)          (700,000)       (1,231,800) Cash           177,000             90,000           267,000 Accounts receivable           356,000           410,000 (P)     40,000           726,000 Inventory           440,000           320,000 (G)     12,000           748,000 Investment in Keller           726,000 (D)     36,000 (*C)      9,000 -0- (S)   612,000 (I)      84,000 (A)     57,000 Land           180,000           390,000 (*TL)   40,000           530,000 Buildings and equipment (net)           496,000           300,000           796,000 Customer List (A)     95,000 (E)       5,000            90,000 Total assets        2,375,000        1,510,000        3,157,000 Liabilities          (480,000)          (400,000) (P)     40,000          (840,000) Common stock          (610,000)          (320,000) (S)   320,000          (610,000) Additional paid-in capital            (90,000) (S)     90,000 Retained earnings, 12/31/10       (1,285,000)          (700,000)       (1,231,800) NCI in Keller, 1/1/10 (S)   408,000            (408,000) (A)     38,000           (38,000) NCI In Keller, 12/31/10                                             475,200          (475,200) Total Liabilities and Equity        (2,375,000)         (1,510,000)        3,157,000