Reference no: EM132636784

You have been placed on a confidential team. The company you work for, Stripe, Inc., is planning an acquisition and has identified a specific company as the target. The acquisition is expected to expand Stripe's existing markets in the U.S. and internationally. The target company (we'll call it RedCo) has a complimentary product line that will also expand Stripe's markets.

The CFO (Pat) hands you RedCo's most recent statement of financial position. Pat supplies the following information.

• Stripe expects to pay $3.4 billion in cash to acquire all of RedCo's outstanding common stock, a premium of nearly 100% over RedCo's current market value.
• Pat asks you to prepare a pro forma statement of financial position for RedCo immediately following acquisition. You should give your best estimates, and specifically identify the amount of goodwill that will result.
• Pat notes that the RedCo has about $1.8 billion of intangible assets (in addition to goodwill from a previous acquisition). The acquisition team has evaluated the intangibles and believe the value is actually about $2.6 billion. RedCo has almost $1 billion of long-term debt, all of which is at floating interest rates, currently at the market rate of 3.5%.
• Pat wishes there was more information to guide you, but there isn't. Since this potential acquisition has not been announced, the company must be careful to not reveal its intentions, so seeking more information is not possible.
• A glance at the income statement (which is not provided here) shows gross profit at about 35% of sales.

Pat concludes: "Good luck, I know you'll do great job and really help us make a decision." Additional background on the company reveals the following.

• RedCo a packaged food company that develops, manufactures, markets, sells, and distributes fresh sweet baked goods in the United States. It offers a range of snack cakes, donuts, sweet rolls, breakfast pastries, snack pies, and related products. The company operates in two segments, Sweet Baked Goods and In-Store Bakery. The Sweet Baked Goods segment offers fresh and frozen sweet baked goods and bread products under a variety of brands, as well as store branded products. The In-Store Bakery segment primarily provides branded eclairs, madeleines, brownies, and iced cookies in the bakery section of grocery and club stores. The company was founded in 1919 and is based in Lincoln, Nebraska.

REQUIRED:

Question 1: Use Excel (or another spreadsheet, must be a spreadsheet) that shows the starting statement of financial position, adjustments you believe should be made, and the adjusted statement of financial position immediately following the proposed acquisition. Make the final document something you would be proud to give to a CFO.

One additional requirement. The purchase price could change, so you must create the spreadsheet so that the purchase price can be easily changed, adjusting statement of financial position. The most recent statement of financial position for

REDCO

Statement of Financial Position

As of a recent date dollars in millions

Cash $ 285

Accounts receivable, net 105

Inventory (FIFO)

Ingredients 21

Finished goods 27

Property, Plant & Equipment

Land 2

Building 52

Right of use assets 24

Machinery & Equipment 209

Less, accumulated depreciation (50)

Goodwill 536

Intangible assets, net 1,853

Other noncurrent assets 13

Total Assets $3,077

Current portion of long-term debt $ 12

Accounts payable 69

Accrued liabilities 8

Other current liabilities 2

Long-term debt 975

Deferred income tax liabilities 256

Common stock 1

Additional paid-in capital 649

Retained earnings 1,105

Total Liabilities and Equity $3,077