AUTO REPAIRBUSINESS BROKERBook a call
Menu

LOI offer comparison workbook

Put competing letters of intent on the same footing by separating cash you receive at closing from amounts that depend on later events. This workbook compares three offers, reconciles their components to the headline price and lets you adjust collection assumptions and timing before deciding which terms deserve further negotiation.

Prepared by HedgeStone Business Advisors · Version 2026-11-21

Inside the loi offer comparison workbook
Map the termsReconcile the face amount · Define the peg · Document timing
Compare outcomesEstimate after-close receipts · Check downside cash · Read the variance

Key takeaways

  • Count escrow once when reconstructing the headline price.
  • Compare cash, contingent value and collection timing independently.
  • Keep the signed working-capital adjustment separate from headline price.

What should you copy from the letter of intent?

Copy the purchase-price language before interpreting it. Record which assets are included, whether inventory is an additional amount and whether the quoted price assumes a specific working-capital balance.

A buyer may use “cash consideration” for the total cash they deposit with their closing agent, including funds diverted into escrow. In the workbook’s cash-at-close row, enter the amount released to you. Put the withheld portion in escrow. Locate the release test and time period in the buyer’s actual language. If the letter leaves one of those points open, ask for written clarification before you assign a recovery share.

Next, check future consideration. A seller note gives you a payment obligation subject to its terms. An earnout depends on defined performance. Rollover equity depends on ownership rights, the value of the new enterprise and a future liquidity event. Put each component in its own row, even if the cover email quotes a single combined amount.

Which terms make two buyer proposals comparable?

The first section, Map the terms, gives you these prompts and room to document your evidence.

  1. Reconcile the face amount. Separate buyer cash, escrow carved out of price, seller-note principal, maximum earnout and rollover. Each component belongs in one bucket.
  2. Define the peg. Choose the same convention for all offers. Enter expected delivered working capital minus the agreed peg as a signed adjustment.
  3. Document timing. Enter each bucket’s expected years to collection and note maturity, subordination, release tests or exit assumptions in the terms field.
LOI offer comparison workbook preview
SectionTopics covered
Map the termsReconcile the face amount · Define the peg · Document timing
Compare outcomesEstimate after-close receipts · Check downside cash · Read the variance

How do you estimate future collection without overstating it?

Use a stated recovery assumption and date for each future component. Leave the estimate unresolved until you have a reasonable basis for the input, then rerun the comparison with a more conservative assumption.

The workbook discounts a component as its face amount multiplied by its expected collectible share, divided by one plus your annual discount rate raised to the years until receipt. For a note, the model represents principal as a single payment at the time you choose. An amortizing note requires a separate payment-by-payment analysis for the final decision. Accrued interest, taxes and collection expenses also belong in that deeper review.

Read the earnout definition carefully. If the buyer controls staffing, prices or expense allocation after closing, your assumption should reflect how those decisions affect the metric. For rollover, ask about the securities you receive, dilution, priority and how you can sell. A nominal dollar amount tells you little about the exit.

How can the lower headline deliver more cash?

Illustrative composite — not a real client.

Offer A describes $600,000 of consideration as $380,000 released cash, $120,000 seller-note principal, a $70,000 maximum earnout and $30,000 escrow. Offer B offers $550,000 with $520,000 released cash and $30,000 escrow. Both component totals match. A delivers $140,000 less on closing day. If your working-capital adjustment is negative $12,000 for A and zero for B, the closing-day gap rises to $152,000. Your expected later receipts determine whether A compensates you for that difference.

How do you get two differently worded offers onto the same sheet?

Start with the signed or current proposed letter from each bidder. Write its date and revision alongside the buyer name on your working copy. Fill one entire Offer terms column before starting the next. Use the Assumption or agreement column to identify the clause behind each material input and distinguish your estimate from a written promise. If a bidder offers an extra amount for the building, keep a separate property comparison unless every column includes precisely the same real estate. Otherwise the price difference tells you more about what is being purchased than what a bidder will pay for your repair operation.

Follow the funds from buyer to seller. The cash released to seller line takes the amount you can actually receive before the worksheet’s working capital adjustment. Put the indemnity holdback into Escrow at closing. Record only principal on Seller note principal. When a landlord requires a new deposit or a lender requires an old lien payoff, mark it for the separate proceeds statement. Ask the deal team who funds each item and where it appears. An item that reduces the seller wire can matter more to your decision than a modest increase in headline price.

How can you check the formulas against an example you can calculate yourself?

Illustrative composite — not a real client. Consider a $700,000 offer for a four-bay mechanical repair business. The letter gives the seller $555,000 immediately, a $115,000 seller note and $30,000 in escrow. Enter zero for Maximum earnout and Rollover equity at entry. The five components sum to $700,000, so the reconciliation gap should equal zero. Suppose delivered working capital falls $12,000 short of the agreed target and the seller bears the shortfall. Enter negative $12,000. Cash at closing and Downside cash only should both show $543,000 before taxes, costs and payoffs.

For a calculation check, assume full recovery on the note in two years and the escrow in one year, with a 10 percent annual discount rate. Put zero into the recovery and timing inputs for unused components. The note contributes about $95,041 in today’s dollars and the escrow about $27,273. Expected present value comes to approximately $665,314. These single-date assumptions simplify the exercise. If the signed note pays monthly, obtain the amortization schedule and examine actual payment dates, interest, standby periods and any balloon before relying on your estimate for personal planning.

Which offer terms are hardest to translate into a recovery share?

Read the earnout definition as though you will receive your last payment after you have left the shop. A condition based on gross profit from an existing fleet account needs a written way to identify that customer’s jobs, warranty credits, parts discounts and sublet charges. Ask who controls pricing after the sale and when you can inspect the underlying repair orders. If the draft leaves room for disagreement, write the question beside your estimated recovery share. Give the buyer a chance to resolve the definition and rerun your comparison with the revised language.

Check the seller note separately. A buyer’s intention to pay and the senior lender’s permission to make payments are two different inputs. Find the proposed first payment date, whether interest accrues during a delay, the final maturity and the seller’s rights following default. Explain which facts support your years-to-receipt estimate. For rollover equity, request information about the ownership class, distribution rules and any right to see future statements. A percentage entered beside an uncertain investment has little decision value unless you can tell the person reviewing your worksheet why you selected it.

What sensitivity checks should you run before making a counteroffer?

Save your original comparison and use a spare offer column for one changed assumption at a time. First remove expected earnout collection while keeping the written price components intact. Then move the note’s expected collection farther away. If the preferred offer changes after one modest input change, focus the counteroffer on what produced the change. You might seek a smaller maximum earnout with a clearer formula, a shorter escrow period, or a larger wire. Document your priorities before another revision changes several features together.

Try a zero discount rate and full recovery on all components as a mechanical check. With a reconciled offer, the expected value should then equal headline price plus the signed working capital adjustment. Next enter zero recovery on all deferred components. Expected value should fall to the cash at closing number. Restore your assumptions once you have verified the calculation. Before circulating the sheet, have the broker check purchase components, counsel check recovery conditions, and the accountant produce a separate net proceeds estimate. Keep those dated responses with the exact offer version you evaluated.

How do you read the difference between two expected values?

Review the timing and collectibility assumptions that produced each result before you decide which term to renegotiate.

  1. Estimate after-close receipts. Give each contingent component a recovery share between zero and one. Enter your annual discount rate separately.
  2. Check downside cash. The cash-only case assumes no later collection. Taxes, closing expenses, debt payoff and a working-capital dispute could reduce that cash further.
  3. Read the variance. A nonzero reconciliation gap means that the stated headline and entered components disagree. Resolve it before comparing expected present values.

Which result should guide your next negotiation?

Start with your required cash at closing, then compare the risks attached to anything you need later. An apparently attractive expected value can still leave your retirement or debt payoff dependent on a buyer’s future decisions.

Change one term at a time in the offer comparison tool. If an earnout turns on EBITDA, build a shared definition from the SDE and adjusted EBITDA workbook. Ask counsel to draft the definition, accounting rules, information access and dispute process before signing definitive documents.

Document the difference between a price concession and a timing change. Moving money from a holdback into day-one cash changes collection risk even if the headline does not move. Compare the revised figures alongside the marked-up letter so you can trace the change to an actual term.

What else should you know?

Is escrow part of cash at closing?

Cash placed with an escrow agent is funded at closing, but you cannot freely use it while claims or release conditions remain outstanding. Enter it separately from money released to you. Read the release date, caps and permitted claims before choosing a recovery assumption.

What does the recovery share mean?

It is your estimate of the proportion of a component’s face value you expect to receive. For an all-or-nothing earnout, that can reflect a probability of payment. If partial payments are possible, consider each outcome and its probability before entering a weighted share.

Can I compare seller notes with different interest rates?

Use this workbook for an initial principal and timing comparison. For materially different notes, model each interest and principal payment separately and check standby, collateral and default terms. Discuss those terms with counsel before treating the note value as equivalent to cash in your account.

Does expected present value equal net proceeds?

Your expected present value discounts modeled future receipts and includes the working-capital assumption. Net proceeds also depend on debt payoff, transaction costs, taxes and final settlement terms. Take your preferred structure to your CPA for a separate estimate using the actual allocation and ownership details.

Which sources can you check?

Explore the operations hub

Recommended for you

Talk through your next move.

Bring your shop, your offer, or the question holding up your decision.

Book an intro call