HVAC Company Business BrokerBook a call
Menu
HedgeStone Business Advisors
Download

LOI offer comparison workbook

Line up your offers on the same price basis before you rank them. This workbook separates the money you collect at closing from the money you might collect later. Enter a different collection or exit assumption for each offer and check how much of your outcome depends on the buyer.

Which number belongs at the top?

Use the consideration promised for the same assets and liabilities in each offer. Write down what the buyer means by enterprise value or equity value and reconcile that language to the closing calculation.

One buyer might quote an enterprise price with debt paid off at closing. Another might state proceeds after debt repayment. Entering both headline numbers and then charging both columns for the same payoff distorts the result. Reconstruct the second offer on a comparable basis or enter only the payoff still due on its stated basis.

Check whether a property, excluded vehicle, minority interest or excess cash changes the comparison. If an offer includes your building, isolate the premises economics before drawing conclusions about what the parties are paying for the contractor.

What changes the cash you can spend?

Subtract deferred consideration and the cash that must leave the settlement statement. Add the expected working-capital adjustment with its correct sign.

A retained escrow and a seller note can both reduce the first wire. Their paths to collection differ. Trace the escrow to a release schedule and claims process. Trace the note to its payment dates, priority, collateral and restrictions on collection. Keep any installment interest outside the face-value comparison and discuss its timing with your CPA.

Use your current debt statement and an estimate of fees. If the closing date is uncertain, write down when the numbers expire. Do a second run with lower eligible inventory or higher accrued payroll if the working-capital definition is still open.

How much uncertainty will you carry after close?

Give each deferred piece its own assumption. A note can default, an earnout can miss its target, an escrow can face claims and rollover equity may produce a wide range of proceeds.

Read a retention earnout as if you were trying to reproduce it. Which members were eligible at the starting date? How are nonpayment, relocation, price increases and buyers who move customers between brands treated? If the contract would let two readers reach different answers, your spreadsheet cannot resolve the wording.

For rollover, enter your estimate of the cash distribution at exit. The workbook does not assume your entry amount will be returned. A cash-heavy offer that meets your immediate needs can look different from a larger offer after you test missed payouts. Bring the resulting questions back to your attorney before agreeing to exclusivity.

How do you set up your working copy?

Pick one dated version of each offer and keep the underlying LOI with the workbook.

  1. Enter the negotiated price and describe the asset and debt basis in your supporting notes.
  2. Identify the amount, form and timing of each payment and how the working-capital figure is determined.
  3. Stress the collection assumptions one at a time. Record which changed assumption would alter your preferred offer.

What will you find in the file?

The three columns use identical lines so you can spot the first term that makes one offer materially different.

LOI offer comparison workbook preview
Workbook lineWhat you enter or check
Headline considerationTotal quoted value before the settlement adjustments.
Seller note face amountDeferred principal.
Earnout maximumMaximum contingent consideration.
Rollover value at entryValue of equity retained or subscribed.
Escrow held backCash retained by escrow agent.
Debt payoffDebt subtracted on the chosen offer basis.
Fees and closing costsTransaction costs due at closing.
Working-capital adjustmentAdd a surplus or enter a shortfall as negative.
Cash at closingHeadline less noncash items, debt and fees, plus true-up.
Note collection shareYour assumed collection share, from 0% to 100%.
Earnout probabilityChance of full payout in this simplified scenario.
Expected rollover proceedsInput your own exit scenario, including zero.
Escrow release shareAssumed share returned after claims.
Expected total pre-tax proceedsCash plus assumed future note, earnout, rollover and escrow receipts.
Deferred amounts lost scenarioImmediate proceeds if all deferred consideration is lost. Excludes indemnity claims beyond holdback.

How should you enter a preliminary offer with missing terms?

Begin with the buyer’s actual letter and mark the date and version in your working records. Find the paragraph that explains what the buyer is purchasing and whether the quoted price assumes cash-free, debt-free delivery with normal working capital. A number described as enterprise value needs a bridge before you treat it as consideration for your equity. If one bidder includes your real estate and another expects to rent the premises, normalize that difference outside the workbook before comparing the operating offers.

Keep missing information visible. A zero debt payoff can mean the company has no relevant debt or the buyer has not yet said how debt will be handled. Those are different economic positions. Track unresolved terms in a separate note or a dated copy of the comparison, and run an explicit assumption only when you can explain it to your lawyer, accountant or spouse. A parameter you supplied yourself should never be mistaken for a commitment from the buyer.

Separate purchase price from your future compensation. A salaried transition job, commission opportunity or management incentive may be valuable, but it requires work and can have different tax consequences. Review employment terms alongside the workbook instead of adding a multi-year salary to the sale price as though the seller receives it for transferring the company.

How can you compare two offers with different working capital definitions?

Request each bidder’s proposed definition, calculation date and target. List material components such as receivables, inventory, payables, customer deposits and prepaid membership obligations. Decide with your advisers whether unusual or debt-like items already appear elsewhere. One buyer may quote a generous headline while requiring delivery of more inventory and cash-generating receivables than the other.

Choose a recent month-end and calculate the adjustment under each buyer’s definition using the same balance sheet. Enter the result with the sign convention stated in the workbook. Then repeat using an actual high-season or low-season balance if the business swings materially. You can see whether a purported price advantage depends on choosing one unusually favorable date.

Keep tax effects out of this pre-tax comparison until you have the proposed structure, allocation and basis records. Use the resulting cash lines as inputs to your CPA’s review. A higher pre-tax expected total may produce a less suitable outcome if you owe tax before receiving deferred payments or retain exposure to a long collection period.

How should you choose assumptions for notes, escrows and rollover?

Read the seller note for principal, maturity, security, payment schedule, subordination and default rights. Ask whether a senior lender restricts payments. The collection share in this workbook is a scenario input. Enter a value supported by your evaluation, then test a case with delayed or impaired payment. A face-value promise and a cash wire are economically different even when the spreadsheet amount looks identical.

For the earnout, obtain the actual measurement period, performance formula, cap and reporting rights. Ask what occurs if the buyer moves your technicians, assigns sales to another branch or changes the software that records membership renewal. The probability input produces a scenario-weighted amount. It cannot determine the likelihood that those business events will happen. Save the rationale for the assumption beside the relevant LOI.

For rollover, identify the issuer and share class. Determine how debt, preferred returns, future dilution and repurchase terms affect a later distribution. Use expected proceeds only when you have considered the actual security. Retain a downside case in which there is no usable cash when you need it. For escrow, use the stated claims and release process to evaluate which portion might return and when.

What questions should you take back to the bidder after the first pass?

Find the largest reason the two offers rank differently. If one promises a greater earnout, ask the buyer to calculate its formula on a real historical quarter with the relevant jobs and adjustments. If the gap comes from working capital, request a specimen closing calculation. If a large escrow drives the result, ask for the claim standard and release deadline.

Run the same adverse event through both proposals. Suppose an important service manager leaves, a financed replacement settles after closing or an old customer submits a warranty claim. Determine which document governs the event, which party controls the response and who funds the result. You will sometimes find that the highest maximum payout exposes the seller to more decisions made entirely by the buyer.

Finish with three lines you can explain without the workbook: cash reasonably expected at closing, amounts dependent on future events and material duties you must perform. Put lender approval, employment obligations and access to future reporting beside those answers. Update the workbook whenever a buyer changes its position and retain the old version so you can identify exactly what improved or deteriorated.

How would you apply this to your shop?

Illustrative composite — not a real client. A $2,000,000 enterprise offer contains a $200,000 note, $100,000 maximum earnout, $300,000 of rollover and a $50,000 escrow. Assume $120,000 of debt, $80,000 in fees and a $10,000 positive working-capital adjustment. The initial cash estimate is $2,000,000 − $200,000 − $100,000 − $300,000 − $50,000 − $120,000 − $80,000 + $10,000 = $1,160,000.

If the note collects in full, the earnout has a 50% chance of full payout, the rollover returns $180,000 and the escrow releases in full, expected nominal proceeds become $1,640,000. The $180,000 rollover assumption is a scenario you supplied. It can fall below the entry value and may take years to arrive.

Check that the holdback appears only once. An LOI may call its first wire cash at close after already withholding escrow. Reconcile the cash definition before deducting the escrow from that figure a second time.

Where can you go next?

What else should you know?

Is deferred consideration the same as an escrow?

Deferred consideration includes multiple kinds of future payment. In the escrow line, enter cash withheld under an agreed release mechanism. Put a seller loan, performance payment and retained equity in their own lines. Treating them separately lets you change the scenario for one risk without changing the others.

Can I compare two offers if I only have two?

Yes. Complete the relevant columns and leave the unused offer empty. In each active column, enter an explicit zero for terms you reviewed and confirmed are absent. A blank means you still need an amount or assumption before the workbook can calculate the scenario.

Where do I enter taxes on my sale?

The comparison displays pre-tax proceeds. Give the workbook and each offer’s allocation and payment schedule to your CPA before estimating taxes. A cash receipt and its tax consequences may fall in different periods, and different assets can receive different treatment in the same sale.

What if my highest-price offer has no rollover exit date?

Model the equity receipt separately and write down how long your money could remain tied up. Include a scenario with no distribution. Ask for the ownership, dilution and liquidity provisions you would need to estimate a return. This workbook compares nominal dollars before discounting for time.

Which sources informed this page?

Explore the selling hub