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.

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. Highpoint Middlebury Lowton Separate Company Income $425,000 340,000 250,000 Dividends Declared $200,000 150,000 75,000 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 Hequired 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 (Hint: The difference between these two amounts should be zero.) interests of the total entity