Complete the excel consolidating spreadsheet

Assignment Help Financial Accounting
Reference no: EM13953308

On January 1, 2014, Powers Company acquired 80% of the common stock of Sculley Company for $280,000. On this date Sculley had total owners' equity of $200,000 (common stock, other paid-in capital, and retained earnings of $10,000, $90,000, and $100,000 respectively). This is the only subsidiary of Powers. All book values of all identifiable assets and liabilities of Sculley were equal to their fair values except: Manufacturing equipment (depreciation expense goes to CGS) was undervalued by $45,000. The equipment has a remaining life of five years and straight-line depreciation is used. Patents worth 20,000 were not recorded. The excess to the patents is to be amortized over 20 years. On January 1, 2015, Powers held merchandise acquired from Sculley for $10,000. During 2015, Sculley sold merchandise to Powers for $50,000, $30,000 of which is still held by Powers on December 31, 2015. Sculley's usual gross profit on affiliated sales is 50%. As of December 31, 2015, Powers owed $10,000 to Scullery for merchandise purchased during 2015. On December 31, 2014, Powers sold an administrative building (depreciation expense goes to operating expense) to Sculley at a gain of $10,000. During 2015, the building was used by Sculley. Depreciation is being computed using the straight-line method, a five-year life, and no salvage value. Both companies have a calendar-year fiscal year. Assume that during 2014 and 2015, Powers has appropriately accounted for its investment in Sculley using the equity method. The balance in the equity investment account of Powers at December 31, 2014 was $298,000.

Note the following concerning the building sale:

The sale of the building is a downstream sale that occurred on the last day of 2014. Just like downstream sales of inventory, downstream sales of fixed assets do NOT impact the NCI portion of net income of the NCI balance in equity.

Complete the Excel consolidating spreadsheet for 2015 (the second year the subsidiary has been owned)

Reference no: EM13953308

Questions Cloud

Draw a similar strategic coherence map for wal-mart : The Porter (1996) Harvard Business Review article ("what is Strategy") provides a graphical description of Southwest Airlines' activity system showing coherence in its strategy. Draw a similar strategic coherence map for Wal-Mart
What is the probability that your sample of five bags : An error with the release valve has caused the setting on the mint release machine to "shift". Assume that the machine shift is filling the bags with a mean weight of 11.56 ounces and a standard deviation of 0.05 ounces
Find the term to replace the question mark : Find the term to replace the question mark in order to complete the series. 5, 9, 21, 37, 81, ?
Problem regarding the costs and expenses : For each cost, explain whether all of the cost or only a portion of the cost would appear as an expense on the income statement for the period in which the cost was incurred. If not all of the cost would appear on the income statement for that per..
Complete the excel consolidating spreadsheet : The sale of the building is a downstream sale that occurred on the last day Powers Company acquired 80% of the common stock of Sculley Company for $280,000. On this date Sculley had total owners' equity of $200,000 common stock
Problem regarding the materiality : Jane Erving, a newly hired accountant wanting to impress her boss, stayed late one night to ana- lyze the long-distance calls by area code and time of day placed. She determined the monthly cost for the previous 12 months by hour and area code cal..
Calculate separately for boys and girls confidence interval : The ages (in days) at time of death for samples of 11 girls and 16 boys who died of sudden infant death syndrome are shown in Table E4.22. Calculate separately for boys and girls the 95% confidence interval for the (population) mean of age (in day..
What is the probability that the card is red : A pair of dice is rolled once. Compute the probability that the sum is equal to each of the integers 2 through 12.
How many such pairs of letters are there in word corporate : How many such pairs of letters are there in the word 'CORPORATE', which have as many letters between them in the word as there are, in the English alphabet between the same letter sequence?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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