A business acquisition can appear fully financed until the buyer adds closing costs, lender fees, existing debt payoffs and the working capital needed after taking ownership.
The seller's asking price is only one part of the transaction. A lender may agree to finance part of the acquisition while leaving specific costs unfunded. Seller financing may also reduce the cash due at closing without providing money to pay operating expenses.
A business acquisition sources-and-uses worksheet helps identify these differences before they become closing problems.
Quick Answer: A business acquisition sources-and-uses worksheet compares the total cost of buying and operating a company with available buyer cash, financing proceeds and documented seller credits. The difference is the funding gap. Calculate both projected and committed funding, account for fees and debt payoffs, and preserve enough cash to operate after closing.
Download the Free Business Acquisition Sources-and-Uses Worksheet
Business Acquisition Sources and Uses — Excel Workbook
Editable USD acquisition budget, proposed and committed funding gaps, cash-reserve checks, repayment estimates and closing checklist.
Download the Excel worksheet (.xlsx)
The workbook contains seven worksheets: START HERE, FUNDING SUMMARY, DEAL INPUTS, USES, SOURCES, DEBT TEST and CLOSING CHECKLIST.
Enter your purchase price, debt payoffs, transaction expenses, financing amounts and available equity. The workbook automatically calculates the funding gap and distinguishes proposed financing from committed sources.
It also checks whether the buyer retains a chosen cash reserve and provides an illustrative monthly debt-payment analysis.
The sample transaction is hypothetical. Replace its figures with your own documents and financing terms. The tool is not an SBA eligibility determination, lender approval or formal closing statement.
What Are Sources and Uses in a Business Acquisition?
A sources-and-uses schedule is a financial statement showing how much money a transaction requires and where that money will come from.
Uses of funds represent the total acquisition costs and cash requirements.
Sources of funds represent buyer contributions, financing proceeds, investor capital and other documented consideration available to complete the transaction.
The basic calculation is:
Funding Gap=Total Uses−Total Sources\text{Funding Gap}=\text{Total Uses}-\text{Total Sources}Funding Gap=Total Uses−Total SourcesFor example, if a business acquisition requires $760,000 and the buyer has arranged $735,000 in financing and other consideration, the projected funding gap is $25,000.
But a mathematically balanced transaction is not necessarily financeable.
A proposed loan may still require final underwriting, documentation, collateral verification or other closing conditions. A seller note may reduce the amount paid in cash without providing usable money for legal fees or payroll.
That is why the worksheet calculates both a projected gap and a committed-funds gap.
For SBA-backed transactions, the SBA's settlement and use-of-proceeds documentation illustrates why the approved uses, borrower contribution and actual disbursements must be properly documented.
What Belongs on the Uses-of-Funds Side?
The uses side should represent the complete project, not simply the amount written into the purchase agreement.
A useful acquisition budget separates the following:
Purchase consideration: The agreed price for the business, assets or ownership interests, including consideration deferred through an eligible seller note.
Additional debt payoffs: Obligations that must be settled at closing and are payable on top of the stated price.
Purchase-price adjustments: Inventory true-ups, working-capital adjustments or other contractual amounts due at closing.
Professional and financing costs: Legal, accounting, valuation, lender, filing and settlement expenses.
Transition investments: Necessary equipment repairs, technology migration, employee training and other planned integration expenses.
Post-closing liquidity: Operating cash reserves and a separately identified contingency.
A buyer should confirm whether each cost is payable immediately, funded into an escrow or reserve at closing, or incurred later.
An expense planned for six months after closing does not necessarily need to be paid to a vendor on closing day. However, if the financing plan depends on setting aside money for that expense, the reserve must still be funded.
Should equipment already included in the purchase price be added again?
No.
Suppose a manufacturing business sells for $600,000, including machinery valued at $180,000.
The uses schedule generally starts with the full $600,000 purchase consideration. Adding another $180,000 simply because the equipment has been valued separately would overstate the transaction.
The equipment allocation may help establish the appropriate financing structure, but it is not an additional purchase expense.
See how equipment financing fits into a U.S. business acquisition for the differences between an acquisition loan, an equipment-specific facility and financing involving a stock purchase.
What if the seller still owes money on equipment?
Determine whether the debt will be paid from the existing purchase consideration or requires additional buyer funding.
If the purchase is priced on a cash-free, debt-free basis, the closing documents may direct some seller proceeds to existing creditors.
That does not automatically increase the buyer's total cost.
If the buyer has separately agreed to pay additional obligations above the purchase consideration, those amounts may belong in the uses schedule.
Request payoff letters and clarify the required lien releases. Existing equipment liens and UCC priority can affect both the acquisition and any new secured financing.
The rule is simple: include each economic obligation once.
What Counts as a Source of Funds?
The sources side identifies how the project will be financed.
Typical sources include buyer cash, cash equity from investors, senior acquisition debt, equipment financing, seller financing and an approved initial draw on a working-capital facility.
However, these sources are not interchangeable.
A buyer contribution is cash that the buyer can actually make available.
A conventional acquisition loan supplies funds that must be repaid under the lender's agreement.
Seller financing represents a portion of the purchase consideration that the seller agrees to receive later.
A line of credit provides revolving borrowing capacity, but only an amount actually available and intended to be drawn at closing should be included as a funded source.
For larger transactions involving several financing providers, Mehmi's guide to $50 million-plus U.S. acquisition capital stacks explains how senior debt, junior capital, seller notes and equity can interact.
A smaller business acquisition should generally keep the structure as straightforward as the transaction allows.
Does seller financing count as cash?
No. A seller note is deferred purchase consideration.
Suppose you purchase a business for $600,000 and the seller agrees to accept $75,000 through a promissory note.
The seller receives $525,000 in cash consideration at closing, assuming no other purchase adjustments.
The sources-and-uses schedule can show the entire $600,000 purchase price as a use and $75,000 of seller financing as a source of deferred consideration.
But the seller note cannot pay a third-party accountant or fund working capital.
The workbook therefore labels seller notes as price credits, rather than immediately available cash.
The note's interest, payment commencement, maturity, security, subordination and any standby requirements must also be considered.
Can an already-paid deposit count as a source?
Yes, as a credit against the purchase price when the closing documents support it.
For example, a buyer may have already paid a $20,000 earnest-money deposit.
That amount can reduce the cash consideration still due at closing, but it should not also be counted as unrestricted cash currently available in the buyer's bank account.
The downloadable worksheet has a separate source row for deposits already paid and credited against the purchase price.
This prevents the same $20,000 from being counted twice.
How Does the Worksheet Calculate the Real Funding Gap?
The workbook provides two calculations because acquisition financing rarely moves from the first proposal directly to unconditional funding.
Projected funding gap
The projected gap considers all sources marked as expected to be available at closing, including indicative financing.
This answers:
If every proposed source funds as expected, how much money is still missing?
A positive amount means the proposed structure is incomplete.
A zero balance means only that the entered amounts add up.
Committed funding gap
The committed gap counts only sources that the user has marked both committed and available at closing.
It answers a stricter question:
How much of the transaction has not yet been covered by documented financing or consideration?
A lender indication should not be marked committed merely because the requested amount appears affordable.
Even written financing commitments may contain conditions that must be satisfied before disbursement. The worksheet's status field is an organizational aid, not a legal determination that funding is unconditional.
The buyer must verify each financing source against the actual agreement.
How Do Loan Fees Change the Amount Available at Closing?
Financing fees can create a funding gap when the buyer confuses gross loan principal with net proceeds.
Assume a conventional lender agrees to finance $500,000 and charges a hypothetical $10,000 origination fee.
If the fee is withheld from disbursement, the amount wired to the closing account may be $490,000.
A consistent sources-and-uses schedule can show:
Gross loan source: $500,000.
Origination fee use: $10,000.
Net cash available from the loan after the fee: $490,000.
Do not enter $490,000 as the loan source and then subtract the same $10,000 fee again.
That would double-count the financing cost.
Actual fee treatment depends on the loan agreement. Some fees are paid separately, some may be financed where permitted and others may be deducted from proceeds.
Closing expenses can also include appraisal, legal, title, filing or guarantee-related charges.
Buyers comparing providers should review more than the stated loan amount. Mehmi's U.S. business loan marketplace guide discusses the importance of comparing repayment, costs, collateral and guarantees rather than treating all financing proposals as equivalent.
Illustrative Example: A $760,000 Business Acquisition With a $25,000 Funding Gap
Consider a hypothetical U.S. buyer acquiring an established commercial services business.
The transaction has a $600,000 purchase price, but the complete budget includes several additional expenses.
Assume the buyer has identified $25,000 of debt payoffs payable outside the agreed price, a $20,000 inventory adjustment, $20,000 in legal and accounting fees, $10,000 in financing charges and $15,000 in equipment repairs and systems migration.
The buyer also plans to retain $60,000 of operating cash in the acquired business and allocate $10,000 to a separate contingency.
Total acquisition uses
$760,000Proposed funding and price credits
$735,000Projected funding gap
$25,000Gap using committed sources only
$565,000The proposed financing includes $120,000 in buyer cash, a $500,000 acquisition term loan, a $40,000 equipment loan and a $75,000 seller note.
These total $735,000.
The $75,000 seller note is a deferred portion of the purchase price. The remaining proposed sources include $660,000 of cash.
The cash required after the seller note is $685,000, leaving the same $25,000 projected gap.
However, assume only the $120,000 buyer contribution and $75,000 seller note are currently classified as committed. The two proposed loans are still indicative.
Committed sources therefore total $195,000, leaving $565,000 not yet covered by committed sources.
That does not mean the buyer necessarily needs another $565,000 of equity. It means that amount remains dependent on arranging or finalizing funding.
Can the buyer simply contribute another $25,000?
Possibly, but available cash must be considered.
Assume the buyer has $160,000 in unrestricted cash before closing and wants to retain at least $25,000 outside the acquisition.
After contributing the original $120,000, $40,000 remains.
Only $15,000 of that balance is available above the buyer's chosen minimum reserve.
If the buyer contributed another $25,000, their remaining cash would fall to $15,000—$10,000 below the intended liquidity floor.
A sensible response might involve negotiating a lower purchase price, securing another legitimate funding source or contributing $15,000 and resolving the final $10,000 separately.
Reducing the acquired business's $60,000 operating reserve solely to balance the worksheet may be more dangerous than it appears.
What would the proposed debt cost?
For illustration, assume all three financing obligations use fixed nominal annual interest rates and equal monthly payments, with no balloons.
The $500,000 acquisition loan carries an assumed 10% rate over 120 months, producing a monthly payment of approximately $6,607.54.
The $40,000 equipment loan uses 9% over 48 months, producing approximately $995.40 per month.
The $75,000 seller note uses 8% over 60 months, producing approximately $1,520.73 per month.
During the first 48 months, combined payments on these new obligations are approximately $9,123.67 per month.
Across their respective full terms, the three obligations produce approximately $931,927.48 in scheduled principal-and-interest repayments, including $316,927.48 in interest. The $10,000 of assumed financing charges is included separately in the project uses.
These are hypothetical mathematical terms, not current lender quotes or Mehmi offers. The calculation excludes additional financing fees, taxes, prepayment charges, irregular payments and seller-note standby arrangements. No fee-inclusive APR is represented.
Now assume the business has $24,000 of normal monthly cash available before all debt payments, plus $2,000 of existing monthly debt service.
Combined debt service would be approximately $11,123.67 monthly.
Normal debt-service coverage is approximately 2.16 times. If cash available falls to $16,000 during a weaker month, coverage declines to approximately 1.44 times.
Actual lender definitions and required coverage differ. The illustration is a repayment stress test, not an approval prediction.
How Much Working Capital Should Remain After Closing?
The correct working-capital amount depends on the acquired business's operating cycle.
A wholesaler buying inventory before customers pay invoices may require more liquidity than a service business receiving payments at completion.
A practical forecast should identify the cash needed for payroll, rent, suppliers, insurance, taxes, fuel and existing debt during the first 13 weeks after closing.
Then account for expected customer deposits and any likely collection delays.
The $60,000 operating reserve in the example is an assumed amount, not a recommended minimum for acquisitions generally.
It is also important to establish whether the seller's cash, accounts receivable, inventory and payables transfer with the business.
An acquisition agreement may include a working-capital target and closing adjustment. If the delivered working capital differs from the agreed amount, the purchase consideration may change.
The worksheet's price-adjustment row should reflect the anticipated effect without duplicating inventory or other amounts already included.
For an explanation of operating cash needs, review working capital for everyday business expenses.
Where the target invoices commercial customers, business financing between customer payments provides additional context on revolving credit and receivables-based structures.
A short-term cash gap and an ongoing operating loss are different problems. The acquisition should not require continuous emergency borrowing just to meet normal expenses.
Which Financing Options Can Close a Business Acquisition Funding Gap?
There is no single product that automatically fills every acquisition shortfall.
A conventional acquisition term loan may finance a qualifying portion of the purchase consideration. Separate equipment financing may support identifiable assets when the transaction and collateral are acceptable.
Seller financing can defer part of the price, while additional buyer or investor equity can reduce the amount borrowed.
A revolving facility may help with qualifying post-closing operating needs, but only approved draws should be included as funds available at closing.
Can SBA 7(a) financing cover multiple acquisition expenses?
Potentially.
The U.S. Small Business Administration's 7(a) program permits eligible complete and partial ownership changes, equipment purchases, working capital, qualifying debt refinancing and multiple-purpose financing.
The maximum 7(a) loan amount is $5 million.
Eligibility, permitted uses, equity requirements and underwriting conditions remain subject to the applicable SBA rules and participating lender's review.
The governing SBA SOP 50 10 version 8.1, effective October 1, 2026, distinguishes categories of change-of-ownership transactions.
Do not apply one assumed equity percentage or seller-note treatment to every acquisition.
A conventional lender may apply different standards. The worksheet is designed to organize funding rather than determine compliance with any particular lending program.
When should you reduce the acquisition budget instead of borrowing more?
Borrowing more is not always the best response to a funding gap.
If the purchase price exceeds a supportable valuation, the buyer may need to renegotiate.
If equipment repairs, working-capital requirements or operating liabilities are materially higher than initially disclosed, the transaction economics may need to change.
If the target is experiencing declining revenue, additional debt can make the transition harder.
Review financing risks during a revenue decline before assuming that short-term borrowing will solve a structural earnings problem.
What Documents Should Support a Lender-Ready Sources-and-Uses Schedule?
The workbook is a starting point. Every major number should eventually be supported by a reliable document.
A lender-ready package generally includes the purchase agreement or letter of intent, historical financial statements, tax returns where required, interim results, existing debt schedule, evidence of buyer funds, seller-note terms and current financing proposals.
Other relevant records can include equipment schedules, appraisals, lien searches, accounts-receivable and accounts-payable aging, customer concentration and lease or franchise agreements.
Lenders may examine the buyer's credit, industry experience, operating history, existing obligations, collateral and combined post-acquisition repayment capacity.
An agreed purchase price alone does not establish lender-supported value.
The lender may also request a cash-flow forecast showing how the acquired business will operate after the ownership transition.
For the next stage, see what lenders evaluate after a business ownership change and when to apply for additional financing after buying a business.
What should happen immediately before closing?
Reconcile the final purchase price, adjustments, fees and payoff amounts against the closing statement.
Confirm when each source will become available, which account receives the funds and whether any lender conditions remain outstanding.
Verify that previously paid deposits are credited correctly, secured creditors receive agreed payoffs and financing proceeds are not overstated.
A transaction that balances on paper can still fail to close if funds arrive after the scheduled settlement or a required lien release is missing.
A qualified U.S. attorney and closing professional should coordinate the legal transfer and disbursement instructions.
For qualifying asset acquisitions, the IRS instructions concerning Form 8594 also explain when buyer and seller must report the allocation of consideration among business assets.
The worksheet does not perform that tax allocation.
Frequently Asked Questions About Acquisition Sources and Uses
Does a zero funding gap mean my business purchase is approved?
No. It means the amounts entered into the worksheet balance.
Lender approval, funding availability, valuation, collateral, legal requirements and final closing conditions must be assessed separately.
A zero projected gap can still coexist with a substantial committed-funds gap.
Can seller financing count toward the required buyer equity?
Not automatically.
Seller financing is ordinarily a debt obligation or deferred purchase consideration.
Certain lending programs may allow specifically structured seller debt to receive particular treatment toward required equity, subject to applicable rules and conditions.
The worksheet should not be used to establish whether a seller note qualifies as an SBA equity contribution.
Should I count my entire approved line of credit as a funding source?
No. Count only the amount expected to be available and drawn for an eligible purpose at closing.
The unused portion of a revolving facility may provide future liquidity, but it is not cash already funded into the acquisition.
Should an operating cash reserve appear under uses?
Yes, when that cash must be funded at closing and retained for operations.
It is not an expense in the same sense as legal fees or interest. The money remains available to the business, but someone must supply it.
Do not also count it as unrestricted buyer cash available outside the transaction.
What happens if the purchase price changes before closing?
Update the uses schedule with the revised purchase consideration and contractual adjustments.
The projected and committed funding gaps will recalculate.
Also review whether the lender needs to reconsider the approval, valuation, equity contribution or permitted uses.
Can I use the worksheet for an asset purchase or stock purchase?
Yes, as a planning framework.
However, the structure affects what is actually being acquired, which liabilities remain, how existing debt is treated and which consents or tax provisions apply.
The applicable closing documents and professional advice determine the correct entries.
What if the funding gap cannot be resolved?
The buyer may need more equity, a revised purchase agreement, different financing, a delayed closing or a smaller transaction.
If the acquisition cannot support reasonable debt payments and essential operating reserves, declining the purchase may be more prudent than accepting an unsustainable financing structure.
Discuss Your Business Acquisition Funding Gap With Mehmi Financial Group
A complete sources-and-uses schedule helps distinguish the amount needed to close from the financing the acquired business can responsibly repay.
If the worksheet identifies a shortfall, determine whether the problem comes from the purchase price, fees, insufficient buyer equity, limited lender proceeds or working capital requirements.
Mehmi Financial Group is a commercial financing brokerage and intermediary, not a direct lender. It can help evaluate possible business acquisition financing structures through independent providers where its services are legally available. Financing providers make their own underwriting, pricing and approval decisions.
U.S. availability is subject to state and transaction restrictions. Under Mehmi's published disclaimer, general commercial loan-broker applications involving borrowers principally located in California, Illinois, Missouri, Nebraska, North Carolina, North Dakota or Vermont are generally not accepted unless appropriate authorization or an exemption has been confirmed. Additional product-specific restrictions apply.
To review a proposed acquisition, contact Mehmi Financial Group or call 833-863-4644.
Provide the purchase amount in USD, the U.S. state, acquisition structure, intended use of funds, available equity, estimated funding gap and expected closing timeline.
The goal is not merely to make the sources equal the uses. It is to establish a transaction that can close with adequate liquidity and remain financially manageable afterward.