Chapter 01 - The Equity Method of Accounting for Investments – Hoyle, Schaefer, Doupnik, Advanced Accounting,
15e
1-33
© McGraw Hill LLC. All rights reserved. No reproduction or distribution without the prior written consent of McGraw Hill LLC.
Solutions to Develop Your Skills
Data Analysis Case 1: Determine Maximum Investment Price (less difficult)—see Connect
for the Excel file solution
Parts 1, 2 and 3
Growth rate in income 10%
Dividends $30,000
Cost $700,000 (given in problem)
Annual amortization $15,000
1st year Omega income $185,000
Percentage owned 40%
2024 2025 2026 2027 2028
Omega reported income $74,000 $81,400 $89,540 $98,494 $108,343
Amortization 15,000 15,000 15,000 15,000 15,000
Equity earnings $59,000 $66,400 $74,540 $83,494 $ 93,343
Beginning Balance $700,000 $747,000 $801,400 $863,940 $ 935,434
Equity earnings 59,000 66,400 74,540 83,494 93,343
Dividends (12,000) (12,000) (12,000) (12,000) (12,000)
Ending Balance $747,000 $801,400 $863,940 $935,434 $1,016,777
ROI 8.43% 8.89% 9.30% 9.66% 9.98%
Average 9.25%
Part 3
Growth rate in income 10%
Dividends $30,000
Cost $639,794 (Determined through Solver [may need to
be added] under Tools command)
Annual amortization $15,000
1
st
year Omega income $185,000
Percentage owned 40%
Omega reported income $74,000 $81,400 $89,540 $98,494 $108,343
Amortization 15,000 15,000 15,000 15,000 15,000
Equity earnings $59,000 $66,400 $74,540 $83,494 $ 93,343
Beginning Balance $639,794 $686,794 $741,194 $803,734 $875,228
Equity earnings 59,000 66,400 74,540 83,494 93,343
Dividends (12,000) (12,000) (12,000) (12,000) (12,000)
Ending Balance $686,794 $741,194 $803,734 $875,228 $956,571
ROI 9.22% 9.67% 10.06% 10.39% 10.67%
Average 10.00%