Question

In: Accounting

Highpoint owns a 95 percent majority voting interest in Middlebury. In turn, Middlebury owns an 80...

Highpoint owns a 95 percent majority voting interest in Middlebury. In turn, Middlebury owns an 80 percent majority voting interest in Lowton. In the current year, each firm reports the following income and dividends. Separate Company income figures do not include any investment or dividend income.

Separate Company Income   Dividends Declared

Highpoint      $425,000                    $200,000

Middlebury  340,000                 150,000 

Lowton          250,000              75,000

EXCEL - All calculations should be performed within the spreadsheet-you should enter only the numbers that are provided by the problem, and every other calculation should be done using an Excel formula.

In addition, in computing its income on a full accrual basis, Middlebury’s acquisition of Lowton necessitates excess acquisition-date fair value over book value amortizations of $25,000 per year. Similarly, Highpoint’s acquisition of Middlebury requires $20,000 of excess fair-value amortizations.

Required Prepare an Excel spreadsheet that computes the following:

1. Middlebury’s net income including its equity in Lowton earnings.

2. Highpoint’s net income including its equity in Middlebury’s total earnings.

3. Total entity net income for the three companies.

4. Net income attributable to the noncontrolling interests.

5. Difference between these elements: Highpoint’s net income. Total entity net income for the three companies less net income attributable to the noncontrolling interests of the total entity. (Hint: The difference between these two amounts should be zero.)

<3 <3 <3 who ever complete this thanks I will try to learn on this example for the future!!

Solutions

Expert Solution


Related Solutions

Cairns owns 80 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired...
Cairns owns 80 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired several years ago on the date that the subsidiary was formed. Consequently, no goodwill or other allocation was recorded in connection with the acquisition. Cairns uses the equity method in its internal records to account for its investment in Hamilton. On January 1, 2017, Hamilton sold $1,500,000 in 10-year bonds to the public at 105. The bonds had a cash interest rate of 8...
Cairns owns 80 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired...
Cairns owns 80 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired several years ago on the date that the subsidiary was formed. Consequently, no goodwill or other allocation was recorded in connection with the acquisition. Cairns uses the equity method in its internal records to account for its investment in Hamilton.      On January 1, 2011, Hamilton sold $1,500,000 in 10-year bonds to the public at 105. The bonds had a cash interest rate of 8...
Cairns owns 80 percent of the voting stock of Hamilton, Inc. The parent's interest was acquired...
Cairns owns 80 percent of the voting stock of Hamilton, Inc. The parent's interest was acquired several years ago on the date that the subsidiary was formed. Consequently, no goodwill or other allocation was recorded in connection with the acquisition. Cairns uses the equity method in its internal records to account for its investment in Hamilton. On January 1, 2011, Hamilton sold $1,300,000 in 10-year bonds to the public at 105. The bonds had a cash interest rate of 8...
Case Facts: Monterey Company owns a majority voting interest in Del Rey, Inc. On January 1,...
Case Facts: Monterey Company owns a majority voting interest in Del Rey, Inc. On January 1, 2017, Monterey issued $1,000,000 of 8 percent 10-year bonds at $935,823.42 to yield 9 percent. On January 1, 2019, Del Rey purchased all of these bonds in the open market at a price of $946,650.74 with an effective yield of 10 percent. 1.In the space provided, prepare amortization schedules for the Monterey Company bonds payable and the Investment in Monterey Bonds for Del Rey,...
Cairns owns 75 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired...
Cairns owns 75 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired several years ago on the date that the subsidiary was formed. Consequently, no goodwill or other allocation was recorded in connection with the acquisition. Cairns uses the equity method in its internal records to account for its investment in Hamilton. On January 1, 2014, Hamilton sold $2,600,000 in 10-year bonds to the public at 105. The bonds had a cash interest rate of 9...
Cairns owns 70 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired...
Cairns owns 70 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired several years ago on the date that the subsidiary was formed. Consequently, no goodwill or other allocation was recorded in connection with the acquisition. Cairns uses the equity method in its internal records to account for its investment in Hamilton. On January 1, 2014, Hamilton sold $2,500,000 in 10-year bonds to the public at 105. The bonds had a cash interest rate of 10...
Cairns owns 70 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired...
Cairns owns 70 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired several years ago on the date that the subsidiary was formed. Consequently, no goodwill or other allocation was recorded in connection with the acquisition. Cairns uses the equity method in its internal records to account for its investment in Hamilton. On January 1, 2014, Hamilton sold $1,900,000 in 10-year bonds to the public at 110. The bonds had a cash interest rate of 8...
Cairns owns 75 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired...
Cairns owns 75 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired several years ago on the date that the subsidiary was formed. Consequently, no goodwill or other allocation was recorded in connection with the acquisition. Cairns uses the equity method in its internal records to account for its investment in Hamilton. On January 1, 2014, Hamilton sold $2,600,000 in 10-year bonds to the public at 105. The bonds had a cash interest rate of 9...
Cairns owns 75 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired...
Cairns owns 75 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired several years ago on the date that the subsidiary was formed. Consequently, no goodwill or other allocation was recorded in connection with the acquisition. Cairns uses the equity method in its internal records to account for its investment in Hamilton. On January 1, 2014, Hamilton sold $2,200,000 in 10-year bonds to the public at 105. The bonds had a cash interest rate of 8...
Cairns owns 70 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired...
Cairns owns 70 percent of the voting stock of Hamilton, Inc. The parent’s interest was acquired several years ago on the date that the subsidiary was formed. Consequently, no goodwill or other allocation was recorded in connection with the acquisition. Cairns uses the equity method in its internal records to account for its investment in Hamilton. On January 1, 2014, Hamilton sold $1,100,000 in 10-year bonds to the public at 110. The bonds had a cash interest rate of 8...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT