Sources and uses · Loan documents

Every dollar placed and sourced before your team funds.

Before your team funds, every line of the sources and uses is tied to a payoff letter, the budget, the appraisal or another document in the file. Both sides are footed, and loan to cost and loan to value arrive with their formulas and every figure cited to its page.

SOURCES AND USES · ILLUSTRATIVE$9.0M REFINANCE
The closing table as the borrower submitted it
SOURCES AND USES · 96-UNIT APARTMENT REFINANCE · PAGE 1 OF 1
LINEAMOUNT
SOURCES
1New first mortgage loan9,000,000
Total sources9,000,000
USES
2Pay off senior bridge loan7,886,930
3Pay off mezzanine loan600,000
4Closing costs108,000
Origination fee, 0.5%45,000
Title, legal and third party63,000
5Cash to borrower405,070
Total uses9,000,000
READ FROM THIS DOCUMENT, EACH FIGURE CITED
1New loan$9,000,000Sources and uses, p. 1 · Term sheet
2Senior bridge payoff$7,886,930Payoff letter, p. 1
3Mezzanine payoff$600,000Mezzanine payoff letter, p. 1
4Closing costs$108,000 · 1.2% of the loanSources and uses, p. 1
5Cash to borrower$405,070Sources and uses, p. 1
Loan to cost above loan to value89.2%
The new loan is 72.0% of the $12,500,000 value and 89.2% of the $10,085,890 the sponsor spent to buy and renovate. $405,070 goes back to the sponsor at closing, so committee sees both ratios.
Sources and uses, p. 1Acquisition budgetAppraisal, p. 41
What a credit officer checks on sources and uses

Both sides footed, then every line traced to its support.

Each check sets the table beside a payoff letter, the acquisition budget, the appraisal or your policy. The results come from the illustrative 96-unit refinance and the bridge loan that preceded it.

THE CHECKON THE SAMPLE FILE · ILLUSTRATIVE
Sources against uses
Both sides must total the same amount, and each payoff must match the balance it retires.
TIES OUT
Both sides total $9,000,000. The $7,886,930 senior payoff matches the funded balance on the payoff letter: $5,700,000 advanced at closing, $1,584,000 of renovation draws and $602,930 of reserve interest.
Sources and uses, p. 1Payoff letter, p. 1
Closing costs
Fees and third-party costs set beside the term sheet and the estimates behind them.
TIES OUT
$108,000, 1.2% of the loan: the 0.5% origination fee of $45,000 and $63,000 for title, legal and third-party reports.
Sources and uses, p. 1Term sheet
Loan to cost beside loan to value
When a refinance returns cash, the loan is measured against what the sponsor spent as well as against value.
FLAGGED
72.0% of value, inside your 75% limit. 89.2% of the $10,085,890 total cost, because $405,070 comes back to the sponsor.
Appraisal, p. 41Acquisition budgetPolicy §4.3
Sponsor equity actually in
Cash equity proven at the acquisition, and how much stays in after closing.
ON THE RECORD
The sponsor put in $1,596,890, 15.8% of cost, against a senior loan at 78.2% and 84.2% with the mezzanine. After the cash out, $1,191,820 of that cash stays in, and equity at today's value is $3,500,000.
Acquisition sources and usesAppraisal, p. 41
Contingency in the budget
Hard cost contingency as a share of hard costs, against the minimum, and what was left at completion.
TIES OUT
$144,000, 10% of the $1,440,000 renovation, meeting a 10% minimum. All of it was used by the third draw, so the work finished on budget with nothing to spare.
Acquisition budgetDraw 3
Interest reserve against its schedule
The reserve should cover the projected interest on the loan as it funds.
TIES OUT
$605,000 against a $602,930 schedule at 9.00%, interest compounding on the draws. $2,070 was left unused when the reserve period ended.
Acquisition budgetReserve schedule
What LenderBox returns

A balanced table, and the ratios committee asks for next.

Each line of the table arrives tied to its support, and the ratios built from it carry their formula.

CITED TO THE SUPPORTEvery line is cited to its document and page: the payoff letters, the budget, the closing cost estimates and the appraisal.
BOTH PAGES FOR ANY GAPWhere the table and a payoff letter disagree, both figures arrive with their pages, and your analyst decides which one to rely on.
FORMULA SHOWNLoan to cost at 89.2% and loan to value at 72.0% each show the formula behind them, so a reviewer can follow each one back to the table.
THE LARGEST LOANThe largest loan and its binding limit sit beside the request, so a counteroffer is ready before the sponsor asks.
CURRENT, OR ASKED FOR AGAINA payoff letter that will lapse before the closing date is flagged for an update.
See how acquisition and refinance loans are sized →
WHERE THE FIGURES GO · ILLUSTRATIVESAME SAMPLE FILE
Maximum loan, value, cost and memo
MAXIMUM SUPPORTABLE LOAN$9,252,146, set by the stress test: $252,146 above the request
LOAN TO VALUE72.0% against your 75% limit
Appraisal, p. 41Policy §4.3
LOAN TO COST89.2% of the sponsor's total cost
Sources and uses, p. 1Acquisition budget
CREDIT MEMOTransaction summary drafted with the recommendation, each line cited

Payoffs, cash out and reserves, with your team deciding.

Reading the table
LENDERBOX DOESReads both sides of the table and cites each line to its support.
STAYS WITH YOUR TEAMWhich version of the table the approval rests on.
Payoffs
LENDERBOX DOESTies each payoff to its payoff letter and the balance it retires, with both pages for any gap.
STAYS WITH YOUR TEAMRequesting updated payoff letters for the closing date.
Equity and cash out
LENDERBOX DOESShows the sponsor's cash in at cost and at today's value, and the cash coming back at closing.
STAYS WITH YOUR TEAMWhether cash out at this loan to cost fits your policy.
Reserves and fees
LENDERBOX DOESSets each reserve beside the schedule it funds and each fee beside the term sheet.
STAYS WITH YOUR TEAMWhich reserves the loan requires and how they are held.
The memo
LENDERBOX DOESDrafts the transaction summary, each line tied to its support.
STAYS WITH YOUR TEAMWhether $405,070 of cash out fits.

The closing table at request, at approval and at payoff.

01 · FIRST LOOKThe table sent with the request gives an early read on loan to cost and cash out.
02 · UNDERWRITING · THIS DOCUMENTEach line is tied to its payoff letter, budget or estimate, and the ratios are built from it.
03 · CREDIT DECISIONCommittee sees loan to cost beside loan to value, with the cash out and the equity left in.
04 · CLOSINGPayoff letters are updated to the closing date.
05 · LIFE OF THE LOANAfter closing, the loan sits beside every other loan the sponsor holds, with covenant monitoring on the loan.

Closing table checks for CRE credit teams

Are both sides of the closing table read?

Yes, every line on both sides: the loan, any subordinate debt and equity, and each payoff, fee, reserve and cost. Each is cited to the document behind it, and loan to cost and loan to value are calculated with the formula shown.

Does it check payoffs against the payoff letters?

Yes. Each payoff is read against its payoff letter and the balance it retires. A payoff that disagrees with its letter shows both pages, and your analyst chooses the figure.

How is cash out on a refinance shown?

With the cash and what it does to the ratios. On the sample, $405,070 returns to the sponsor, so the loan is 89.2% of total cost while it is 72.0% of value, and the memo states both.

Does it handle construction and bridge budgets?

Yes. Construction loans are underwritten on loan to cost, and on a bridge loan the interest reserve and renovation holdback are measured against the timeline in the plan.

How are reserves on the closing table checked?

Each reserve is set beside the schedule it funds and each fee beside the term sheet; which reserves to require stays with your team.

Test the next refinance before the payoff letters expire.

The demo can run on your own deal documents: bring a sources and uses and the payoff letters behind it, and every line comes back cited.

Bring a deal
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.
Not ready to talk? See pricing