PLEASE SOLVE IN EXCEL!!! THANK YOU SO MCUH!

Interim Purchase, Cost Method LO 6 Punca Company purchased 85% of the common stock of Surrano Company on July 1 , 2022 , for a cash payment of $590,000. December 31,2022 , trial balances for Punca and Surrano were: Surrano Company declared a $50,000 cash dividend on December 20, 2022, payable on January 10, 2023, to stockholders of record on December 31,2022 . Punca Company recognized the dividend on its declaration date. Any difference between book value and the value implied by the purchase price relates to subsidiary land, included in property and equipment. Income is earned evenly throughout the year. Required: Prepare a consolidated statements workpaper at December 31, 2022