Please do in excel

Consolidated Workpaper, Partially Owned SubsidiarySubsequent Years On January 1, 2022, Perez Company purchased 90\% of the capital stock of Sanchez Company for $85,000. Sanchez Company had capital stock of $70,000 and retained earnings of $12,000 at that time. On December 31,2026, the trial balances of the two companies were: Any difference between book value and the value implied by the purchase price relates to goodwill. Required: A. What method is being used by Perez to account for its investment in Sanchez Company? How can you tell? B. Prepare a workpaper for the preparation of consolidated financial statements on 12/31/2026