Skip to main content
401kROBSCheck eligibility
Free browser worksheet

Deal Sources-and-Uses Builder

Build a closing ledger that separates uses from cash equity, ROBS-funded corporate equity, debt, seller financing, assumed debt, seller credits, and other documented sources.

Direct answer: this tool tells whether entered eligible sources equal, exceed, or fall short of listed deal uses. It does not approve a lender package, test affordability, set a valuation, recommend a capital structure, or decide whether ROBS is appropriate.

Author: Dennis ShirshikovUpdated: Aug. 13, 2026

Enter one closing sources and uses case

Use a purchase agreement, lender worksheet, franchise estimate, or closing statement when available. This browser form uses native FormData, does not save inputs, does not write local or session storage, and does not append query-string persistence.

Uses at closing

Purchase price or other consideration paid at closing. Do not reduce it here for seller credits entered below. Input accepts whole dollars, rounded to the nearest $1,000.

Buyer-paid transaction costs, closing costs, diligence costs, lender fees paid at close, transfer costs, and similar one-time costs. Input accepts whole dollars, rounded to the nearest $100.

Existing debt payoff or refinancing only when the closing sources must fund that payoff as a listed use. Input accepts whole dollars, rounded to the nearest $1,000.

Immediate working capital, opening reserve, deposits, payroll buffer, or inventory reserve needed at closing. Do not also count monthly expenses separately. Input accepts whole dollars, rounded to the nearest $1,000.

Immediate equipment, buildout, technology, vehicle, leasehold, or other capital expenditure needed at or right after close. Input accepts whole dollars, rounded to the nearest $1,000.

Other documented one-time uses in the closing ledger. Exclude ongoing revenue assumptions and recurring post-close monthly expenses. Input accepts whole dollars, rounded to the nearest $100.

Non-cash seller credit that explicitly reduces a listed use. It is handled as a contra-use and is not counted again as a cash source. Input accepts whole dollars, rounded to the nearest $100.

Sources at closing

Buyer cash or company equity cash available as closing proceeds outside ROBS and outside debt. Input accepts whole dollars, rounded to the nearest $1,000.

Corporate cash proceeds from a qualified plan purchase of employer stock. This is company equity, never personal cash to the buyer. Input accepts whole dollars, rounded to the nearest $1,000.

Bank, SBA-backed, conventional, equipment, or other lender debt proceeds funding listed uses. This worksheet does not test debt service. Input accepts whole dollars, rounded to the nearest $1,000.

Seller note principal used as a source. It is debt and should not also reduce purchase consideration or appear as a seller credit. Input accepts whole dollars, rounded to the nearest $1,000.

Assumed debt only when it actually funds a listed use or is part of closing consideration. Do not enter legacy debt merely because it remains after closing. Input accepts whole dollars, rounded to the nearest $1,000.

Other documented closing sources, not ongoing revenue and not existing target cash that is already counted in working capital. Input accepts whole dollars, rounded to the nearest $100.

Net uses

$910,000

Eligible sources

$900,000

Status

$10,000 gap

Reconciliation worksheet

Equity sources

$300,000

Includes cash equity $125,000 and ROBS-funded corporate equity $175,000.

Debt sources

$600,000

Includes lender debt, seller financing, and assumed debt only when entered as funding listed uses.

Buyer cash requirement fact

$125,000

Only entered buyer or company equity cash is shown as a cash requirement. ROBS proceeds are corporate equity proceeds, not personal cash.

Debt and equity mix

Debt 65.9% of uses; equity 33.0% of uses.

Shares use net uses as denominator when uses are greater than zero. Eligible-source shares use total eligible sources when sources are greater than zero.

Purchase consideration

Buyer-paid purchase price or consideration included in the closing ledger.

Uses
$750,000
Sources
-

Transaction and closing costs

Buyer-paid closing costs and transaction costs counted once.

Uses
$28,000
Sources
-

Debt payoff or refinancing

Only debt payoff that closing sources must fund.

Uses
-
Sources
-

Immediate working capital

Opening working capital or reserves needed at close, not monthly expenses counted again.

Uses
$90,000
Sources
-

Immediate capital expenditures

Equipment, buildout, or other capital spending required at or immediately after close.

Uses
$35,000
Sources
-

Other closing uses

Other documented one-time uses in the closing ledger.

Uses
$12,000
Sources
-

Seller credit contra-use

Non-cash seller credit reducing a listed use. It is not cash proceeds.

Uses
-$5,000
Sources
-

Buyer or company equity cash

Cash equity contributed outside ROBS and debt.

Uses
-
Sources
$125,000

ROBS-funded corporate equity

Corporate cash proceeds from qualified-plan purchase of employer stock, not personal cash.

Uses
-
Sources
$175,000

Lender debt proceeds

Debt proceeds funding listed uses.

Uses
-
Sources
$520,000

Seller financing

Seller note principal treated as debt source, not a purchase-price reduction.

Uses
-
Sources
$80,000

Assumed debt funding a listed use

Assumed debt counted only when it funds a listed use or part of closing.

Uses
-
Sources
-

Other documented sources

Other source documented as closing proceeds, not ongoing revenue.

Uses
-
Sources
-

Net uses = purchase consideration + closing costs + closing debt payoff + immediate working capital + immediate capital expenditures + other closing uses − explicit seller-credit contra-use. Total eligible sources = buyer/company cash + ROBS-funded corporate equity + lender debt + seller financing + assumed debt funding a listed use + other documented sources.

$915,000 gross uses − $5,000 seller-credit contra-use = $910,000 net uses. $300,000 equity sources + $600,000 debt sources = $900,000 eligible sources. $900,000 − $910,000 = -$10,000 gap.

Unrounded details: gross uses 915000, seller-credit contra-use 5000, total uses 910000, cash sources 125000, equity sources 300000, debt sources 600000, total eligible sources 900000, gap or surplus -10000.

Assumptions and boundaries

  • All amounts are modeled at closing or immediately after closing. Ongoing revenue is not a source in this worksheet, and post-close monthly operating expenses are not uses unless they are part of the immediate working-capital amount.
  • Debt payoff or refinancing belongs in uses only when the closing sources must fund that payoff. Existing debt is not a source unless assumption of that debt actually funds a listed use or forms part of the closing settlement.
  • Seller credits are contra-uses here, not cash. Do not also enter the same credit as other sources.
  • Existing cash inside the target business is not a buyer source unless the purchase agreement and closing statement make it available to fund a listed use without double counting working capital.
  • This worksheet reconciles arithmetic only. It does not determine lender, SBA, ROBS, legal, tax, accounting, fiduciary, valuation, structure, or approval outcomes.

Buyer cash facts this worksheet can defend

  • Buyer or company equity cash is the only personal or corporate cash requirement this worksheet can identify from entered sources.
  • ROBS-funded corporate equity is stock-purchase proceeds received by the corporation from a qualified plan, not personal cash available to the buyer.
  • Seller credits reduce a listed closing use only when entered as an explicit contra-use. They are not counted again as cash proceeds.

What belongs in sources and uses

Use a sources-and-uses schedule for one timing point: the closing and immediate post-close funding need. SBA business-plan guidance treats funding needs, requested debt or equity, use of funds, and projections as separate parts of the financing request [1]. SBA 7(a) guidance also lists distinct loan purposes such as changes of ownership, working capital, current business debt refinancing, and equipment or supplies [2].

Uses are amounts the transaction must pay or reserve: purchase consideration, transaction and closing costs, debt payoff only when the closing funds that payoff, immediate working capital, immediate capital expenditures, and other one-time closing uses. Do not add ordinary monthly expenses separately if they are already inside the working-capital reserve.

Sources are proceeds available to meet those uses: buyer or company cash equity, ROBS-funded corporate equity, lender debt, seller financing, assumed debt only when it funds a listed use or forms part of closing, and other documented sources. Ongoing revenue is not a closing source.

Double-counting boundaries

Seller credits are handled as explicit contra-uses. They reduce a listed use and are not cash proceeds. Entering the same seller credit again as other sources would overstate funding.

Assumed debt is not always new funding. Count assumed debt as a source only when it directly funds a listed use or is part of the closing settlement. If old debt simply remains with the business and does not fund the closing ledger, leave it out and model it elsewhere.

Existing target cash can also be easy to double count. If the purchase price already reflects normalized working capital, do not also treat the same cash as a buyer source. If a closing statement explicitly leaves cash in the company to satisfy a working-capital requirement, document that treatment before entering it.

ROBS source classification

In a typical ROBS structure, available retirement assets roll into a qualified plan sponsored by a C corporation, and the plan purchases employer stock. The corporation receives the stock-purchase proceeds, while the plan holds employer stock [3] [4]. That is why the worksheet labels this line as ROBS-funded corporate equity rather than buyer cash.

This classification does not decide whether the ROBS transaction is properly structured, valued, documented, or administered. IRS materials identify case-by-case review, valuation, filing, prohibited-transaction, plan-operation, business-failure, bankruptcy, lien, and dissolution concerns [3] [4].

What this builder does not determine

The builder is arithmetic. It does not calculate debt service or affordability, value the business, test SBA eligibility, approve lender equity injection, validate seller financing terms, recommend debt or equity mix, or decide purchase structure. Ongoing revenue is not a source, and post-close monthly operating expenses are not uses in this closing ledger.

It also does not provide legal, tax, accounting, fiduciary, ROBS, valuation, lender, or SBA approval advice. Review the actual purchase agreement, closing statement, lender term sheet, plan documents, corporate records, valuation support, and tax treatment with qualified professionals.

Need affordability math?

Use the adjacent calculator for buyer cash, debt service, DSCR, and liquidity checks.

Business Purchase Affordability Calculator

Need ROBS plus SBA mix?

Use the funding-mix calculator when the question is how ROBS equity and SBA debt combine.

ROBS and SBA Funding-Mix Calculator

Need account screening?

Screen account type and availability before treating retirement assets as a possible ROBS source.

Eligible Retirement Account Checker

Sources and verification

  1. [1] SBA Plan your business. SBA says a business plan funding request should explain how much funding is needed, whether debt or equity is requested, terms, timing, how funds will be used, and financial projections. Checked Aug. 13, 2026; page modified July 30, 2026.
  2. [2] SBA 7(a) loans. SBA states 7(a) loans may be used for changes of ownership, working capital, refinancing current business debt, equipment, furniture, fixtures, supplies, and multiple-purpose loans. SBA also states borrowers work directly with lenders and must be creditworthy with reasonable ability to repay. Checked Aug. 13, 2026; page modified July 27, 2026.
  3. [3] IRS ROBS compliance project. IRS describes ROBS as retirement funds rolled into a plan that buys stock of a new C corporation, and notes determination letters do not approve plan operations. It identifies valuation, filing, prohibited-transaction, business-failure, bankruptcy, lien, and dissolution concerns. Page last reviewed Nov. 16, 2025.
  4. [4] IRS ROBS guidelines memorandum. The IRS memorandum describes the typical ROBS sequence, including C corporation formation, plan creation, rollover or transfer to the plan, and plan purchase of employer stock. The memorandum says arrangements are not noncompliant per se but must be developed case by case. Dated Oct. 1, 2008.