Please post answers as formula that will work with excel.

Following are preacquisition financial balances for Padre Company and Sol Company as of December 31 . Also On December 31, Padre acquires Sol's outstanding stock by paying $412,000 in cash and issuing 10,200 shares of its own common stock with a fair value of $40 per share. Padre paid legal and accounting fees of $22,800 as well as $10,500 in stock issuance costs. Required: Note: Use the cells A2 to D32 from the above information to complete this question. Formulas for any items to be subtracted must return negative values. Determine the value that would be shown in Padre's consolidated financial statements for each of the accounts listed below