LOI Comparison Worksheet: How to Evaluate Competing Offers

An LOI comparison worksheet gives founders a disciplined way to evaluate competing offers by looking beyond headline price and comparing structure, certainty, control, timing, and post-close obligations side by side. When multiple letters of intent arrive, the strongest offer is rarely the one with the biggest number at the top. It is the one that delivers the best combination of cash at close, manageable risk, realistic earnouts, acceptable legal terms, and alignment with your goals.

That matters because negotiation and deal structuring shape what you actually keep, how long you stay involved, and whether the deal closes at all. In lower middle-market M&A, two offers with the same valuation can produce radically different outcomes after working capital adjustments, escrows, rollover equity, employment terms, tax treatment, and indemnification exposure. I have seen founders focus on purchase price, only to realize late in diligence that a “better” bid carried a long exclusivity period, aggressive reps and warranties, and an earnout they were unlikely to hit.

This article is the hub for negotiation and deal structuring aids inside the broader tools, checklists, and resources category. It explains how to use an LOI comparison worksheet, what criteria to score, how to weigh tradeoffs between strategic and financial buyers, and how to create a repeatable decision process before you grant exclusivity. If you are preparing to sell, this framework belongs next to your data room, valuation work, and exit planning process.

What an LOI comparison worksheet should accomplish

An LOI comparison worksheet is not just a spreadsheet. It is a decision framework that translates competing offers into comparable categories. Its job is to remove emotion, surface hidden risk, and help founders negotiate from leverage instead of reacting to pressure.

At minimum, the worksheet should compare valuation, cash at close, contingent consideration, assumed liabilities, working capital expectations, escrow terms, rollover equity, tax implications, required employment terms, restrictive covenants, diligence timeline, financing risk, and cultural fit. It should also force a simple question: if two buyers both say your company is worth $20 million, which one gives you the highest probability of closing on acceptable terms?

That last phrase matters. Probability of close is often undervalued. A strategic buyer with a fully funded balance sheet and a history of acquisitions may be less risky than a private buyer relying on third-party debt approval. Likewise, a private equity group offering more total value may still be less attractive if the deal depends on a heavily back-ended earnout and a broad net working capital peg that will reduce proceeds at closing.

The core categories every worksheet should include

The best LOI comparison worksheets use consistent categories so founders can compare apples to apples. Start with the economic terms. These include enterprise value, equity value, cash at close, seller note, earnout, rollover equity, and any holdback or escrow. Then move to structural terms such as asset sale versus stock sale, debt treatment, working capital peg, and whether the buyer expects excess cash to remain in the business.

Next, compare legal and risk terms. Look at exclusivity length, breakup rights, indemnification caps, survival periods, treatment of fundamental reps, and whether a representation and warranty insurance policy is likely. Then compare execution terms: financing contingency, buyer diligence burden, expected closing date, management presentation requirements, and whether the buyer has identified key issues already.

Finally, compare relational and strategic terms. Does the buyer want you to stay? For how long? What authority would you retain? Will your team be kept intact? Is the buyer likely to preserve brand identity or merge you immediately? These are not soft issues. They affect retention, earnout performance, customer confidence, and whether you will regret saying yes.

How to score competing offers without overcomplicating the process

A practical LOI worksheet should use a weighted scoring model. Not every category matters equally. Cash at close may deserve a heavier weight than office lease assignment. Certainty of close may deserve a heavier weight than a slightly higher enterprise value. Assign each category a weight from 1 to 10 based on your priorities, then score each buyer on a standardized scale, such as 1 to 5.

For example, a founder who wants a clean break might assign high weight to cash at close, limited earnout exposure, short transition support, and low post-close indemnity risk. A founder who believes strongly in a second bite of the apple may assign greater weight to rollover equity quality, growth capital access, and cultural fit with the acquiring platform.

Worksheet Category	Why It Matters	Common Risk	Suggested Weight
Cash at close	Determines immediate liquidity	Headline price masks low upfront proceeds	10
Earnout structure	Affects total potential proceeds	Targets depend on buyer-controlled decisions	9
Working capital peg	Can change final closing payment	Peg set above normalized levels	8
Financing certainty	Measures likelihood of close	Lender approval or syndication risk	9
Rollover equity	Drives future upside	Weak governance or unclear exit path	7
Employment terms	Impacts your time and autonomy	Long lock-in or unrealistic role expectations	7
Indemnity and escrow	Determines post-close risk	Too much cash trapped after closing	8
Cultural and strategic fit	Supports retention and integration	Team loss and customer disruption	6

This type of table gives structure to what is otherwise a highly emotional decision. It also creates a clean discussion framework with your M&A advisor, transaction attorney, and CPA.

Why headline valuation is often misleading

One of the most common mistakes founders make is anchoring on total purchase price. Buyers know this. That is why many LOIs are designed to look larger than they really are. A $25 million offer with $12 million at close, a $5 million earnout, $3 million of rollover equity, a $2 million escrow, and an aggressive working capital target may be economically worse than a $22 million offer with $19 million at close and cleaner legal terms.

Strategic buyers and private equity firms often frame value differently. A strategic may offer stronger cash certainty but less upside after closing. A financial buyer may offer attractive rollover potential but ask you to stay involved longer and accept more complexity. Neither approach is inherently better. The worksheet exists to expose the differences.

This is where disciplined comparison helps founders avoid the “big number” trap. If your worksheet calculates percentage of total value payable at close, contingent percentage, and realistic net proceeds after expected adjustments, the ranking of offers often changes fast.

Key LOI terms that deserve extra scrutiny

Some terms deserve disproportionate attention because they create downstream problems. The first is exclusivity. If one buyer demands 90 days of exclusivity while another asks for 45, that difference matters. Longer exclusivity reduces leverage and gives the buyer time to retrade.

The second is the working capital peg. Buyers often present it as a routine accounting item, but a poorly defined peg can shift meaningful value away from the seller at closing. Use trailing monthly averages, remove anomalies, and make sure seasonality is reflected.

Third is earnout design. The best earnouts are based on clearly defined metrics, with reporting rights and limited buyer discretion. The worst depend on future staffing, discretionary budget decisions, or integration choices you do not control. If the buyer can change pricing, headcount, channel mix, or shared cost allocation, the earnout may be worth far less than advertised.

Fourth is rollover equity. If you are rolling part of your proceeds, understand the capital structure above and below you, expected holding period, governance rights, dilution protections, and whether management incentive pools will be refreshed after closing. A second bite at the apple can be powerful, but only if the orchard is healthy.

How the worksheet improves negotiation leverage

An LOI comparison worksheet is not just for choosing an offer. It is a negotiation weapon. Once you can identify exactly where Buyer A is stronger and Buyer B is weaker, you can counter with precision. Instead of saying, “Can you improve the offer,” you can say, “We prefer your strategic fit, but we need shorter exclusivity, a lower escrow, and more cash at close to move forward.”

Specificity creates credibility. Buyers respond better when they see that you understand the economics and are comparing them against real alternatives. In my experience, disciplined sellers with a clear worksheet create more urgency and suffer fewer post-LOI surprises because buyers know they are dealing with a prepared counterparty.

This is also why the worksheet belongs inside a broader negotiation and deal structuring toolkit. It works best when paired with valuation analysis, quality of earnings preparation, working capital modeling, tax planning, and a disciplined buyer outreach process. The worksheet is one tool, but it sits at the center of decision-making once offers arrive.

Common founder mistakes when comparing LOIs

The first mistake is comparing only purchase price. The second is failing to normalize timing of payment. Money at close is not equal to money tied to performance two years from now. The third is ignoring legal structure and tax effects. An asset sale versus stock sale can materially change after-tax outcome depending on entity type and state tax exposure.

Another mistake is underestimating post-close quality of life. If one buyer expects a five-year employment agreement with strict non-competes and another wants a six-month transition, the lifestyle difference is enormous. Founders often discover too late that they sold the business but not the burden.

The last major mistake is trying to evaluate offers without advisors. A founder may understand the business better than anyone, but an experienced M&A attorney, CPA, and advisor understand where buyers hide risk in paper. A worksheet makes those conversations more efficient because everyone can react to the same framework.

How to use this page as a hub for negotiation and deal structuring aids

Because this page is the hub for negotiation and deal structuring aids, think of it as the starting point for a full toolkit. The LOI comparison worksheet should connect to resources on working capital pegs, earnout design, rollover equity analysis, tax structuring, exclusivity strategy, and due diligence preparation. Founders should be able to come here, understand the comparison framework, and then go deeper into each deal term.

For example, if your worksheet exposes major differences in earnout language, the next step is a dedicated earnout guide. If the biggest variance is in rollover equity, you need a resource on minority recap structures and second-bite economics. If the concern is execution certainty, you need a framework for evaluating buyer financing risk and closing history.

That is the practical role of a hub page: orientation first, then depth. If you are building your own internal transaction file, this article should sit beside your M&A checklist, valuation memo, buyer tracker, and diligence request list.

What a high-quality worksheet process looks like in practice

A serious seller starts by standardizing the worksheet categories before offers arrive. Then, as LOIs come in, each one is summarized into the same template within 24 hours. The founder, advisor, attorney, and CPA review scoring together, highlight negotiation points, and identify whether to push multiple buyers forward.

The process should produce three outputs. First, a ranked comparison based on weighted scoring. Second, a red-flag memo identifying terms that could become problems later. Third, a negotiation plan with specific asks by buyer. This turns an emotional moment into a structured process.

Done well, the worksheet does not eliminate judgment. It improves judgment. Some founders will still choose the buyer with a lower score because of mission fit, team preservation, or future upside. That is fine. The point is not to let important tradeoffs stay hidden.

Conclusion: compare offers like a dealmaker, not just a founder

An LOI comparison worksheet is one of the most practical tools a seller can use because it forces clarity when emotion is highest. Competing offers should never be judged on headline valuation alone. They should be compared on net proceeds, certainty of close, legal risk, working capital mechanics, earnout realism, rollover quality, and post-close life.

That is why this page anchors the negotiation and deal structuring aids subtopic. It is not just about choosing a buyer. It is about building a repeatable framework for decision-making across every major deal term. If you are serious about maximizing value and reducing regret, create your worksheet before the first LOI lands. Then use it with your advisory team to negotiate from strength, protect your downside, and choose the offer that truly fits your goals. Start building that worksheet now, before you need it.

Frequently Asked Questions

What is an LOI comparison worksheet, and why is it so important when reviewing competing offers?

An LOI comparison worksheet is a side-by-side decision tool that helps founders evaluate multiple letters of intent using the terms that actually determine deal quality, not just the headline purchase price. In practice, it turns a stack of competing offers into a structured framework for comparing cash at close, rollover equity, seller financing, earnouts, working capital expectations, exclusivity periods, closing conditions, indemnification terms, employment obligations, and the likelihood that the buyer can actually complete the transaction. This matters because two offers with the same nominal value can produce very different real outcomes once taxes, risk allocation, post-close obligations, and timing are taken into account.

Founders often make the mistake of focusing on the largest number at the top of the LOI, but sophisticated buyers know how to shift value through structure. A higher-priced offer may include an aggressive earnout, broad reps and warranties, a long diligence timeline, or financing contingencies that create real execution risk. A lower-priced offer may deliver more cash at close, fewer post-closing entanglements, and a cleaner path to completion. The worksheet helps you identify those differences quickly and objectively so you can make decisions based on net value, certainty, and alignment with your priorities rather than emotion or negotiation pressure.

Just as importantly, an LOI comparison worksheet improves internal decision-making and advisor coordination. It gives founders, boards, shareholders, and legal and financial advisors a common format for reviewing terms, spotting red flags, and deciding where to negotiate. Instead of debating offers in broad, subjective language, everyone can point to specific terms and assess tradeoffs with discipline. That structure often leads to better negotiations, because once you clearly understand where one buyer is stronger or weaker, you can push for meaningful concessions rather than vague improvements.

What terms should founders include in an LOI comparison worksheet beyond purchase price?

The most effective worksheet goes well beyond headline valuation and captures every term that affects economics, risk, control, and closing certainty. At a minimum, founders should compare total stated purchase price, cash at close, escrow or holdback amounts, earnout structure, rollover equity requirements, seller notes, and any working capital adjustment mechanism. These terms determine how much money is actually received, when it is received, and how much remains at risk after the transaction closes.

Another essential category is deal certainty. This includes whether the buyer is using committed financing, whether the offer is contingent on lender approval or investment committee signoff, the expected diligence scope, exclusivity period length, target signing and closing dates, required third-party consents, and any unusual closing conditions. A buyer with a lower price but cleaner process and fewer contingencies may represent a better outcome than a more aggressive bidder whose deal depends on financing or prolonged confirmatory diligence. In many sale processes, certainty has real economic value because failed deals can damage momentum, distract leadership, and reduce competitive tension.

Control and post-close obligations should also be compared carefully. Founders should include management rollover expectations, employment agreements, non-compete and non-solicit terms, board or governance rights tied to retained equity, decision-making authority after closing, and any performance milestones linked to future payouts. Legal risk terms belong in the worksheet as well, including indemnification caps, baskets, survival periods, treatment of fundamental reps, and whether representation and warranty insurance is expected. When all of these categories are captured in one document, founders can see which buyer is offering a transaction that is not only attractive on paper, but also practical, financeable, and consistent with their personal and strategic goals.

How can a founder tell whether a higher-priced LOI is actually worse than a lower-priced one?

The key is to translate each offer into expected realized value rather than stated value. A higher-priced LOI can be worse if too much of the consideration is deferred, contingent, or exposed to post-closing disputes. For example, an offer that promises a larger total price but pays a smaller percentage in cash at close, requires a substantial earnout, includes a large escrow, and imposes strict post-close performance conditions may leave the seller with less certainty and potentially less money than a lower-priced offer with cleaner terms. The worksheet helps quantify those tradeoffs by separating guaranteed proceeds from contingent proceeds and by highlighting how difficult it may be to achieve the contingent portion.

Execution risk is another major factor. A buyer may bid aggressively to win exclusivity, then retrade during diligence, struggle to secure financing, or introduce stricter legal terms later in the process. If the LOI includes financing contingencies, vague diligence language, an extended exclusivity period, or multiple internal approval requirements, the real value of that offer may be significantly lower than it first appears. By contrast, a lower-priced buyer with committed capital, a narrower diligence scope, and a history of closing deals may provide a superior risk-adjusted outcome. Founders should ask not only, “What is the offer worth if everything goes right?” but also, “How likely is it that this offer closes on the current terms?”

Personal goals also matter. A founder planning to exit fully may place far more value on cash at close and limited post-sale obligations than on upside tied to future company performance. Another founder may prefer rollover equity and strategic partnership if they want a second bite at the apple. The better LOI is the one that best fits the seller’s objectives while delivering an acceptable balance of value and certainty. A worksheet makes those judgments more disciplined by forcing a direct comparison between economics, risk, timing, and lifestyle impact instead of treating every offer as if the only variable is price.

How should founders evaluate earnouts, rollover equity, and other contingent consideration in competing LOIs?

Contingent consideration should be evaluated with healthy skepticism and a clear framework. Earnouts, rollover equity, and seller financing can create upside, but they also transfer risk back to the seller after the company has changed hands. With earnouts, founders should compare the percentage of total purchase price tied to future performance, the measurement period, the specific metrics used, who controls the business during the earnout period, and whether the targets are realistic based on current performance and the buyer’s post-close operating plan. An earnout tied to revenue may be easier to track than one based on EBITDA if the buyer controls cost allocations, but any metric can become problematic if the seller lacks visibility or influence after closing.

Rollover equity requires a different analysis. Founders should understand what percentage of proceeds must be rolled, what security they are receiving, the capital structure above and below them, governance rights, dilution protections, expected hold period, and the buyer’s value-creation strategy. Rollover can be highly attractive if the buyer has a credible plan and strong alignment, but it is not equivalent to cash. It carries illiquidity, future market risk, and dependence on management and sponsor decisions. A worksheet should therefore separate hard cash from rollover and note both the potential upside and the lack of immediate certainty.

Seller notes and similar deferred instruments should be assessed based on duration, interest rate, payment priority, security, subordination, and default remedies. In all cases, founders should avoid treating contingent consideration at face value. A disciplined approach is to estimate probability-weighted value and then compare that to the guaranteed proceeds in other offers. If one LOI offers a larger theoretical total value but requires the seller to bear substantial execution and operating risk, it may be less attractive than a simpler structure with lower stated value but stronger certainty. The purpose of the worksheet is to make those risks visible before exclusivity is granted, not after leverage has shifted to the buyer.

What are the most common mistakes founders make when comparing LOIs, and how can a worksheet help avoid them?

The most common mistake is anchoring on headline price and failing to unpack structure. Founders naturally focus on the largest number, especially after a long sale process, but buyers often use structure to reallocate risk and reduce certainty. If a founder does not compare cash at close, escrow, working capital adjustments, earnouts, rollover, and legal exposure side by side, they may choose an offer that looks superior but produces a worse outcome in practice. A well-built worksheet prevents that by forcing each economic component into its own line item and making contingent value impossible to confuse with guaranteed proceeds.

Another frequent mistake is underestimating execution risk. Founders sometimes assume an LOI reflects a near-final commitment, when in reality it is often the start of a much more demanding process. Financing contingencies, broad diligence rights, long exclusivity periods, and vague language around approvals can all signal that the buyer may retrade or fail to close. The worksheet helps avoid this by assigning attention to certainty factors such as source of funds, buyer reputation, timeline credibility, required approvals, and the scope of confirmatory diligence. This shifts the conversation from “Who bid the most?” to “Who is most likely to close on acceptable terms?”

A third mistake is ignoring personal and strategic fit. Not every founder wants the same outcome. Some prioritize speed and certainty, others want maximum upside, and others care deeply about employee retention, brand legacy, or their own continuing role. Without a structured comparison, these goals can get lost in the excitement of competitive bidding. A worksheet helps by making room for qualitative considerations alongside economic ones. It allows founders to score or rank offers based on what matters most to them, whether