How to document a multifamily bad-debt assumption
A concrete evidence checklist for sponsors preparing a multifamily loan request that assumes a specific bad-debt level, explaining how each item affects the financing discussion and distinguishing source facts from borrower assumptions.
A concrete evidence checklist for sponsors preparing a multifamily loan request that assumes a specific bad-debt level, explaining how each item affects the financing discussion and distinguishing source facts from borrower assumptions.
Prepare a bad-debt assumption workpaper
Create a single-page workpaper that lists each income line from the trailing twelve month (T-12) operating statement alongside the corresponding rent roll snapshot. For every unit, record the scheduled gross rent, the actual collected rent each month, and any concessions, vacancies or write-offs. Sum the total shortfall between scheduled and collected income over the twelve months, then divide by the total scheduled gross rent for the same period. The result is the property's historical bad-debt ratio, which quantifies the portion of rent not collected historically. This workpaper is your evidence file; it shows the lender the basis for any bad-debt assumption you use in the pro forma.
Distinguish the rent roll from the T-12
The rent roll is a snapshot of current occupancy, scheduled rents and any outstanding balances. It tells you who is in place today and what they owe. The T-12 is twelve months of actual operating results, reported on either a cash or accrual basis. It shows what was collected, not just what was billed. Comparing the two reveals timing differences: a tenant who paid late last month may appear as a collection in the T-12 but as a current balance on the rent roll. Do not treat the rent roll as a collection record. The lender will reconcile both documents against the bank statements and deposit records to verify that the reported income is real and recurring. [1]
Break down the income waterfall
A multifamily property's income flows through several layers before it reaches debt service. Start with gross scheduled rent: the total rent if every unit were occupied at market rate. Subtract vacancies and concessions to get gross potential rent. Then subtract credit losses—the bad debt you are trying to quantify—to arrive at effective gross income (EGI). [1] From EGI, subtract operating expenses to get net operating income (NOI). NOI is the figure used to calculate debt service coverage and debt yield. [1] Be careful not to confuse gross rent with collected income or NOI with cash flow after debt service. Each layer has a different meaning in underwriting.
Identify the bad-debt pattern in the T-12
Review the T-12 month by month. Look for recurring shortfalls that are not explained by seasonal vacancy or one-time events. A consistent pattern of uncollected rent within the lender's actual test or the sponsor's documented assumption may be acceptable, but any spike or persistent gap beyond that requires a specific explanation. [1] The lender will want to know whether the shortfall is due to tenant credit quality, management collection practices, lease terms or local economic conditions. Your workpaper should flag any month where the collected income fell below the lender's actual test or the sponsor's documented assumption and note the cause if you can identify it.
Compare the assumed bad-debt to the historical evidence
If your pro forma assumes a bad-debt ratio lower than the historical average shown in the T-12, the lender will question the assumption. You can propose a forward-looking assumption, but you must reconcile it with the historical record. Explain what has changed: a new management company, a renovation that will attract better tenants, or a shift to shorter or longer lease terms. Without a credible explanation, the lender will likely underwrite to the historical bad-debt level, which may reduce the loan amount or require a higher debt service coverage ratio. [1]
Understand how bad-debt affects debt yield and coverage
Debt yield is net operating income (NOI) divided by the loan amount. [1] A higher bad-debt assumption reduces NOI, which lowers the debt yield for a given loan size. Lenders use debt yield as a risk measure independent of interest rate and amortization. [1] If your bad-debt assumption is too optimistic, the actual debt yield may fall below the lender's threshold, and the loan may not qualify. Similarly, debt service coverage ratio (DSCR) is NOI divided by annual debt service. [1] Changes in bad-debt assumptions affect DSCR and may push it below the lender's minimum. Run your pro forma with both your assumed bad-debt and the historical rate to see the range of outcomes.
Prepare a written narrative for the bad-debt assumption
Write a short memo that states the assumed bad-debt percentage, cites the historical evidence from the workpaper, and explains any adjustment. Include the property class (A, B or C), the average lease term, the tenant profile and the collection history. [1] If the property has a high tenant turnover rate, note that management quality is critical to maintaining collections. [1] The memo is not a guarantee; it is a disclosure of your reasoning. The lender will test it against the appraisal, the rent roll and the T-12. If the narrative is consistent with the evidence, the underwriting discussion focuses on risk rather than on missing information.
Frequently asked questions
Does the lender require a specific bad-debt percentage? No. The lender evaluates your assumption against the property's historical performance and market data. There is no universal bad-debt rate. Your job is to provide the evidence and explain your reasoning. The lender's underwriting will apply its own criteria, which may include a stress test using a higher bad-debt assumption. [1]
Should I include bad-debt in the rent roll or only in the T-12? Include bad-debt in both documents. The rent roll shows current outstanding balances, which are a snapshot of uncollected rent. The T-12 reports historical income and expenses on its stated accounting basis over time, reported on either a cash or accrual basis. The lender will compare the two to see if the current rent roll is consistent with the historical collection pattern. A rent roll that shows no bad-debt but a T-12 that shows uncollected rent beyond the lender's actual test or the sponsor's documented assumption is a red flag.
What if the property has no historical bad-debt because it is new or recently renovated? For a property without a twelve-month track record, the lender will look at comparable properties in the same market and class. You can provide a market survey of vacancy and collection rates for similar properties. The lender may also require a higher debt service coverage ratio to compensate for the lack of operating history. [1]
We are not a lender and do not make loans or commitments. If you have a multifamily property and a business plan, send us the property details, the plan and the amount and timing of capital needed. We will tell you how we would approach the financing.
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).