Clearly identify the requirements being addressed show all

Question

Perform the accounting required for the elimination of each independent intercompany transaction:

Prepare the book calculations

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.

Review the grading rubric, which can be accessed from the Course Information page, to understand how you will be graded on this assignment.

Reach out to your instructor if you have questions about the assignment.
Assume that Parent Company decides to sell Equipment (Cost = $10,000, Accumulated Depreciation = $1,000) to Sub for $20,000 cash. Show the sale and the subsequent elimination entries by Parent Company.

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	$0
Total Assets	$2,600,000
AP	$100,000
Common Stock	$450,000
Additional Paid In Capital	$600,000
Retained Earnings	$1,450,000
Total Liabilities & Equity	$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

Sale By Parent
Account	DR	CR

 

Acquisition by Sub
Account	DR	CR

 

Elimination Entries by Parent
Account	DR	CR