How to compare additional equity needs across apartment acquisition cases
A practical guide to preparing a side-by-side equity gap worksheet for multifamily acquisition deals, using financing models and lender guidance to clarify how assumptions about NOI, debt service, and capital costs affect the sponsor's required cash contribution.
A practical guide to preparing a side-by-side equity gap worksheet for multifamily acquisition deals, using financing models and lender guidance to clarify how assumptions about NOI, debt service, and capital costs affect the sponsor's required cash contribution.
When you are evaluating multiple apartment acquisition opportunities, the financing structure often determines which deal is feasible and which requires more sponsor cash. This guide walks through a concrete worksheet you can build for each case, explains how the information connects to lender underwriting expectations, and distinguishes what is a source-backed fact from what is your own assumption.
Prepare a side-by-side equity gap worksheet
Create a simple spreadsheet with one column per acquisition case and rows for the following items. This is a suggested organizing tool, not a mandatory lender form. The goal is to record your assumptions in one place so you can compare the additional equity each deal needs after financing.
- Purchase price
- Estimated total project cost (purchase plus hard and soft costs for rehab or value-add)
- Expected first mortgage amount (based on your assumed loan-to-cost or loan-to-value)
- Equity gap before financing (total cost minus first mortgage)
- Your planned sponsor equity contribution (cash you will invest)
- Additional equity needed (gap minus your contribution)
Record the source of each number. For the mortgage amount, note whether you used an assumed loan-to-cost ratio or an estimated debt service coverage ratio. This distinction matters when you compare cases because the feasible loan size depends on the property's net operating income, not just the purchase price.
Distinguish rent roll snapshot from T-12 historical income
A current rent roll shows the in-place rents and occupancy as of today. A trailing twelve-month (T-12) operating statement shows actual income collected over the past twelve months. These two documents measure different periods and often produce different totals. When you compare cases, identify the reporting basis for each property's income figure. If the rent roll shows gross potential rent but The T-12 reports historical income and expenses on its stated accounting basis, the difference may reflect vacancies, concessions, or collection losses. Adjust your net operating income estimate to match the more conservative collected figure. This adjustment directly affects the debt service capacity and therefore the additional equity needed.
Break down income and expense layers
When you calculate net operating income, separate these layers to see where your assumptions differ across cases:
- Gross potential rent
- Vacancy and collection loss (use the T-12 actual, not a market assumption)
- Effective gross income
- Operating expenses (distinguish pass-through expenses like utilities from fixed costs)
- Net operating income (NOI)
Once you have NOI, estimate annual debt service for the assumed loan amount. The remaining cash flow after debt service is the equity cash flow. If two deals have the same purchase price but different NOI, the one with higher NOI can support more debt, reducing the additional equity needed.
Identify capital expenditure assumptions separately
Rehabilitation or value-add budgets include capital expenditures (capex) that improve the property. These are not operating expenses and should not be deducted from NOI when calculating debt service capacity. Instead, record capex as a separate line in the total project cost. [1] The OCC Commercial Real Estate Lending handbook notes that banks financing repositioning or rehabilitation should closely examine the borrower's assumptions to determine the likelihood that projections can be realized. When you compare cases, note which costs are for deferred maintenance (required to stabilize the property) versus discretionary upgrades. The lender may treat required capex as a condition for funding, which affects the timing and amount of your equity contribution.
Compare equity timing, not just total amount
Lender guidance on equity contribution timing is relevant here. [1] The OCC handbook states that allowing the contribution of borrower equity to be deferred can significantly increase completion risk, and that bank policy should state that equity be contributed before disbursements of the construction loan commence. When you compare cases, record not only the dollar amount of additional equity needed but also when that equity must be available. A deal requiring a large equity contribution at closing may be harder to fund than a deal requiring the same total equity spread over several draws. However, the lender may require equity upfront regardless of the draw schedule. Ask the actual lender for their policy on equity timing.
Prepare an evidence checklist for each case
For each acquisition case, gather these documents before you compare equity needs:
- Current rent roll (dated within 30 days)
- Trailing twelve-month operating statement (T-12)
- Purchase agreement or letter of intent with price and terms
- Rehabilitation or capital expenditure budget with line items
- Your assumed loan amount and structure (rate, amortization, term are assumptions until you get a term sheet)
- Your planned sponsor equity contribution amount and source
Compare the rent roll totals to the T-12 totals. If they differ by more than a few percent, investigate why. Record the NOI from the T-12 and use that as your base case. Then run a sensitivity with the rent roll NOI to see how much the equity gap changes.
FAQs
What is the difference between gross rent and collected income when comparing deals?
Gross rent is the total rent if all units were leased at market rates. Collected income is what tenants actually paid after vacancies, concessions, and bad debt. Use collected income from the T-12 for your NOI calculation because it reflects real cash flow. The rent roll shows potential, not performance.
Should I include deferred developer fees or overhead as equity?
No. [1] The OCC handbook states that deferred developer's profit, unearned developer fees, incurred overhead expenses, or interest or other holding fees paid or accrued on contributed land do not contribute to the value of the project and are generally not considered equity. Only cash or cash-equivalent contributions count toward your equity.
Does a higher NOI always mean less additional equity needed?
Generally yes, because higher NOI supports more debt service, which can increase the loan amount and reduce the equity gap. But the lender also considers the property's condition, your track record, and the feasibility of your projections. [1] The OCC handbook emphasizes evaluating the borrower's assumptions and track record with similar properties. A high NOI based on aggressive rent growth assumptions may not convince a lender.
Ready to test your assumptions? The website has the submission form and contact information to get started.
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).