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

Man's search for meaning download - Binocular vision dysfunction questionnaire - Eco203 - How to address an appeal letter - Structure of a biography - Barbara ehrenreich serving in florida questions - Boss of the plains - Video tutor current carrying wire in magnetic field - Nursing student goals and objectives examples - Half life lab answer key - Rock paper scissors lizard spock java code - Analysis of spotty handed villainesses - How to find rtt in wireshark - Kepner and tregoe decision making model - Discussion: In My Opinion - +91-8890675453 vashikaran specialist IN Alwar - Hayman reese level riders - Unlocking the Power of the Cisco Smart Switch - Explain the principles of and barriers to effective interpersonal communications - Finance 370 - BBC Documentary "Billion Dollar Day" - Wk 2 Entrepreneurial Process - Mat 510 week 8 case study 2 - Community assessment windshield survey - Happy endings margaret atwood symbolism - Political science essay - for Essays Guru - How to calculate dynamic compliance - Research paper - Aluminum lithium alloys have been developed by the aircraft - Kitchen heaven case study - Long service leave provision calculation aasb - Monash exam period semester 2 - Ncopds - 15 to 20 slide powerpoint on article for Master in Nursing program - Austria hungary ultimatum to serbia document - Po box 1253 sutherland house crawley - Range tribune immersion heater instructions - Change management specialists often work __________. - Role and Scope Research 1 - Publishers of a magazine wish to determine what proportion - Frederick granger williams smith - A local group claims that the police issue - Assassin's creed freedom cry common sense media - Mcdonald's darling quarter haymarket nsw - Po9 1 it risk management framework - Week8 discussion - Breezair service code 02 - Excel crash course exam answers - Buddhism key stage 1 - Isidewith com political quiz - Why are bryophytes considered incompletely liberated from their ancestral aquatic habitat? - Behind the swoosh nike - IP2 - Swagelok hose and flexible tubing catalog ms 01 180 - Wee- 4 disscusion-833 - Co nh3 5 h2o cl3 - 8 PAGES - In conclusion in japanese - Barbara strang teaching centre - Multiple choice questions on mediation - Windshield survey nursing examples - Food safety standard 3.2 2 division 4.15 - Jeremy rifkin animal rights essay - The odd couple play monologue - Patrick corporation acquired 100 percent of o brien company - Colombo frozen yogurt case study solution - Elements of an ethical sampling plan in nursing - Manchester academic phrase bank - Moral choices 4th edition pdf - Circuit board fabricators inc - Pc 12 training manual - Qld teachers meritorious sick leave - Herbivores in the sahara desert - Strategic Planning Discussion1 - The assessment of the external and internal environments is called - Perri klass learning the language - News articles unethical business practices - ENTERPRISE ARCHITECTURE - Search and Seizure - Real application security oracle 12c - How to interpret vertical analysis of income statement - Responding - Excel lab 2 sales summary worksheet - Black board learn brunel - MC WK 7 - Qut academic penalty date 2021 - Three ways that energy is transferred in the atmosphere - Coles direct sourcing pvt ltd - Tracker cereal bars asda - Flinders street station ballroom renovation - Thin and fat clients - Cost accounting chapter 3 solutions - Management - MBA 6601 POWER POINT UNIT II - Wileyplus managerial accounting homework answers - Dirty john episode 1 reddit - Dan saracino abstract algebra pdf - Proposal Completion Challenges and review - Concrete encased duct bank design - GENERAL CHEMISTRY 104: EVALUATING THE EQUILIBRIUM CONSTANT FOR THE REACTION OF IRON (III) ION WITH THIOCYANATE ION - Command to check crashinfo on cisco router