Sources & Uses: Modeling Fees, Working Capital & Cash at Close | ModelReef
back-icon Back

Published February 13, 2026 in For Teams

Table of Contents down-arrow
  • Quick Summary
  • Introduction
  • A Simple Framework
  • Step-by-Step Implementation
  • Real-World Examples
  • Common Mistakes to Avoid
  • FAQs
  • Next Steps
Try Model Reef for Free Today
  • Better Financial Models
  • Powered by AI
Start Free 14-day Trial

Sources & Uses: Modeling Fees, Working Capital & Cash at Close

  • Updated February 2026
  • 11–15 minute read
  • Mergers & Acquisitions
  • Deal structuring
  • M&A working capital
  • Sources and uses

⚡ Quick Summary

  • The sources & uses table is the cash control centre of any deal – it shows exactly where money comes from and where it goes on day one.
  • Good tables connect cleanly to your operating cash flow model, debt schedule, and cash flow statements, so nothing “disappears” in M&A accounting.
  • You should model equity, debt, vendor finance, and rollovers on the sources side, then fees, purchase price, working capital items, and cash at close on the uses side.
  • Working capital pegs and cash true-ups need explicit rows and timing, or you’ll misrepresent real cash flow in mergers.
  • Fees, OID, and other frictional costs must be treated as cash, not tucked into goodwill only.
  • The right structure makes it easy to test alternative company valuation methods (different prices, leverage, or vendor financing) without breaking the model.
  • If you’re short on time, remember this: one clear, linked sources & uses schedule is worth more than ten disconnected tabs.

💡 Introduction: Why This Topic Matters

Every stakeholder in an M&A deal eventually asks the same question: “Where is the cash actually going?” Your sources & uses schedule is the single answer. It shows investors, lenders, and management exactly how the transaction is funded and how much reaches sellers, fees, and the balance sheet. When built in isolation, it quickly diverges from the rest of your cash flow model, creating reconciliation headaches and surprises at closing. When built as part of a coherent M&A cash flow stack, it becomes the bridge between valuation, documentation, and day-one liquidity. This guide shows you how to structure sources & uses so fees, working capital, and cash at close all line up cleanly with your broader DCF and working capital models.

🧩 A Simple Framework You Can Use

Use a three-layer framework:

  1. Economic purchase price: equity value, net debt, and any other adjustments flowing from your discounted cash flow model or comparable company valuation methods.
  2. Funding mix: equity, bank debt, mezzanine, seller notes, and any vendor finance, ideally consistent with your debt modelling.
  3. Cash deployment: purchase price, fees, leakages, working capital items, and cash left on the balance sheet at close.

Treat the sources & uses as a single table powered by drivers: leverage ratios, fee percentages, peg levels, and minimum cash requirements. Keep it integrated with your operating cash flow statementsso changes to structure instantly show up in covenant headroom and liquidity views.

🛠️ Step-by-Step Implementation

Step 1: Define or prepare the essential starting point

Start with your agreed valuation range. Take enterprise value from your discounted cash flow model or other company valuation methods, then adjust for net debt and any normalised working capital assumptions. Confirm what’s being bought: shares, assets, or a carve-out. Gather key deal terms – rollover equity, seller reinvestment, earnouts, and vendor finance – and input them as high-level parameters. At this stage, you also need draft estimates of transaction fees (advisers, legal, financing fees, stamp duty)and an initial view on the working capital peg. Build a blank sources & uses layout with placeholders for each component. The aim is to make sure every dollar of consideration and friction is captured somewhere in the table before you layer in detailed mechanics.

Step 2: Walk through the first major action – model the sources

On the sources side, structure capital in a way that matches your funding strategy and lender expectations. Typical categories include equity injection, management rollover, senior debt, mezzanine, vendor notes, and any PIK instruments. Link each to simple drivers: target leverage multiples, minimum equity cheque, or fixed seller note amounts. This lets you flex combinations without rewriting formulas. Where applicable, treat OID and financing fees as separate uses that reduce proceeds but don’t count as principal. Ensure that any pre-funded items, such as escrowed capex or pre-funded working capital, are clearly separated. The goal is a transparent view of “who is writing which cheque”, fully consistent with your ongoing debt and cash flow model.

Step 3: Introduce the next progression – model the uses and working capital peg

Now fill in the uses side. Start with equity value to sellers, then add debt payoff, transaction fees, and capitalised financing fees. Crucially, model the working capital peg and associated cash flow in mergers explicitly: show any cash top-up required if closing working capital falls short, or cash released if it exceeds the peg. Connect these rows back to your working capital and cash flow statements, so your 13-week or annual cash views reflect the same mechanics. If the deal includes cash left on the balance sheet, set a minimum cash requirement and calculate any excess as a separate line. This clarity prevents last-minute disputes and helps everyone understand what “cash-free, debt-free” really looks like in your schedule.

Step 4: Guide through an advanced or detail-heavy action – add fees, OID, and timing

Fees cause more confusion than almost any other part of sources & uses. Separate adviser and legal fees, financing fees, and stamp or transfer taxes. For each, specify whether it’s paid at close, capitalised, or amortised through M&A accounting. Mirror that treatment in your cash flow statements: all are cash at some point, even if accounting recognition differs. For OID and similar instruments, calculate cash impact separately from face value, and ensure your debt schedule uses net proceeds while your covenant and interest calculations use gross notional. Finally, build timing flags so items that settle after close (e.g., some true-ups or fee holdbacks) appear in later periods of your cash flow forecasting model, aligned with your 13-week headroom views.

Step 5: Bring everything together and prepare for the outcome or completion

Once the table balances – total sources equals total uses – connect it into the rest of your cash flow model. Feed net new debt and equity into your balance sheet and financing cash flow statements, and feed peg and true-up logic into your working capital schedules. Create a small dashboard that shows pre- and post-transaction leverage, cash at close, and pro forma liquidity over the next 13 weeks. Then pressure-test the structure: flex price, leverage, and peg levels to see how sensitive headroom is. Use these views in negotiations with lenders and sellers, and later as a reference point when you track whether the deal delivered the cash profile you modeled. A clean, linked sources & uses schedule becomes the backbone of that entire discussion.

📌 Real-World Examples

Consider an industrial acquisition where the buyer wants to push leverage while funding a large capex program soon after close. The team builds an integrated sources & uses schedule that shows equity, senior debt, mezzanine, and a vendor note, then layers in adviser fees, financing fees, and a conservative working capital peg. By connecting this schedule to a 13-week cash view and covenant model, they discover that a slightly higher minimum cash level and marginally lower leverage greatly reduce default risk. They restructured the deal by increasing the equity cheque and using vendor terms more aggressively. Because the sources & uses are cleanly linked to the broader cash flow model, these changes can be evaluated in minutes, not days.

⚠️ Common Mistakes to Avoid

Teams often treat sources & uses as a static presentation slide rather than a dynamic part of the cash flow model. That leads to inconsistencies between what’s shown to boards and what sits in the 13-week or multi-year cash flow statements. Another mistake is burying fees and OID inside accounting adjustments, which hides real cash flow in mergers and leaves lenders uncomfortable. A third trap is modelling the working capital peg loosely or off to the side, so the true cash impact at close is unclear. The fix is to model everything as explicit rows, connect them to timing and drivers, and keep the schedule tightly integrated with your DCF, debt, and working capital models.

❓ FAQs

Aim for clear categories, not line-by-line minutiae. You want enough detail to separate types of funding, fees and cash movements, but not so much that small changes become unmanageable. Anything that materially affects cash flow in mergers (leverage, fees, working capital pegs, minimum cash) deserves its own row. You can always provide supporting schedules for auditors and banks if needed.

The peg sets a target for working capital at close; deviations lead to cash paid or received in the true-up. That cash impact should appear both in your sources & uses and in near-term cash flow statements, often within the 13-week view. Aligning peg logic with your ongoing working capital model helps you see how quickly the asset moves to its steady-state cash profile post close.

Yes, at least at a high level. Seller notes belong on the sources side as part of funding, while earnouts typically appear as contingent uses, either at notional or expected value. Even if the timing and amount are uncertain, including them makes conversations about true leverage and future cash flow model obligations more honest. You can refine these as terms are negotiated.

Drive sources & uses from a small set of parameters: purchase price, leverage targets, fee percentages and peg level. As term sheets evolve, update those assumptions and let formulas flow through. Keep the schedule under version control so you can compare iterations and understand how each change affected cash at close and leverage. This makes your table a live negotiation tool, not a static artefact.

➡️ Next Steps

With a robust sources & uses framework in place, your next move is to embed it into every deal model, not rebuild from scratch each time. Turn the schedule into a reusable template that plugs into your DCF, working capital, and debt modules. Pair it with a dedicated working capital peg and true-up model and a transaction cost schedule, so all major day-one cash items are visible and consistent. Finally, connect sources & uses to your post-close tracking pack, so you can see whether the cash actually landed where you expected. When everyone – from IC to lenders – can see “where the money went” in one clean view, deal conversations become faster, clearer, and more confident.

Start using automated modeling today.

Discover how teams use Model Reef to collaborate, automate, and make faster financial decisions - or start your own free trial to see it in action.

Want to explore more? Browse use cases

Trusted by clients with over US$40bn under management.