Roku Sold to Fox for $22 Billion — How to Track a M&A Buyout in Your Google Sheets Portfolio

The Deal at a Glance

The companies framed the transaction as sitting “at the intersection of two of the most important forces reshaping video consumption” — the continued shift of audiences to streaming and the enduring demand for live sports and news. That story makes sense on a slide. In the market, the immediate reaction told a different one: investors in both companies wanted more cash and less Fox paper.

Why the Stock Reaction Is the Story

When a target's stock falls on a buyout announcement, the deal is almost always under-priced, structured oddly, or both. In Roku's case the issue is structure. A large equity component means the per-share price Roku holders will ultimately receive depends on what Fox shares are worth at the close — and Fox just printed a record selloff, so the math is moving against Roku shareholders in real time.

Fox holders have their own grievance. Issuing equity to fund a streaming acquisition dilutes them, and the streaming business historically runs at lower margins than Fox's linear TV and sports assets. So you end up with a deal that is bad for Fox shareholders on the day of the announcement and potentially bad for Roku shareholders on the day of the close, depending on where the Fox stock lands. That is a textbook setup for a messy merger arbitrage trade.

There is also a strategic question that the market will be watching closely: does Roku, now owned by a content company, start to favor Fox programming on its streaming platform? The deal announcement hinted at the question but did not answer it. Watch for it in the proxy materials and in the language of the new carriage agreements.

How to Track a Pending Buyout in Your Spreadsheet

A pending acquisition is one of the most awkward positions to track. Your ROKU shares are still on your brokerage statement, but their value is no longer set by the market — it is set by the deal terms. The cost basis does not change, the ticker does not change, and your brokerage will keep reporting the position the same way it always has until the deal closes. That is exactly the kind of situation where a Google Sheets model beats a brokerage app, because you can mix deal mechanics with live data.

With InvestSheet, your ROKU position keeps updating while the deal is pending, and the formulas stay useful right through to close:

The Day of Close: Splitting Cash and Stock

On the day the deal closes, your brokerage will (1) deliver cash for the cash portion, (2) credit you with new Fox shares for the stock portion, and (3) close out the ROKU position. That is two new lines in your sheet and one closed line — and the work happens automatically if your data is wired in. The tax event is the cash plus the fair-market value of the Fox shares on the close date, measured against your ROKU cost basis.

A spreadsheet model lets you compare three numbers on close day: the cash you received, the value of the Fox shares at issue, and the cost basis you carried in. The difference is your realized gain or loss. The same sheet that shows your ROKU position will show your new FOX position a few minutes later — no rebuilding required.

The other thing to watch after close is your asset allocation. Suddenly having Fox shares you did not pick is a real allocation change, especially in a market where Fox sold off to fund the deal. Use the close as a forcing function to re-check your sector weights and rebalance if needed.

M&A Is Quietly the Hardest Thing to Track

Most portfolio tools are designed for the steady state: you own X shares of Y, the price ticks, the value changes, and you go about your day. Acquisitions break that model. A pending deal changes the meaning of every field on the page — price is no longer the market, position size may not be the final position size, and the ticker may not survive to close. The right answer is a system that can carry a position through the announcement, the regulatory review, the vote, the close, and the after-market position without losing the cost basis or the history.

That is what a Google Sheets portfolio with InvestSheet is built for. Whether the headline is the largest IPO in history, a $22 billion streaming acquisition, or a quiet spin-off in your retirement account, the workflow is the same: keep the spreadsheet as your source of truth and let the live data flow in. ROKU is the headline today; the next deal is already in someone's pipeline.

Frequently Asked Questions