6-1 Final Project One Submission: Consolidation Workbook and Memo

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.PromptReview 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] 1

1. Calculate the balance of investment Posey has in the Stargell Stock account as of January 1, 20X7. [ACC-405-01]
2. Calculate the income that should be assigned to the noncontrolling interest in the 20X7 consolidated income statement. [ACC-405-01]
3. Calculate the total noncontrolling interest as of December 31, 20X6. [ACC-405-01]
4. 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]
5. Present all consolidation entries that would appear in a three-part consolidation worksheet as of December 31, 20X7. [ACC-405-02]
6. 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:

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

Milestones
In Module Four, you will submit an Excel worksheet. This milestone will have the completed calculations and consolidation entries for the requirements for this

Milestone One: Consolidation Calculations, Entries, and Worksheets 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.

   Milestone

One

Deliverable

Consolidation Calculations, Entries, and Worksheets
Final Project One: Consolidation Workbook and Memo

Deliverables Module Due

Four Six

Grading

Graded separately; Milestone One Rubric Graded separately; Final Project One Rubric

         2

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.