LBO Sources and Uses: Downloadable Excel Template with Deal-Specific Tweaks

An LBO sources and uses schedule is the one-page map of cash at closing that shows where money comes from and where it goes. In Excel, the template links debt proceeds, equity checks, and seller rollover to purchase price, payoffs, fees, and required cash on the balance sheet. It is not an operating model or a purchase price allocation. It is the bridge among the purchase agreement, the financing documents, and the funds flow memo that makes closing day executable.

The payoff is speed and certainty. When your schedule is tight, you avoid last minute shortfalls, wire mistakes, and document mismatches. When it is sloppy, wires slip and your closing date moves.

Why this schedule matters and who uses it

The schedule sits next to the equity bridge and the funds flow memorandum. The equity bridge converts enterprise value to cash to the seller and then to equity required from the sponsor and co-investors. The funds flow memo then turns every use into a payee, a bank account, and a wire. All three must reconcile to the cent and to the document language.

Stakeholders use the schedule for different ends. Sponsors want the least equity with high closing certainty. Lenders want clean permitted uses and adequate liquidity. Sellers want cash proceeds clarity and no surprises on debt payoffs or expenses. Counsel uses it to align documents with the actual movement of funds. A well built LBO sources and uses table gives each party what they need without rework.

Mirror the legal structure to avoid funding blocks

You must tie the model to the acquisition entity chart so proceeds can flow lawfully. In a private-company deal, Holdco owns a Merger Sub or Acquisition Sub. In a take-private, the merger sub combines with the target, with a paying agent handling consideration. In a carve-out, the buyer may purchase assets or a subsidiary and pay one-time separation amounts, usually alongside a transition services agreement.

Debt lives within borrowers and guarantors that match collateral, corporate law, and licenses. U.S. loans follow agented agreements with upstream and cross-stream limits. European deals track LMA conventions. Pick governing law to match the main debt instrument and enforcement venue. If ring fencing is required for regulatory or joint venture reasons, reflect it because eligible borrowers and guarantors drive proceeds and fees. The schedule must echo these limits or you will show sources you cannot use.

Model the flow of funds exactly as it happens

Treat the schedule as a single period cash flow at close, in one base currency. You do not mix currencies on a line and you do not assume sequencing that documents do not allow.

Sources: Funded debt net of original issue discount and upfront fees, sponsor equity, seller rollover or notes, and any available pre-positioned cash that can be distributed legally at closing.
Uses: Cash to sellers, payoffs of target debt with accrued interest and premia, seller transaction expenses that buyer pays, buyer fees, OID and upfront lender fees, minimum cash on the balance sheet, and any escrows or holdbacks.

Payoff letters and closing deliverables dictate priority. Agent banks control secured payoffs. Paying agents manage stockholder consideration in public deals. Model the actual sequencing so OID and lender fees do not show up as a shortfall in debt proceeds on closing day.

Map every line to a document

Every number should tie to a clause, letter, or certificate. When you tie the model to source documents, review cycles shrink and confidence rises.

Purchase agreement: Price mechanics, working capital peg or locked box, transaction expenses, RWI and escrows, rollover, earnout, settlement currency.
Commitment papers and fee letter: Available tranches, flex, OID, upfront fees, ticking or commitment fees, conditions, permitted uses.
Credit agreement or indenture: Use of proceeds language, permitted transaction expenses, revolver availability at close.
Equity commitment and guarantee: Funding obligation, enforcement, and specific performance alignment for take-privates.
Payoff letters and lien terminations: Wire amounts, per diem interest, premia, release mechanics.
Funds flow memo: Payees, accounts, and cutoffs which is your execution checklist.

Fees and economics that change cash

Deal fees reduce usable proceeds. If you misclassify them, you will underfund and scramble for equity at the eleventh hour.

Debt economics: Original issue discount reduces proceeds at funding. Upfront fees are cash uses. Arrangement or underwriting fees may be netted. Ticking fees accrue until funding. Commitment fees hit at signing or close depending on the letter.
Advisor and regulatory fees: Financial, legal, accounting, tax, insurance, RWI premium, and HSR and other filings where applicable.
Target obligations: Principal, accrued interest, change-of-control premia and make-wholes, option and RSU cash-outs, and any 280G payments where applicable.
Taxes: Transfer taxes, stamp duty, withholding, and VAT on fees in some jurisdictions.

For templates and formatting ideas, see this practical LBO modeling template which complements the schedule without replacing it.

Worked example that never lies

A small numerical illustration grounds the mechanics. Assume enterprise value of 1,000. The target is cash free and debt free for valuation, but sellers will sweep 15 of excess cash. Net debt to repay is 200. Seller rollover is 10. Buyer transaction fees are 20. A senior term loan of 450 carries 2 percent OID. A revolver funds 25. Equity fills the gap.

Uses

Equity cash to sellers: 1,000 minus 200 plus 15 equals 815. Subtract 10 rollover equals 805.
Buyer fees: 20.
OID: 2 percent of 450 equals 9 which is a use with no payee.
Upfront lender fees: 3.
Minimum balance sheet cash: 10.

Total uses visible to funding equals 847.

Sources

Term loan net: 450 minus 9 OID minus 3 fees equals 438.
Revolver: 25.
Seller rollover: 10.
Equity plug: 847 minus 473 equals 374.

Two lessons are consistent across deals. OID is a use even without a wire. You pick one representation, either reduce proceeds or add a separate use, then stay consistent.

Accounting, reporting, and pro forma alignment

Under U.S. GAAP and IFRS, acquisition related costs are expensed as incurred, not capitalized into purchase price. Debt issuance costs offset the debt carrying amount and amortize to interest. OID is a discount and amortizes the same way. The schedule is not a financial statement, but you should flag which fees are expensed versus capitalized so cash planning is right and pro formas reconcile to capitalization tables.

If you deliver pro formas to lenders or investors, adjust for financing fees and OID amortization and strip one-time costs. Reconcile the pro forma to the sources and uses schedule and the debt cap table. For more background on structuring your debt schedule and linkages, review best practices before you start drafting.

Remember that the schedule is separate from purchase price allocation which is an accounting exercise after close.

Taxes and regulatory items that pull cash

Tax rules can limit interest deductibility at the group level and create unexpected uses. In the U.S., Section 163(j) caps deductible interest to a percentage of adjusted taxable income. OID amortization counts toward interest and can push your group over the line. Cross-border service fees and interest may face withholding. Gross-up obligations belong in uses if triggered at close. In the U.K., Corporate Interest Restriction rules bring a similar group cap. If you are close on solvency or liquidity, consider an equity reserve for disallowed interest to keep the closing test clean.

HSR and foreign investment filings come with fees and timing gates. In take-privates, dissenters’ rights and appraisal processes can require reserves and affect the path of cash consideration through exchange agents. Show these mechanics so both sides see the timing and liquidity impact.

Template architecture that does not break

Build a modular Excel file with no circularity. Use named ranges, fix sign conventions, and add simple checks. A strong architecture makes it easy to link to your three-statement model without polluting the closing schedule.

Inputs: Currency, valuation, net debt, working capital or locked box, rollover terms, equity treatment, fee categories, debt terms including par, OID, and upfront fees, and deal type toggles.
Sources and Uses: A single balanced table grouped by equity, debt, seller paper, and cash along with grouped uses for purchase price, payoffs, fees, and balance sheet items.
Equity Bridge: EV to equity value with adjustments for net debt, non-controlling interests, debt-like items, and leakage which links to cash to seller and rollover.
Debt Schedule: Par, OID, upfront fees, ticking fees, currency, and net proceeds checks with links to the commitment letter and fee letter.
Fees Register: Payee, responsible party, currency, expensed versus capitalized, and funding status.
Options and Incentives: Option and RSU cash-outs, acceleration, withholding, and MIP rollover.
Payoffs: Balances, per diem interest, premia, payoff letter references, and letters of credit or hedges with breakage.
Funds Flow Interface: Aggregates uses into payee-level wires.

Logic controls that prevent last minute gaps

Smart gating and scenario switches cut build time and catch errors early. These quick controls save headaches the week of close.

Use-of-proceeds gates: Each debt tranche has a permitted-use switch. If a use is not allowed, the model blocks funding from that source and highlights the gap.
OID and upfront split: OID reduces proceeds with no payee. Upfront fees are a cash use with a payee. Lock that rule.
Rollover math: Show rollover as both a reduction to cash to seller and a source. Fix the percentage basis and tax treatment.
Working capital versus locked box: Switch between post-close true-up and leakage with interest. The equity bridge should feed the cash to seller line correctly, which ties to your working capital drivers logic.
Currency control: Store input FX and convert at the base currency. Never mix currencies on a single line.
Scenario control: Base, flex, and syndication cases where flex increases OID and reduces proceeds within fee-letter limits.
Solvency and liquidity: Enforce minimum cash. If the test fails, increase equity automatically or flag the shortfall.

Fresh angle to adopt now: run a closing day dry run 48 hours before funds flow. Freeze inputs, print the schedule, and have the agent bank and counsel trace three payoffs end to end. This five minute drill often catches one miskeyed account number, one missing per diem, and one fee coding error before they become costly.

Deal specific add-ons you will need

Different deal types add predictable wrinkles. Prepare the scaffolding in your template so you can toggle them on when needed.

Take-private: Exchange agent wires, fractional shares, dissenters’ reserve, RSU and option acceleration, proxy solicitor and SEC fees, and fees tied to the marketing period in commitment papers.
Carve-out: TSA prepayments, one-time separation reimbursements, intercompany AR or AP true-up, and LC novations with a clear stranded costs classification.
Add-on: Carry forward existing debt, test baskets and MFN, include an earnout escrow if agreed, and keep contingent earnouts out of uses.
Equity backstop pending syndication: Interim equity or Holdco PIK, delayed-draw refinancing and ticking fees, and any reverse termination fee mechanics if marketing fails.
Cross-border: Withholding and gross-up, hedge premia or collateral if required at close, and a clean base currency presentation.

Debt, collateral, and consent constraints

Respect restricted payments and proceeds waterfalls. If tranches fund into different borrowers, map uses by borrower. Do not show Holdco advisory fees funded from OpCo secured proceeds if not permitted. Revolvers often cannot fund acquisition consideration. Use them for fees or balance sheet cash only when allowed and built into your revolver mechanics.

Lender and seller lens: what they check first

Lenders read permitted uses, test solvency and liquidity, compare OID and fees to the fee letter, and confirm payoff letters include per diem interest and release language. Sellers look for clean math from EV to cash, clear treatment of their expenses, tight payoff numbers, and minimal retainage via escrow. A concise checklist helps both sides align in one pass.

Implementation timeline, owners, and governance

Ownership and timing drive accuracy. Assign one owner per line and require dual approvals for price changes, large fees, or borrowing mix changes.

IOI to LOI: Light version with EV, rough net debt, term loan, and equity. Owner is the investment team. Purpose is to anchor bid equity. Speed is days.
Confirmatory diligence: Add net debt detail, working capital mechanics, employee equity, fees, and debt OID or fees. Owner is the modeler with finance counsel. Purpose is alignment with drafts. Speed is weeks.
Signing: Lock to signed purchase agreement and executed commitments and fee letter. Owner is the investment team and counsel. Purpose is disclosure to lenders. Speed is days.
Pre-close: Update for final net debt, working capital estimate, fee invoices, and draft funds flow. Owner is counsel and the admin agent with sponsor ops. Purpose is executable wires. Speed is days.
Closing: Run per diem, lock FX, confirm solvency metrics. Owner is agent and sponsor controller. Purpose is no shortfall. Same day.
Post-close: Working capital true-up and reconciliation of funds flows to bank statements. Owner is controller. Purpose is audit trail. Weeks.

Governance matters after close too. Archive the final model, equity bridge, funds flow, versions, Q&A, user access, and audit logs. Hash the archive and apply your retention policy. If a legal hold applies, it overrides deletion.

Common pitfalls and five minute kill tests

Most errors repeat. Build guardrails and a few fast tests you can run under pressure.

Frequent pitfalls: Double counting OID or deducting upfront fees twice, treating seller expenses as reductions to purchase consideration without support, missing make-whole or change-of-control premia, understating employee equity cash-outs and tax withholdings, ignoring stamp duty or withholding on advisory fees, misplacing rollover between Holdco subscription and consideration offset, mixing currencies within a line item, relying on the revolver to fund consideration when prohibited, and failing to match funds flow to uses.
Kill tests: Sources minus uses equals zero across toggles. Set OID to zero and proceeds should increase by the same amount. Switch to locked box and cash to seller should reflect leakage. Disable the revolver and the equity plug updates instantly. Increase purchase price by one when debt is maxed and sponsor equity rises by one.

Closing Thoughts

Treat the sources and uses schedule as the single source of truth for cash at close. Keep it modular, document tied, and lender compliant. Add a closing day dry run and a small equity cushion for safety. When this page is tight, you protect timing, credibility, and returns, and you also simplify the downstream integration of your three-statement model and lender deliverables.