Prepare a worksheet

Assignment Help Financial Accounting
Reference no: EM131144019

Write the solution of the problem and send the file in excel format with all detailed calculations and explanation.

The individual financial statements for Gibson Company and Keller Company for the year ending December 31. 2015. follow Gibson acquired a 60 percent interest in Keller on January 1. 2014. in exchange for various considerations totaling $750,000. At the acquisition date, the fair value of the noncontrolling interest was $500,000 and Keller's book value was $1,000,000. Keller had developed internally a customer list that was not recorded on its books but had an acquisition-date fair value of $250.000. This intangible asset is being amortized over 20 years.
Gibson sold Keller land with a book value of $75.000 on January 2. 2014. for $160,000. Keller still holds this land at the end of the current year.
Keller regularly transfers inventory to Gibson. In 2014. it shipped inventory costing $180,000 to Gibson at a price of $300,000. During 2015. intra-entity shipments totaled $350,000. although the original cost to Keller was only $245,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 $35,000 at the end of 2015.

 

Gibson
Company

Keller
Company

Sales

S       (950.000)

S     (650.000)

Cost of goods sold

650.000

450.000

Operating expenses

140.000

30.000

Equity in earnings of Keller Company

(102.000)

0

Net income

$       (262.000)

(170.000)

Retained earnings. 1/1/15

 

 

$(1.266.000)

$ (695,000)

Net income (above)

(262.000)

(170.000)

Dividends declared

145,000

45,000

Retained earnings. 12/31/15

$(1.383.000)

(820.000)

Cash

 

 

S        184.000

S        60.000

Accounts receivable

386.000

560,000

Inventory

540.000

470,000

Investment in Keller Company

966.000

0

Land

120.000

540,000

Buildings and equipment (net)

511.000

450.000

Total assets

$ 2,707,000

$ 2.080.000

Liabilities

 

 

$       (584.000)

(720.000)

Common stock

(740.000)

(470.000)

Additional paid4n capital

0

(70,000)

Retained earnings. 12/31/15

(1.383.000)

(820.000)

Total liabilities and equities

5(2,707.000)

$(2,080,000)

(Note: Parantheses indicate a credit balance)

a. Prepare a worksheet to consolidate the separate 2015 financial statements for Gibson and Keller (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.)

b. How would the consolidation entries in requirement (a) have differed if Gibson had sold a building with a $135,000 book value (cost of $290,000) to Keller for $250,000 instead of land as the problem reports? Assume that the building had a 10-year remaining life at the date of transfer (If no entry is required for a transactiont/event. select No journal entry required" in the first account field.)

Attachment:- Project.rar

Attachment:- Gibson---Keller--Sample-Worksheet.rar

Reference no: EM131144019

Questions Cloud

Build a flowchart to solve a simple payroll calculation : Build a flowchart to solve a simple payroll calculation. Find the amount of pay given, hours worked, and hourly rate. (The formula to calculate payroll is pay = hourly rate * hours worked.)
Write the given assignment question : He is seated behind the steering wheel, conscious and complaining of chest and abdominal pain. - How do you proceed? - What steps will you take to help?
Describe whether the potential population of interest : Develop two to three research questions that align with the area of focus and address what you hope to answer in this study. The questions need to be answerable and presented in list format, and they must appropriately represent the population/par..
Determine the maximum stress in the bar : A couple of moment M = 2 kN.m is to be applied to the end of a steel bar.
Prepare a worksheet : Prepare a worksheet to consolidate the separate 2015 financial statements for Gibson and Keller. - How would the consolidation entries in requirement have differed if Gibson had sold a building with a $135,000 book value.
What rms velocity will the drill have : What natural frequency must a hand drill have if its vibration must be limited to a minimum rms displacement of 10 μm and rms acceleration of 0.1 m/s2 ? What rms velocity will the drill have?
What is the purpose of your proposed antiharassment policy : Why is it important to have such a policy in place? If the basic purpose is to stop harassing behavior, why is that important? Why is harassment detrimental to an organization?
What issues of transference are displayed by the client : What issues of transference are displayed by the client? Explain in your own words. Did the consultant act ethically by allowing the client to be discharged? Discuss.
Select one of the disorders covered in the book : Select one of the disorders covered in the book (object agnosia, prosopagnosia, color agnosia, movement agnosia, or neglect) to research in more detail. Locate a research report or other scientific article about this disorder in the Walden Library..

Reviews

Write a Review

 

Financial Accounting Questions & Answers

  Identify decisions that managers like choi

Identify decisions that managers like Choi must make in applying depreciation methods.

  Calculating net cash flow from operating activities

Which one of the following below should be added to net income in calculating net cash flow from operating activities using the indirect method?

  What new rules were enacted under the sarbanes- oxley act

What new rules were enacted under the Sarbanes- Oxley Act to address unethical accounting practices? Tony Andres is studying for his next accounting examination.

  Vailable from records of hodges periodic inventory system

On November 21, 2013, a fire at Hodge Company’s warehouse caused severe damage to its entire inventory of Product Tex. Hodge estimates that all usable damaged goods can be sold for $18,000. The following information was available from the records of ..

  What is the clean price of the bond

You purchase a bond with an invoice price of $1,120. The bond has a coupon rate of 8.5 percent, semi annual coupons, and there are three months to the next coupon date. What is the clean price of the bond?

  What is the trick companys factory overhead

The Trick Company manufactures tacks. Costs for September were direct labor, $84,000; indirect labor, $36,700; direct materials, $55,900; taxes on raw materials and work in process, $4,800; factory utilities, $3,200; and insurance on plant and equipm..

  Detailed calculation of non-controlling interest balance

Detailed calculation of non-controlling interest balance and consolidation worksheet and consolidated financial statements and statements of changes in equity for the group and parent.

  Normative accounting theories

Find a newspaper article or web page report of an item of accounting news, i.e. it refers to a current event, consideration, comment or decision that has been published after June 2013

  Marginal costs calculations and the assumptions on capacity

marginal costs calculations and the assumptions on capacity and requirement of fixed expenses.company xy manufactures

  Monthly level of sales dollars

What is the monthly level of sales dollars needed to break even-What is the monthly level of sales dollars needed to earn an operating profit of $10,000 monthly.

  Compute correct amount of the physical inventory at november

Compute the correct amount of the physical inventory at November 30, 2007. Assume that the correct amount of the inventory at November 30, 2007 was $57,700. Compute the amount of the inventory at December 31, 2007.

  How much gain must the sa general partnership recognize

How much gain must the SA general partnership recognize on the transfer of these assets from Sue and Andrew?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd