***Please submit in an excel spreadsheet format. Thank you!

Multiple Stock Purchases Sarko Company had 300,000 shares of $10 par value common stock outstanding at all times, and retained earnings balances as indicated here: Pelzer Company acquired Sarko Company stock through open-market purchases as follows: Sarko Company declared no dividends during this period. The fair values of Sarko Company's assets and liabilities were approximately equal to their book values throughout this period (2010 through 2012). Pelzer Company uses the cost method. Required: A. Prepare a schedule to compare investment cost with the book value of equity acquired. B. Prepare elimination entries for the preparation of a consolidated statements workpaper on December 31, 2012