ACT 470 Colorado State University Intercompany Transactions Worksheet

User Generated

ertvezq

Writing

ACT 470

Colorado State University

ACT

Question Description

I don’t understand this Accounting question and need help to study.

Intercompany Transactions

Assume that a parent company acquired 100% of a subsidiary on 1/1/X1. The purchase price was $175,000 in excess of the subsidiary's book value of net assets on acquisition date and the excess was assigned entirely to an unrecorded patent. The life of the patent is 10 years.
Assume the subsidiary sells inventory to the parent. The parent ultimately sells the inventory to outside customers. The following relates to the years X2 and X3:

Inventory SalesGP of unsold inventoryReceivable (Payable)
X3$103,300$29,441$41,320
X2$87,900$19,137$27,986

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

Submission Requirements:

ACT470_Mod04-Option01.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.

Unformatted Attachment Preview

ACT470-Module 4-Option 1 Parent Consolidation Entries Dr Subsidiary Income Statement: Sales Cost of goods sold 8,220,000 (5,754,000) 1,549,500 (929,700) Gross profit Equity income Operating expenses Net income 2,466,000 189,126 (1,561,800) 1,093,326 619,800 0 (402,870) 216,930 4,129,728 1,093,326 (251,465) 4,971,589 800,575 216,930 (28,201) 989,304 555,910 1,052,160 1,594,680 7,670,904 500,842 359,484 461,751 854,291 1,314,788 0 12,188,442 2,176,368 615,678 758,475 3,500,000 1,343,970 998,730 4,971,589 12,188,442 184,948 253,191 516,500 103,300 129,125 989,304 2,176,368 Statement of Retained Earnings: BOY retained earnings Net income Dividends EOY retained earnings Balance Sheet: Assets Cash Accounts receivable Inventory Building, net Patent Equity investment Liabilities & stockholders' equity Accounts payable Other current liabilities Long-term liabilities Common stock APIC Retained earnings 0 Consolidation Entries Cr Consolidated 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Explanation & Answer

Attached.

ACT470-Module 4-Option 1
Parent
Income Statement:
Sales
Cost of goods sold

8,220,000
(5,754,000)

Gross profit
Equity income
Operating expenses
Net income

2,466,000
189,126
(1,561,800)
1,093,326

Statement of Retained Earnings:
BOY retained earnings
Net income
Dividends
EOY retain...

GrnpureFrguTert (15069)
Purdue University

Similar Content

Related Tags