You are required to use the excel spreadsheet to finish the project. Your final product will be one excel file with separate worksheets for each individual question. It is required for you to use the basic excel formula such as =, =a1+a2, etc., so the numbers carry forward automated to the final answers. Prepare your excel spreadsheet in a professional way that is easily understandable

Acquisition date data: Doone acquired 80 percent of Akrons outstanding shares on January 1, 2013, in exchange for $369,000 in cash. The subsidiarys stockholders equity accounts totaled $353,000 and the noncontrolling interest had a fair value of $92,250 on that day. However, a building (with a ten-year remaining life) in Akrons accounting records was undervalued by $19,000. Doone assigned the rest of the excess fair value over book value to Akrons patented technology (five-year remaining life).

1. Prepare schedules for acquisition-date fair-value allocations and amortizations for year 2013 for Doones investment in Akron (Question1).

2. Akron reported net income from its own operations of $67,000 in 2013 and $83,000 in 2014. Akron declared dividends of $18,000 in 2013 and $22,000 in 2014. Doone applies the equity method for recording its investment in the Akron. Given the above acquisition date data and the additional information, show the calculation of ending balance of investment in Akron on Dec 31, 2014 and amount of equity in investee earnings for year 2014 for Doone (Question2)

3. Given the above information at acquisition date and in Question 2, Akron also sells inventory to Doone as follows: Year Cost to Akron Transfer Price to Doone Inventory Remaining at Year-End (at transfer price)

Year Cost To Akron Transfer Price to Doone Inventory Remaining at Year-End (at transfer price)

2013 $ 72,000 $130,000 $28,000

2014 $97,500 $150,000 $40,500

2015 $87,500 $175,000 $50,000

At December 31, 2015, Akron $19,000 for inventory acquired during the period. The following separate account balances are for these two companies for December 31, 2015. Note: Parentheses indicate a credit balance.

Doone Akron

Sales revenues and interest income: $ (868,000 ) $ (381,000 )

Cost of goods sold: 518,000 212,000

Expenses: 185,700 64,000

Equity in earnings of Akron (59,540 ) 0

Net income $ (223,840 ) $ (105,000 )

Retained earnings, 1/1/15 $ (494,000 ) $ (284,000 )

Net income (above) (223,840 ) (105,000 )

Dividends declared 132,000 22,000

Retained earnings, 12/31/15 $ (585,840 ) $ (367,000 )

Cash and receivables $ 149,000 $ 101,000

Inventory 270,000 151,000

Investment in Akron 456,000 0

Long-term Investment and PPE (net) 967,000 331,000

Total assets $ 1,842,000 $ 583,000

Liabilities $ (726,160 ) $ (37,000 )

Common stock (530,000 ) (179,000 )

Retained earnings, 12/31/15 (585,840 ) (367,000 )

Total liabilities and equity $ (1,842,000 ) $ (583,000 )

What amounts make up the $59,540 equity earnings of Akron account balance for 2015 and what amounts make up the $456,000 Investment in Akron account balance as of December 31, 2015? Show the detailed calculation (Question3)

Given the above data, prepare the complete consolidation worksheet to determine appropriate balances for external financial reporting as of December 31, 2015 (Question4)

4. Doone sold Akron a building on January 2, 2014. It had cost Doone $100,000 but had $90,000 in accumulated depreciation at the time of this transfer. The price was $25,000 in cash. At that time, the building had a 5-year remaining life. Prepare the necessary consolidation entries related to intra-entity sale of building for year 2014 and year 2015 (Question5)

5. On January1, 2014, Doone acquired on the open market bonds for $10,800 originally issued by Akron. This investment had an effective rate of 8%. The bonds had a face value of $10,000 and a cash interest rate of 9%. At the date of acquisition, these bonds were shown as liabilities by Akron with a book value of $8,400 (based on an effective rate of 11%). Prepare the necessary consolidation entries for these bonds on December 31, 2014 and December 31, 2015. You have to include the Akrons bond issue amortization schedule, Doone and Akrons individual financial records, side by side comparison of effects of intra-entity debt transaction, and consolidation entry for each year (Question6)