Tool

Capital Allocation & Deal Affordability Tool

Compare buying, building, partnering, and doing nothing; test funding and downside constraints; and set the buyer's private hard price ceiling.

What this helps you decide

Is the acquisition the best use of capital, and what is the buyer's hard price ceiling?

The decision this tool answers

Download the Capital Allocation & Deal Affordability workbook · Excel · Version 1.0 · USD millions

An acquisition competes for capital with building internally, partnering, and preserving the option to do nothing. The decision is larger than whether the buyer can assemble enough money to close.

This tool asks: Is the acquisition the best use of capital, and what is the buyer's hard price ceiling? It connects the alternatives to a five-year cash-flow view, financing choices, operating headroom, and a private walk-away price.

When to use it

Use it after the mandate and an initial operating case are defined, before bidding or agreeing core economics. Revisit it when diligence changes the forecast, financing terms move, separation costs emerge, or competitive pressure starts to pull the price upward.

Start with a 15-minute first pass: enter the proposed price, available buyer capital, financing terms, and the largest cash demands. Look at which condition limits the deal. A complete investment decision needs the supporting forecast and evidence behind those inputs.

What to bring

Bring the buyer's unrestricted cash, minimum liquidity reserve, existing debt and debt service, other capital commitments, and expected cash generation. Bring the target's normalized revenue and margins, capital expenditure, working-capital needs, tax assumptions, required follow-on investment, transaction costs, and any supported buyer-specific synergies.

Bring financing amounts and terms that distinguish a modeled borrowing limit from an actual commitment. For equity financing, bring the valuation basis used to calculate ownership dilution. For the alternatives, bring the capability delivered, timing, upfront and later cash requirements, annual cash benefits, and the basis for any residual value.

Use one price definition

All monetary inputs and outputs are in USD millions. The acquisition price in this workbook is debt-free, cash-free enterprise value with normalized working capital. It is the price for the operating business. It is not the cash amount paid to shareholders after adjusting for target debt, cash, and other closing items.

Reconcile the negotiated enterprise-to-equity bridge and closing funds flow in the LOI Economics & Risk Allocator and the transaction model. An equity-price quote should not be pasted into this tool as enterprise value without that reconciliation.

Compare buy, build, partner, and do nothing

Compare the four routes against the same business need and the same five-year horizon. Buying a capability immediately and building a different capability three years later are not automatically equivalent alternatives.

Record what each route delivers, whether it meets the required outcome, and what remains uncertain. Compare incremental cash flows using a common hurdle rate, including the cash required after the initial commitment. Explain the consequences of doing nothing; preserving capital may still leave an operating gap or a lost opportunity.

Before deducting an alternative's value from the acquisition price ceiling, confirm that the alternatives are comparable and mutually exclusive. A complementary project that can proceed alongside the acquisition is a separate capital commitment, not automatically the opportunity cost of buying.

Distinguish three price limits

Affordable price: the amount the buyer can fund under the selected financing plan while respecting the modeled leverage, coverage, and liquidity constraints.
Return-supported price: the price supported by the operating cash flows and residual value at the entered hurdle rate, after the other investment costs.
Hard walk-away price: the lowest applicable constraint after the downside and opportunity-cost reviews, including the buyer's own strategic price cap.

More borrowing capacity does not make the business more valuable. A high modeled return does not supply cash for closing. A strategic cap preserves discipline when the auction becomes competitive.

The Base and Upside cases show their own conditional price limits. Select Downside to calculate the hard walk-away price. Revisit the limit whenever the facts change.

A reviewed hard walk-away also requires a named owner, a populated evidence and approval record, Verified evidence, a confirmed required outcome, feasible buying, reviewed comparable alternatives, and confirmed funding. Those labels require renewed review after a material assumption changes.

Count the capital that is actually available

Begin with unrestricted buyer cash, then preserve the minimum operating reserve and deduct other committed uses of capital. Include transaction fees, initial additional investment, and the cash needed after close.

Keep cash already on the balance sheet separate from future cash generation. Keep new borrowing separate from existing debt. An undrawn facility is not cash on hand, and a financing indication is not an executed funding commitment.

Review the full five-year period. A deal can fund at close and still run short when working capital grows, a replacement system is required, or debt becomes due.

Compare the financing choices

The financing table supports three editable choices. Compare the new debt amount, cash interest rate, repayment schedule, external equity, and commitment status on the same operating case.

Leverage tests opening gross debt against each year's forecast combined buyer and target EBITDA. The modeled new-debt capacity is the lowest amount allowed by the annual leverage and interest-coverage tests, capped by the committed borrowing limit. Interest coverage tests earnings against cash interest. These are planning constraints, not a reading of a lender's covenant definitions or proof that financing is available.

Equity can preserve borrowing capacity, but it changes ownership. The dilution view measures the ownership issued to new capital against the entered pre-issue equity value. It does not calculate earnings-per-share accretion or dilution, purchase accounting, or future share-price performance.

More debt can increase closing funds while increasing later debt service. The affordable-price result is conditional on the selected financing plan; it is not an optimization across every possible capital structure. Compare the available plans and review the binding period before choosing how much to borrow.

Enter transaction and financing fees once in the shared Controls estimate. Update that estimate when comparing plans with different fees; the three financing choices do not carry separate fee inputs.

Make the downside survivable

Stress revenue and margin together. Carry the resulting earnings and cash flow through interest, principal repayment, other obligations, capital expenditure, working capital, and follow-on investment.

Check the weakest period, not just the closing leverage ratio. A year-five refinancing assumption should not quietly rescue an otherwise unfundable balloon payment. Name the contractual repayment and the source of cash that would meet it.

Mike's governing rule is that a deal which cannot survive the combined downside should not advance. A stronger Base case does not cancel an unresolved liquidity deficit or a financing condition.

The liquidity screen uses closing and annual end-period cash balances. It does not reveal an intra-year seasonal cash shortfall. Terminal sale proceeds used in the return calculation are excluded from this operating survivability test. Use a monthly cash forecast when payroll, seasonality, capital spending, or debt timing can create a gap within a year.

Keep buyer-created synergy separate

Build the target's standalone cash flows first. Then show supported buyer-specific synergy cash separately, after the costs and investment required to deliver it. Use the Synergy Underwriting & Value Bridge to establish those assumptions.

The workbook presents a standalone price reference separately from any private buyer benefit. Synergies may help the buyer judge affordability and its private ceiling; they do not automatically belong to the seller. Avoid counting the same benefit in both the target forecast and the synergy line, or counting its implementation cost twice.

The price ceiling includes only the entered share of each positive annual discounted synergy cash flow. Each negative annual discounted synergy cash flow reduces the ceiling in full, even when total synergy NPV is positive. Economic NPV includes all net synergy cash. No synergy terminal value or EBITDA add-back increases modeled borrowing capacity.

Read the return measures on their stated basis

Net present value (NPV) expresses the modeled cash flows and residual value in today's money at the entered hurdle rate, less the investment required. It helps compare the value created by the alternatives when their scope and timing are comparable.

Internal rate of return (IRR) here is the unlevered acquisition or project IRR: the discount rate at which the operating investment cash flows, including residual value, have zero NPV. It is not the leveraged return earned by sponsor equity. Read it together with the dollar value created and the size of the investment. A small project can have a high percentage return while creating little total value.

Return on invested capital (ROIC) is a Year 1 standalone proxy: standalone NOPAT divided by enterprise value plus initial additional investment and Year 1 follow-on investment. It excludes transaction fees and buyer synergies. This acquisition-cost basis differs from purchase-accounting invested capital and a mature run rate.

Payback shows the first whole year in which cumulative operating cash flows recover the initial investment. Initial outflows occur at close and annual cash flows at year-end. Keep terminal sale proceeds separate. An assumed sale at the end of year five is not evidence that the operations paid back within five years.

Mike emphasizes payback for strategic buyers and IRR for financial sponsors. A sponsor needs a separate equity cash-flow model to calculate its leveraged IRR. Read these project returns alongside the funding, cash timing, and downside on which they depend.

Make opportunity cost explicit

A positive acquisition NPV does not establish that buying is the best choice. Compare it with the best feasible alternative that meets the same need. The workbook shows that comparison and, when comparability is confirmed, the effect on the price the buyer can justify.

The opportunity-cost adjustment is not an extra cash payment to the seller or lender. It is value the buyer gives up by selecting one route instead of another. Do not also enter the same forgone value as a cash expense.

If the alternatives have materially different scale, timing, risk, or capability, resolve that difference before using a numerical ranking as the decision.

Use the seven workbook tabs

Dashboard: read the active case, limiting condition, price headroom, and next decision.
Controls: set the buyer, transaction, operating cases, hurdle, and review inputs.
Deal cash flow: follow the selected case through standalone cash generation, synergies, investment, and returns.
Financing: compare three funding choices and select the plan to test.
Capacity: inspect leverage, coverage, debt service, liquidity, and the price limits.
Alternatives: compare buying with building, partnering, and doing nothing.
Guide: check the definitions and calculation boundaries before relying on a result.

Replace fictional inputs labeled Assumption with the transaction's supported inputs. Missing inputs should remain visible. Review evidence and financing status separately from whether the arithmetic calculates.

Common mistakes

Using the maximum financing amount as the offer price.
Spending the buyer's operating reserve or counting an undrawn facility twice.
Ignoring follow-on investment, other capital commitments, or a debt maturity.
Calling an Upside result a survivable downside.
Using buyer-created synergy to increase the seller's standalone value.
Comparing alternatives that deliver different outcomes without explaining the difference.
Letting terminal value hide weak operating payback.
Using ownership dilution as though it were earnings-per-share dilution.

Carry the result into the next decision

Use the Acquisition Mandate & Target Screen to confirm why buying serves the business need. Carry separation and temporary-service cash requirements from the Carve-Out Perimeter & TSA Planner into the appropriate forecast period.

Before the next commitment, name what needs to change: Investigate an unsupported cash flow, Price a supported cost or weaker forecast, Protect a funding or transition condition, or Walk when the required outcome or downside cannot be made acceptable. Record the owner and next action in the M&A Deal Workflow.

The workbook is a capital-allocation and affordability screen. It does not replace a transaction-specific integrated deal model, financing commitment, valuation conclusion, or approval process.

Version

Version 1.0. Updated September 10, 2026. Editable Excel workbook. Entries stay in your downloaded copy.