Reconciling the requested loan with the acquisition sources-and-uses budget
A practical guide to preparing a sources-and-uses worksheet that reconciles the requested loan with the acquisition budget, including an evidence checklist, key distinctions between source facts and assumptions, and how each line item affects the financing discussion.
A practical guide to preparing a sources-and-uses worksheet that reconciles the requested loan with the acquisition budget, including an evidence checklist, key distinctions between source facts and assumptions, and how each line item affects the financing discussion.
What a sources-and-uses budget shows a lender
A sources-and-uses budget is the financial plan for an acquisition. It lists every dollar that will be spent (uses) and every dollar that will fund those costs (sources). When a sponsor requests a loan, the lender compares the requested amount against this budget to see whether the debt fits the total capital stack and whether the sponsor's equity is sufficient. The OCC notes that land acquisition loans made for speculative purposes should require considerable equity and be extended infrequently [1]. The lender will also look at whether the sources and uses are consistent with the business plan, the appraisal, and the property's projected cash flow.
Building a worksheet that reconciles the loan request
A worksheet is a suggested way to prepare information. It is not a mandatory lender form, but most lenders will expect to see a clear reconciliation. Create a two-column table with the following line items. Record the dollar amounts from the purchase agreement, the appraisal, the title company, and the lender's preliminary quote. Compare each use to a source.
Uses side
- Purchase price (from the signed contract or letter of intent)
- Acquisition costs: transfer taxes, recording fees, title insurance, legal fees, environmental reports, survey, appraisal
- Loan origination costs: lender fees, points, third-party reports required by the lender
- Interest reserve: funds set aside to pay loan interest during the initial period before the property generates enough income. The OCC defines an interest reserve as a reserve account established by the lender and used by the borrower to cover loan interest during construction and lease-up [1].
- Capital improvements or deferred maintenance identified in the property condition report
- Working capital or operating reserve for the first few months
- Any other hard or soft costs tied to the acquisition
Sources side
- Senior loan amount (the requested debt)
- Mezzanine or subordinate debt, if any
- Sponsor equity (cash, contributed property, or deferred fees)
- Other investor capital
- Seller financing, if any
Reconcile by ensuring total sources equal total uses. The loan amount you request should match the senior loan line on the sources side. If the uses exceed the sources, the gap must be filled with additional equity or a reduction in uses.
Distinguishing source facts from assumptions
A fact is a number that is fixed or independently verifiable. The purchase price is a fact if it is in a signed contract. The appraisal is an estimate, but once delivered it becomes a fact for that report. An assumption is a projection about the future: projected rent, projected operating expenses, projected interest rates, or projected timing of lease-up. The lender will treat assumptions skeptically unless they are supported by market data and historical performance. The OCC handbook instructs examiners to assess the adequacy of cash flow to meet debt service requirements and comment on trends in NOI, vacancy, and expenses [1]. That means the lender will compare your assumptions to actual rent rolls and trailing twelve months of operating statements for existing properties. For an acquisition, the lender will look at comparable properties and market reports.
How the reconciliation affects the financing discussion
The reconciliation shows the lender how the loan fits into the total capital stack. If the loan amount is large relative to the total sources, the lender may require more equity or a lower loan-to-value ratio. The OCC states that land acquisition loans made for speculative purposes should require considerable equity [1]. The lender will also evaluate whether the interest reserve is adequate. If the uses include an interest reserve that is too small, the borrower may run out of funds before the property is stabilized. The lender may also ask about the source of the sponsor's equity. The OCC warns that unsecured working capital loans to fund a developer's equity investment in a project or to cover cost overruns may indicate an undercapitalized project or an inexperienced developer [1]. That is bank supervisory guidance, not a rule that binds every borrower, but it shows why lenders prefer equity that comes from the sponsor's own cash or from a source that is not borrowed.
Evidence checklist for the acquisition budget
Prepare this checklist as a workpaper. For each item, record whether you have the document, the date, and the source.
- Purchase agreement or letter of intent
- Appraisal report (ordered by the lender or by the sponsor, but must be acceptable to the lender)
- Title commitment and preliminary title report
- Property condition report or engineering report
- Environmental report (Phase I, and Phase II if recommended)
- Quote or estimate from the lender for loan fees and points
- Estimate of legal and closing costs from the closing attorney
- Sponsor's bank statements or audited financials showing equity funds
- Organizational documents for the borrowing entity (LLC agreement, partnership agreement, or corporate resolution)
- Sponsor's schedule of real estate owned
- Financial statements for the principals and guarantors
- Rent roll (if the property is existing) and trailing twelve months of operating statements
- Pro forma with assumptions for the first three to five years
Mark each item as "received," "pending," or "not applicable." If an item is pending, note the expected date. If an item is not applicable, explain why.
Common pitfalls in reconciling sources and uses
One common mistake is using a rent roll that is not current. A current rent roll is a snapshot of the property at a single point in time. A trailing twelve-month operating statement (T-12) shows twelve historical months of income and expenses. The timing difference matters. A rent roll may show full occupancy, but the trailing twelve-month operating statement (T-12) may show that some tenants have not paid rent for months. Compare the gross rent on the rent roll to the collected income reported on the T-12, noting that the T-12 may be on a cash or accrual basis. The difference is the collection loss. The lender will use the collected income, not the gross rent, to calculate NOI and debt service coverage.
Another pitfall is confusing NOI with cash flow. NOI is net operating income: gross income minus operating expenses, before debt service and capital expenditures. Cash flow is NOI minus debt service, capital expenditures, and reserves. The lender will look at NOI to assess whether the property can support the debt. The sponsor will focus on cash flow to evaluate equity returns. Do not equate a cap rate with a debt constant. A cap rate is used to value the property, while a debt constant is used to calculate annual debt service as a ratio of the loan amount. They serve different purposes.
A third pitfall is assuming all legal costs are fixed. Legal fees vary by transaction complexity, jurisdiction, and the lender's requirements. Get a written estimate from the closing attorney before finalizing the uses side of the budget.
How to present the reconciliation to the lender
Organize the worksheet in a clear table. On the left, list each use with the amount. On the right, list each source with the amount. At the bottom, show that total uses equal total sources. Write a short narrative explaining any assumptions, for example, "Interest reserve is calculated based on the lender's preliminary quote and the sponsor's documented assumptions." Attach the supporting documents from the evidence checklist. The lender will review the worksheet and ask for additional information if anything is unclear.
FAQs
What if the uses exceed the sources?
If the uses exceed the sources, the budget is not balanced. You must either reduce uses (for example, by negotiating a lower purchase price or reducing the interest reserve) or increase sources (by adding more equity or a mezzanine loan). The lender will not approve a loan request that leaves a gap in the capital stack.
Does the lender require the sponsor to pay for the appraisal before the loan is approved?
Typically, the lender will order the appraisal and require the sponsor to pay for it. The cost is usually included in the uses side of the budget. The appraisal is needed before the lender can confirm the loan-to-value ratio and finalize the loan amount.
Can the sponsor use a personal loan to fund the equity contribution?
The OCC guidance notes that unsecured working capital loans to fund a developer's equity investment may be considered risky [1]. Most lenders will ask the sponsor to disclose the source of equity. If the equity is borrowed, the lender may require a higher equity contribution or may not accept that source at all. Ask the actual lender about its policy on borrowed equity.
This guide is a suggested way to prepare information. It is not a lender and does not make loans or loan commitments. All financing is subject to the lender's underwriting and approval. To start a financing conversation, send us the property, the business plan, the amount needed, and the timing. We will tell you how we would approach it.
Model this deal and request financing
Run a multifamily acquisition or value-add model with your own numbers in the financing workbench. Results are calculated on the server with the assumptions shown. If you choose to send the request, you get a preliminary lender-package PDF and can attach your rent roll, T-12 or OM.
Opens the financing workbench operated by Wraith Real Estate. Nothing goes to any lender without Wraith's review and your agreement.
Talk through your financing
Working on a real property? Send us the deal and a financing advisor will review it and get back to you. It costs nothing to ask and does not commit you to anything.
Requests are reviewed by Wraith Real Estate, a commercial real estate debt advisor (not a lender).