Chapter 01 – The Equity Method of Accounting for Investments – Hoyle, Schaefer, Doupnik, 13e
1-33
Education.
Excel Assignment No. 2 (more difficult)—see textbook Website for the Excel file solution
Intergen’s ownership percentage of Ryan 40% Intra-entity Transfer Price = $1,025,000
Cell F4
Ryan’s Income Statement Intergen’s Income Statement
Sales $900,000 Sales $1,025,000
Intergen $1,000,000 21.00%
Two outside equity partners $300,000 26.25%
Difference -5.25%
Intergen’s ownership percentage of Ryan = 40% Intra-entity Transfer Price = 1,050,000
Ryan’s Income Statement Intergen’s Income Statement
Sales $900,000 Sales $1,050,000
Beginning inventory $ -0- Cost of goods sold $ 850,000
Purchases from Intergen $1,050,000 Gross profit $ 200,000
Inventory 25% Equity in Ryan‘s earnings $ 25,000*
Ending inventory $ 262,500 Net income $ 225,000
Cost of goods sold $787,500
Cell D20 to zero
by changing Cell
F4