+1(316)4441378

+44-141-628-6690

Excel Accounting Work

  

Consolidation Entries and Worksheet

On January 1, 20X8, C Company acquired 90 percent of S Company’s voting stock, at underlying book value. The fair value of the noncontrolling interest was equal to 10 percent of the book value of S at that date. C uses the equity method in accounting for its ownership of S. On December 31, 20X8, the trial balances of the two companies are as follows (doc attached later)

  

Required: 

  1. Provide      all consolidating entries required as of December 31, 20X8 to prepare      consolidated financial statements.
  2. Prepare      a three-part consolidation worksheet as of December 31, 20X8.

Use Excel formulas to make or evidence each of your calculations of all dollar amounts. Do not enter any dollar amounts directly, unless it is unavoidable for obvious reasons. Use the tab function at the bottom of the Excel file to complete the assignment. 

Prepare and submit one Excel spreadsheet for this assignment. Use the following naming convention for your file: MyNameCTA2Option1.

Requirements:

  • Show      calculations for all questions.
  • Support      the writing portion of the assignment (if applicable) with credible      sources.
  • Use      terms, evidence, and concepts from class readings, including professional      business language.

Chapter 3 in Advanced Financial Accounting

Deloitte. (2018). A roadmap to consolidationIdentifying a controlling interest. Retrieved from https://www2.deloitte.com/us/en/pages/audit/articles/a-roadmap-to-consolidation-identifying-a-controlling-financial-interest.html

Jones, R. C. (2018, August). Common control entities and consolidation of variable interest entities. The CPA Journal. Retrieved from https://www.cpajournal.com/2018/08/15/common-control-entities-and-consolidation-of-variable-interest-entities/

Chapter 3 in Advanced Financial Accounting, PowerPoint presentation

Lange, C. D., & Fornaro, J. M. (2017). Consolidation of variable interest entities for private companies. CPA Journal, 87(2), 46-50.

PWC. (2015). A comprehensive guide to consolidation and equity method of accounting under U.S. GAAP. Retrieved from https://www.pwc.com/us/en/cfodirect/publications/accounting-guides/consolidation-framework-equity-method-accounting-vie-guide.html

PWC. (2016, January 19). In depth: New consolidation standardUpdated insights. Retrieved from http://www.pwc.com/us/en/cfodirect/publications/in-depth/new-consolidation-standard-fasb-guidance-adoption-updated-insights-us2015-08.html

Christensen, T., Cottrell, D., & Budd, C. (2019). Advanced financial accounting (12th ed.). New York, NY: McGraw-Hill.

 

You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.

 

Latest completed orders:

# topic title discipline academic level pages delivered
6
Writer's choice
Business
University
2
1 hour 32 min
7
Wise Approach to
Philosophy
College
2
2 hours 19 min
8
1980's and 1990
History
College
3
2 hours 20 min
9
pick the best topic
Finance
School
2
2 hours 27 min
10
finance for leisure
Finance
University
12
2 hours 36 min
[order_calculator]