9. Scroll down to Balance Sheet Adjustments at Closing and enter the June 30, 2000 balance sheet data from Exhibit A from Problem 13.4 on the Cap & Seal column.

A number of adjustments, such as the use of available cash to fund the transaction, will already appear on the adjustment columns for Cap & Seal, but you may need to make further adjustments as appropriate. The far-right column contains the closing balance sheet that is the start of the pro-forma projections.