Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

Part 2: Problem Solving – Consolidated Financials

Assume that on 1/1/X0, a parent company acquires a 70% interest in its subsidiary for a price at $480,000 over book value. The excess is assigned as follows:

Asset Fair Value Useful Life
Patent $320,000 8 years
Goodwill 160,000 Indefinite

70% of the goodwill is allocated to the parent.

Included in the attached Excel spreadsheet are the pre-consolidation financial statements for both the parent and the subsidiary.

Submission Requirements:

Using the ACT470_Mod08-Portfolio_Option01.xlsx Excel spreadsheet in the Module 8 folder:

  • Prepare the consolidated financial statements at 12/31/X6 by placing the appropriate entries in their respective debit/credit column cells.
  • Indicate, in the blank column cell to the left of the debit and credit column cells if the entry is a [C], [E], [A], [D] or [I]entry.
  • Use Excel formulas to derive the Consolidated column amounts and totals.
    • Using the “Home” key in Excel, go to the “Styles” area and highlight the [C], [E], [A], [D] or [I]entry cells in different shades.

"Get 15%discount on your first 3 orderswith us"
Use the following coupon
"FIRST15"

testimonials icon
Using a company of your choice, determine the strategic business goals. Develop an IT strategy that aligns to the business goals. You can use the b...
testimonials icon
Create a 15- to 20-slide Microsoft® PowerPoint® presentation on the interaction and influence among leadership tactics according to the following...
testimonials icon
·  This assignment helps you develop the skills to master the following course competencies:Apply critical thinking to...
testimonials icon
please find the attached documents on guidelines for the asignment.Regards,Prathik,...
testimonials icon
Dependent variable-time to remission of colorectal cancer. Independent variables – three levels of t...
testimonials icon
1. Review the majorfederal lawsrelated to Human Resources Management onpage 359of your textbook. What, in your opinion,...
testimonials icon
In Milestone Three, you will submit the company and key personnel, which includes your explanation of why your organization is well positioned to carr...
testimonials icon
Is screen time advantageous or harmful for kids below three years old? Cite medical references/studies in your answer. Whichever your...
testimonials icon
In vitro Fertilization Powerpoint Presentation- To be presented on BB collaborate by Students The ethical issues presentation will address an eth...
testimonials icon
Amatea (2013) suggests that socioeconomic status, cultural group membership, and family structure do not determine a child’s academic success or...

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
$65
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price
$65