Sources and Uses
Sources and uses is a two-sided table that lists where every dollar in a transaction comes from and where every dollar goes, and the two sides must total the same amount.
What is the sources and uses formula?
Total sources = total uses
Cash to borrower on a refinance = new loan - payoffs - closing costs - required reserves and escrows
- Sources: the senior loan, any subordinate debt, sponsor equity and any seller financing or credits.
- Uses: the purchase price or loan payoffs, closing costs, fees, reserves and escrows, construction or renovation costs, and any cash returned to the borrower.
- Payoffs: the balances of the loans being repaid, from payoff letters, with accrued interest and exit fees.
A table that does not balance has an error or an unexplained party in it.
What do the sample refinance's sources and uses show?
Illustrative figures. The 96-unit community is being refinanced with a $9,000,000 loan that retires the bridge and mezzanine loans used to buy and renovate it.
| Sources | Amount | Uses | Amount |
|---|---|---|---|
| New loan | $9,000,000 | Pay off senior bridge loan | $7,886,930 |
| Pay off mezzanine loan | $600,000 | ||
| Closing costs (origination $45,000; title, legal and third party $63,000) | $108,000 | ||
| Cash to borrower | $405,070 | ||
| Total | $9,000,000 | Total | $9,000,000 |
$7,886,930 + $600,000 + $108,000 + $405,070 = $9,000,000. Both payoffs are taken from the payoff letters, with interest paid to the payoff date and no exit fee on either loan. The new loan replaces $8,486,930 of debt that cost $781,824 a year in interest with one loan carrying $665,000 of annual debt service.
The original acquisition table balanced at $10,085,890: the $7,889,000 bridge commitment, the $600,000 mezzanine loan and $1,596,890 of sponsor equity, against the price, closing costs, renovation, fees and interest reserve. Together, the two tables show the new loan at 89.2 percent of the sponsor's total cost, with $3,500,000 of equity remaining at today's $12,500,000 value.
How do credit officers read sources and uses?
Sources and uses shows the sponsor's cash in the deal and whether any comes back out at closing. Cash to the borrower on a refinance is normal, but it changes the story: the lender is funding the sponsor's return of equity, so many lenders compare the new loan with total cost as well as with value. On an acquisition, it shows whether the equity is really cash or partly credits, fees and deferred items.
Typical policy treatment (illustrative): the sample lender requires a payoff letter for every loan retired, verifies sponsor equity on an acquisition, and states loan to total cost beside loan to value when a refinance returns cash to the borrower, as this one does with $405,070.
What are common sources and uses errors?
- A payoff figure without a payoff letter, or one that omits accrued interest and exit fees.
- Listing sponsor equity as a plug with no evidence of where the cash comes from.
- Missing a use the loan documents require, such as an escrow or a required repair reserve.
- Counting a seller credit or deferred fee as cash equity.
Where does sources and uses appear in the credit memo?
The table usually sits near the front of the memo, in the transaction summary, so the reader sees the whole transaction before the analysis. Each line cites its support: the payoff letter, the settlement statement draft, the budget or the equity verification.
Related terms
Loan to cost, hard and soft costs, bridge loan, mezzanine debt, term sheet.
Where LenderBox does this work
LenderBox drafts the credit memo from the file with every figure cited to the document and page it came from, so committee can trace each line of sources and uses to its support, and your underwriter approves the memo.