Comparing in-place DSCR with stabilized DSCR in a value-add plan
A practical guide to preparing two distinct debt service coverage ratio calculations — one for the property as it is today and one for the plan — and how lenders use each to underwrite a value-add bridge loan.
A practical guide to preparing two distinct debt service coverage ratio calculations — one for the property as it is today and one for the plan — and how lenders use each to underwrite a value-add bridge loan.
This guide explains how to prepare and present two DSCR calculations for a value-add property. The goal is to show a lender both where the property is today and where the business plan expects it to go. Lenders use these two numbers to size the loan, set reserves, and decide whether the property can carry the debt during the transition.
What in-place DSCR shows
The in-place DSCR uses the property's actual operating history. It answers the question: can the property, as it is today, pay the proposed debt service? Lenders typically want to see a trailing twelve-month (T-12) operating statement and a current rent roll. The T-12 gives twelve months of historical income and expenses. The current rent roll is a snapshot of who is in place, what they pay, and what is vacant. The two will differ because the T-12 includes periods when some units were vacant or tenants were on different terms. To compare them, note the timing difference: the rent roll is a point in time, while the T-12 is a historical average. [1]
What stabilized DSCR shows
Stabilized DSCR uses the projected income after the value-add plan is complete and the property has reached stabilized occupancy. Stabilized occupancy is the occupancy level the property is expected to achieve after being exposed to the market for lease-up over a reasonable period at comparable terms to similar properties. [1] This is not the same as full occupancy or the sponsor's target. It is a market-based estimate from the appraisal.
How the two DSCRs affect the financing discussion
A lender sees a value-add plan as a transition from the in-place condition to the stabilized condition. The gap between the two DSCRs tells the lender how much income growth the plan depends on. A large gap means more risk that the plan does not materialize. A small gap means the property is closer to stabilized already. [1]
For a bridge loan on a value-add property, the lender may underwrite to the in-place DSCR for the initial loan amount and then allow a higher loan amount or better terms once the property reaches stabilized occupancy. The lender may also require a debt service reserve to cover shortfalls during the transition. The borrower should ask the lender about their reserve requirements. [2]
Preparing the DSCR workpaper
Prepare a single-page workpaper that shows both calculations side by side. Use the following structure:
Property name and date
Source of in-place data: T-12 period (e.g., January 2025 to December 2025) and current rent roll date
Source of stabilized data: Appraisal or pro forma, with date and preparer name
In-place calculation: - Gross rent (from T-12) - Vacancy loss (from T-12) - Operating expenses (from T-12) - NOI - Annual debt service (proposed loan amount times rate, plus amortization) - In-place DSCR
Stabilized calculation: - Projected gross rent (market rents from appraisal) - Projected vacancy (market vacancy rate from appraisal) - Projected operating expenses (market expenses from appraisal) - Projected NOI - Annual debt service (same as above) - Stabilized DSCR
Reconciliation: - Explain any differences between the T-12 and the rent roll (e.g., a tenant moved in mid-year, a large vacancy was filled, rents were raised) - Note any non-recurring income or expenses in the T-12 (e.g., a lease termination fee, a one-time repair) - State whether the stabilized NOI is from the appraisal or the pro forma, and whether the appraiser used the same assumptions as the sponsor
This workpaper is not a lender form. It is a way to organize the information so the lender can see the logic behind the two DSCRs. [2]
Distinguishing source facts from assumptions
The in-place DSCR is based on actual historical data. The stabilized DSCR is based on projections. The appraisal's stabilized value is an estimate of market value under projected conditions, not a guarantee of future performance. [1] The sponsor's pro forma may use different assumptions than the appraiser. Lenders will compare the two and ask about differences. Be prepared to explain why the sponsor's assumptions are reasonable and how they compare to market data.
Evidence checklist
Before submitting a loan request for a value-add property, gather the following:
Each item supports the lender's underwriting. The appraisal is especially important because it provides the stabilized value and the stabilized NOI that the lender will rely on. [1]
How do I reconcile the T-12 to the rent roll?
The T-12 shows twelve months of history. The rent roll shows today. To reconcile, identify any leases that started or ended during the T-12 period, any rent changes, and any periods of vacancy that are not reflected in the current rent roll. Create a simple schedule that shows the monthly rent roll for each month of the T-12 and compare it to the actual income recorded. This explains why the T-12 NOI may differ from a simple annualization of the current rent roll.
Does the lender use the same DSCR for the whole loan term?
Not necessarily. For a bridge loan, the lender may underwrite to the in-place DSCR for the initial period and then require the property to reach a minimum stabilized DSCR before converting to a permanent loan. The term sheet should specify the DSCR tests at each stage. Ask the lender directly what DSCR they require at closing and what DSCR they require for conversion or extension. [2]
To discuss your value-add property, send us the property, the business plan, and the amount and timing you need. We will tell you how we would approach it. Submission is a preliminary request, not an engagement or lender submission.
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).