This guide is for ACCT 402 Week 5 Excel Spreadsheet Project Part 1, start to submission. Part 1 of the textbook's Computer Project: build the spreadsheet that illustrates consolidation under the parent's investment method.
ACCT 402 is Consolidations and Advanced Accounting Topics, 3 credit hours, in Liberty University's BS in Accounting. Canvas and the course guide file print the code as ACCT402; it is the same course.
| Course | ACCT 402 Consolidations and Advanced Accounting Topics |
|---|---|
| Module/Week | 5 |
| Points | 80 points |
| Length | Excel workbook (Part 1) |
| Sources | The textbook's Computer Project data |
| Faith integration | Not required by the guide |
| Format | Microsoft Excel |
What ACCT 402 Week 5 Excel Spreadsheet Project Part 1 asks for
You complete a 2-part Excel spreadsheet project, developing a spreadsheet that illustrates the consolidation process when the parent company applies the equity method, partial equity method or initial value method to account for its investment in a subsidiary, as presented in the textbook under "Computer Project." Part 1 is due in Module/Week 5 with Hoyle et al. chapter 3. Worth 80 points.
Where it fits in ACCT 402
In the published schedule, Excel Spreadsheet Project Part 1 is one of 6 graded written assignments in ACCT 402. It follows Week 5 Group Discussion Board Forum 3 and comes before Week 6 Excel Spreadsheet Project Part 2. The same week also has Group Discussion Board Forum 3, so plan the week's writing together.
How ACCT 402 Week 5 Excel Spreadsheet Project Part 1 is graded
Liberty grades Excel Spreadsheet Project Part 1 with the rubric attached to the assignment in Canvas, worth 80 points in the published guide. That is about 8% of the course's 1,010 points. Read the rubric first. Each row is a criterion, and the wording of the highest column is the closest thing you have to a model answer.
Course grades in ACCT 402 use Liberty's point scale: an A is 900 to 1010 points of the course total. Missing the length or source minimum usually costs points on several rows at once, which is why the checklist below starts with them.
Timing in the published guide: Each course module/week (except Module/Week 1) begins on Tuesday morning at 12:00 a.m. (ET) and ends on Monday night at 11:59 p.m. (ET). The final module/week ends at 11:59 p.m. (ET) on Friday. Check the due dates in your Canvas section, which govern.
The ACCT 402 Week 5 method, step by step
Set up the data before the write-up
Work through the Excel Spreadsheet Project Part 1 calculations or software steps first and save the output. The written part interprets those numbers, so they have to be right before you explain them.
Show the method
Name the method and the reason it fits. One or two sentences are enough, but they must be there.
Report the results plainly
Report each result with its value and what it measures. Tables and figures help when they are labeled and referred to in the text.
Interpret in the context of the question
Translate the numbers into a conclusion about the question. Say what decision they support and how confident you can be.
Name the limits
Name the assumptions and limits. A result with its limits stated reads as professional.
Submit the files the guide asks for
Submit every file requested and check that formulas, output and the write-up agree (Excel workbook, Part 1).
A structure for ACCT 402 Week 5 Excel Spreadsheet Project Part 1
Word targets are planning numbers for about 900 words of body text, set by the length in the guide; the rubric decides where to spend more.
| Section | What it must do | Target |
|---|---|---|
| Parent and subsidiary trial balances | From the project data. | ~220 words |
| Acquisition-date fair value allocation | Excess over book value and amortization. | ~270 words |
| Investment account by method | The parent's entries. | ~230 words |
| Checks | Balances that tie out. | ~180 words |
A topic angle that works
Put the acquisition-date allocation (fair value over book value, assigned to specific assets and goodwill) on its own schedule; every consolidation entry in Part 2 references it.
Model paragraph with notes
An original paragraph written by our desk to show the register that earns full rubric credit. It is study material: learn the moves, then write your own.
The parent paid $900,000 for all of the subsidiary when its book value was $700,000. The $200,000 excess is allocated $60,000 to undervalued equipment (amortized over 10 years) and $140,000 to goodwill, which is not amortized.1 The schedule computes the $6,000 annual amortization that both the equity method entries and the consolidation worksheet will use.
- Computes the excess.
- Allocates it.
- Sets up amortization.
Mistakes that cost points on ACCT 402 Week 5
- Amortizing goodwill.
- Typed numbers instead of formulas.
- An allocation that does not tie to the price.
Checklist before you submit
- Length: Excel workbook (Part 1)
- Sources: The textbook's Computer Project data
- Calculations checked and output saved
- Every table and figure referred to in the text
- Each rubric row read against the section that answers it
Questions students ask
What is in ACCT 402 Excel Part 1?
The first part of the textbook's Computer Project on consolidation under the parent's investment method.
How many points is ACCT 402 Week 5 Excel Spreadsheet Project Part 1 worth?
80 points in Liberty's published course guide for ACCT 402, out of a course total of 1,010 points (about 8% of the grade). The rubric attached to the assignment in Canvas shows how those points are divided.
Is ACCT 402 Week 5 the same in every section of ACCT 402?
This guide follows Liberty's published course guide for ACCT 402. Liberty notes that course content can change from term to term, so if your Canvas section shows different instructions, a different week or different points, follow Canvas and your instructor.
Want a tutor to look at your draft?
Send the instructions and what you have so far. A Liberty tutor replies with what to fix first, usually within the hour.