​Assignment Option #1: Intercompany Transactions - Equipment

Anonymous
timer Asked: Oct 21st, 2018
account_balance_wallet $9.99

Question Description

Assignment Option #1: Intercompany Transactions - Equipment

Using the data in the Option 1 Spreadsheet (linked at the bottom of the page), perform the accounting required for the elimination of each independent intercompany transaction:

  1. Prepare the book calculations
  2. Perform the required journal entries

Requirements:

Complete all work on the spreadsheet attached to this assignment; it will be your only deliverable.

Clearly identify the requirements being addressed. Show all calculations within the cells of an Excel spreadsheet. This means that you must use formulas and links so that the thought process can be examined. Make good use of comments to convey your thought process as well. No hard coding of solutions. Submit a single MS Excel file for grading.

Unformatted Attachment Preview

Assume that Parent Company decides to sell Equipment (Cost = $10,000, Accumlated Deprecia Show the sale and the subsequent elimination entries by Parent C Parent Company Balance Sheet Assets, Liabilities & Equities Book Value Cash $1,500,000 AR $10,000 Inventory $200,000 Land $640,000 Equipment $400,000 Accumulated Depreciation -$150,000 Patent Total Assets AP Common Stock Additional Paid In Capital Retained Earnings Total Liabilities & Equity $0 $2,600,000 $100,000 $450,000 $600,000 $1,450,000 $2,600,000 Sub Company Balance Sheet Assets, Liabilities & Equities Book Value Cash $35,000 AR $10,000 Inventory $65,000 Land $40,000 PP&E $400,000 Accumulated Depreciation -$150,000 Patent $0 Total Assets $400,000 AP $100,000 Common Stock $100,000 Additional Paid In Capital $50,000 Retained Earnings $150,000 Total Liabilities & Equity $400,000 Assume that book Value = Fair Value pment (Cost = $10,000, Accumlated Depreciation = $1,000) to Sub for $20,000 cash. he subsequent elimination entries by Parent Company Sale by Parent Account DR CR DR CR DR CR Acquisition by Sub Account Elimination Entries by Parent Account ...
Purchase answer to see full attachment

Tutor Answer

TeacherHamilton
School: Duke University

Hi,Ple...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors