Prepare a consolidated worksheet in Excel to arrive at a consolidated balance sh

Prepare a consolidated worksheet in Excel to arrive at a consolidated balance sheet totals as the acquisition .
Needs to be in Excel and just use the Equity method. I am having a hard time with that method. I have attached the problem and the begining of the balance sheet.