Parker Company acquires an 80% interest in Sargent Company for $300,000 in cash on January 1, 2015, when Sargent Company has the following balance sheet:

Assets Liabilities and Equity

Current Assets	$100,000	Current Liabilities	$50,000
Depreciable fixed assets (net)	200,000	Common Stock ($10 par)	100,000
		Retained Earnings	150,000
Total Assets	$300,000	Total Liabilities and Equity	$300,000

The excess of the price paid over book value is attributable to the fixed assets, which have a fair value of $250,000, and to goodwill. The fixed assets have a 10-year remaining life. Parker Company uses the simple equity method to record its investment in Sargent Company.

The following trial balances of the two companies are prepared on December 31, 2015:

Parker Sargent

Current Assets	10,000	130,000
Depreciable Fixed Assets	400,000	200,000
Accumulated Depreciation	(106,000)	(20,000)
Investment in Sargent Company	316,000
Current Liabilities	(60,000)	(40,000)
Common Stock ($10 par)	(300,000)	(100,000)
Retained Earnings, January 1, 2015	(200,000)	(150,000)
Sales	(150,000)	(100,000)
Expenses	110,000	75,000
Subsidiary Income	(20,000)
		5,000
Totals	0	0

Please prepare the following using this excel

1. Prepare Acquired COmpany's Balance Sheet Before Purchase

2. Determination and distribution of Excess Schedule

3. Account Adjusted

4. Amortization Schedules

5. Income Distribution Schedules

- Amortization Schedule Annual Amount Life Current Year Prior Years Account Adjusted Total Key - Accounts Subject to Amortization Total Amortizations Income Distribution Schedules Subsidiary Debit Credit Internally Generated Net Income - Amortizations Total NCI Share - Controlling Share - Parent Internally Generated Net Income - Controlling Share of Subsidiary Total Acquired Company's Balance Sheet Before Purchase Book Value Market Value Life Market Book Value Value 8,000 Life Liabilities Assets Cash Depreciable Fixed Assets Accumulated Depreciation Investement 102,000 400,000 130,000 320,000 Equity Common S Retained E 300,000 260,000 Goodwill Total Liabilities and Equity Total Assets 952,000 568,000 Determination and Distribution of Excess Schedule Company Value Parent Price NCI 375,000 300,000 75,000 100,000 Fair Value of Subsidiary Less Book Value of Interest Acquired Common Stock Paid in Excess Retained Earnings Total Equity Interest Acquired Book Value 150,000 250,000 250,000 80% 200,000 250,000 20% 50,000 Excess of Cost over Book Value 25,000 125,000 100,000 Worksheet Distribution Accounts Adjusted Total 0