Reconciling a sponsor equity schedule with the closing budget
A practical guide for sponsors to prepare an equity schedule that aligns with the closing budget, including a concrete evidence checklist and document worksheet.
A practical guide for sponsors to prepare an equity schedule that aligns with the closing budget, including a concrete evidence checklist and document worksheet.
When you prepare a financing request for a commercial real estate project, one of the first things a lender will examine is how your sponsor equity schedule matches the closing budget. This guide explains how to reconcile the two, why it matters for the financing discussion, and what concrete documents you can prepare to support your request.
Understanding the equity schedule and closing budget
The sponsor equity schedule lists all sources of equity capital—cash, contributed assets, or deferred fees—that you plan to invest in the project. The closing budget itemizes all costs to acquire, construct, or renovate the property, including hard costs, soft costs, and a contingency reserve. Reconciling these two documents means showing that the total equity committed equals or exceeds the equity requirement stated in the budget, and that the equity is available when needed.
Bank supervisory guidance, such as that from the OCC, emphasizes that lenders should evaluate the borrower's initial hard equity—cash or unencumbered investment in the property—as part of prudent underwriting [1]. This is not a legal rule for every borrower, but it reflects how lenders assess credit risk. Your reconciliation directly addresses this concern by demonstrating that you have sufficient equity to cover cost overruns or delays.
How reconciliation affects the financing discussion
A well-prepared reconciliation shows lenders that you understand the project's financial structure and have realistic contingency plans. It can influence loan terms such as leverage, recourse, and reserve requirements. If the equity schedule and budget are inconsistent, a lender may question the project's feasibility or require additional guarantees. Conversely, a clear reconciliation can strengthen your negotiating position when comparing quotes from multiple lenders [2].
Concrete document to prepare: the equity-budget reconciliation worksheet
Create a simple spreadsheet or table with three columns: (1) budget line item, (2) source of funds (equity or debt), and (3) amount. For each cost in the closing budget—land, hard costs, soft costs, contingency—indicate whether it is funded by equity or by the loan. Then total the equity column and compare it to the lender's minimum equity requirement. This worksheet is not a substitute for a formal sources-and-uses statement, but it is a practical tool to organize information before you submit a loan request.
Evidence checklist for reconciliation
Use this checklist to gather supporting documents for your reconciliation:
- Equity commitment letters: Letters from equity partners or guarantors confirming the amount and timing of their contributions.
- Bank statements or proof of funds: For cash equity, provide recent statements showing sufficient liquidity.
- Appraisal or valuation reports: If equity includes contributed property or deferred fees, include independent valuations to support the amounts.
- Construction budget detail: A line-item budget that separates hard costs, soft costs, and contingency, as described in OCC guidance [1].
- Project pro forma: Financial projections showing how equity and debt service are covered by projected income.
- Sponsor financial statements: Current and historical statements for the borrowing entity and guarantors, as lenders typically require [1].
- Organizational documents: For the borrowing entity, to confirm authority to commit equity.
Comparing gross rent, collected income, and net operating income
When your reconciliation involves operating properties, you may need to show how equity relates to cash flow. Distinguish these key metrics:
- Gross rent: Total potential rent from all units or spaces, before vacancies or collections.
- Collected income: Actual rent received, after vacancies, concessions, and bad debt.
- Net operating income (NOI): Collected income minus operating expenses (but before debt service).
- Capital expenditures (capex): Major improvements or replacements, often funded separately from operations.
- Debt service: Loan payments (principal and interest) due each period.
- Equity cash flow: NOI minus debt service, representing the return to equity.
A current rent roll is a snapshot of occupancy and rents at a single point in time. A trailing twelve months (T-12) statement shows historical operating performance over the past year. Before comparing totals, note that the rent roll reflects current conditions, while the T-12 includes past vacancies and expenses. Reconciling these with your equity schedule helps lenders see whether the property's cash flow supports the equity commitment.
Reconciling timing differences between equity and budget
Equity is often contributed in stages: some at closing, some during construction, and some at stabilization. The closing budget, however, may require full equity upfront to cover land acquisition and initial hard costs. A mismatch can create a funding gap. To address this, prepare a timeline showing when each equity contribution is available and when each budget cost is due. Lenders may require that equity be contributed before or concurrently with loan draws [1].
Suggested way to prepare information
- Create a simple schedule with months or quarters across the top.
- For each period, list expected equity inflows and budgeted outflows.
- Identify any periods where cumulative equity is less than cumulative costs, and plan how to cover the gap (e.g., a bridge loan or additional equity commitment).
What if my equity includes deferred fees or contributed services?
Deferred fees or services can be part of your equity, but lenders may discount them compared to cash. Include independent appraisals or market-rate comparisons to support the value, and be prepared to explain how the deferred amount will be paid if the project does not generate sufficient cash flow.
How do I handle equity from multiple partners?
List each partner's commitment separately in the equity schedule, with supporting commitment letters. Ensure the total equals the required equity, and that each partner's contribution is clearly traceable to specific budget items. Lenders may require that all equity be contributed before any loan funds are advanced.
What if my budget changes after I submit the reconciliation?
Notify the lender immediately and provide an updated reconciliation. Changes to the budget—such as cost overruns or scope reductions—affect the equity requirement. Lenders may require additional equity or adjust loan terms to maintain the same collateral margin.
We can help you organize your property information, business plan, and capital needs to present a clear reconciliation to lenders. Send us the property, the business plan, and the amount and timing of capital you need, and we will tell you how we would approach it.
Run the numbers on your deal
Try your own NOI, value and lender tests to see which one limits the loan: DSCR, LTV or debt yield.
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).