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)
- Provide all consolidating entries required as of December 31, 20X8 to prepare consolidated financial statements.
- 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.