Please solve with excel formulas

Assume that the following balance sheets are stated at book value. Suppose that Meat Co$.$

purchases Loaf, Inc. The fair market value of Loaf's fixed assets is $$11,500$ versus the $$8,300$

book value shown. Meat pays $$18,400$ for Loaf and raises the needed funds through an

issue of long$-$term debt. Construct the postmerger balance sheet under the purchase

accounting method.

Input Area:

$($Use cells A$6$ to D$17$ from the given information to complete this question.$)$