Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Consolidation of less than wholly owned subsidiaries solutions

04/12/2021 Client: muhammad11 Deadline: 2 Day

ACC 405 Final Project One Guidelines and Rubric

Overview

The first final project for this course is to prepare computations, consolidation entries, and a consolidation worksheet in an Excel worksheet. This worksheet focuses on the consolidation of the parent company and a less-than-wholly-owned subsidiary with differential, intercompany transfers and indebtedness. Additionally, you will create a memo outlining the unique calculations required on the consolidation worksheet and on the statement of cash flows if Posey also obtains an international subsidiary with non-US$ functioning currency. The final product represents an authentic demonstration of competency because accounting professionals are often asked to work within complex or unique business situations. Your response will rely heavily on using accounting standards to create reports, as well as considering any outstanding factors that could affect the report. Final Project One has one milestone, which will be submitted in Module Four to scaffold learning and ensure quality final submissions. Final Project One will be submitted in Module Six. In this assignment, you will demonstrate your mastery of the following course competencies:

 ACC-405-01: Analyze economic activity of complex or unique business situations

 ACC-405-02: Use accounting standards to create various financial reports intended for a variety of stakeholders.

Prompt

Review the Project One Scenario document. Then address the critical elements listed below. Most of the critical elements align with a particular course outcome (shown in brackets).

I. Excel Workbook: In this section you will prepare computations, consolidation entries, and a consolidation worksheet for the preparation of consolidated financial statements for 20X7. Do not round your intermediate calculations. Round your final answer to the nearest whole dollar. If no entry is required for a transaction/event, select “No journal entry required” in the first account field. In regard to the three-part worksheet for the preparation of consolidated financial statements, values in the first two columns (the “parent” and “subsidiary” balances) that are to be deducted should be indicated with a minus sign, while all values in the “Consolidation Entries” columns should be entered as positive values. For accounts where multiple adjusting 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.

A. Calculate the amount of the goodwill as of January 1, 20X7. [ACC-405-01]

https://learn.snhu.edu/d2l/lor/viewer/view.d2l?ou=6606&loIdentId=22961
https://learn.snhu.edu/d2l/lor/viewer/view.d2l?ou=6606&loIdentId=22962
2

B. Calculate the balance of investment Posey has in the Stargell Stock account as of January 1, 20X7. [ACC-405-01] C. Calculate the income that should be assigned to the noncontrolling interest in the 20X7 consolidated income statement. [ACC-405-01] D. Calculate the total noncontrolling interest as of December 31, 20X6. [ACC-405-01] E. Calculate the gain or loss on the constructive retirement of Stargell’s bonds that should appear in the 20X7 consolidated income statement.

[ACC-405-01] F. Present all consolidation entries that would appear in a three-part consolidation worksheet as of December 31, 20X7. [ACC-405-02] G. Prepare and complete a three-part worksheet for the preparation of consolidated financial statements for 20X7. [ACC-405-02]

II. Memo: Assume Posey were to obtain an international subsidiary with non-US$ functioning currency. Prepare a short memo that addresses the following critical elements:

A. Outline the unique calculations required to complete the consolidation worksheet. [ACC-405-02] B. Outline the unique calculations required on the statement of cash flows. [ACC-405-02]

Milestones

Milestone One: Consolidation Calculations, Entries, and Worksheets In Module Four, you will submit an Excel worksheet. This milestone will have the completed calculations and consolidation entries for the requirements for this project. This milestone will be graded with the Milestone One Rubric. Final Submission: Consolidation Workbook and Memo In Module Six, you will submit Final Project One. It should be a complete, polished artifact containing all of the critical elements of the final product. It should reflect the incorporation of feedback gained throughout the course. In addition to revising your milestone work, make sure that you include Section II: Memo, which was not included in the milestone. This submission will be graded with the Final Project One Rubric.

Deliverables

Milestone Deliverable Module Due Grading

One Consolidation Calculations, Entries, and Worksheets

Four Graded separately; Milestone One Rubric

Final Project One: Consolidation Workbook and Memo

Six Graded separately; Final Project One Rubric

3

Final Project One Rubric

Guidelines for Submission: Your Excel workbook must be completed thoroughly. The memo should follow these guidelines: 1–2 pages in length, double spaced, 12-point Times New Roman font, one-inch margins, and citations in APA style.

Critical Elements Exemplary Proficient Needs Improvement Not Evident Value

Excel Workbook: Goodwill [ACC-405-01]

Accurately calculates the amount of goodwill as of January 1, 20X7 (100%)

Calculates the amount of goodwill but does not consider the date of January 1, 20X7, or response contains errors or is illogical (70%)

Does not calculate the amount of goodwill as of January 1, 20X7 (0%)

9.50

Excel Workbook: Balance of Investment [ACC-405-01]

Accurately calculates the balance of investment as of January 1, 20X7 (100%)

Calculates the balance of investment but does not consider the date of January 20X7, or response contains errors or is illogical (70%)

Does not calculate the balance of investment as of January 1, 20X7 (0%)

9.50

Excel Workbook: Assigned Income

[ACC-405-01]

Accurately calculates the income assigned to noncontrolling interest with the 20X7 consolidated income statement (100%)

Calculates the income assigned to noncontrolling interest but does not consider the year of 20X7, or response contains errors or is illogical (70%)

Does not calculate the income assigned to noncontrolling interest with the 20X7 consolidated income statement (0%)

9.50

Excel Workbook: Noncontrolling Interest

[ACC-405-01]

Accurately calculates the total noncontrolling interest as of December 1, 20X6 (100%)

Calculates the total noncontrolling interest but does not consider the date of December 1, 20X6, or response contains errors or is illogical (70%)

Does not calculate the total noncontrolling interest (0%)

9.50

Excel Workbook: Gain or Loss

[ACC-405-01]

Accurately calculates the gain or loss on the constructive retirement of Stargell’s bonds on the 20X7 consolidated income statement (100%)

Calculates the gain or loss on the constructive retirement of Stargell’s bonds but does not consider the 20X7 statement, or answer contains errors or is illogical (70%)

Does not calculate the gain or loss on the constructive retirement of Stargell’s bonds (0%)

9.50

4

Critical Elements Exemplary Proficient Needs Improvement Not Evident Value

Excel Workbook: Three- Part Consolidation Entries

[ACC-405-02]

Clearly and thoughtfully presents all consolidation entries that would appear in a three-part consolidation worksheet as of December 31, 20X7 (100%)

Presents consolidation entries but is missing information that would appear in a three-part consolidation worksheet, or does not consider the date of December 31, 20X7 (70%)

Does not present consolidation entries that would appear in a three-part consolidation worksheet (0%)

11.88

Excel Workbook: Three- Part Worksheet

[ACC-405-02]

Prepares and completes a three-part worksheet for the preparation of consolidated financial statements for 20X7 (100%)

Prepares and completes a three-part worksheet, but finished work contains inaccuracies (70%)

Does not prepare or complete a three-part worksheet (0%)

11.88

Memo: Unique Calculations for

Consolidation Worksheet [ACC-405-02]

Meets “Proficient” criteria and uses industry-specific language to establish expertise (100%)

Outlines the unique calculations required to complete the consolidation worksheet (85%)

Includes some calculations but not all required calculations (55%)

Does not outline the unique calculations required to complete the consolidation worksheet (0%)

11.88

Memo: Unique Calculations For

Acquisition [ACC-405-02]

Meets “Proficient” criteria and demonstrates a complex grasp of the unique calculations required (100%)

Outlines the unique calculations required on the statement of cash flows (85%)

Outlines some but not all calculations required on the statement of cash flows (55%)

Does not outline the unique calculations required on the statement of cash flows (0%)

11.88

Articulation of Response Submission is free of errors related to citations, grammar, spelling, syntax, and organization and is presented in a professional and easy to read format (100%)

Submission has no major errors related to citations, grammar, spelling, syntax, or organization (85%)

Submission has major errors related to citations, grammar, spelling, syntax, or organization that negatively impact readability and articulation of main ideas (55%)

Submission has critical errors related to citations, grammar, spelling, syntax, or organization that prevent understanding of ideas (0%)

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Solutions Store
Assignment Hub
Ideas & Innovations
Essay & Assignment Help
Math Specialist
Smart Accountants
Writer Writer Name Offer Chat
Solutions Store

ONLINE

Solutions Store

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$42 Chat With Writer
Assignment Hub

ONLINE

Assignment Hub

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$16 Chat With Writer
Ideas & Innovations

ONLINE

Ideas & Innovations

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$45 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I have worked on wide variety of research papers including; Analytical research paper, Argumentative research paper, Interpretative research, experimental research etc.

$19 Chat With Writer
Math Specialist

ONLINE

Math Specialist

As an experienced writer, I have extensive experience in business writing, report writing, business profile writing, writing business reports and business plans for my clients.

$18 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

I have assisted scholars, business persons, startups, entrepreneurs, marketers, managers etc in their, pitches, presentations, market research, business plans etc.

$33 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Sustainability Initiative Part 6 - Broad lane leisure alcester - Microsoft Power Point Assignments 3 - Emerging Threats A1 - Mask you live in discussion questions - Worn or bald tires quizlet - Medibank private stolen card - Bds monitored radio stations - 4775 south freeway at felix fort worth texas 76115 - Challenges of consecrated life today ppt - A0 size in mm - Nandalala navaneetha chora lyrics - Importance of good documentation - Revising Unit 2 Assignment - Piece of land surrounded by water on three sides - 48 bus timetable newcastle - Cherry pink and apple blossom white musical ideas - Enron code of ethics pdf - Interview questions BAES - Zeus and the frog king quill answers - Group work self evaluation - Financial Statement Analysis - Mitsubishi e1012 programming manual - How to cite hbr case study - Emirates airlines strategic objectives - A different species of cockroach has weights - 4.9 newtons to mass - Trial of t hall - Yahoo business model case study - Explain why disorders caused by dominant alleles on - Need answer for Discussion question 300 words each with 2 peer responses. - Respond to 2 Colleagues Assignment post Wk4 1-2 paragraphs each - Distorted evidence definition - Business and Society.03 - Omnibus mexicanos dallas tx jefferson - Week 1 - Mathoverflow trap rslogix 500 - Www william shakespeare info bubonic black plague elizabethan era htm - +971561686603 Abortion pills in Dubai/Abu Dhabi-mifepristone & misoprostol in DUBAI - The media coverage of Brexit was biased and misleading - Nicholas bowen oil city - What best practices in practice issues does a business or company face today? Explain. - Criminal Justice/discussion - Which itil process uses mean time between failures mtbf - According to real business cycle theory - A callable bond pays annual interest of - What does isol stand for - Lickable nail polish - Access cost management data to determine a make or buy decision - Charlton college of business - David h freedman credentials - April fools day poem by kenn nesbitt - The possessive investment in whiteness sparknotes - Sifting property of dirac delta function - Arthur miller death of a salesman sparknotes - No reserve no retreat no regrets tattoo - Trends in Social Class Today - How to become a clinical coder in australia - Describe the role of three external services during an emergency - Ways to celebrate naidoc week - Ezbox sports eastwood - Modern real estate practice in pennsylvania 13th edition pdf - Siegler deloache & eisenberg 2014 - Adirondack white pine cabins - Blank uk driving licence template - Waves word search answers - The Systems Development Life Cycle (SDLC) - Who is clarissa's father in reign - A doll's house themes - Kg m3 to kn m3 - A balloon rubbed against denim gains - Bared to you excerpt chapter 9 - Chemistry of benzene electrophilic aromatic substitution - Word chapter 3 simulation training - Gartner penetration testing magic quadrant - Myitlab answers excel chapter 2 - Moses jesus and muhammad similarities - Thank you for not believing in me hoodie yellow - Cigweld 200 ac dc - Demand for Labor and Minimum Wage - Disaffected democrats beliefs - Is no2- polar or nonpolar - Digestive system animation game - Grandma's experiences leave a mark on your genes - Introduction of distributed database system - Sailing the sea of osint in the information age - Computer Science, Disaster Recovery Plan: Types of Testing - Five star music ringwood - St john the baptist margate - Vce religion and society - Week 2 course project proposal - We are all alike we are all different lesson plans - Cu boulder summer storage - Critique Research Assignment. Research of nursing - Module six wellness plan - Marisa es la más inteligente (the most intelligent) de todas. - Library management system requirements - Are toxins involved in set point theory - Fences play full text - Poole hospital mri department