Testing a multifamily acquisition with no assumed rent growth
A concrete worksheet and evidence checklist to stress-test a multifamily acquisition using current rent and expense data without assuming future rent growth, helping sponsors prepare a credible financing request.
A concrete worksheet and evidence checklist to stress-test a multifamily acquisition using current rent and expense data without assuming future rent growth, helping sponsors prepare a credible financing request.
Identify the base rent roll and trailing twelve months
Start with the current rent roll and the trailing twelve months (T-12) of operating statements. The rent roll is a snapshot of today's tenants, lease terms, and rent amounts. The T-12 is a historical record of income and expenses over the past twelve months, reported on a cash or accrual basis; clarify which. Do not compare these two directly without adjusting for timing differences. The rent roll shows what is due now; The T-12 reports historical income and expenses on its stated accounting basis and spent month by month. To reconcile them, align the rent roll's monthly rent totals with the T-12's income line for the same period. If the T-12 shows lower income, identify whether the gap comes from vacancies, delinquencies, concessions, or timing of rent receipts. This reconciliation is a suggested way to prepare information for the lender's review. [1]
Separate gross rent, collected income, and net operating income
Gross rent is the total contractual rent from all occupied and vacant units if fully leased. Collected income is what the landlord actually received after vacancies, concessions, and bad debts. Net operating income (NOI) is collected income minus operating expenses, before debt service. To build a conservative model, use the T-12 collected income and expenses as the base, not the rent roll's gross potential. The OCC guidance states that actual collections should be examined to determine true economic occupancy, not just the rent roll occupancy rate. [1] Record the NOI from the T-12, then subtract a reasonable vacancy and collection loss factor based on the property's history and local market data. Do not assume future rent growth unless you have signed leases or market evidence that the lender can verify.
Build a capital expenditure and reserve schedule
Capital expenditures (capex) are major improvements that extend the property's life, such as roof replacement, HVAC upgrades, or parking lot resurfacing. Operating expenses are recurring costs like repairs, utilities, and management fees. The T-12 may show some capex as repairs; separate these items into a capex schedule. The OCC handbook notes that property management ability is critical and that inept or inexperienced management is a major cause of difficulty for multifamily loans. [1] A suggested way to prepare is to list each major system's age and expected replacement year, then estimate the annual reserve needed. Add this reserve to the operating expense line when calculating NOI for the pro forma. This shows the lender that you have identified future capital needs and are not relying on deferred maintenance to inflate cash flow.
Calculate debt service capacity without rent growth
Debt service includes principal and interest payments on the proposed loan. Use the conservative NOI (after vacancy, collection loss, and capex reserves) to determine how much debt the property can support. Do not equate a cap rate with a debt constant. The cap rate converts NOI to property value; the debt constant is the annual debt service divided by the loan amount. They measure different things. To test the acquisition, divide the conservative NOI by the proposed debt service to get the debt service coverage ratio. If this ratio indicates the property cannot cover its debt payments from current cash flow, consult the actual lender about acceptable mitigants, such as additional equity, a lower loan amount, or a shorter interest-only period. The OCC handbook lists loans renewed on an interest-only basis without appropriate mitigants as an underwriting concern. [1]
Prepare an evidence checklist for the lender
Create a workpaper that lists the following items with your findings. This is not a mandatory lender process but a suggested way to organize information.
- Current rent roll with unit mix, lease terms, and rent amounts.
- T-12 income and expense statements, reconciled to the rent roll.
- Vacancy and collection loss history, calculated from the T-12.
- Capex schedule with estimated costs and timing.
- Conservative NOI calculation, assuming no rent growth.
- Debt service coverage ratio using the proposed loan terms.
- Sponsor's schedule of real estate owned and financial statements. [2]
For each item, note the source (rent roll, T-12, property inspection, market report) and any assumptions you made. The OCC guidance expects the lender to evaluate the borrower's ability to service debt and the plans for repayment. [1] Your checklist shows that you have done this analysis and are not relying on optimistic projections.
Distinguish source facts from assumptions in the pro forma
In the pro forma, label each line item as a source fact (from the T-12, rent roll, or signed lease) or an assumption (projected rent growth, expense inflation, or occupancy improvement). For example, current rent from the rent roll is a fact; any rent growth is an assumption. The OCC handbook lists assumptions relative to current market conditions such as higher than current rents or occupancy rates as an underwriting concern. [1] If you include any assumed growth, explain why it is reasonable and how you will achieve it. For a conservative test, set all growth assumptions to zero and see if the deal still works.
Ask the actual lender about underwriting criteria
Lenders differ on leverage, recourse, prepayment, reserves, extension tests, and covenants. [2] The OCC guidance applies to banks and is not a rule binding every borrower or nonbank lender. [1] A suggested way to prepare is to ask the lender directly what debt service coverage ratio they require, how they treat capex reserves, and whether they allow interest-only periods. Do not assume all lenders use the same standards. Record their answers in the workpaper and adjust your model accordingly.
Frequently asked questions
What if the T-12 shows higher income than the rent roll?
This can happen if the T-12 includes one-time income such as laundry, parking, or late fees. Separate recurring income from one-time items. The rent roll should be the base for recurring rent. Use the T-12 to verify collection rates, not to inflate gross income.
Do I need to include a property management analysis in the workpaper?
Yes. The OCC handbook states that property management ability is critical to multifamily success. [1] Include the manager's experience, whether self-managed or third party, and their track record with collections and tenant retention. This is not a lender requirement but a suggested way to demonstrate competence.
Can I use the workpaper for other property types?
The worksheet is designed for multifamily but can be adapted for office, retail, or industrial by adjusting the income and expense lines. The principle of testing without assumed rent growth applies to any income-producing property where lease terms are shorter than the loan term.
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).