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)



  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.


  • 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.

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"