ACT 470 Charleston Southern University Intercompany Transactions Excel Worksheet

Get perfect grades by consistently using Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20

Order a Similar Paper Order a Different Paper

Option #2: Intercompany Transactions

Assume a parent company acquired 100% of a subsidiary on 1/1/X1 at a purchase price that was $300,000 in excess of the subsidiary’s book value.  Of that excess, $200,000 was assigned to an unrecorded patent that is being amortized over 10 years.  The remaining $100,000 was assigned to goodwill.  In the year X2, the subsidiary sold land to the parent for $100,000.   The land was reported on the balance sheet of the subsidiary for $70,000 at the date of sale.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

The financial statements for the parent and subsidiary for the year ended 12/31/X3 are attached in the Excel spreadsheet.

Submission Requirements:

Using the ACT470_Mod04-Option02.xlsx Excel spreadsheet in the Module 4 folder:

  • Prepare the consolidated financial statements at 12/31/X3 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.

We offer the best essay writing services to students who value great quality at a fair price. Let us exceed your expectations if you need help with this or a different assignment. Get your paper completed by a writing expert today. Nice to meet you! Want 15% OFF your first order? Use Promo Code: FIRST15. Place your order in a few easy steps. It will take you less than 5 minutes. Click one of the buttons below.

Order a Similar Paper Order a Different Paper